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

BPCS/LX Tip of the Day: Material Requirement Dates and Lead Time Offsets in MRP

Anthony Etzel 0 343 Article rating: No rating

The system automatically performs offsets for requirements dates for components in the MPS/MRP calculations. It also performs offsets for calculation of material need dates at the time that shop orders are released.

To calculate the offset, the system takes the parent lead time from the Item Master and adjusts it by the bill of materials offset (plus or minus) for the component. This gives the lead time days for that specific component. The system starts with the due date of the parent and backs up and skips all non-work days in the shop calendar.

 

Note that the offset calculation uses only calendar records that have a blank work center (the calendar record applies to all work centers). See the information for the Shop Calendar Maintenance program, SFC140, in your Shop Floor Control documentation for shop calendar details.

Baan/LN Tip of the Week: Database Sizing – Moving to LN

Kathy Barthelt 0 219 Article rating: No rating
The Infor LN database must be created with the appropriate size. For example, if at least 150 GB is required for a year, create the database with the required size from the beginning. Do not let the size increase to the required size and cause additional fragmentation in the database and the NTFS volume.  Set the autogrowth to a minimum of 10 percent or 1 GB (for each extent) to avoid fragmentation on file system level. Never use the default extent size of 1 MB.

How Do You Measure Success in Your Business?

Anthony Etzel 0 52951 Article rating: 5.0

Business owners may measure success in different ways – some tangible, some intangible.

In order to establish how you should measure success for your business, you need to first examine how you measure your personal success. If you are a business owner, or a part of the management team of the company you work for, ask yourself these questions to see how you measure up:

Assess personal success.

1.    Am I happy in my job?

2.    Do I have passion for what I’m doing?

3.    Do I get the desired results based on the effort I’m putting in?

4.    Am I putting forth my best effort?

5.    Am I patient and allow for sufficient time to see results?

6.    Do I get respect from my co-workers?

7.    Do I have the endurance to hang in there when things get a bit rough?


Reflect on successes and failures.

After answering these questions, do you need to make any changes? Do you still have the same ambition and drive to achieve the goal? Are you content with your work, or have you come to the conclusion that you have not done your best?

To be successful...

Baan/LN Tip of the Week: Switching to a Difference Series

Kathy Barthelt 0 204 Article rating: No rating

In general, you can enter a different series in the order field if you have an available series.

To add a new series, find the appropriate group in the First Free Number session, and add a new series and first free number (usually 1).

In Baan IV, go to the Maintain First Free Numbers Session (under Common, Tables, Maintain Logistics Tables, Maintenance 1). Groups are easily identified (e.g., Purchase Order, Sales Order, etc.).

In Baan V, go to the First Free Number Session (under Common Data, Tables, Logistics). There are number groups (e.g., 570 may be for Purchase Orders, 650 may be for Sales Orders, etc.).

In LN, go to the First Free Number Session (tcmcs0150m000 – it is in different places in the menu under different Feature Packs). There are number groups (e.g., 210 may be for Purchase Orders, 310 may be for Sales Orders, etc.).

BPCS/LX Tip of the Day: MRP/MPS Simulation

Anthony Etzel 0 786 Article rating: No rating
The system allows you to manipulate and maintain a simulated MPS and MRP. You can copy the simulation from the existing first cut or you can create a totally new schedule. You can also perform a simulation of the rough-cut capacity plan. This allows a quick visual inspection by inquiry or menu of needed work center loads for the proposed MPS. After you choose a suitable MPS and rough-cut capacity, the system allows you to transfer the simulated MPS to the live Master Production Schedule.

BPCS/LX Tip of the Day: Inventory Stocking Levels – LX

Anthony Etzel 0 735 Article rating: No rating

The system supports four levels of inventory. You can view summaries of stock at each level through the Material Status Inquiry program or through reports.

 

Below are the four levels:

▪  Item

▪  Item + warehouse

▪  Item + warehouse + location

▪  Item + warehouse + location + lot

 

The lot number level and/or container of inventory can cross multiple warehouses and locations. For example, item + lot or item + lot + container. Locations exist within warehouses. There is no limit on the number of warehouses, locations, or lots that you can assign to an item.

Baan/LN Tip of the Day: Transfers - LN

Kathy Barthelt 0 2779 Article rating: No rating
A Transfer involves either one or two warehouses. If items are transferred between two different warehouses, all activities of the warehousing procedures must be carried out. However, if a transfer takes place between two locations within the same warehouse, the receipt activities are not carried out. You can use transfer orders to define a replenishment system within a single warehouse. This system controls replenishment from bulk locations to pick locations. Note: LN allows you to modify the outbound order line data based on the value the Allow Updating Outbound Order Lines up to and including field is set to in the Warehousing Order Types (whinh0110m000) session.

BPCS/LX Tip of the Day: LX Inventory Pallet Status Flow

Anthony Etzel 0 49973 Article rating: No rating

Four fields in the Item/Warehouse record (IIW file) affect the disposition of the

pallet status.

 

1.  Goods Receiving Code: You define these codes in Goods Receiving Maintenance (WHM130). The codes control whether or not the stock passes through inspection, what percentage, or quantity of a delivery to inspect, and the number of quarantine days, if any.

 

2.  Inspection Zone/Inspection Location: Either the Inspection Zone or the Inspection Location must be entered on the Item/Warehouse Master Maintenance screen WHM150D2-01.

 

First112113114115117119120121Last

Tips:  LX | BPCS | M3

Improves control over PO costing changes during invoice entry by replacing passive warnings with an intentional override action.

  • In ACP500D3 (Invoice Entry PO Costing), users previously could unintentionally accept changes by pressing ENTER, even when quantity to cost or amount to cost values had changed.

  • A new “F14 to Override” warning message replaces the old message:
    “Details have changed. Press enter again to accept data.”
    This ensures users acknowledge and confirm significant changes explicitly.

New System Parameter:

  • “Apply GRN Costing Tolerance for PO Costing” (optional):

    • Within tolerance: Displays the original message —
      “Details have changed. Press enter again to accept data.”

    • Outside tolerance: Triggers the new override requirement —
      “F14 to Override”

Benefits:

  • Enhances oversight and reduces unintentional cost acceptance.

  • Enables better control of PO costs when invoice details differ from expectations.

Last

Tips: LN | Baan

George Moroses

Infor LX & BPCS Tip: PowerLink

PowerLink is a Windows-based client for end-users within the Infor Development Framework (IDF). PowerLink allows exports/imports from/to the ERP database, but how much do you really know about it? Here is some helpful information about PowerLink.​

Why does PowerLink sometimes fail to export all records?
There's not a finite amount of records that PowerLink can export. However, PowerLink export was never intended to handle large volumes of data. It was designed as a quick snapshot of a fairly small subset and a simple view of the user's PowerLink card. 

What is the maximum amount of data that can be exported?
The maximum number of records is only limited by the system resource like memory, etc. When the system runs out of resources, an OutOfMemory error should occur. In previous testings, we have exported +1 million records, although the size of records differs greatly between business objects, the total size of the data could be an issue. For larger volumes of data, customers should investigate other tools such as the iSeries Access "Data Transfer from iSeries Server" feature to download directly to Excel.

How do I know if the size of the data is an issue?
1. When exporting to an external file (text, HTML) then importing to Excel: You can easily check the output (text, HTML) to see if the intermediate output has all the records. This can be done by visual inspection or through the use of column totals. Simply compare between the output and what you see in PowerLink. If the exported file has all the records, then the problem is definitely Excel.
2. When exporting to clipboard, then copy/paste to Excel: There is a clipboard export size limit that is controlled through client preferences. Check the exported data in the clipboard, and see if it contains all the records or only partial records due to the size limitation set in client preferences. If limited, change the client preferences using Customize from the Main browser > Preferences > Miscellaneous tab > Limit Clipboard Export, and try the export again. If the clipboard has all the records the problem is in Excel, which we don't have jurisdiction over.

Suggestions for improving the export process. 

  1. Reduce the number of columns seen in the view. This will serve to reduce the data being exported and may increase the number of records that can be exported. 
     
  2. Reduce the complexity of the view. If the view has one column that lives on a related object, then it has to build SQL behind the scenes to get that related record. If all of the columns come from a single business object, then the processing will be significantly faster.
     
  3. Export to HTML, which can be opened directly by Excel, Access, and many other programs. This reduces the processing of the export formatting because PowerLink needs only to put begin and end tags around each data element. This will also preserve column alignment when Excel or other programs open the file.
     
  4. Unless you are exporting a fairly small volume of data, export to a file, not clipboard. Clipboard is held in memory until the entire view is read, and records are written to the file as they are retrieved.
     

 Also see KB 1357068 for more information about testing your view.

Print
50004 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories