Negative distributor stock is usually a ledger problem, not a physical shortage. Check the transaction trail before releasing orders or posting a balancing entry: a missing receipt, duplicate dispatch, unit conversion, return status or location scope can make recorded stock negative while physical stock remains available.
In the example, the report shows minus 80 cartons for a still-water SKU and the warehouse count is 70. Sales wants to release orders; finance wants a balancing entry. Neither reaction is safe until the movements reconcile at the same cutoff.
Treat negative distributor stock as an exception, not a shortage
Physical stock is what can be counted and dispatched. Recorded stock is a sequence of dated movements. A negative closing balance means at least one movement or scope condition is inconsistent. Warning signs include a negative in only one warehouse, a negative after a batch posting, an amount that exactly matches an earlier document, or a balance that changes when another location is included.
Freeze corrections and take a read-only snapshot at a declared cutoff. Do not delete movements or add an unexplained adjustment. Identify the date and transaction that made the running balance negative, then tie every movement to a source document.
Follow this negative-stock investigation sequence
Work in this order so a later correction does not hide the original cause.
-
Cutoff timing
Compare transaction date, posting date, approval time and report time, including time zones. A receipt posted after cutoff, or a dispatch posted before its receipt, can create a temporary negative. Check which document posted immediately before the first negative and whether all approved same-day documents are included.
-
Missing or misposted receipts
Trace the purchase order, gate entry, receiving log, goods receipt note, supplier delivery note and invoice. Goods may be in the warehouse with no receipt posted, or the receipt may be posted to another warehouse, status or unit. Check inspection hold as well.
-
Duplicate dispatches
Look for the same order, delivery note, invoice, vehicle, quantity and near-identical timestamps. Integration retries and manual rekeying can create a second posting. A duplicate dispatch often produces a negative exactly equal to the duplicated quantity.
-
Incorrect units and pack conversions
Check order unit, base unit and conversion factor. If one carton contains 24 pieces, a carton recorded as a piece inflates outbound quantity. Compare the pricing unit with the stock unit.
-
Returns status
Separate the physical return, inspection result, stock status and credit note. A return in transit should not be available to sell. A resalable return may increase stock; a damaged return should be held in quarantine. Confirm whether credit posted without stock, or stock posted twice.
-
Adjustments and opening balances
Review manual adjustments, stock-count postings, write-offs, free-goods issues and opening balance loads. Check the reason code, approver and source count sheet. An earlier unexplained adjustment can make this month’s balance negative.
-
Stock location and ownership
Sum every location: main warehouse, transit, sales van, quarantine, consignment and third-party storage. A negative in one location may be offset elsewhere. Confirm whether the report shows one location or the total network, and whether consignment stock is included.
Hypothetical quantity ledger: a duplicate dispatch turns stock negative
The table is illustrative, not a real customer case. Opening stock is 120 cartons. A receipt of 80 arrives, followed by a dispatch of 150. That dispatch is posted a second time. A resalable return of 20 is recorded.
| Sequence | Movement | Recorded balance | Evidence |
|---|---|---|---|
| Opening balance | +120 | 120 | Opening stock record |
| Receipt R-881 | +80 | 200 | Signed goods receipt |
| Dispatch D-442 | -150 | 50 | Outbound delivery |
| D-442 posted again | -150 | -100 | Same document and quantity |
| Return RT-219 | +20 | -80 | Resalable return receipt |
| Physical count | 70 counted | -80 | Signed count sheet |
The valid documents reconcile to 70 cartons: 120 plus 80 minus 150 plus 20. The recorded balance is minus 80 because the dispatch was counted twice. The 150-carton gap matches the duplicate exactly. This is a transaction-sequence problem, not evidence that 150 cartons were stolen.
Separate a physical shortage from a ledger error
A physical shortage exists when valid documents reconcile to an expected balance and a controlled count is lower, with no unposted or duplicated movement to explain the gap. Investigate unrecorded issues, damage, misplacement, short delivery or shrinkage through a signed recount and source documents.
A transaction-sequence error is different: after the missing receipt, duplicate dispatch or out-of-order posting is reversed, the ledger returns to the physical count. A scope error is also different: the units, stock status, location or ownership boundary is wrong, so the total may be accurate while the available-to-sell view is not. Do not call either one a shortage until the ledger and the count have been reconciled at the same cutoff.
Correct negative stock with authorization and preserve the audit trail
The inventory coordinator should lead the investigation, the warehouse supervisor should witness the count, finance should verify returns and credit, and the channel operations owner should approve the correction. Use this checklist:
- Export a read-only movement ledger at a stated cutoff, including document ID, posting time, user, unit, location and status.
- Attach the signed count sheet and source documents for the first negative transaction.
- Record the root cause, affected quantity, location and the exact correction proposed.
- Reverse an erroneous movement; do not delete or overwrite it. Use a reason code and an approver separate from the requester where possible.
- Recalculate the balance and reconcile it to a fresh count before releasing normal orders.
- Log prevention actions: duplicate-posting checks, receipt posting deadlines, unit master review, return status rules and location mapping.
- Monitor the SKU for repeat exceptions over the next agreed review period.
Do not post an unexplained balancing entry. It hides the root cause, weakens the audit trail and makes the next investigation harder.
DMS evaluation note
Airpalm’s public product description covers mobile visits, route planning, store audits, sales orders, inventory and promotion management. If you are evaluating a distributor management system (DMS), ask for a demonstration of inventory transaction detail, location-level balances, exception handling and permissioned corrections, then confirm supported boundaries in the scope document. The public overview is at airpalm.com.
Frequently asked questions (FAQ)
Is a negative stock balance always a stockout risk?
No. A duplicate dispatch or location mismatch can leave physical stock available while the recorded balance is negative. Check physical availability and the correct location view before promising orders, and treat the balance as unreliable until reconciled.
Should we clear a negative balance with a stock adjustment?
Only after the cause is identified and an authorized approver signs off. A balancing entry can hide a missing receipt, duplicate dispatch or returns error, weaken the audit trail and allow the same problem to recur.
What evidence should be collected first?
A read-only movement ledger for the SKU at a declared cutoff, showing document ID, posting time, user, unit, location and status. Add the signed physical count sheet and source documents for the first transaction that made the balance negative.
Put this guide into practice
This general-purpose worksheet is a starting point. Adapt its fields, responsibilities and rules to your business process.




