AccountingDistribution query for VendInvoiceJour, VendInvoiceTrans (ax 2012)

(0) Share

Report

Posted on by Pedro Rodriguez

2,245

Hi all,

In the vendor invoice journal we have a useful view pressing in the button "View distributions". There we can see per invoice line the postings that would be done or were done for each invoice line. Also there info about the taxes.

I need to access to this information in code with a query but I find the table structure a little confusing. The tables are AccountingDistribution, SourceDocumentHeader, SourceDocumentLine, AccountingEvent, ...

Anyone have any idea how create a query that gives from an invoice all the information per invoice line that we can see in the tree that is on the left side of the Accounting Distribution form?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Danzel Zuo 131 on at

Like (0)

Report

RE: AccountingDistribution query for VendInvoiceJour, VendInvoiceTrans (ax 2012)

tks a lot!

Was this reply helpful? Yes No
Pedro Rodriguez 2,245 on at

Like (1)

Report

Re: AccountingDistribution query for VendInvoiceJour, VendInvoiceTrans (ax 2012)

Ok. I found it. On AccountingDistribution table the field SourceDocumentHeader points to VendInvoiceJour.SourceDocumentHeader and SourceDocumentLine points to VendInvoiceTrans.SourceDocumentLine, TaxTrans.SourceDocumentLine, and so on...

Was this reply helpful? Yes No