A machine shop with 40 employees had 11,000 parts on their shelves but could not tell you what was actually there. Sound impossible? It happens more than you think. The owner once told me he ordered 200 brass fittings because the spreadsheet said they had 40 left. After the order arrived, they found 180 sitting in a bin behind the lathe.
Where the Real Money Was Leaking
The problem was never the machines. It was the gap between what paper said and what the floor had. Workers wrote down part numbers by hand, some bins got mislabeled, and nobody updated the system during the middle of a batch run.
ERPNext Consulting started with a physical count, not a software demo. We counted every bin over two weekends and found the stock records were off by an average of 18 percent. That 18 percent meant thousands of dollars in duplicate purchases every single quarter.
What We Changed in the First 30 Days
- Every part got a bin location code, not just a name, so workers could find things without asking
- Production staff got a simple handheld scan routine, scanning parts in and out at each machine step
- Reorder points were set using actual usage from the last six months, not guesses from the old spreadsheet
The discipline took three weeks to stick. The owner said the hardest part was stopping people from just writing on paper and asking them to scan instead. Once the routine became normal, the stock record accuracy climbed above 96 percent.
The Number That Convinced the Owner
In the first full quarter after the ERPNext Consulting rollout, the shop cut its emergency material purchases by more than half. They stopped buying parts they already owned and started using the money for a second CNC machine instead.
Here is the part most people ignore. The system only works if someone owns the data. They assigned one person to check the mismatch report every Friday morning. That single habit kept the accuracy from sliding back.
If nobody owns the cleanup, any system drifts back to chaos within three months.