Stock Projected Qty
Per item and warehouse: actual, reserved, ordered, requested and projected quantity, from Bin.
In detail
Stock Projected Qty reads the Bin for each item and warehouse and shows actual quantity on the shelf, quantity reserved on Sales Orders, quantity ordered from suppliers on Purchase Orders, quantity requested on Material Requests, quantity planned by Work Orders, and the projected quantity that results. Projected is what you will have once every open document is honoured, so it is the figure to check before promising a customer or raising another order. It also shows the item's reorder level and reorder quantity, and a row whose projected quantity is below the level is what the auto reorder job acts on. No money is shown; this is purely quantities.
Formula
Projected qty = actual + ordered + indented + planned - reserved - reserved for production - reserved for subcontract
How to record it in BRAccount
- 01Go to Stock > Stock Projected Qty.
- 02Set Company; filter by Warehouse, Item or Item Group, or tick Include UOM.
- 03Read Actual Qty against Projected Qty for each row.
- 04A projected figure below actual means orders are waiting to take stock out.
- 05A projected figure below Reorder Level means a Material Request is due.
- 06Raise a Material Request or a Stock Reservation Entry from the finding.
When to use it
Open before promising stock to a customer to see what will really be available.
Example from the demo books
Actual 50, reserved 10 on sales orders, ordered 20 from supplier, projected 60.