Have you ever built a GI to show POs that are linked to Production Order, where the PO is raised through the MRP screen? can you please help pointing me to the right direction?
I have a very simple scenario:
- User raises a Production Order (through Prod Order Maintenance) for one item, which has 1 component
- User regnerates MRP
- The component of the item is suggested in MRP Display
- User click Purchase - the PO is created
I’m trying to build a generic inquiry to show which PO is raised for which Production Order.
What I have found so far is that:
- On the POLine, there’s a PlanID, which I can link to INItemPlan
- In INItemPlan, for the same component, there are actually 2 records:
- One have a PlanType = Production Demand - this line has a PlanID that is linked to the AMRPDetail table - where I can potentially get the Production Order Number, and this PlanID also linked to AMProdOper table, where I can also get the PO number, but only when the PO is raised through the Critical Material screen (which is not the case, because my PO was raised through the MRP Display screen)
- One have a PlanType = POPrepare - this line has a PlanID that is linked to my PO, but I cannot find anything that links back to the Production Order to show the Production Order number.