Hello,
I want to be able to display the POs linked to a production order.
Generic Inquiry, reports that type of thing.
I don’t seem to be able to inspect any element to find a DAC or anything. I usually would be asking for the SLQ Table but I know that isn’t relevant for Acumatica hosted.
How would I be able to determine this for elements I can’t inspect?
Does anyone know what I am looking for? I need a “table” with production order ID and the linked PO(s).
Thanks!
Best answer by jinin
Hi
Please try with the AMProdOper table. You can get the POOrderNbr and the Production orderID .
Select POOrderNbr, ProdOrdID, * from AMProdOper
+11Hi
Please try with the AMProdOper table. You can get the POOrderNbr and the Production orderID .
Select POOrderNbr, ProdOrdID, * from AMProdOper
Perfect! Thanks!
+2It would be nice if you could add this to see when you are in the PO itself. While you can link it at the PO level, and see the connection on the GI, you cannot see it with the screen. You can always add it at the table, but it would be cleaner if you could see it on the line details.
+3When the PO Line Type is Goods for Manufacturing the INItemPlan has the linkage when the PlanType is ‘M3’ or ‘M4’ purchase for production; conversely, the production order material has an M9 Production to Purchase allocation. the old help article attached explains the allocations.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
