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
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;
- 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
Order Customer
Statement of Account
Procedure
- Open the Customer
Statement of Account dialog box.
- 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.
- 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.
- Select a value for the Template ID field from the list of values.
- 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.
- 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.
- 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.
- Enter the
required value for days of ageing for Period 1, Period 2 and
Period 3 fields.
- Select the Exclude Advance Payments check box if you want advance
payments to be excluded from the report.
- Select the Exclude Payments on Account check box if you want payments
on account to be excluded from the report.
- Select the Non Cashed/ Open Pay Documents check box if you want to
exclude non cashed/open payment documents from the report.
- Select the Include Customers with No Open Items check box if you want
to include customers that do not have open ledger items.
- 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.
- 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.
- Select the Use Confirmation Statement Template check box if you want
to use the customer statement of account report as a customer confirmation
statement.
- Select the Print Notes check box if you want to print latest note
connected to each ledger item.
- 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.
- 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.