Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Infor LX & BPCS Materials Tip of the Week: Drop Shipments

George Moroses 0 26831 Article rating: 5.0

Infor LX provides a tightly integrated drop shipment processing capability. The product supports the creation, tracking, and management of customer drop shipment orders via the Order Management, Purchasing, and Billing applications.

The order processing professional initiates drop shipments during customer order creation. You can designate any order line for drop shipment if it meets user-defined drop-ship controls. If you designate a line as a drop-ship line, the system automatically creates a drop-ship request in purchase order processing.

When a buyer responds to a drop-ship request and creates a purchase order, Infor LX

Infor LX & BPCS Finance Tip: AR Aging

George Moroses 0 26936 Article rating: 5.0

An ACR system parameter allows you to specify whether to measure invoice age from the date on which you create the invoice, invoice date, or the date on which the invoice is due. You can set up a separate terms code for each customer on the system to set the basic terms of payment for that customer. For example, this term could specify the number of days an invoice can be due before it is considered past due and the number of days that a discount is available. The system uses the terms code data to...

Infor LN & Baan Finance Tip: What Can You Do in the Financial Statements Module?

Kathy Barthelt 0 51895 Article rating: 5.0

In the Financial Statements module, you can:

  • Define financial statements, and link a structure of child statement accounts and parent statement accounts to these financial statements.
  • Link ledger accounts and/or dimensions to the statement accounts.
  • Link cash flow reasons to cash flow statement accounts.
  • Export financial data to FST reporting tables.
  • Print reports directly, or use the BIRT report functionality to print to PDF, HTML, and export to Excel or Word.


Data drill down in financial statements - You can...

Infor LN & Baan Manufacturing Tip: All About Routings

Kathy Barthelt 0 52315 Article rating: 4.0

The planning data for the method of manufacturing is defined in Routing. A routing consists of operations, with each operation identifying the last to be carried out in a work center and/or on a certain machine defined for a specific site.

Routings can be as follows:

  • Standard Routing - A generic routing that can be attached to multiple items
  • Item specific - A routing that is applied to one item
  • Network routing - A routing containing sequentially ordered operations and parallel operations
  • Order quantity dependent routing - A routing that is defined for a specific quantity of items

You use the Routing module to record routings for manufactured items. You can define the following:

Infor LX & BPCS Manufacturing Tip: Backward Scheduling

George Moroses 0 24243 Article rating: 5.0

Operations are automatically backward scheduled at shop order release time. The backward scheduling algorithm starts with the shop order due date and schedules each operation based upon the standard move and queue times in the routings and the number of days the job is expected to run at standard. The system calculates and stores the operation scheduled start date. The dates may be modified by the shop order maintenance program. The number of days that a job is expected to run an operation is dependent upon the available capacity for that work center and the total hours scheduled for that operation.

The backward scheduling algorithm also considers...

Infor LX & BPCS Tip: What is IDF and how could it make my life easier?

George Moroses 0 26437 Article rating: 5.0

The Infor Development Framework (IDF) re-architects the way a user interacts with the application. IDF provides an efficient, task-oriented process to view application information that is contained within Infor LX. IDF enables users to configure their view of the application data without modifying the core application and its supportability.

The examples below describe how users can configure their display of data and maximize overall productivity:

  • Arrange application information into multiple groupings and sequences that make sense for the job.
  • Hide information that does not apply to a particular job or task.
  • Filter records to show only the information that applies to the job or task that the user is performing.
  • Customize the information for an individual user, for a group of users, or for all users.
     

Infor LN & Baan Tip: Deleting Records

Kathy Barthelt 0 53420 Article rating: 5.0

To improve performance and reduce database growth, deleting records is highly effective. The disadvantage of deleting records is that data is no longer available. Usually, however, not all records need to be saved. For example, line activities are stored by warehouse. Normally, you do not need to keep these records. Therefore, after closing a warehouse order, line activities can be removed. The User's Guide for ERP LN Archiving and the corresponding Baan IV/V Guides describe several sessions you can use to delete old data. Other data such as items and business partners can be reviewed once in a while, after which you can delete the data you no longer need. For every order and contract table, a session is available to archive and delete old orders. In these sessions, you can specify several characteristics to select the orders to be removed, such as date or status. Run these sessions on a regular basis.

Are ERP System Blockages Thwarting Your Progress?

Kathy Barthelt 0 24468 Article rating: 5.0

After a week of blocking the Suez Canal, the now-famous cargo ship, Ever Given has been freed from the 27,000 cubic meters of sand and mud that were surrounding the ship. Supply chains are flowing again. I for one am very glad to hear that the ship has been freed since coffee, toilet paper and a whole host of other items were being held up! In all seriousness, it was and is a crisis that will have ripple effects on the global economy.

As I often do, I started to relate this crisis to the world of ERP that we live in. Although we are not responsible for dealing with a situation like what happened in the Suez Canal, we all deal with problems in our jobs every day. Some of these problems are small, and some are not so small. Some problems are caused by human error, some by prevailing winds that blow us in a particular direction, and some by circumstances out of our control. It is what we do about the problems we encounter that make all the difference. We could bury our heads and hope the problems somehow go away on their own, or we can take action and do something to bring about the change necessary to get past the blockage.

I see “blockages” every day in working with my customers. Sometimes it is a lack of understanding of best practices in a given department, or a reliance on tribal knowledge that determines how and why something is done in the system, or inefficient manual processes destroying a company’s efficiency, or hundreds (or thousands) of customizations standing in the way of an upgrade, or employees labeling an ERP system as “no longer a fit” when their company is only using 10% of the available functionality in the system.

So, maybe today we could focus on what it would take to remove the “blockage” that we have in our way. What benefits could we realize if we worked together to bring about incremental change? Could we actually get that upgrade done? Could we start operating based on industry-leading best practices? Could we increase our market share? Could we decrease our costs and boost our revenue? All of this is possible.

Contact me today so that we can begin to work together to solve the problems that stand in the way of your progress.

solutions@crossroadsrmc.com or 800.762.2077

First3334353638404142Last

Tips:  LX | BPCS | M3

Item Facility Master has a new attribute to define the override inspection days lead time CICP.ICINSD.

  • When an item facility has a defined override inspection days lead time, that value will be used instead of the system parameter inspection days lead time.

MRP exception report, MRP200B
Purchase planning report, PUR285B
Purchase order / Requisition maintenance, PUR500D3
Purchase order consolidation / release, PUR640B1
Vendor splits, PUR653B

This enhancement improved the subfile utilized in MRP320D Master Schedule Detail Inquiry -SCR001 by expanding the subfile with data rather than clearing the subfile as user pages. This change provides full support for the WebTop 4.8 Grid decorator.

This enhancement updated the approach used to populate the subfile to allow a deployed Webtop Grid to function correctly. There is no visible or user-impacted change to the way the program functions.

This enhancement provides improved functionality and full support of a Webtop grid applied to the subfile.

Last

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Interest Invoices

You can generate interest invoices for paid invoices, partially paid invoices, and unpaid invoices. In addition, after you generate and send an interest invoice, you can generate a subsequent interest invoice for the next period.

Setting up interest invoicing: You can set up interest invoicing in Accounts Receivable and the General Ledger.
To set up interest invoicing, use these sessions:

  • Invoice-to Business Partner (tccom4112s000)

For invoice-to business partners for which you want to raise interest invoices, select the Charge Interest check box. If this checkbox is selected, you can select the Interest Rate Code. This interest rate code is assigned to the business partner. If you specify this value, the Interest Rate Code specified in the Financial Business Partner Groups (tfacr0110m000) session is ignored. The interest rate defined for this Interest Rate Code is used to calculate interest amount on reminder letters and interest invoices.

  • Mapping Scheme (tfgld4573m000)

Use this session to define the mapping of the Interest Invoice/Revenues Analysis integration document type.

  • Interest Percentages (tfacr5102m000)

Use this session to define the interest percentages for each financial business-partner group, and for different periods of days. 

  • Interest Invoice Related Data (tfacr5101s000)

Use this session to define whether interest must be calculated on unpaid invoices, partly paid invoices, interest invoices, and/or fully paid invoices. You can also indicate that LN must take advance payments, unallocated payments, and credit notes into account for the generation of interest invoices.

  • Optionally, set conditions

Example: LN only generates an interest invoice advice entry if these conditions are met:

  • The total of all advice entries in one currency is higher than the allowed minimum amount of an interest invoice defined in the Minimum Amount for Interest Invoice field.
  • The invoice is overdue for a greater number of days than the number of days defined in the Minimum Days for Interest Invoice field.


OPERATIONS: Blocking or Unblocking Warehouses

You can block a warehouse for inbound procedures, outbound procedures, or both. For example, you can block inbound and outbound procedures for a warehouse if the warehouse must be closed temporarily for inspection.

You can impose these types of blockings:

  • Full block: Full block on warehousing procedures.

  • Interactive block: Override blocking allowed except blocks on confirm shipment or confirm receipt.

If you impose a full block on inbound procedures, the receipt and inbound inspection procedures are not allowed for the warehouse.

If you impose a full block on outbound procedures, the outbound, outbound inspection, and shipment procedures are not allowed for the warehouse.

An interactive block on inbound procedures blocks the confirm receipt step. For the other inbound steps (for goods already received), a warning is displayed and you are prompted to cancel the procedure or to continue.

These are the other inbound steps:

  • Generate and release inbound advice
  • Print and confirm storage lists
  • Put away stock

If you perform the outbound steps of a warehouse transfer and an interactive inbound block is imposed on the receiving warehouse, you are warned that the receiving warehouse is blocked.

An interactive block on outbound procedures blocks the confirm shipment step. For the remaining outbound and shipment steps, a warning is displayed and the user is prompted to cancel the procedure or to continue. Assembly, internal inventory movements and inventory adjustments are also allowed.


TECHNOLOGY: Archiving Concept

Companies are developing procedures for entering data into an ERP system and for archiving manuals, drawings, specs, and other hard-copy documents. However, in many cases there is no defined procedures to store historical electronic data. Archiving electronic data should be an integral part of your business processes. 

Generally, archiving is the process of moving historical data from the operational environment to a special archive environment. At home, you might move old bank statements from a closet in your study to a box in the attic. At the office, you might store old hard copies of purchase orders in a room far from your own desk. Just because you no longer need the information in your daily work, does not mean you can dispose of the information. In terms of electronic data in your ERP system, archiving means moving historic data from the operational company to a special archive company; in that way, the historic data will be out of your way and safely stored. To free up disk space on your machine after you have archived the data, you can also move the historic data to an external medium.

Archiving strategy:
Archiving historical data is an irreversible process. After data is moved to the archive company, the data can no longer be uploaded back into the operational company. Archiving has a direct effect on the accessibility and availability of information; therefore, you must define a robust archiving strategy which addresses three major topics: What, When, and Who.

Business requirements:
Your business requirements determine what must be stored and for how long. For example, if you have a warranty situation on your projects for five years, you might be required to keep your project open during this time, or you may keep the project in an archive company. Therefore, if the project must remain open, no project-related information, including orders and integration transactions, can be archived.

Every business manager must decide how long what data must be stored in an operational environment for quick access. Reporting requirements must also be listed.

Legal requirements:
In most countries, legal requirements apply to financial data. Tax authorities may require financial data to be stored for a minimum number of years. Additionally, in specific lines of business such as food and beverages or aerospace, governments maintain specific legal requirements, which impact your archiving strategy.

User requirements:
Users rely on historical information. For example, a customer service employee may need to have shipment information of up to one year in the past to accurately address customer queries. These requirements must also be taken into account when you define what can be archived.

Data to be archived or deleted:
Various parties related to your company use information based on logistical and financial transactions occurring in the past. Before you archive or delete this information, you must investigate the need for the information.

Your ERP system contains standard archiving sessions in all major modules. These sessions are designed to copy historical data to the archive company, and then delete the data from the operational company. 

You have three options in archiving sessions:

  1. Archiving and deleting: Data is transferred to the archive company and then deleted in the operational company.

  2. Deleting: Data is deleted in the operational company, but not archived.

  3. Archiving: Data is transferred to the archive company, but not deleted in the operational company.

Using option 1 or 2 makes archiving irreversible. If you archive only because you want to preview the results, the archiving can be done a number of times.

Usually, in archiving sessions, you can also specify:

  • The date up to which the data must be archived
  • If texts must also be archived
  • If texts that already exist in the archive company must be replaced

In addition to archiving logistical and financial data, you can archive general data. 

Delete sessions:
In all major modules, your ERP system contains delete sessions. These sessions only have delete functionality, no archive functionality. Consequently, they are used to clean up data in the operational company, not to transfer data to the archive company. For more information about these delete sessions, see the "Delete sessions" sections under the various modules. For example, see Delete sessions under Procurement.

After data is deleted using delete sessions, the data is no longer available in the operational company. However, parameter settings may determine whether history data is logged when you remove specific data. If required, you can archive the history using the appropriate archiving session.

When can data be archived?
Based on the answers to the previous question, you can now set a term of retaining relevant historical data in your operational environment, and a term of keeping data available in the archive environment.

Who can archive data?
Because archiving is an irreversible process, a certain risk is involved. For example, what if one of your employees starts up an archiving session by mistake? For this reason, you must determine who is authorized to archive and delete data, and then set up these authorizations with the functionality your ERP system offers.

Because no further changes must be made to archived data, access to the archive company must also be restricted to read-only authorization for most users.

Match strategy with ERP functionality: 
After you list all your requirements, the next step is to verify whether the standard ERP functionality is sufficient to facilitate your needs. Usually, your ERP system provides the functionality to meet all of your needs, but must not force you to compromise. We recommend that you avoid customizing your software, however, because we are looking for long-term operational-data storage, customizations must not be ruled out entirely. An example is the requirement to show, in one report, the data from the operational company and archive company. In the current version, this is not standard functionality, but this can be important to manage your business. What can be even more important, if you are using customized software, is the question of whether the archiving sessions have been included. Do you take into account the fields and tables you have customized? Customized tables and fields may have to be included when performing delete/archive runs.

Archiving plan:
After you define an archiving strategy that suits your requirements, you can define the archiving plan. In this plan, you translate the strategy to a more operational level.

Previous Article Infor LN & Baan Tips & Tricks for Finance: Problem Invoices
Next Article Infor LN & Baan Tips & Tricks for FINANCE: Interest Invoices
Print
30310 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories