Export (0) Print
Expand All
Expand Minimize

Customer account statement report (CustAccountStatementExt) [AX 2012]

Updated: November 20, 2012

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

The Customer account statement report displays external customer account statements that you can send to your customers.

The currency and language for the customer are used on the external account statement. This differs from the internal customer account statement, which always displays amounts in the accounting currency for the legal entity. If the account statement includes transactions for more than one currency, the opening balance and the closing balance are displayed in each currency.

To improve performance when you run statements for many customers at the same time, use one or more of the following options:

  • Use batch processing. By moving the processing to a server, report performance can improve.

  • Apply range restrictions to limit the number of records in each batch. Performance can be improved by submitting multiple smaller batches to be processed at the same time on different servers, instead of submitting one large batch.

  • You can select the Only open check box to include only open transactions, instead of all transactions, for each customer.

  • You can select the Balance other than zero check box to avoid printing statements for customers who have a balance of 0.00.

If your organization uses centralized statements, which means sending customer statements from one legal entity on behalf of other legal entities in your organization, make sure that you are using the legal entity of the statement before you print statements. Information about a customer's account activity in other legal entities is included on the statement, if the legal entities use the same party ID for that customer account. The transactions for each legal entity will be grouped together on the statement.

The statement address that is specified for the customer account is included on the statement. If a statement address is not specified, the primary address for the customer account is used.

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

Use print management destination

Select this check box to print the customer statement original and copies to the printer destination that is specified for the module or customer.

From date

Select the starting date of the transactions to include on the statement. By default, the report displays the opening balance in each currency for which transactions exist, as of the date in the From date field.

To date

Select the ending date of the transactions to include on the statement. By default, the report displays the closing balance in each currency for which transactions exist, as of the date in the To date field.

Only open

Select this check box to include only transactions that are not settled. This option helps reduce the time that is required to generate statements, because the reports include only open transactions, instead of all transactions, for each customer.

Include reversed

Select this check box to include reversed transactions.

Associated payment attachment on interest note

Select the type of giro money transfer slip to print, or select None. If you are printing centralized statements, a giro money transfer slip is printed only if the currency code of all the transactions printed on the statement is the same as the accounting currency of the statement legal entity.

TipTip

To be able to select one type of giro money transfer slip at a time in the Criteria column, click the Select button, and on the Range tab, select Associated payment attachment on interest note in the Field column.

Giro with sum

Select this check box to print the giro money transfer slip that is selected in the On an account statement field on the Invoice and delivery tab in the Customers form. The amount is printed on the giro money transfer slip only if this check box is selected and the accounting currency is used.

Balance other than zero

Select this check box to exclude statements that have a closing balance of zero. This option helps reduce the time that is required to generate statements, because statements are not generated for customers who have a balance of 0.00.

Show payment schedule

Select this check box to print the payment schedule installments in detail.

If this check box is cleared and a payment schedule exists, Multiple is shown as the due date.

Show credit limit

This check box is selected if a credit limit has been assigned to a customer.

NoteNote

The credit limit is always in the accounting currency and is shown on a customer statement only if the customer currency is the same as the accounting currency.

The available credit for the customer, which is calculated after the closing balance, is also included on the report.

Show due until

Select a date to include information about transactions that are due as of that date, in a separate section of the statement. For example, you can use this to include the amount, transactions, and date due for the next payment on the statement.

Show maturity distribution

Select this check box to print the maturity distribution at the bottom of the statement.

You can select this check box only if you have entered dates in the From date and To date fields. Amounts are included in the maturity distributions based on the due date for each transaction.

Aging period definitions

Select this option to show the maturity distribution according to aging period definitions that have been specified for your legal entity.

Aging period definition

Select an aging period definition. Aging period definitions that have more than six columns (aging periods) are not available in the selection list and cannot be included on a printed statement.

This field is available only if you selected the Aging period definitions option.

Print period description

Select Yes to include aging period descriptions at the top of each aging period column on the report.

This field is available only if you selected the Aging period definitions option.

Manual setup of maturity distribution

Select this option to show the maturity distribution according to period intervals that you define.

Interval

Define the period to use by entering the number of the day or month units in each period that is selected in the Day/Mth field. For example, to view aging information by week, enter 7 in this field and select Day in the Day/Mth field.

This field is available only if you selected the Manual setup of maturity distribution option.

Day/Mth

Select the unit, either Day or Month, that is used to define the period in the Interval field.

This field is available only if you selected the Manual setup of maturity distribution option.

Printing direction

Select whether to print summarized information for past or future periods, with regard to the date that is selected in the To date field. Select Backward to show information for past periods. Select Forward to show information for future periods.

This field is available only if you selected the Manual setup of maturity distribution option.

Customers

The information displayed in this field group is determined by your selections when you create a query.

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

CustAccountStatementExt

Location of report in the AOT

SSRS Reports\Reports\CustAccountStatementExt

Menu item of the report

CustAccountStatementExt

CustAccountStatementExtAction

Navigation to the report

Click Accounts receivable > Reports > External > Customer account statement.

Click Accounts receivable > Common > Customers > All customers. On the Action Pane, on the Collect tab, click Statements.

Click Accounts receivable > Common > Collections > Collections. On the Action Pane, on the Communicate tab, click Statements.

The data on this report comes from the following sources:

  • CustTable table

  • CustAccountStatementExtTmp table

NoteNote

To determine where the data in the temp table comes from, view the cross-references for the CustAccountStatementExtDP.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