Relationship between AgreementHeader table and PurchTable

Question

In AX I have the PurchTable which holds purchases and in the AgreementHeader table which holds agreements. I need to tie together both tables in a join but can't see a link.

Can someone provide me with a join. I'm guessing it involves the vendaccount somewhere because each vendor purchases items and has multiple agreements in place.

Answer 1

Please, could you chek in PurchTable the Relation Agreement

PurchTable.MatchingAgreement == AgreementHeader.RecId

Like this:

Good work.