(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.
Open the AOT.
Locate the report in the SSRS Reports\Reports node.
Right-click the report and click Add-Ins > Cross-reference > Using (instant view).