INVENTORY INSIGHTS / WHOLESALE & TRADING
Inventory Discrepancy:
System Shows Stock,
Warehouse Can’t Find It
When the system says 50 units but the shelf is empty, the stock rarely vanished. A delivery, transfer or return was usually not recorded on time. Here are 6 causes of inventory discrepancy, 5 fixes and a checklist to use before you adjust stock.

Goods, documents and data must move together.
01 / THE REAL PROBLEM
What Is an Inventory Discrepancy?
An inventory discrepancy is a gap between the stock your system records and the stock on the shelf. Your system calculates stock from posted transactions, so a late, skipped or wrong posting leaves the balance out of step.
Based on posted documents.
What the warehouse can find.
What Sales has already promised.
Most gaps start at the desk, not the rack
Goods often leave before the Delivery Order is posted. Until it is, the old balance stays and Sales keeps selling it.

02 / SIX COMMON CAUSES
6 Common Causes of Inventory Discrepancy
Missing stock is rarely theft. Check these process gaps first.
Goods leave before the Delivery Order is posted. Watch for unposted DOs at day end.
Paper, spreadsheets and chat messages add handovers. Watch for data typed twice.
Scanners only help when every movement is scanned. Watch for rush jobs.
Stock moves between warehouses but is recorded days later.
Selling past the balance to “fix later” distorts cost and reorder data.
Staff are unsure whether the SO, DO or invoice moves stock.
Moving goods between locations? Follow the AutoCount stock transfer guide.
03 / BUSINESS IMPACT
How Inventory Discrepancy Hurts the Business
Sales confirms stock that is not on the shelf.
Staff search for goods or rush emergency transfers.
Delays and cancelled orders.
Urgent buying, transport and overtime.
Reordering stock you have, or missing real shortages.
Wrong stock valuation and delayed billing.
04 / FIVE FIXES
5 Ways to Fix Inventory Discrepancy and Improve Accuracy
Sales, purchasing, warehouse and accounts share the same stock records.
Post deliveries by day end and transfers before goods leave.
Set rules for wrong scans, damaged labels and quantity differences.
Show stock as in transit, received, reserved or quarantined.
Cycle-count fast-moving and high-value items. Investigate before adjusting.
Scan at receiving, not just at dispatch
Scanning confirms the item, quantity and location as goods arrive. It only helps when it is a required step, not an optional one.

05 / CYCLE COUNTING
How to Run a Cycle Count That Catches Inventory Discrepancy Early
A cycle count checks a small group of items often, instead of counting the whole warehouse once a year. It finds gaps while the cause is still easy to trace.
Start with fast-moving, high-value and frequently adjusted items.
Post pending DOs, receipts and transfers for those items before counting.
Counters record what they find without seeing the system quantity.
Trace each gap to a document or location before posting an adjustment with a reason.
Count by location, not just by item
Record the rack or bin with every count. A gap that appears in one location usually points to a transfer or put-away that was never posted.
For a full count, see our stock take guide for Malaysian businesses.

06 / TROUBLESHOOTING CHECKLIST
Inventory Discrepancy Checklist Before You Adjust Stock
Ask where the data stopped flowing, not only where the goods went. Fix that workflow step, then post the adjustment with a reason.
| Check | What to look for |
|---|---|
| Unposted documents | Delivery orders, goods received, returns, transfers and adjustments |
| Location | Branch, warehouse, bin or temporary storage area |
| Reserved stock | Quantities already committed to Sales Orders |
| Transfers | Both sending and receiving sides are complete |
| Negative stock | Items issued before receiving was posted |
| Unit of measure | Piece, box or carton conversions |
| Returns & damage | Posted to the correct stock status |
| Timing | Report time compared with movement time |
Keep the paper trail. LHDN Public Ruling 5/2000 says a physical stock-take should be made at the end of the accounting period, and Public Ruling 4/2000 (Revised) expects companies to keep sufficient records for 7 years. Recording why each adjustment was made helps at audit time.
07 / WHERE AUTOCOUNT FITS
Keep Orders, Deliveries and Stock in One System
The AutoCount inventory system links sales, purchases, transfers and stock by location. Use AutoCount Stock Take for counts and the Stock Availability Report plugin to see stock by location.
Results still depend on a consistent workflow. Software records what your team posts.
Inventory Discrepancy: Common Questions
01What causes an inventory discrepancy?⌄
Usually a delivery, transfer, return or adjustment that was posted late, skipped or entered wrongly, so the recorded balance no longer matches the shelf.
02Should I adjust stock as soon as it does not match?⌄
Not yet. Check unposted documents, locations, reserved stock, transfers, returns and units first. Then adjust and record why.
03Can barcode scanning stop every inventory discrepancy?⌄
No. It reduces entry errors, but only when scanning is required at receiving, picking, transfer, delivery and stocktaking.
04How often should we count stock?⌄
It depends on item count, volume and value. Many businesses add regular cycle counts of fast-moving or high-value items to the year-end stock-take.
05Is negative stock a problem?⌄
Yes. Selling past the recorded balance distorts cost and reorder data. Post goods received before issuing stock.
06How can AutoCount help with inventory accuracy?⌄
AutoCount links orders, deliveries, purchases, transfers, returns and stock by location in one system. Accuracy still depends on posting promptly.
Need Better Inventory Accuracy With AutoCount?
Tell SL Software how your sales, warehouse and stock records work today. We can help you set up an AutoCount workflow that keeps them aligned.
Prefer to read first? See the wholesale inventory management guide.
Continue Exploring Inventory Control
Official sources (checked November 2026):
- LHDN Public Ruling No. 5/2000, Keeping Sufficient Records (Individuals & Partnerships)
- LHDN Public Ruling No. 4/2000 (Revised), Keeping Sufficient Records (Companies & Co-operatives)
General guidance only. Confirm record-keeping duties with LHDN or your tax adviser.