(FRA) Transaction list by date or voucher report (LedgerTransDateVoucher_FR) [AX 2012]

Updated: April 17, 2014

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

The Transaction list by date or voucher report displays a list of vouchers, sorted by voucher type or date. The journal entries are recorded chronologically. Each entry shows debit and credit amounts, the account number, the date, and a short description. 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 a summary of the selected editing options.

  • The entries that include the date, the account, and whether the entry is a debit or a credit. The entries are classified by period and by document number.

  • The totals for each period, 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.


(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 Filter the data on a report.



From date

Select a starting date for the date range.

To date

Select an ending date for the date range.

Voucher filter

Enter a 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.


Select the method to use to sort transactions in the report. You can select Date or Voucher. You must select Voucher to print the totals of the transaction amounts that are sorted by voucher numbers.

Total for first characters in voucher

Enter a number. For example, enter 2 to print a total of the transaction amounts for the first two digits in the specified voucher.

Total by voucher

Select this check box to print a total of the transaction amounts for each voucher.

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\LedgerTransDateVoucher_FR

Menu item of the report


Navigation to the report

Click General ledger > Reports > France > Transaction list by date or voucher.

The data on this report comes from the following sources:

  • DimensionAttributeValueCombination table

  • GeneralJournalAccountEntry table

  • GeneralJournalEntry table

  • MainAccount table

  • SubledgerVoucherGeneralJournalEntry table

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).