This report allows users to determine the projected qty of an inventory item using the current on hand qty and calculate a total based on all sales orders and production orders going out and purchase orders being received. This report can also be used to determine if more items are needed to be placed ordered based on all current entered data.

All totals use the inventory UOM quantity. If the order (sales, purchase, or production) uses a different UOM from the inventory default, the report will convert the quantity to the inventory UOM and then calculate the projected inventory quantity that should be on hand that day.

All reports are calculated using the required date of each line order.

Report can be run on all inventory items at once but could take a long time to run depending on the size of the database and the number of inventory items. Running this on a small number of items at a time, this report generates very quickly.