(ESP) Bill-Invoice relation by transaction date report (CustInvoiceSettled_TransDate_ES)
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 Bill-Invoice relation by transaction date report displays a list of invoices that are settled with bills of exchange. The invoices and their corresponding bills of exchange are grouped by transaction date and are displayed in the report. This report is typically used by accountants, collections managers, and financial controllers to check the status of the bills of exchange.
Note
(ESP) This report is available only to legal entities whose primary address is in Spain.
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 customer |
Select the customer account that is used to generate the bill of exchange. |
To customer |
Select the customer account for the recipient of the bill of exchange. |
From date(Posting date) |
Select the starting posting date of the transactions to include in the report. |
To date(Posting date) |
Select the ending posting date of the transactions to include in the report. |
From date(Due date) |
Select the starting due date of the transactions. |
To date(Due date) |
Select the ending due date of the transactions. |
Enable status |
Select these check boxes to include bills of exchange that have a specific status in the report. You can select up to three different statuses in the Status fields. |
Status |
Select the status of the bill of exchange from the following options:
Note You must select the Enable status check box for each of the Status fields to include the bill of exchange with the selected statuses in the report. |
Method of payment |
Select a method of payment to include in the report. |
Bill ID |
Select the unique identifier for the bill of exchange. |
Invoice number |
Select a specific invoice number to include in the report. |
Amount |
Enter the minimum transaction amount for transactions to be included in the report. The transaction amount is entered in the accounting currency. |
Amount |
Enter the maximum transaction amount for transactions to be included in the report. The transaction amount is entered in the accounting currency. |
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 |
CustInvoiceSettled_TransDate_ES |
Location of report in the AOT |
SSRS Reports\Reports\CustInvoiceSettled_TransDate_ES |
Menu item of the report |
CustInvoiceSettledTransDate_ES |
Navigation to the report |
Click Accounts receivable > Reports > Bill of exchange > Bill-Invoice relation by transaction date. |
Where the data in this report comes from
The data on this report comes from the following sources:
CustInvoiceSettled_TransDateTmp_ES table
Note
To find out where the data in the temp table comes from, view the cross-references for the CustInvoiceSettled_TransDateDP_ES.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.
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).