Negative inventory in NetSuite is what you get when the system has recorded more of an item leaving than it ever recorded arriving. On-hand quantity goes below zero, and because NetSuite has no cost for units it does not have, the accounting goes wrong with it. It is one of the most common findings in a NetSuite health check, and one of the most fixable. This guide covers the three ways it usually happens, how to find every affected item, how to clean it up, and the one setting that stops it recurring.
The three ways negative inventory happens
Almost every case comes down to one of these.
- Shipping more than was received. The goods physically arrived, the order was picked and shipped, but the item receipt was never entered, or was entered later. NetSuite fulfilled a sales order against stock it had not been told about.
- Consuming more than was available. The manufacturing version of the same problem. A work order is completed, or components are backflushed, before the raw materials were received or before the previous batch’s output was recorded. In formula and batch environments this also happens when the bill of materials calls for more than the run actually used, and the difference is never adjusted.
- Adjustments that overshoot. An inventory adjustment or cycle count entered against the wrong location, the wrong item, or with the wrong sign, taking the quantity past zero in one move.
The common thread is timing and sequence: the outbound transaction was recorded before the inbound one. The stock was usually real. The record was not.
Why it matters more than a wrong number
When an item goes negative, NetSuite still has to post cost of goods sold for the shipment or the work order, so it uses whatever cost it can find. When the receipt is finally entered, NetSuite posts a reversing entry to correct the cost it guessed. That is the reverse COGS impact: cost hits one period, the correction hits another, and margin by item, by customer, or by month is wrong in both. The longer the gap between shipment and receipt, the further apart the two entries land. Finance sees it as COGS that does not reconcile to inventory movement; operations sees it as available quantities that do not match the shelf.
How to find every affected item
Three places, in order of usefulness.
- The Negative Inventory report. NetSuite’s standard report under Reports → Inventory lists every item and location currently below zero. Run it by location, since the same item can be positive in one warehouse and negative in another.
- The item level. On any item record, the Inventory subtab shows on-hand by location. A quick saved search on items where quantity on hand is less than zero, grouped by location, gives the same list with the fields you want to act on: last receipt date, last fulfillment date, and the transactions in between.
- The COGS side. A GL search on cost of goods sold with reversal entries points at items that went negative in the past and were corrected, which the current negative inventory report will not show. That history is where the margin distortion lives.
How to fix it
Fix the record to match reality, in this order.
- Enter the missing receipts, dated when the goods actually arrived. If the stock was real and simply unreceived, a backdated item receipt against the purchase order restores the quantity and lets NetSuite correct the costing. This is the cleanest fix because it puts the right cost on the right units.
- Correct the wrong adjustments. Reverse the adjustment that overshot and enter it against the right item and location.
- Adjust to the count only when there is nothing to receive. If the negative quantity reflects a genuine loss or an unrecorded consumption, an inventory adjustment brings on-hand to the physical count. Use a dedicated adjustment account so the correction is visible in the GL rather than buried in COGS.
- Re-run the reports. Negative inventory should be empty, and the COGS reversals should now sit in the periods where the receipts were dated.
Do this before period close if you can. Once a period is locked, corrections post to the open period and the distortion becomes permanent in the closed one.
How to stop it recurring
Two controls, one of them a setting and one of them a decision.
Install the Enhanced Validation and Defaulting bundle. It is a free NetSuite bundle, and it adds a Stop Negative Inventory preference under General Preferences. Switch it on and any transaction that would take an item below zero is blocked at save, with a message telling the user what to receive first. Shipments wait for receipts; work orders wait for materials. That is the point. The problem is now fixed at the source by the person who has the information, instead of at month-end by someone who does not.
Move critical items to lot, serial, or bin control. Lot-numbered, serialized, and bin-managed items cannot go negative, because the lot, serial number, or bin is mandatory on consumption and on shipping, and you cannot pick stock that does not exist. For a manufacturer this is often the better answer for raw materials and finished goods that need traceability anyway: it delivers recall-ready records and stops negative inventory in one move.
Negative inventory in manufacturing
Manufacturers hit this more than anyone, because work order completions and backflushing consume components automatically and in quantity. The usual pattern is a BOM that overstates usage, a completion recorded before the receipt of a key ingredient, or yield recorded as planned rather than actual. Stop Negative Inventory catches the timing cases; the BOM and yield cases need the underlying data fixed. Consule’s ProShop records actual yield and consumption per batch so the quantities NetSuite consumes are the quantities that were used, and FactorySync schedules completions against material availability so a work order is not finished on paper before it can be finished on the floor. Both are part of what we look at in a NetSuite optimization for manufacturers.
Frequently asked questions
Why does NetSuite allow negative inventory at all?
By default NetSuite lets a transaction post even when it takes an item below zero, so that a shipment or a work order completion is never blocked by a receipt that has not been entered yet. That flexibility is useful in a pinch and expensive over time, which is why most companies switch the behavior off once they are live and stable.
Does negative inventory affect my financials?
Yes. When an item goes negative, NetSuite has no cost to use for the units it does not have, so it posts cost of goods sold at whatever cost it can find. When the receipt finally arrives, it posts a reversal to correct the earlier costing. The result is COGS and inventory value that move in the wrong periods, and a margin report nobody trusts until it is cleaned up.
Can lot-numbered or serialized items go negative?
No. Lot, serial, and bin-managed items require the specific lot, serial, or bin to be selected on consumption and shipping, and you cannot select stock that does not exist. That is one reason many manufacturers move their critical items to lot control: it forces the discipline.
What is the Enhanced Validation and Defaulting bundle?
A free NetSuite bundle that adds a set of validation controls, including a Stop Negative Inventory preference under General Preferences. With it enabled, any transaction that would take an item below zero is blocked at save with a clear message, so the problem is fixed at the source rather than found at month-end.
Finding negative inventory every month? It is a symptom, and the causes are fixable. Talk to Consule, or read the guide to NetSuite optimization for the wider set of things to check.