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 ???
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