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

George Moroses
/ Categories: Infor LX & BPCS Tips

Infor LX & BPCS Tip: Inventory Stocking Levels – Warehouses, Locations and Lots…Oh My!

The Infor LX system supports 4 levels of inventory. You can view summaries of stock at each level through the Material Status Inquiry program or through reports. Below are the 4 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.

Multiple Warehouses
You can assign as many warehouses as needed for any item. You can designate each warehouse as allocatable, allowed for order processing, or non-MRP, not used in the MRP netting logic. This allows your business to set up staging areas and quarantined warehouses. The warehouses can be physical or logical warehouses.

Multiple Locations
You can assign as many inventory locations as needed for any item. The location number is six characters long. This allows you to define sub-locations within a location, which can be an aisle, bin, or row.

The system stores item-warehouse combination inventory and allocation data. Optionally, sales history is available by item and warehouse in sales by units for the past twelve months. Total monetary amounts of sales by warehouse are also available in year-to-date, the last twelve months individually, and previous year-to-date.

Lot Inventory
On an item-by-item basis, the system requires the input of and performs tracking of lot numbers by inventory transaction. The system supports forward and backward lot traceability. The system provides inquiries and reports for the stock, allocation, and movement of inventory by lot. The system also automatically supports shelf life, expiration date, and reject data for each lot. The system automatically uses the expiration date in this allocation logic and MRP logic.

Previous Article Need Knowledgeable ERP Staff Quickly?
Next Article Tim Baker – Infor LX User Group’s Newest Board Member!
Print
20697 Rate this article:
4.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

You can create new macros in the Infor LX Configurable Enterprise Financials CEA107. 

On the Macro Definition window, you define the source file and the field in which you perform an arithmetic or special operation. For example, you can create a macro to accrue sales commission based on revenue. Your source file and field are the Invoice Line History (SIL) file and the G/L revenue (ILREV) field. 

Select Functions to access the Macro Functions window, on which you define the arithmetic, character, or special operation to process against the defined source field. In the previous example of accrued sales commission, you enter an arithmetic operation of multiply (*) and an operand value for the percentage, such as 0.05 for five percent. 

Note:  Previously created user defined macros will have to be updated to include any expanded field sizes in V84. 

To utilize the Security Rules Optimization feature, a system administrator can assign security codes to 100 pre-defined user groups. User groups are created in the Group Security Maintenance (SYS603) program. All users assigned to this group possess the same level of security.   

A system administrator can assign security codes for up to 100 of the user groups. All user groups over 100 are still administered by all security reject/allow rules assigned to them but are not able to utilize the optimized process. 

Each of the security codes and access levels are assigned to user groups and are mapped to the account strings and stored in the Account Cross Reference (CEA106D1) file.   

Once security codes have been assigned, the system administrator must: 

  • Determine which level each group is allowed access.

  • Determine which segment values/account strings are assigned to which user groups.

  • Create security rules for specific segment values/account strings and assign these groups to the created rules.

  • Select the rules to be processed.  Processing can be done in either batch mode or interactively.

  • The Security Rules flag must be on in the CEA Control Parameters program before any rules are effective. 

FirstLast

Tips: LN | Baan

To create a purchase order (with subcontracting) third party outsourcing from purchase order, execute these steps:

  1. Create a purchase order using the same data set defined in the Subcontracting Models (tisub1100m000) session.
  2. In the Purchase Order Intake Workbench (tdpur4601m200) session, click New. The Purchase Order (tdpur4100m900) session is displayed.
  3. ...

Categories