(FRA) Ledger totals by periods report (LedgerPeriodSum_FR) [AX 2012]

Updated: April 16, 2014

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

The Ledger totals by periods report is used to print ledger account totals by period for a date interval and a voucher interval. The report displays the changes in accounts for a period or time interval that you specify. The report allows you to review the accounting records. This is an annual statement that you can generate at the end of the year. The report includes the following information:

  • On the first page, a summary of the parameters that are used to generate the report. For example, the starting and ending dates, and the posting layer.

  • The starting and ending dates, the type and status, the debtor and creditor balances, and the balance sheet for each account, in chronological order.

  • The totals for each page, and the grand total.


This topic includes information about features that were added or changed for cumulative update 7 or later for Microsoft Dynamics AX 2012 R2. This information also applies to AX 2012 R3.

This report is used by account managers and accountants.


(FRA) This report is available only to legal entities whose primary address is in France.

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 筛选报表上的数据.



Start date

Enter the starting date of the period.

End date

Enter the ending date of the period.

Voucher filter

Enter the voucher number. The transactions for only this voucher are included in the report.

Posting layer

Select a posting layer that has transactions to be included in the report.

This control is not available in versions of Microsoft Dynamics AX 2012 prior to cumulative update 7 for AX 2012 R2.

The following topics explain how to print a report and how to filter and sort the data on a 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.



Name of report in the AOT


Location of report in the AOT

SSRS Reports\Reports\LedgerPeriodSum_FR

Menu item of the report


Navigation to the report

Click General ledger > Reports > France > Ledger totals by periods.

The data on this report comes from the following sources:

  • LedgerPeriodSumTmp_FR Table


    To find out where the data in the temp table comes from, view the cross-references for the LedgerPeriodSumDP_FR.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).

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