On the last day of the month, your team ships 1,000 cases to an important customer. The product was made on time and loaded on the truck. The production receipt, however, will not be entered until Monday.
When finance reviews the month, that invoice shows a gross margin far higher than any other. The system shows finished goods stock of minus 1,000 cases. And next month, the same product appears to lose money.
Nothing went wrong on the warehouse floor. The goods existed, and the customer received them. What went wrong is the order in which transactions were recorded, and the cost the system had to use when it found no stock to draw from.
For manufacturers and distributors, zero and negative inventory is one of the most common, and least understood, causes of unreliable COGS. In our article on CapEx, OpEx, and COGS, we explained how stock valuation, stock accounting, and accounting codes work together to produce cost of goods sold. In our article on FIFO, LIFO, and average cost, we compared how each valuation method assigns cost. This article looks at what happens to all of that when the system has no stock to value.
Why does zero inventory affect COGS and manufacturing costs?
The short answer: when stock is issued, most valuation methods value it using the stock on hand. When there is no stock on hand, the system has to find a cost somewhere else.
Every issue of inventory needs a cost:
- A sales shipment needs the cost of the finished goods, which becomes COGS.
- A material issue to a work order needs the cost of the raw materials, which becomes work in progress and, eventually, the cost of the finished product.
- A production receipt needs the accumulated cost of materials, labor, and overhead, which becomes the value of finished goods inventory.
Under FIFO, the cost comes from the oldest receipt layers. Under weighted average, it comes from the running average of stock on hand. Under standard cost, it comes from the standard. When stock reaches zero, valuation methods that rely on existing stock values or receipt layers may no longer have a directly available cost basis for the next issue. Sage X3 then applies the configured valuation rules, which may include standard costs, alternate valuation methods, or other permitted fallback values.
In most businesses, zero or negative stock in the system does not mean the shelves are empty. It usually means a transaction has been recorded out of sequence:
- Materials were consumed before the purchase receipt was entered.
- Finished goods were shipped before the production receipt was entered.
- A backflush consumed components that had not yet been transferred to the production location.
- A stock count adjustment, unit of measure error, or lot mismatch left the system short of what is physically there.
The physical operation is correct. The cost record is not, at least temporarily. Whether that temporary gap becomes a permanent error depends on how the system is configured and how quickly it is corrected.
How does Sage X3 value a movement when stock is zero?
In Sage X3, four settings largely decide what happens when an issue finds no stock:
- Whether negative stock is allowed. If it is not, the transaction is blocked until stock is available. If it is, the issue goes through and the stock balance becomes negative.
- The valuation method. The primary method on the product-site, such as standard cost, FIFO, weighted average, or average lot cost, decides which cost the system looks for first.
- The alternate valuation. When the primary method has no cost to offer, Sage X3 can fall back to an alternate valuation defined on the valuation method, such as standard cost or last cost.
- Whether a null cost is allowed. If no cost can be found and null costs are permitted, the movement can be valued at zero. This is the setting that produces COGS of zero and margins of 100 percent.
A fifth setting decides whether the error is temporary:
- Issue cost adjustment. For methods such as average cost and FIFO, when the "adjust issues cost" option is enabled, Sage X3 can generate cost adjustments to revalue issues once the real receipt cost is known. Enabling it does not guarantee the correction, however. The Cost adjustment function (
FUNSTKADJ) can skip affected products when negative stock conditions are detected in the relevant stock history, recording the issue in its processing log. These situations require investigation of transaction chronology, movement allocation dates, and valuation settings. If the stock period is closed, the adjustment is not posted until the period is reopened, or, where the period is set to balance adjustment, it is posted to the next period.
In other words, zero stock forces the system to choose between stopping operations and using a provisional cost. Most businesses choose to keep operating, which is reasonable. The risk lies in what the provisional cost is, and whether anyone corrects it before the period closes.
Example 1: Raw materials issued before the receipt is posted
A beverage manufacturer receives a delivery of 5,000 kg of sugar on Tuesday morning. The sugar goes straight to the production floor. The purchase receipt is not entered until Thursday, because the paperwork is waiting for the receiving clerk.
On Tuesday afternoon, a work order consumes 2,000 kg of sugar. In the system, sugar stock at the site is zero, so the issue drives it to minus 2,000 kg.
The last receipt was valued at $0.50 per kg. The new delivery, after a supplier price increase, actually costs $0.62 per kg. How the 2,000 kg issue is valued depends on configuration:
| Scenario | Cost used | Value issued to WIP | Difference from actual |
|---|---|---|---|
| Receipt posted before the issue | $0.62 per kg | $1,240 | None |
| Negative stock, alternate valuation at last cost | $0.50 per kg | $1,000 | $240 understated |
| Negative stock, null cost allowed | $0.00 per kg | $0 | $1,240 understated |
Illustrative figures.
A material issue valued at an incorrect provisional cost can affect several stages of manufacturing accounting:
- Work in progress: the material consumption value may be understated or overstated.
- Production costing: the incorrect material value may affect actual production costs and manufacturing variances.
- Finished goods and COGS: depending on the finished product's valuation method and accounting configuration, the difference may affect finished goods inventory, cost of sales, or manufacturing variance accounts.
The financial impact can extend beyond the original material movement, particularly when work orders are completed or accounting periods close before adjustments are resolved.
When Thursday's receipt is posted, Sage X3 may generate a cost adjustment to correct the earlier issue, depending on the valuation method and configuration. However, enabling issue cost adjustment does not guarantee successful processing. The Cost adjustment function (FUNSTKADJ) can skip a product when negative stock is detected in its stock history, which requires investigation and potentially correction of the receipt allocation dates. The financial result also depends on whether the relevant stock and accounting periods remain open.
One issue of $240 is not significant. The same pattern across dozens of materials and hundreds of work orders each month is. It is also invisible in the transaction screens, because every transaction processed without an error.
Example 2: Finished goods shipped before the production receipt is posted
This is the scenario from the introduction. On October 31, the manufacturer ships 1,000 cases at $16 per case, for $16,000 in revenue. The production tracking and finished goods receipt are not entered until November 2. The actual cost of the product is $5.05 per case, and the standard cost is $4.80.
At the time of shipment, finished goods stock is zero, so the shipment drives it to minus 1,000 cases. The October invoice looks very different depending on the cost the system uses:
- Production receipt posted first68.4%
- Alternate valuation at standard70.0%
- Null cost allowed100.0%
| Scenario | Cost per case | COGS | Gross profit | Gross margin |
|---|---|---|---|---|
| Production receipt posted first | $5.05 | $5,050 | $10,950 | 68.4% |
| Negative stock, alternate valuation at standard | $4.80 | $4,800 | $11,200 | 70.0% |
| Negative stock, null cost allowed | $0.00 | $0 | $16,000 | 100.0% |
Illustrative figures.
The null cost case is the most visible, because a 100 percent margin stands out. The standard cost case is more dangerous, because a 70 percent margin looks entirely believable.
Consider a scenario where the October shipment is initially valued at zero and a subsequent accounting correction is recognized in November rather than October. The following table illustrates the potential financial reporting impact when the cost is recognized in a later accounting period:
| Month | Revenue | COGS | Gross profit |
|---|---|---|---|
| October | $16,000 | $0 | $16,000 |
| November | $0 | $5,050 | ($5,050) |
| Total | $16,000 | $5,050 | $10,950 |
This is a simplified example, not a guaranteed Sage X3 posting sequence. Actual results depend on the valuation method, cost adjustment processing, period status, and accounting configuration.
Over the two months, the total is correct. Each month on its own is wrong. October overstates gross profit by $5,050, and November carries a cost with no matching revenue. Anyone reviewing product or customer profitability for either month reaches the wrong conclusion.
This is the timing problem described in our CapEx, OpEx, and COGS article, caused this time not by a supplier invoice but by the sequence of manufacturing transactions.
Example 3: How negative stock distorts average cost and FIFO layers
Negative stock does not only affect the transaction that caused it. It can also distort the cost of every transaction that follows.
Consider a distributor using weighted average cost for a packaging component:
| Step | Quantity on hand | Stock value | Average cost |
|---|---|---|---|
| Opening balance | 500 | $4,500 | $9.00 |
| Issue 700 units at $9.00 | (200) | ($1,800) | $9.00 |
| Receive 300 units at $10.00 | 100 | $1,200 | $12.00 |
Simplified running-average illustration, assuming the earlier issue is not revalued.
The reason is that 200 units were issued at $9.00 when they should have cost $10.00. That $200 difference did not disappear. It was loaded onto the 100 units still in stock, adding $2.00 to each one. Under this simplified calculation, the remaining stock carries an average cost of $12.00 per unit despite the latest purchase price being $10.00. Actual Sage X3 results depend on valuation configuration, cost adjustment processing, and how negative inventory is handled.
FIFO has a similar problem. When stock goes negative, the issue has no receipt layer to consume. The next receipt has to cover the shortfall before it can form a normal layer, and if receipts are later backdated or entered out of sequence, the layers no longer reflect the order in which goods actually arrived. In our FIFO, LIFO, and average cost article, we noted that FIFO relies on established receipt layers. Negative stock is one of the main reasons those layers become hard to explain.
When issue cost adjustment is enabled and processes successfully, Sage X3 may revalue the earlier issue at the correct receipt cost instead of shifting the difference onto later stock. The illustration above shows the risk when that correction does not take place.
Should you allow negative stock?
There is no single right answer. Blocking negative stock protects the cost record but can stop production and shipping. Allowing it keeps operations moving but shifts the burden to finance. The comparison below summarizes the trade-off:
| Consideration | Block negative stock | Allow negative stock |
|---|---|---|
| Operations | Production and shipments stop when paperwork lags | Production and shipments continue on schedule |
| Customer service | Orders can be delayed for system reasons | Orders ship when the goods are ready |
| Cost accuracy | Every issue uses a real cost from stock on hand | Issues may use a provisional, alternate, or zero cost |
| Average cost and FIFO | Layers and averages stay clean | Averages can spike and layers fall out of sequence |
| Period-end close | Fewer corrections and adjustments | Cost adjustments must be processed before close |
| Reconciliation | Stock valuation is easier to tie to the general ledger | Differences are harder to trace and explain |
| Discipline required | Transactions must be entered in sequence, in real time | Negative balances must be monitored and cleared daily |
In practice, most manufacturers and distributors need some flexibility. The aim is not to ban negative stock everywhere. It is to decide deliberately where it is allowed, what cost it uses, and how quickly it is cleared:
- Good candidates for allowing negative stock: high-volume, low-value components that are backflushed, where the cost of stopping production is far greater than the cost of a short timing difference.
- Poor candidates: high-value raw materials, finished goods, lot-controlled products where traceability matters, and products valued at FIFO or average cost where a provisional cost can distort later transactions.
Where to investigate negative stock in Sage X3
When negative stock is distorting costs, these are the places we look first:
| Where to look | What it tells you |
|---|---|
| Stock movement history | The sequence and dates of receipts, issues, and production transactions, and which movement drove the balance negative |
| Average cost history for the product-site | When the average cost changed, and which movement caused a spike or drop |
Cost adjustment (FUNSTKADJ) and its processing logModifies data | Whether adjustments were generated, and which products were skipped and why |
Allocation date modification (FUNIPTD)Modifies data | Where a receipt's allocation date may need correcting so receipts precede the issues they cover |
Stock valuation report (FUNSTVA) | The value of stock by product and site at a given date |
| Stock-to-GL reconciliation | Whether stock valuation agrees with the inventory accounts, and where it does not |
Sage recommends running cost adjustment as a recurring task, and before stock values are calculated and declared. Allocation date corrections should be made only for eligible movements, after the transaction chronology has been investigated, never as a routine way to make errors disappear.
These functions are used by finance and system administrators with appropriate access. The value of a review is knowing which ones to use, in which order, and what the results mean for the financial statements.
How to control negative stock without stopping operations
The controls that matter most fall into three groups: configuration, daily process, and period-end checks.
Configuration
- Allow negative stock selectively. Decide by product-site and transaction which items can go negative, rather than enabling it across the board.
- Never allow null costs on valued products. A zero cost on a shipment or material issue is almost never correct. Disallowing it forces the system to use an alternate cost or stop.
- Set the alternate valuation deliberately. If a fallback cost is needed, make it a maintained standard cost rather than a stale last cost.
- Enable issue cost adjustment where appropriate, so provisional costs on FIFO and average cost products can be corrected once the real cost is known.
Daily process
- Post receipts before issues. Purchase receipts should be entered when goods arrive, not when the paperwork catches up.
- Post production before shipping. Production tracking and finished goods receipts should be entered before the goods leave the building.
- Review negative stock every day. A short daily report of negative balances by product, site, and location lets the team clear timing differences while they are still small.
Period-end checks
- Clear all negative stock before close, or document why each remaining balance exists.
- Process cost adjustments before the period closes, so corrections land in the right month.
- Close completed work orders on time, so costs move from work in progress to finished goods.
- Reconcile stock valuation to the general ledger, and investigate any difference before the books are closed.
None of these controls requires new software. They require clear rules, consistent transaction discipline, and a system configured to support both.
Is negative stock distorting your costs?
These are the signs we see most often:
- Individual invoices show margins near 100 percent. Shipments were valued at zero cost because no stock or cost was available.
- Margins swing between the end of one month and the start of the next. Corrections for late receipts land in the following period.
- Average costs jump above any recent purchase price. Differences from negative stock are being loaded onto the stock that remains.
- The negative stock report is long and old. Balances have been negative for weeks, not hours.
- Work orders close with large material variances. Components were issued at provisional costs that were later corrected.
- Stock valuation does not reconcile to the general ledger. Adjustments for negative stock are unprocessed, or are posting to unexpected accounts.
If two or more of these sound familiar, the issue is usually transaction sequence and configuration, not the valuation method itself.
Frequently asked questions
What is negative inventory?
Negative inventory is a stock balance below zero in the system. It usually means an issue, such as a shipment or material consumption, was recorded before the receipt that brought the stock in.
Does negative inventory mean we sold something we did not have?
Not necessarily. Negative inventory often results from transactions being recorded out of sequence, but it can also indicate stock discrepancies, incorrect units of measure, or other inventory-control issues. The underlying transactions and physical quantities should be investigated.
Why did an invoice show a 100 percent gross margin?
The most common reason is that the shipment was valued at zero cost. This happens when stock was zero or negative, no alternate cost was available, and null costs were allowed.
Can Sage X3 correct the cost once the receipt is posted?
In many cases, yes. For valuation methods such as average cost and FIFO, Sage X3 can generate cost adjustments when issue cost adjustment is enabled. Processing is not guaranteed: products with negative stock conditions in their history can be skipped, and the relevant period must still be open for the correction to land in the right month.
Should we turn off negative stock completely?
Not necessarily. Blocking it everywhere can stop production and shipping for reasons that have nothing to do with the goods themselves. A better approach is to allow it selectively and clear negative balances every day.
Does negative stock affect standard cost products?
Less than FIFO or average cost, because the issue uses the standard. The difference between standard and actual still has to be captured, however, and timing problems can move variances into the wrong period.
Sage X3 Inventory Valuation and Costing Review
Negative stock is rarely a single error. It is usually a combination of transaction timing, configuration choices, and period-end processes that no one owns end to end.
PRH Consulting's Sage X3 Inventory Valuation and Costing Review includes a focused look at zero and negative inventory:
- Negative stock settings by product-site and transaction
- Valuation methods, alternate valuations, and null cost settings
- Issue cost adjustment setup and processing
- Receipt, production tracking, and shipment sequencing
- Work order closing and WIP balances
- Stock-to-GL reconciliation and period-end controls
What you receive: a prioritized findings report that identifies where negative stock is distorting costs, estimates the financial impact where possible, and lists recommended configuration and process changes.
We are not here to sell you a new system. In most cases, the Sage X3 environment you already have can produce reliable costs once transactions are recorded in the right order and the system is configured to support it.
Schedule a Sage X3 Inventory Costing Review