Skip to content

Negative Stock in ERP: Does Fixing Quantity Also Fix Cost?

Read this article in ไทย 中文

Negative Stock in ERP: Does Fixing Quantity Also Fix Cost?

Goods have left before their receipt is recorded

A warehouse may physically deliver goods while ERP shows negative stock because the receipt has not yet been entered. That does not necessarily mean goods are missing. However, restoring the quantity to zero does not prove that cost of sales is correct. Check the movement sequence, the cost used by the system and the accounting-period impact before correcting records or routinely allowing negative issues.

The system may value an issue before receipt data is complete

Odoo 19 documentation gives an example: selling before entering the receipt can create negative stock, with the issue valued at the last known cost. A later receipt at a different price causes the outbound value to be adjusted to the actual cost. This describes the cited system, not every ERP version, valuation method or company customization. Verify the version, cost method and actual accounting entries.

Review quantity and value reports separately, retaining the before-and-after receipt evidence from the same test. Correct quantities with an outdated cost can mislead users reading margins for that period. If the accounting period is closed, the accounting owner must determine the correction and effective date from the facts. Do not unlock a period or backdate records merely to remove a negative figure from the screen.

Hypothetical example: the cost difference survives the quantity fix

Assume an item starts with zero recorded stock. Five units are issued using a known cost of THB 100 each, producing an initial issue value of THB 500. The corresponding five-unit receipt is later entered at THB 120 per unit. With no other movements and actual cost as the applicable basis, the issued goods should reconcile to THB 600; the THB 100 difference needs an explanation. This hypothetical example excludes tax, freight and discounts and does not prescribe a universal chart of accounts.

Trace the delivery to its cost record and any system-generated adjustment, including the report date on which the difference appears. Avoid fictitious receipts followed by a second quantity adjustment that corrects the same event twice. If evidence of the actual receipt is still missing, keep a tracked investigation with an owner rather than inventing records to make the numbers look tidy.

Find the cause before choosing a blocking rule

Start with item, warehouse, location, unit, lot and the time the balance became negative. Check for receipts in the wrong warehouse, pending documents or mismatched carton and piece units. If physical counts disagree, use a separate count-investigation and adjustment-approval process. The related Chawinnix stock-count article explains that process; a count adjustment should not substitute for a missing receipt entry without investigation.

Blocking negative stock can stop unexplained movements, but it may disrupt operations if receipts are routinely entered late. Improve the receiving workflow and, where justified, allow exceptions only for authorized users with a reason, evidence and a follow-up deadline. One urgent blocked delivery is not a reason to grant the exception to everyone.

Acceptance must cover quantity and cost

Before rollout, test receipt before issue, late receipt at the same cost, late receipt at a changed cost, returns and cross-period cases in a separate test environment. Review quantity, value, references, approval rights and the reports used by each team. If results disagree, stop expanding permissions and ask the implementer to explain the mechanism. Bring sanitized examples, the costing method and warehouse workflow to Chawinnix to define ERP acceptance criteria based on observed results.

Concept illustration of stock shelves, a ledger and a receiving document linked by review arrows

Sources

Back to all articles

Start the conversation

Tell us briefly what concerns you and our team will get back to you. What you send stays confidential.