Inventory accuracy and control
Field notes on cycle count variances, negative inventory, adjustment reason codes, location numbering and replacing the annual physical count.
Scope a project
An inventory record is only useful if the number on the screen is the number on the shelf. The notes in this section deal with how records drift away from reality, how to find out why, and how to set up counting, adjustment and location rules so the drift is caught early and explained.
Where to start
- If counts keep disagreeing with the system, start with investigating a cycle count variance before you adjust. It covers the order of checks, from open transactions to unit-of-measure errors, before anyone posts a correction.
- If the ERP shows stock below zero, read negative inventory in your ERP for the posting sequences that cause it and the settings that stop it.
- If finance asks whether you can drop the year-end count, cycle counting versus the annual physical inventory sets out what has to be true first.
- Adjustments that nobody can explain later are the subject of inventory adjustment reason codes and approval rules.
- And when pickers, scanners and the system read the same location three different ways, designing a warehouse location numbering scheme is the place to begin.
Tools for this section
The inventory accuracy calculator measures the share of count lines within tolerance, the way the ASCM dictionary defines inventory accuracy. The cycle count planner turns an ABC split into counts per day, and the safety stock and reorder point calculators show what an accurate record makes possible.
If you need software that records counts, moves and adjustments with a full audit trail alongside your ERP or WMS, see inventory management software.
Scope your project.
Tell us what you need to track, which systems you run and when it has to work. We reply with questions or a time to talk.