web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Is there any relation between vendinvoicetrans and purchagreementheader, agreementheader or agreementLine?

(0) ShareShare
ReportReport
Posted on by 70

Hi all,

am looking for a relation to use it in a report.

is there any relation between VendInvoiceTrans and PurchAgreementHeader, or AgreementHeader, or AgreementLine 

other than VendInvoiceTrans.AgreementLine_PSN == AgreementLine.RecID ???

I have the same question (0)
  • Mariano Gracia Profile Picture
    on at
    RE: Is there any relation between vendinvoicetrans and purchagreementheader, agreementheader or agreementLine?

    The table AgreementLineReleasedLine contains the relation between the agreement line and the vendor invoice line, you'll find in this table the fields AgreementLine and VendInvoiceTrans, both are RecId's, you can also check the method createAgreementLinks from the PurchInvoiceJournalCreate class so you can see how this relation is created. Of course, once you have the agreementLine it is easy to get the agreement header record

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,100

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 890 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 633 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans