We are generating summary and detailed P&L Expense BI reports after exporting data from D365.

We are generating the summary and detail reports that can trace voucher transactions in trail balance till the source document line, for example receipt and vendor invoice lines.

The tables behind voucher transactions are GENERALJOURNALACCOUNTENTRY & GENERALJOURNALENTRY. The main table behind underlying subledger voucher transactions is SUBLEDGERVOUCHERGENERALJOURNALENTRY.

When multiple lines are aggregated into a single voucher transaction, we are able to identify source document lines by matching the voucher and ledger dimension in the AccountingDistribution table.

But, when purchase order receipt is corrected, cancelled and re-received, there are too many entries in the AccountingDistribution linking the same SourceDocumentLine and AccountingDistribution, this makes it impossible to link the voucher transaction to the source document line.

This is significantly impacting the result of our BI reports, when these numbers go out of whack.

Is there is a way to directly link the Accounting distribution and voucher transactions? If not, can MS establish this link in the backend?

We have same issue even with GL journal transactions as well. We couldn’t establish a link between voucher transactions and journal line. Customer have some journals that have huge number of lines.