Customer account statement report (CustAccountStatementExt)
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 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.
Use parallel processing. By dividing this process into multiple tasks, report performance can improve. Because multiple tasks are running at the same time, the reports might be printed in a different order than the order that was specified.
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.
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 |
|---|---|
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. Tip 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. Note 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. |
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 |
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. |
Where the data in this report comes from
The data on this report comes from the following sources:
CustTable table
CustAccountStatementExtTmp table
Note
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.
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).
See also
Print periodic customer account statements