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!
Solved
How to show Original PO Amount Value in a GI - Need to link PX.Objects.PM.PMCommitment to Order!
Best answer by Naveen Boga
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.