(FRA) Transaction list by date or voucher report (LedgerTransDateVoucher_FR)

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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.

Note

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.

Note

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

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

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.

Note

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

Sorting

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.

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

LedgerTransDateVoucher_FR

Location of report in the AOT

SSRS Reports\Reports\LedgerTransDateVoucher_FR

Menu item of the report

LedgerReport_TransDateVoucher_Fr

Navigation to the report

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

Where the data in this report comes from

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