An inventory discrepancy is not just a problem for the warehouse team. When physical stock differs from the quantity recorded in the system, a company may invoice products that are unavailable, tie up cash in unnecessary purchases, or make production decisions based on wrong data. The question of why physical stock differs usually comes up late, when the financial and operational impact is already visible.
For a growing organization, stock should be treated as critical operational information, not just as the outcome of the annual stocktake. Discrepancies can point to process errors, a lack of discipline in recording documents, traceability issues, or ERP settings that don’t reflect the way the company actually works. The first step is not to correct the quantity, but to identify the cause.
Why physical stock differs from system stock
Stock in the ERP is the result of every documented movement: receipts, deliveries, transfers between warehouses, returns, production consumption, adjustments and stock counts. Physical stock is what is actually in a location at a given moment. The two figures only match if every physical movement is reflected in the system correctly, completely and on time.
The most common explanation is the time gap between the physical operation and the document that records it. Goods may be received in the morning, but the goods receipt is posted in the afternoon or even the next day. During busy periods, products may leave the warehouse before the delivery is validated. The discrepancy is temporary, but it becomes risky if reporting and planning rely on data that hasn’t been updated.
A second cause is incomplete documentation. Transfers between warehouses, picking zones, sites or production locations are often handled informally. A pallet is moved to free up space, and the movement is never recorded. In the system, the product exists, but it is assigned to the wrong location. For the team preparing the delivery, the product appears to be missing, even though it is on the premises.
Unit of measure errors also cause discrepancies that are hard to explain. A supplier delivers boxes, the warehouse counts pieces, and sales are made by the set or by the metre. If conversion factors are not defined correctly or are applied manually, the system may show quantities that look plausible but are wrong. This risk is common in distribution, retail, construction, manufacturing and fashion, where packaging, variants and sizes add complexity.
Causes that go beyond the warehouse
Stock discrepancies are not always the warehouse manager’s responsibility. They can arise where purchasing, sales, finance, production and logistics meet. For example, a goods receipt without a quantity check carries the supplier’s error into the internal records. An urgent delivery made before the order is confirmed creates a physical outflow with no document behind it. A customer return stored separately, without an inspection and restocking process, stays outside the real available stock.
In production, the cause may be unrecorded consumption, or consumption recorded according to the theoretical bill of materials even though what happened on the shop floor was different. Scrap, process losses, substituted materials and semi-finished products must be captured within the process. If these exceptions are managed in separate spreadsheets or through verbal communication, the ERP no longer gives a true picture of availability and cost.
Some discrepancies are caused by master data. Duplicate item codes, similar descriptions, unclearly configured colour or size variants, and locations created without rules can lead to postings on the wrong item. When the same goods have two codes, the stock count may confirm they physically exist, while the sales report shows a shortage on one code and a surplus on the other.
Real losses should not be ignored either: damage, expiry, theft, improper handling or picking errors. They don’t disappear if they are postponed until the annual stocktake. On the contrary, failing to record them quickly hides costs and makes it hard to establish accountability. A company with good control does not automatically assume that every discrepancy is an administrative error; it validates the facts through traceability and documented checks.
How to investigate inventory discrepancies properly
A stock adjustment fixes the report for the moment, but it doesn’t fix the process. The investigation should start from the item, the location and the period in which the discrepancy appeared. If discrepancies recur for the same products, in the same warehouse or around the same types of documents, there is a pattern worth analysing.
An effective check compares the physical path with the path in the system. For an item with a discrepancy, the team should be able to answer clearly: when the goods came in, where they were stored, whether they were moved, reserved, delivered, returned, consumed or adjusted, and who validated each operation. If the answers depend on people’s memory, control is insufficient.
Cycle counting is more useful than waiting for the full stocktake. High-value items, fast movers, products at risk of expiry or with many variants should be counted more often. The frequency depends on the company’s profile: a distributor may prioritise high-turnover items, while a manufacturer may focus on critical raw materials and semi-finished goods. What matters is that the count leads to analysis and corrective action, not just to accounting adjustments.
To reduce the sources of discrepancies, a few clear operational controls are needed:
- receipts and deliveries are validated at the moment the goods are physically checked;
- transfers between locations are always documented, including temporary movements;
- items, units of measure and barcodes are governed by a single set of rules;
- access to stock adjustments is restricted and approved by role;
- discrepancies are reviewed regularly by cause, location, item and user.
These controls need to be calibrated. A process that is too rigid can delay deliveries, while one that is too permissive will produce unreliable data. The goal is for operational speed to be supported by simple rules that people accept and can easily apply on the ground.
The role of an ERP in controlling physical stock
A properly configured ERP does not replace warehouse discipline, but it turns that discipline into a measurable process. SAP Business One can centralise stock movements, sales and purchasing documents, financial data and inter-warehouse operations, so that all teams work from the same version of the information. The result is not just a more accurate quantity, but a better basis for purchasing, commitments to customers and margin control.
The real value comes when the system reflects the company’s processes. In retail, integration with points of sale and variant control matter most. In distribution, the priorities are locations, scanning and delivery flows. In manufacturing, consumption, bills of materials, batch traceability and production reporting must be aligned with what happens in the plant. A standard implementation without process analysis may simply move the problem from Excel files into an ERP.
Reports should help managers quickly spot exceptions: items with recurring discrepancies, unusual adjustments, negative stock, movements without related documents, or slow-moving stock. Instead of a reactive check at month-end, the company can intervene while operations are running. That is the difference between record-keeping and control.
At Serra Software, SAP Business One projects start with an analysis of how goods and information flow between departments. Configuration, integration, data migration and user training must all serve one common goal: data that management can rely on to run operations with confidence.
Accurate stock, safer decisions
Physical stock that differs from the records is not an inevitable side effect of doing business. It is a signal that there is a gap between real operations and the digital process. Sometimes the cause is a one-off, such as a delayed goods receipt. Other times, the discrepancy reveals a broader issue of accountability, configuration or collaboration between departments.
Companies that treat every discrepancy as management information reduce their losses, improve product availability and plan more accurately. Your next stocktake shouldn’t just be the moment you correct the figures, but an opportunity to make the process that produces them easier to control.
