Question

How to show Original PO Amount Value in a GI - Need to link PX.Objects.PM.PMCommitment to Order!

  • 7 January 2022
  • 3 replies
  • 17 views

Struggling to find a way to link the  PX.Objects.PM.PMCommitment to the PX.Objects.PO.POOrder record in a GI or to show it during the PO entry screen.  User needs to see what the original amoount was separate from revised after change orders in the system.  That information seems to be in the PM Committment record but cant link it to the POOrder, any insights would be appreciated!


3 replies

Userlevel 7
Badge +11

Hi @Mike Baio  Project ID field is available in the PMCommitment and POOrder table. Did you check by joining with Project ID in the GI?

 

That just gets me to the Project I need to link to the PO Order, the PM Committment record is a one to one relationship with the PO Order.  

Userlevel 7
Badge +11

@Mike Baio  Understood. Have you tried this?

PMCommitment Join with POLine using Commitment ID. This is unique record identification and from there you can fetch the proper PO Amount value. 

Query:

Select * from PMCommitment PM inner join POLine PL on PM.CompanyID= PL.CompanyID and PM.CommitmentID = PL.CommitmentID
Where PM.CompanyID=2

 

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved