AccountDistribution View for vendor invoices (ax 2012)

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!

`Hi,

The distribution amounts are also available in MarkupTrans table.

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…

Hi,

Does any one have idea regarding, when data is created on Source document Line while posting Invoice in Ax2012?

Regards,

Enrique

Hi ,

does anyone know why in the invoice journal for some invoices (posted from purchase order) the view distribution button is disabled?

regards

Maddalena

I am also having the same question like EnriqueKevin06 “Does any one have idea regarding, when data is created on Source document Line while posting Invoice in Ax2012”? any have idea about this?