(BRA) Trial balance summary report (LedgerTrialBalance_BR)

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

The Trial balance summary report displays a summarized trial balance for a specified period. This report can be used by accountants, accounting managers, accounting supervisors, and accounts payable clerks to make journal and transaction status inquiries and to review the general ledger status.

How to filter the data on this report

When you generate this report, the following default parameters are displayed. You can use these parameters to filter the data that will be displayed on the report. For more information, see Filter the data on a report.

Field

Description

Date interval

Select a date interval code.

From date

Select the starting date of the period that the report is printed for.

To date

Select the ending date of the period that the report is printed for.

Include opening

Select this check box to include opening transactions in the report.

Page

Enter the number of pages in the report.

Book number

Enter the book number for the report.

Posting layer

Select a posting layer that has transactions that you want to include in the report, from the following options:

  • Current – Transactions that are posted to the Current posting layer are included.

  • Operations – Transactions that are posted to the Current or Operations posting layer are included.

  • Tax – Transactions that are posted to the Current or Tax posting layer are included.

  • Operations minus tax – Transactions that are posted to the Operations posting layer, minus the transactions that are posted to the Tax posting layer are included.

  • Only operations – Transactions that are posted to the Operations posting layer are included.

  • Only tax – Transactions that are posted to the Tax posting layer are included.

  • Operations plus tax – Transactions that are posted to the Operations or Tax posting layer are included.

  • Total – Transactions that are posted to the Current, Operations, and Tax posting layers are included.

  • Dual warehouse – Transactions that are posted to the Dual warehouse posting layer are included.

How to work with reports

The following topics explain how to print a report and how to filter and sort the data on a report.

Details of this report

The following table explains where to find the report in the Application Object Tree (AOT) and how to navigate to the report in the Microsoft Dynamics AX client.

Detail

Description

Name of report in the AOT

LedgerTrialBalance_BR

Location of report in the AOT

SSRS Reports\Reports\LedgerTrialBalance_BR

Menu item of the report

LedgerTrialBalance_BR

Navigation to the report

Click General ledger > Reports > Transactions > Trial balance summary.

Where the data in this report comes from

The data on this report comes from the following sources:

  • LedgerTrialBalanceTmp_BR table

  • To see where the data in the temp table comes from, view the cross-references for the LedgerTrialBalanceDP_BR.processReport class.

If you are a developer, you can learn more about where the data on a report comes from by using the following procedure.

  1. Open the AOT.

  2. Locate the report in the SSRS Reports\Reports node.

  3. Right-click the report and click Add-Ins > Cross-reference > Using (instant view).

See also

(BRA) Generate a trial balance report

(BRA) Page and book control for legal accounting reports

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).