(ESP) Payment documents-invoices relation by transaction date report (VendInvoiceSettled_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 Payment documents-invoices relation by transaction date report displays the relationship between promissory notes and invoices, grouped by transaction date. This report is used to inquire into the status of promissory notes. This report is typically used by chief financial officers, accountants, accounting managers, accounting supervisors, financial controllers, accounts payable clerks, and accounts payable managers.

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 vendor

Select or enter the starting vendor account number for the vendor account range to include in the report.

To vendor

Select or enter the ending vendor account number for the vendor account range to include in the report.

From date

Select or enter the starting date of the date range in which the transactions are posted or are due.

To date

Select or enter the ending date of the date range in which the transactions are posted or are due.

Enable status

Select this check box to include the status of the promissory note in the report.

Status

Select the status of the promissory note to be included in the report from the following options:

  • None – No promissory note has been drawn.

  • Drawn –The promissory note is posted in a draw promissory note journal.

  • Redrawn – The promissory note was previously protested and is redrawn in a redraw promissory note journal.

  • Protested – The promissory note was not honored by the bank and is protested in a protest promissory note journal.

  • Honored – The promissory note is settled.

  • Remitted – The promissory note was posted in a remittance journal.

  • Invoiced – The promissory note for an invoice that uses the promissory note method of payment has been posted.

  • Invoice remitted – The promissory note for an invoice that uses the promissory note method of payment has been drawn and posted.

Method of payment

Select the vendor method of payment.

Note ID

Select the identification for promissory notes.

Invoice

Enter the invoice number.

Amount

Enter the transaction amount.

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

VendInvoiceSettled_TransDate_ES

Location of report in the AOT

SSRS Reports\Reports\VendInvoiceSettled_TransDate_ES

Menu item of the report

VendInvoiceSettledTransDate_ES

Navigation to the report

Click Accounts payable > Reports > Promissory notes > Payment documents-invoices relation by transaction date.

Where the data in this report comes from

The data on this report comes from the following sources:

  • VendInvoiceSettled_TransDateTmp_ES table

    Note

    To find out where the data in the temp table comes from, view the cross-references for the VendInvoiceSettled_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).