Skip to main content
Solved

Production order linkage to purchase orders for GI


Forum|alt.badge.img+5

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 @ltussing03 

Please try with the AMProdOper table. You can get the POOrderNbr and the Production orderID .

Select POOrderNbr, ProdOrdID, * from AMProdOper
 

View original
Did this topic help you find an answer to your question?

4 replies

jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 702 replies
  • Answer
  • January 6, 2022

Hi @ltussing03 

Please try with the AMProdOper table. You can get the POOrderNbr and the Production orderID .

Select POOrderNbr, ProdOrdID, * from AMProdOper
 


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 292 replies
  • January 10, 2022

Perfect!  Thanks!


jdobish
Pro II
Forum|alt.badge.img+2
  • Pro II
  • 226 replies
  • January 11, 2022

It 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. 


Forum|alt.badge.img+3
  • Varsity I
  • 217 replies
  • July 18, 2022

When 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings