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!
How to show Original PO Amount Value in a GI - Need to link PX.Objects.PM.PMCommitment to Order!
Page 1 / 1
Hi
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.