Insights
Ghost stock! Buying by the “kilo” but issuing by the “piece”: plugging invisible raw-material leaks with ERP unit-of-measure management
blog
“At month-end, the accounting team comes down to do a physical count and can’t find the 20 ‘aluminum sheets’ still showing in the system! The warehouse team insists, ‘We issued everything in the warehouse to production, honestly.’ Checking the records, there was no theft either… So where did the stock go?
The answer is, ‘It never existed in the first place!’ When purchasing placed the order, it bought in ‘tons,’ and the system had been hard-coded with 1 ton = 1,000 aluminum sheets. In reality, the supplier’s latest lot had sheets that were slightly thicker and heavier than normal, so one weighed ton contained only 980 sheets! Once production had drawn all 980 sheets, the real stock on the floor was gone, but the computer system, using its fixed multiplication formula, kept haunting you with ‘You still have 20 sheets left.’…”
If your factory deals with raw materials that have physical variation, such as steel, fabric rolls, plastic pellets, meat or chemicals, then managing your warehouse with software that converts units of measure (UoM) on a fixed 1:1 basis is creating an enormous “pitfall” for your financial statements.
The “ghost stock” crisis: when the numbers on screen don’t match what’s in the warehouse
Forcing a system that supports only a single unit of measure, or setting up rigid conversion formulas (static conversion), leads to knock-on effects that keep growing:
- Ordering mistakes from misleading numbers (False Inventory Signals): Planners see 20 aluminum sheets left in the system and hold off on ordering a new lot, but when it’s time to set up the machines for actual production, they find “an empty bin,” and the production line stops (line stop) immediately.
- Distorted costing (Costing Discrepancies): When the quantity in the system doesn’t match the shop floor, accounting has to make an inventory adjustment. Writing off these 20 sheets for nothing gets recorded as a “loss from missing stock,” pushing up the company’s total cost for no good reason.
- Being shortchanged by suppliers without knowing it: If you buy industrial adhesive by the “drum” but the system doesn’t also record the receiving weight in “kilograms,” you may be paying full price for drums that were not filled to spec, lot after lot!
Wiping out invisible stock with Multiple UoM and Catch Weight in ERP
A smart factory won’t let small discrepancies eat into its profits. Bringing in ERP (Enterprise Resource Planning) software to control the warehouse removes the limits of complex units of measure through 3 world-class features:
1. Multiple Unit of Measure structure
An ERP can separate units of measure according to how each department actually works, independently of one another yet all on the same database!
- Purchasing (Purchasing UoM): Open POs in “tons” or “pallets.”
- Warehouse (Inventory/Base UoM): The system stores stock and calculates its value in “kilograms” or “liters.”
- Production (BOM/Production UoM): Materials are issued to the machine in “pieces” or “millimeters,” and the system converts back and forth automatically, so every department can work in its own language without the data going out of sync.
2. Catch Weight Management at the point of receipt
This is the secret weapon for industries with high variability! The Catch Weight feature allows a single item of raw material (for example, one steel coil) to have a “different” receiving weight in each lot. When goods arrive, the ERP requires warehouse staff to weigh them (actual weight) and record it together with the piece count, so the system knows that “this lot’s steel coil weighs 5,020 kilograms, not exactly 5,000 as in theory.” When stock is issued to production, the system deducts according to the actual weight of that particular lot, leaving no stray decimals for accounting to lose sleep over.
3. Precise issue of fractional and off-cut material (Fractional & Off-cut Management)
When a 100-meter fabric roll is drawn for sewing and 98 meters are used, the ERP won’t carelessly round the remainder away. It handles the remaining 2 meters as an “off-cut,” which you can set to be returned to the warehouse as a secondary-grade item or written off as scrap, keeping balance management transparent down to the last square inch.
Summary: control your units of measure and you control the money in your pocket
A tiny decimal error, multiplied by a production volume in the hundreds of thousands of pieces per month, can turn into damages in the millions of baht. Investing in an ERP with functions that support complex unit-of-measure conversion (Advanced UoM) and actual weighing (Catch Weight) is the definitive way to plug the leak, helping the numbers on the computer match what’s in the warehouse 100%, and settling the conflict between production and accounting for good.
Try walking to the warehouse today and spot-checking a raw material that involves unit conversion… Do the numbers on paper match exactly what is sitting on the pallet, or is ghost stock hiding there? Raise the accuracy of your warehouse and put an end to unit-conversion problems with your raw materials. Talk to an expert in ERP implementation for manufacturing today!
Theoretical References
- Arnold, J. R. T., Chapman, S. N., & Clive, L. M. (2011). Introduction to Materials Management (7th ed.). Prentice Hall. (Cited for the principles of inventory materials management, control of inventory record accuracy, and the impact of unit-conversion errors.)
- Silver, E. A., Pyke, D. F., & Thomas, D. J. (2016). Inventory and Production Management in Supply Chains (4th ed.). CRC Press. (Cited for the theory of managing inventory with physical variation, and the importance of tracking inventory data by quantity and actual weight (Catch Weight) to reduce variability in the MRP system.)