- Contents
- Index
- Search
Display results with all search words
Statement Report
This report prints customer statements. The report launched from this menu uses the default statement form selected in AR Module Control.
The statement prints this information:
Header Details
- Company name
- Company address
- Company phone
- Customer code
- Customer name
- Customer address
- Period end date
- Currency
The statement
address selected in Accounts Receivable Module Control determines the
address that prints on the statement header.
Line Details
The details displayed on the statement include:
- Opening balance
- One line for each transaction that occurred during the period,
up to the period end date specified. This information displays:
- The transaction type,
- The reference of the transaction,
- The transaction date and value.
A closing balance, and the statement message (if you entered one in the report parameters), appears at the bottom of the statement.
The statement is designed to print on pre-printed stationery, and includes a remittance section that the customer can separate from the statement to send back to you with their payment.
Outstanding amounts are separated into the overdue period to which they apply, and display at the base of the statement form. If the option to Print overdue messages on statements is selected for the customer, these messages will also print on the statement. These messages are set up in Overdue Interest Code Maintenance.
Select the report Profile to determine the sort order you want the statements to print out in:
- Customer code
- Branch/Customer code
- Customer name
- Branch/Customer name
- Salesperson/Customer code
- Salesperson/Customer name
- Currency/Customer code
- Currency/Customer name
- Calendar/Customer code
- Calendar/Customer name
- Parameters
Parameters
These parameters are available when you run the report:
Period End Date
Enter the end date of the period for which you want to generate the report.
From Customer Name
Enter the name of the first customer in the range of customers that you want to include in the report.
To Customer Name
Enter the name of the last customer in the range of customers that you want to include in the report. To include only one customer in the report, enter the name in the From Customer Name field and leave this field blank.
From Customer Code
Enter the first code in the range of customer codes that you want to include in the report.
To Customer Code
Enter the last code in the range of customer codes that you want to include in the report.
Print by Parent Account
Select this option to sort the entries in the report by the customers' parent accounts.
Print Since Paid
Select this option to include all customer invoice that have been paid since the Period End Date in the report.
Statement Message
Enter a short message that will appear at the bottom of each page of the report.
Print Credit Balance Statements
Select this option to include all credit balance statements in the report.
Print Zero Balance Statements
Select this option to include all zero-balance statements in the report.
Open/Outstanding Items Only
Select this option to include only open or outstanding items in the report.
From Branch
Enter the code for the first branch in the range of branches that you want to include in the report.
To Branch
Enter the code for the last branch in the range of branches you want to include in the report. If you want to report on a single branch, enter a code in the From Branch field and leave this field blank.
Leaving the Branch Code From field empty and entering zzzzzz in this field will include all branches in the report.
From Salesperson
Enter the name or code of the first salesperson in the range of salespeople to include in the report.
To Salesperson
Enter the name or code of the last salesperson in the range of salespeople to include in the report.
From Currency
Enter the code for the first currency in the range of currencies you want to include in the report.
To Currency
Enter the code for the last currency in the range of currencies you want to include in the report. If you want to include a single currency code in the report, enter a code in the From Currency field and leave this field blank.
Leaving the From Currency field blank and entering zzz in this field includes all currencies in the report.
|
If you are using
parent/child accounts, and the option to Print
by Parent account is selected in the parameters, the
standard method used to sort the statement transaction output
is to first print all outstanding parent transactions in date
order, then each child account's transactions in date order.
You can also have Greentree combines both parent and child transactions in a pre-sort, so that they are printed in combined date order. |