Hello all,
I am looking to better understand the logic of the Purchase Advice report.
I have an item that is allocated as a component on assembly orders. From the item card:
However, when I run the Purchase Advice report, the QtyAvailable is equal to the Item Inventory. I would expect the QtyAvailable to be 10 less than the Item Inventory, since 10 are allocated to assembly orders. Excel output of Purchase Advice report:
Note that QtyAvailable does decrease by the expected amount if the item is allocated to production orders. In this case, the item card will show the quantity allocated to production orders in the "Qty. on Component Lines" field, and the Purchase Advice report behaves as expected.
Why does the QtyAvailable field account for "Qty. on Component Lines" but ignore "Qty. on Asm. Component"?
In both cases, inventory has been allocated to orders and the system should calculate purchasing advice accordingly.
Thanks for your help!