Negative Stock and Stock Adjustments
In ERPNext, negative stock occurs when a delivery or stock issue is recorded before the system has sufficient incoming stock. This usually happens when users enable the “Allow Negative Stock” option in Stock Settings to complete urgent dispatches even when inventory is not yet updated.
While this allows operational flexibility, it can lead to valuation inconsistencies and requires automatic stock adjustment entries when actual purchase or stock receipt entries are recorded later.
1. Typical Business Scenario
In real-world operations, companies often dispatch goods first and record purchase receipts later. This creates a temporary mismatch in stock valuation.
For example, an item may be delivered to a customer even though the system shows zero stock. To proceed, ERPNext forces the user to enter a valuation rate manually, which is often a temporary or estimated value.
In such cases, the system assumes a provisional cost to complete the transaction, even though actual procurement cost is not yet recorded.
2. Example Flow of Negative Stock
Let’s understand the process step by step using a simple scenario.
- An item “Testing Item Stock Adj” has no available stock in the system.
- The user creates a Delivery Note and is forced to set a valuation rate (e.g., 100) to proceed.
- Since no stock exists, ERPNext records the stock as negative and uses the provided valuation rate for accounting entries.
- A Purchase Receipt is created later with the actual purchase rate (e.g., 300).
3. Why Stock Adjustment Happens
When the purchase entry is posted after the delivery, ERPNext must reconcile the difference between:
- The earlier assumed valuation rate (used during delivery)
- The actual purchase cost (recorded later)
Since stock was already issued using a lower or estimated cost, ERPNext cannot simply overwrite past transactions. Instead, it creates a stock adjustment entry to correct valuation differences.
This adjustment ensures that stock quantity remains correct while financial books reflect accurate cost distribution.
4. Impact on Accounting and COGS
When the system detects a difference in valuation, it posts the gap into a Stock Adjustment / COGS account.
- If purchase cost is higher than delivery valuation, additional expense is booked.
- If purchase cost is lower, the system reduces expense accordingly.
This ensures that the Cost of Goods Sold (COGS) reflects the most accurate cost over time.
5. Reposting and Backdated Correction
ERPNext uses a reposting mechanism to correct historical valuation when backdated transactions are entered.
- If the purchase receipt is backdated before the delivery note, valuation is recalculated.
- The system updates the original delivery valuation from estimated cost to actual cost.
- Stock and COGS values are then corrected automatically across linked entries.
6. How to Avoid Stock Adjustment Issues
- Avoid using Allow Negative Stock unless necessary for operational urgency.
- Always enter purchase receipts before or close to dispatch dates.
- Use proper stock planning to ensure stock availability before sales transactions.
Maintaining correct transaction sequence (Purchase → Stock Receipt → Delivery) ensures accurate valuation without requiring adjustment entries.
7. Key Takeaway
Negative stock is a temporary operational workaround, but it introduces valuation corrections later. ERPNext handles this automatically through stock adjustment and reposting logic, ensuring financial accuracy even when transaction timing is not ideal.
