Home › Discussions › Questions & Answers › Detailed General Ledger Distribution Reporting

Detailed General Ledger Distribution Reporting

Avatar photoCustomer Questions & Answers 5 replies

We need a GL report that breaks down transactions by individual distribution line, including all segments, the associated subledger data, and specifically, VAT tax codes and rates for AR and AP transactions.

5 replies

  • Support Enginatics

    The GL Account Analysis (Distributions) report is the most appropriate. It provides a detailed GL transaction report with one line per distribution, including all segments and subledger data, along with VAT tax codes and rates for AR and AP transactions.

  • This report sounds useful for debugging subledger links. If I want to look up documentation explaining which source IDs are populated for different subledger tables, is there a report to assist developers with that structure?

  • Support Enginatics

    Yes, developers can use the XLA Distribution Links Summary report. It provides a summary of subledger distribution links to help understand which source IDs are populated for which subledger table sources, referencing relevant MOS documents.

  • The output includes amounts in both transaction currency and ledger currency. Is this standard across both the GL Account Analysis reports?

  • Support Enginatics

    Yes, both the GL Account Analysis (Distributions) and the standard GL Account Analysis report show amounts in both transaction currency and ledger currency.

  • You must be logged in to reply to this post.