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:

• Report should be ordered from the navigator
• IFS/Print Server and IFS/Connect has to be installed.
• Print Server Archiving has to be enabled.
• The PDF_REPORT_CREATED event must be defined and enabled.
• If the customer statement of account  should be sent as an Email, select E-mail from the Communication Method field in the Customer/Comm Method tab and specify the receiver's e-mail address in the Value field for the respective customer. The customer's AR Customer Contact should be entered using list of values in the Customer/Payment tab. And also select E-mail as the output media type from the Customer/Payment tab.
• If the customer statement of account  should be sent using Mail to Fax, select Fax Server from the Communication Method filed in the Company/Comm Method tab and specify the fax server in the Value field for the company.  In the Customer/Comm method tab  fax should be selected as communication method and the receiver's fax number should be specified in the Value field for the respective customer. The customer's AR Customer Contact should be entered using list of values in the Customer/Payment tab. And in the Customer/Payment tab select Mail to Fax as the output media type.
• If the customer statement of account  should be sent as an XML file, in the Customer/Comm Method tab a communication method and a corresponding Value for the communication method should be added. The customer's AR Customer Contact should be entered using list of values in the Customer/Payment tab. And in the Customer/Payment tab select XML as the output media type.

System Effects

When the customer statement of account is printed;

• The system will distribute the report to each customer based on output media when the selected output media is Email or Mail to Fax.
• The system will generate a single PDF file for all the customers having output media Printout.
• The system will generate a single XML file for all the customers having output media XML.
• A separate PDF files will be created in Report Archive window depending on output media and language.

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.