This content has been marked as final. Show 1 reply
~ There is no direct table to get the projected inventory details.
~ Current on hand Qty for a given item shall be obtained from ON HAND QTY table.
For calculating the future supply upto a patricular date, all the expected supplies such as Receipts, Jobs, Internal SO transfer, etc to be considered.
For calculating the future demand, qty required for SO demand, forecast demand, ISO demand etc to be considered.
Projected Inventory = Current Stock (OHQ) + Expected Supply - Expected Demand.