Order - Customer Statement of Account

Explanation

This activity is used to view or print the customer statement of account. The customer statement of account contains all open (unpaid) customer transactions of the company, as of the date for which the statement was ordered. The customer statement of account can also be used as a customer confirmation statement by using the confirmation statement template connected to the customer to generate the report.

When the customer statement of account is printed, the information sends to each customer based on the details connected to the AR customer contact and output media; Printout, Email, Mail to Fax and XML.

Prerequisites

In order to perform this activity, records of transactions which have taken place between the company and it's customers during the time period specified in the Customer Statement of Account dialog box must exist in the system.

The following prerequisites should be met in order to send the customer statement of account using output media:

System Effects

Confirmation Statement Template System Effect
Used The customer confirmation statement report will be generated for customers for whom a confirmation statement template is specified in the Customer/Payment tab window. This report consists of two copies of the customer statement of account report.
Not used The customer statement of account report will be generated for all the customers with whom the company has carried out transactions during the time period specified in the Customer Statement of Account dialog box.

When the customer statement of account is printed;

Window

Customer Statement of Account

Related Window Descriptions

          Customer Statement of Account

Order Customer Statement of Account

Procedure

  1. Open the Customer Statement of Account dialog box.
  2. Select the Document Date from the Selection Based On list if you want the transactions to be reported according to the invoice date/payment date. Or select Voucher Date from the Selection Based On list if you want the transactions to be reported according to the voucher date. The voucher date is selected by default.
  3. Select the Period option and enter the year and period up to which the transactions should be fetched to the report. By default the Date option is selected with the system date.
  4. Select a value for the Template ID field from the list of values.
  5. Enter from/to values for the selection objects or add new selection objects with from/to values according to the way you want to order the report. If you want the selection information to be saved in a new template, click Create Template and define a new template ID in the Create Selection Template dialog box. Note that the information cannot be saved in the currently selected template or any other existing template.
  6. In the Options tab, select a value for the Ledger Status field from the list to specify the ledger status of the transactions to be included in the report.
  7. In the Advance/Prepayment Invoices field select a value from the list to indicate whether advance/prepayment invoices should be included in the report. If Include is selected, advance invoices/prepayment based invoices, as well as other ledger items will be included in the report. If Exclude is selected, advance invoices/prepayment based invoices will be excluded from the report. If Only is selected, advance invoices/prepayment based invoices will be included in the report, but all other invoice ledger items will be excluded.
  8. Enter the required value for days of ageing  for Period 1, Period 2 and Period 3 fields.
  9. Select the Exclude Advance Payments check box if you want advance payments to be excluded from the report.
  10. Select the Exclude Payments on Account check box if you want payments on account to be excluded from the report.
  11. Select the Non Cashed/ Open Pay Documents check box if you want to exclude non cashed/open payment documents from the report.
  12. Select the Include Customers with No Open Items check box if you want to include customers that do not have open ledger items.
  13. Select the Include Connected Suppliers check box if you want to include transactions entered for any supplier who has the same association number as any customer for whom the report is generated.
  14. Select the Print Separate Debit and Credit Amounts check box if you want the debit amounts and the credit amounts resulting from the transactions to be separately disclosed in the report.
  15. Select the Use Confirmation Statement Template check box if you want to use the customer statement of account report as a customer confirmation statement.
  16. Select the Print Notes check box if you want to print latest note connected to each ledger item.
  17. Specify whether the transactions included in the report should be sorted based on the Document Date or the Document No by selecting a sort by option.
  18. Click OK to order the report.

Note: Alternatively, you can view or print this report from AR Reports/Reports. First page of the report with report parameters will not be printed when you order the report from the navigator. Therefore to get the total report, it should be ordered from AR Reports/Reports.