Warehouse Inventory Does Not Reconcile? Trace Material, Containers, Documents and Time

How to Investigate Discrepancies in Warehouse Inventory? Trace Materials, Containers, Documents, and Time

At the end of the month, the system shows 120 units, but only 116 are found on the shelves. The warehouse staff checks the inbound and outbound records, the workshop claims the materials have been returned, and procurement says the supplier replenished the stock. Everyone is explaining, but the discrepancy only becomes more confusing.

The biggest risk in inventory discrepancies is to adjust the inventory numbers immediately. If the numbers are smoothed out, the real issue could be a mistransfer, unpacking, return, or re-entry event. If the same chain breaks again next month, the inventory will once again diverge.

A more effective method is to cross-check along four lines: physical items, containers, documents, and time. The point where these four lines intersect is usually where the discrepancy occurs.

What is the real thing?

First, confirm the material code, specifications, batch, and status. Do not just count the number of boxes that look similar. Conforming, pending inspection, nonconforming, returned, and customer-supplied materials, even if placed in the same area, should not be combined into one inventory count.

Randomly check the smallest packaging quantity. If the label on the box states 20 units, the actual number inside may not be 20. If the loose items are still counted as a full box, the discrepancy will be hidden by the packaging appearance. For high-value or high-risk materials, it is necessary to trace down to the batch or individual item level.

Where is the container now?

Assign a verifiable identity to each pallet, tote, rack, and storage location. During inventory counts, record both the container and actual storage location where the material is located, to prevent discrepancies when a pallet moves between temporary storage, line-side warehouse, and main warehouse, with only one record being updated.

The GS1 traceability standard emphasizes object identification and event recording granularity. Containers are merely carriers and must be able to identify what is inside; storage locations are positions and must be able to indicate when an object enters or leaves. Scanning only storage locations without scanning objects may still result in empty locations being counted as inventory.

Does the document have a closed loop?

Investigate discrepancies by checking documents in the direction of the difference. If physical inventory is less than system records, prioritize checking whether material issuance, transfer, unpacking, scrapping, and shipping have occurred but not posted; if physical inventory exceeds system records, prioritize checking whether receipt, return, replenishment, and temporary inventory gains have not been recorded.

Do not only check whether documents exist, but also verify quantities, batch numbers, source locations, target locations, and business status. Created but not submitted, submitted but not approved, and approved but not executed represent three distinct shop-floor realities.

When did the incident occur?

Start from the last point where inventory records matched reality, and sort events such as receipt, shelving, transfer, material issuance, return, and inventory count by time. The EPCIS method used by GS1, which describes business events with what, when, where, and why, is well-suited for reconstructing the material movement path.

Pay particular attention to cross-shift movements and month-end cutoffs. If the night shift moves material and the day shift records the transaction later, or physical stock moves before the count while documents are approved afterward, the same material can appear ‘correct’ under two different time cutoffs.

Four more questions before closing the difference

Have the objects and batch numbers been confirmed? Have the containers and storage locations been verified? Is the document status closed-loop? Are the event times aligned? Before these four points are aligned, only a pending investigation can be marked, and an adjustment sheet cannot be used to replace the root cause.

This approach is suitable for growing factories with main warehouses, line-side warehouses, and multi-shift operations. Owners can require the warehouse to summarize where discrepancies occur each week, rather than only focusing on inventory accuracy. Otherwise, to make the numbers look better, it's easy to first adjust the accounts and then look for reasons afterward.

Small, loosely managed factories can start by managing high-value materials. Medium-sized growing factories should address cross-warehouse and cross-shift events. Large or mature factories should prevent rigid boundaries in responsibilities. Not all warehouses need to achieve single-item tracking in one step.

Factory owners should also clearly define handling permissions: up to which step can the warehouse staff investigate, when should the team leader take over, when should finance close the case, and to whom should major discrepancies be escalated. If errors are proactively identified, it may lead to accountability issues, and shop-floor personnel may say 'it's not my responsibility,' eventually leading to a situation where more work leads to more errors and less work leads to fewer errors.

Turn these four lines into a checklist. Each time a discrepancy occurs, follow the same order for verification and review. This allows the plant manager to forward the checklist to the warehouse and shop floor for execution, and also prevents arguments based on experience when inventory discrepancies occur.

I am Huang Chaoxing, the inventor of the TreeMES stack-light MES system. Follow me for more practical factory-management methods.