Skip to main content
Investigate stock discrepancies when the system does not match the physical warehouse, negative stock appears, or a location shows unexpected quantities. Do not correct the balance before investigating. First identify which movement is missing or was recorded incorrectly.

​
Interpret stock

A stock query answers three questions: how much is physically present, how much remains free to commit, and what will remain after expected receipts and issues. Use physical stock for counts and warehouse tasks. Check available stock before committing quantities to a customer. Use projected stock to anticipate purchases or manufacturing.

​
Diagnosis

1

Narrow down the problem

Identify the affected item, location, lot, package, and unit of measure.
2

Check current stock

Check the balance by location and lot. Look for stock elsewhere.
3

Review movements

Sort recent movements and locate receipts, issues, adjustments, counts, consumption, or shipments.
4

Find pending documents

Check for receipts, shipments, production, stock counts, or internal movements pending recording.
5

Compare with the warehouse

Physically validate location, lot, package, and quantity before correcting.

​
Query by item, location, or lot

If physical stock exists but availability is low or negative, review confirmed orders, expected consumption, and reservations before moving materials.

​
Review movements

Stock movements explain why a quantity changed. Each receipt, shipment, consumption, manufacturing run, adjustment, or stock count leaves records you can review. Path: Warehouse > Stock control > Stock history Stock history shows changes for all items and locations over a period of up to one year. The Cause column lets you open the receipt, shipment, stock count, or order that originated the change if you have permission to view it. Without that permission, Bold shows only its identifier. If the item uses lots, enable Include lot reclassifications to also see lot reassignments and merges. Start from the last point when stock was correct. To find it, query the item’s stock at date on several dates. From there, follow movements by date and open related documents before adjusting.

​
Correct

Avoid compensating discrepancies with adjustments when an actual receipt or issue remains unrecorded. An adjustment balances stock but does not explain the process that happened.

​
Negative stock

Negative stock usually indicates that an issue was recorded before the receipt covering it. First review:
  • pending purchase receipts;
  • unrecorded production;
  • consumption from an incorrect lot;
  • shipments from an incorrect location;
  • unclosed stock counts;
  • omitted internal movements.
Do not treat it as a normal balance. If an actual receipt is missing, record it through the correct workflow. If the problem was an incorrect shipment, consumption, or lot, use reversal where available. Adjust only when you cannot confidently reconstruct the actual movement.