Export (0) Print
Expand All
Expand Minimize

(ESP) Bill-Invoice relation by transaction date report (CustInvoiceSettled_TransDate_ES) [AX 2012]

Updated: October 10, 2011

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.

NoteNote

(ESP) This report is available only to legal entities whose primary address is in Spain.

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:

  • None – No bill of exchange is drawn. The bill of exchange has not been posted.

  • Drawn - The bill of exchange has been posted in a draw bill of exchange journal.

  • Redrawn - A bill of exchange that was previously protested has been redrawn in a redraw bill of exchange journal.

  • Protested - A bill of exchange that was not honored by the bank has been protested in a protest bill of exchange journal.

  • Honored - The bill of exchange has been settled. The settlement may occur before you receive confirmation from the bank.

  • Remitted - The bill of exchange has been posted in a remittance journal.

  • Invoiced – The bill of exchange has been invoiced.

  • Invoice remitted – The bill of exchange has been invoiced and remitted.

NoteNote

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.

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.

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.

The data on this report comes from the following sources:

  • CustInvoiceSettled_TransDateTmp_ES table

    NoteNote

    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.

  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).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft