Take into account Committed Stock in Reorder Report
We have a longer shipping delay and a lot of orders coming in daily. We need the reorder report to include committed stock in order to be ahead of our inventory.
Example:
Items in stock: 50
Reorder point: 40
On Sales Order: 35 (Committed Stock)
On Purchase Order: 10
That's 50 items in stock, minus 30 committed stock we're at 20 available stock.
I already have 10 on a PO so to get back up to 40 I would need to order 20 more.
Basic inventory management equation:
In stock items - Committed Stock + On Purchase Order - Reorder Level = Missing/Excess
(Negative means you need to order and should show in the reorder report)