I am trying to understand the "Prod Order - Shortage List" report. In particular the data shown in the last columns. I have tried to match the data for various items on the report by comparing the report to the associated items cards and prod orders without success.
Please can someone explain how these columns are calculated / using what data.
Remaining Qty. (Base)
Quantity on Hand
Qty. on Hand after Production
Qty. on Purch. Order
Also, if there are 2 production orders requiring the same item but there is only 1 on hand how does Nav decide which order will take the stock and which order will show a shortage when you generate this report.
Quantity on Hand = Inventory - Reserved Qty. on Inventory
Qty. on Hand after Production = Inventory - (Remaining Qty of prod+ Reserved Qty on prod).
Scheduled Need = Remaining Qty of item on production component
Needed Qty = Scheduled Need (Qty.) +( "Qty. on Sales Order" - "Qty. on Purch. Order" -"Scheduled Receipt (Qty.)" - nventory;