Skip to main content
Solved

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


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!

Best answer by Naveen Boga

@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

 

 

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • January 7, 2022

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?

 


  • Author
  • Freshman I
  • 11 replies
  • January 7, 2022

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.  


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • January 7, 2022

@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


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