(ESP) Open cartera transactions report (CustBillOfExchangeOpenTrans_ES)

  • Article

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 Open cartera transactions report displays cartera transactions grouped by bill of exchange ID, customer, or due date. This report is used to inquire into the status of bills of exchange. This report is typically used by collections agents, collections managers, clerks, accountants, accounting managers, and financial controllers.

You can use the Grouping by field to select how information is grouped in the report. Use the other fields on the General tab to select ranges of information to include in the report.

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

Grouping by

Select how to group the transactions on the report:

  • Bill ID – The transactions are sorted by using the bill of exchange ID. The report title is Open cartera transactions by bill.

  • Due date – The transactions are sorted by using the transaction due date. The report title is Open cartera transactions by due date.

  • Customer – The transactions are sorted by using the customer ID. The report title is Open cartera transactions by customer.

From customer

Select the starting customer account for the range of customer accounts that you want to include in the report.

To customer

Select the ending customer account for the range of customer accounts that you want to include in the report.

From Bill ID

Select the starting bill ID for the range of bill of exchange IDs that you want to include in the report.

To Bill ID

Select the ending bill ID for the range of bill of exchange IDs that you want to include in the report.

From date(Due date)

Select the starting due date for the range of due dates that you want to include in the report.

Note

This field is available only when you select Due date or Customer in the Grouping by field.

To date(Due date)

Select the ending due date for the range of due dates that you want to include in the report.

Note

This field is available only when you select Due date or Customer in the Grouping by field.

From date(Risk date)

Select the starting date of the time limit period for banks to provide feedback about customer payments.

Note

This field is available only when you select Due date or Customer in the Grouping by field.

To date(Risk date)

Select the ending date of the time limit period for banks to provide feedback about customer payments.

Note

This field is available only when you select Due date or Customer in the Grouping by field.

Open

Select this check box to include open transactions in the report.

Voucher

Enter or select a voucher to include in the report.

Status

Select a bill of exchange status to include in the report:

  • None – Include bills of exchange without a status.

  • Drawn – Include bills of exchange that are drawn.

  • Redrawn – Include bills of exchange that are redrawn.

  • Protested – Include bills of exchange that are protested.

  • Honored – Include bills of exchange that are settled.

  • Remitted – Include bills of exchange that are remitted.

  • Invoiced – Include bills of exchange that are invoiced.

  • Invoice remitted – Include bills of exchange that have remitted invoices.

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

CustBillOfExchangeOpenTrans_ES

Location of report in the AOT

SSRS Reports\Reports\CustBillOfExchangeOpenTrans_ES

Menu item of the report

CustBillOfExchangeReport_ES

Navigation to the report

Click Accounts receivable > Reports > Bill of exchange > Open cartera transactions.

Where the data in this report comes from

The data on this report comes from the following sources:

  • CustBillOfExchangeOpenTransTmp_ES table

    Note

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