Unit-of-measure mistakes can make a healthy warehouse look inaccurate. A purchase order might be written in cases, a product catalog in kilograms, a count sheet in pieces, and the inventory system in pounds. Before concluding that stock is missing, verify the unit at every step.
Create a master unit table for each item. Record the base stocking unit, purchase unit, sales unit, pack size, and documented conversion factor. For weight-based products, consider the difference between nominal case weight and actual catch-weight, because a fixed case-to-pound conversion may be inappropriate for variable-weight items.
Example one: A box contains 24 pieces. Purchasing receives five cases while the inventory system stores pieces. Correct on-hand addition is 5 × 24 = 120 pieces. If the receiver posts five pieces, the ledger understates stock by 115. A physical recount will appear to show a huge overage even though nothing unexpected was delivered.
Example two: A supplier invoices 10 kilograms while the stock report is in pounds. Using approximately 2.20462 pounds per kilogram, 10 kilograms equals about 22.0462 pounds before considering actual product tolerances. If the system assumes one kilogram equals one pound, reported quantities drift.
Check the conversion at item setup and test it with a known example. Never silently switch among eaches, packs, cases, and weights in a report. Show the unit in the column header or alongside each quantity, and normalize values before summing.
When investigating a suspicious variance, compare purchase-order unit, item receipt unit, transfer unit, sales unit, and count unit. Look for ratios that match common pack sizes. A 12× or 24× mismatch is a strong clue to test, not conclusive proof.
For business controls, approve unit conversion changes, document effective dates, and evaluate whether historical transactions need correction. Fixing only today's item setup may leave old reports misleading.
The takeaway: quantities have meaning only when their units are known. A reliable inventory report should never make staff guess what one unit represents.