Negative On-Hand Inventory — Root-Cause Analysis v2

Systemic root cause (14 of 15): the 02: NYC Store is replenished by item receipts on the 2nd of each month. The August 2026 receipt was never entered — replenishment POs PO03211, PO03214, PO03217, PO03220 (dated 7/25/2026) sit at 0 units received while POS cash sales kept posting daily. The chart below makes the missing receipt visible: every NYC balance staircases down through August with no recovery spike.

The anomaly: Ghost Whisperer Thermal Jacket GR M @ 01: San Fran Store was sunk by standalone Item Fulfillment IF4893 (id 26967) — −10 units on 7/1/2026 with no linked order — and has no open PO. See the waterfall in section 3.

1. Balance timelines — May–Aug 2026, all 15 item-locations

Gray lines: NYC items · amber line: the San Fran anomaly · green dashes: monthly receipt dates · red dash: the receipt that never happened.

2. Summary — all 15 negative item-locations

Click a column header to sort. Sparkline shows the last ~120 days of running balance (red band = below zero). The break point is the transaction where the current, unrecovered negative streak began.

All (15) 02: NYC Store (14) 01: San Fran Store (1)

Item	Location	On hand	Min bal	Trend (120d)	Break point	Status

3. Anomaly deep-dive — Ghost Whisperer Thermal Jacket GR M @ 01: San Fran Store

Waterfall of the collapse: healthy at zero on 6/27, then the unlinked fulfillment IF4893 punches a −10 hole that two receipts never fully repair.

4. Fix coverage — 4 documents resolve 14 of 15 problems

Action	Document	Dated	Items covered (qty on PO vs. shortfall)	Result

5. Recommended fixes

Each fix has a copy button — paste straight into a ticket or hand to the receiving clerk. Backdate receipts to 8/2/2026 (the normal monthly cadence date, on/before every NYC break point) and confirm the period is open first.

6. Full transaction ledgers — drill-downs

break point of current streak anomalous unlinked fulfillment balance below zero

Anomaly — 01: San Fran Store

Systemic — 02: NYC Store (missing August replenishment)

Verification notes: net quantity sums of posting, inventory-affecting lines equal inventoryitemlocations.quantityonhand for all 15 item-locations. IF4893 has no nexttransactionlink parent. Open POs confirmed status B (partially received) with quantityshiprecv = 0 on all relevant lines.