A real-time alert list of any item whose physical on-hand went negative in any warehouse. Negative on-hand signals a posting-sequence error, an oversell, or a sync race, and it corrupts costing.
At a glance
A live list of every item whose physical on-hand quantity has dropped below zero in any warehouse or location, across every legal entity. Negative on-hand is not a stock-level warning, it is a data-integrity alarm: physical inventory cannot truly be less than nothing, so a negative value means an issue transaction posted before its matching receipt, an oversell let a sale post against stock that was not there, or a sync race double-counted an issue. Beyond the operational risk, negative on-hand corrupts inventory costing, because cost-of-goods calculations have no valid quantity to value against.
| What it counts | Each row is an item whose on-hand quantity is below zero in a specific warehouse / location. The card lists, per row: item, warehouse, legal entity, and the negative quantity. It is a row-per-breach alert list, not a single rolled-up number. An item negative in two warehouses appears as two rows. As soon as a corrective receipt or adjustment lifts on-hand back to zero or above, the row clears. |
| Currency | Not applicable to the headline, which is a quantity. The downstream cost impact is monetary, because negative on-hand distorts inventory valuation, but the card itself reports quantities and locations. |
| Time window | RT (real time, recomputed as inventory transactions post) |
| Alert trigger | any item on-hand < 0. A single item going negative in a single warehouse raises the alert; there is no tolerance band, because negative physical stock is never legitimate. |
| Roles | owner, operations, engineering |
Calculation
Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A multi-warehouse outdoor-equipment retailer running Business Central across two legal entities, with a Shopify storefront syncing orders in and inventory out. The alert list snapshot is taken at 14:20 on 16 Jun 26 after a busy sale day.| Item | Warehouse | Legal entity | On-hand qty |
|---|---|---|---|
| TENT-2P-GRN | MAIN-UK | UK Outdoor Ltd | -12 |
| STOVE-CMP-01 | MAIN-UK | UK Outdoor Ltd | -3 |
| JACKET-WP-L | EU-NL | EU Outdoor BV | -8 |
| HEADTORCH-200 | EU-NL | EU Outdoor BV | -1 |
- Four rows, two warehouses, two legal entities, all live. This is not a forecast or a low-stock warning; every one of these items is physically recorded as below zero right now. The list is the work queue for the operations team to clear before stock-take or month-end.
- TENT-2P-GRN at -12 is the worst breach and the most likely oversell. A negative of that size on a popular sale item points at the storefront continuing to sell after physical stock hit zero, with the issue transactions posting against nothing. Pair with OOS with Open Sales Order Demand to see the open orders piling up behind it.
- The single-unit breaches are usually posting-sequence errors, not oversells. HEADTORCH-200 at -1 is the signature of a sales shipment posting before its purchase receipt or transfer receipt landed. These clear themselves the moment the receipt posts, but until then they distort costing on every transaction that touches the item.
- Negative on-hand corrupts costing immediately. Average-cost and FIFO valuations have no valid quantity to apply a unit cost to, so cost-of-goods on these items is unreliable until the quantity is corrected. That is why the card is an alarm, not a metric: the longer a row sits, the more downstream postings inherit a bad cost.
Sibling cards merchants should reference together
Negative on-hand is usually a symptom of a sync or sequencing problem. These siblings show the cause and the blast radius.| Card | Why pair it with Inventory On-Hand Went Negative |
|---|---|
| ERP vs Ecom Inventory Variance | The variance that lets oversells happen. When ERP and ecom disagree on stock, the storefront sells what the warehouse does not have. |
| SKUs with D365 vs Ecom Inventory Drift > 5 | The item-level drift list. SKUs drifting hardest are the ones most likely to go negative next. |
| Inventory Sync Drift | The sync-health view. A negative-on-hand spike usually coincides with a sync drift event. |
| Inventory Value by Warehouse | The valuation context. Negative on-hand corrupts the value figure for the affected warehouse. |
| Batch Job Error Queue (24h) | The posting-failure context. A failed receipt-posting batch is a classic cause of negative on-hand. |
| OOS with Open Sales Order Demand | The demand backlog behind an oversold item. Shows how many open orders are stacked against negative stock. |
Reconciling against Microsoft Dynamics 365
Where to look in Business Central / Finance & Operations:Business Central: Item Availability by Location (negative quantities show in red against the affected location) Business Central: Item Ledger Entries (filter to the item to trace the issue transaction that posted before its receipt) Business Central: Inventory Setup (check whether “Prevent Negative Inventory” is enabled; if not, oversells can post) Finance & Operations: Inventory management > Inquiries > On-hand list (filter on-hand below zero by site and warehouse) Finance & Operations: Inventory management > Periodic > Closing and adjustment (negative on-hand blocks a clean inventory close)To verify a single row, open Item Availability by Location (or the F&O on-hand list) for the named item and warehouse; the negative quantity should match the card. Then drill into the Item Ledger Entries to find the sequence: a negative on-hand is almost always an issue transaction (a sales shipment or transfer) timestamped before the receipt that should have preceded it. The fix is to post the missing receipt or an inventory adjustment, after which both the native screen and the card return to zero or positive. Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Snapshot timing | Either | The card is real time. A native on-hand screen refreshed at a different moment, or before a corrective receipt posted, will show a different set of rows. |
| Location vs warehouse granularity | Either | The card reports at warehouse / location level. A native view rolled up to the item level can mask a negative in one bin that nets out across the whole item. |
| Reservations vs physical on-hand | Card focuses on physical | The card watches physical on-hand, not available-to-promise. A native availability screen that subtracts reservations can show a different, more negative figure. |
| Prevent-negative setting | Either | If “Prevent Negative Inventory” is on, postings that would go negative are blocked, so genuine breaches are rarer and usually trace to adjustments or transfers rather than sales. |
| Sync lag | Card up to 15 min behind | A corrective receipt posted in the last few minutes may not yet have cleared the row on the card. |