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: Infor LX & BPCS Cycle Counting Selection Process

The cycle counting sub-system in Inventory Management determines which items are selected for cycle counting based on the following criteria:

  1. Cycle Counts/Year: The system calculates the cycle count frequency for each item using the "Cycle Counts/Year" field in the Item Master file (optional).

  2. Last Cycle Count Date: If you use locations, this date is found in the Location Inventory file (ILI), and if you don't, it's in the Warehouse Inventory file (IWI).

The system adds the calculated cycle count frequency to the last cycle count date. If the result is less than or equal to today's date, the item is selected for cycle counting. If it's greater, the item is not due for cycle counting yet.

Additionally, an item is automatically selected for cycle counting if the Cycle Flag field in the ILI/IWI record contains 'Y.' This flag indicates that the item's on-hand balance has gone negative since the last cycle count, even if it's not negative at the time of selection. The programs INV500D, INV510, and BIL540 can set this flag.

You can further narrow down the selection of items by specifying item number or warehouse limits.

Previous Article "Apologies, boss, but at the moment, we are unable to contribute to advancing the business."
Next Article Infor LX & BPCS Tip: How to handle “ZERO COST” items
Print
23133 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Users can now freeze period-end balances at the end of a fiscal period. You can now store the opening/ending on hand balance for each Inventory period at the Item (IIM), Warehouse/Item (IWI) and Lot/Location (ILI) levels. This information can then be used for inventory tracking and valuation purposes, as well as other ad hoc financial and audit reporting requirements. Infor LX clients can backdate inventory transactions into the immediate previously closed period, and thus update what was saved as the opening/ending balance throughout the current open period.

FirstLast

Tips: LN | Baan

Categories