On a Friday afternoon, the production manager at a 70-person precision machining shop opened the stockroom door and couldn’t find 300 brass fittings the system said were on the shelf. He checked again — same screen, same number. The fittings were simply not there. That moment started a six-week ERP Consulting engagement that changed how this shop runs.
Why the inventory numbers kept lying to us
Three root causes surfaced quickly. The receiving team counted parts by hand and entered numbers hours later, so the system and the shelf never matched. Second, the shop used three different naming conventions for the same part — one for purchasing, one for the lathe operators, one for shipping.
And third, nobody ever did cycle counts. The annual physical count happened in December, and by February the numbers were fiction again.
The ERP Consulting team asked a blunt question: if you can’t trust your stock count, how do you know which jobs to schedule next week? The answer was, we didn’t. We were buying parts we already owned and stalling jobs that had plenty of material.
The fix cost $0 in software and took 30 days
We didn’t buy anything new. We changed four processes and stuck to them.
- Receiving counts at the shelf, not the desk — within 30 minutes of delivery, not end of day.
- One part number per part, enforced everywhere, with the ERP Consulting team mapping the old codes to the new ones.
- Cycle count 20 SKUs every Friday, rotating through the full list six times a year.
- A “material hold” flag for any part with a count variance over 2%, so nobody plans around a bad number.
What 30 days of discipline changed
After one month, inventory accuracy went from 88% to 96%. After three months it hit 99.1% and stayed there. We stopped an estimated $38,000 in duplicate purchases over that quarter, and job scheduling became calm. The production manager now checks Friday cycle-count results like he used to check sports scores.
The lesson worth passing on: inventory accuracy is a behavior problem, not a software problem. But good ERP Consulting gives you the exact routine to make that behavior stick. If your stock numbers feel shaky, run one cycle count next Friday and watch what turns up. I suspect you’ll be surprised too.