Statement Report
This report prints customer statements. The report opened from this menu uses the default statement form selected on the Accounts Receivable Module Control form.
The statement prints this information:
Header Details
- Company name
- Company address
- Company phone
- Customer code
- Customer name
- Customer address
- Period end date
- Currency
Note: 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) display 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 prints on the statement. These messages are set up on the Overdue Interest Code Maintenance form.
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
You can set these parameters for the report:
Period End Date
Enter the end date of the period for which to generate the report.
From Customer Name
Enter the name of the first customer in the range of customers to include in the report.
To Customer Name
Enter the name of the last customer in the range of customers 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 empty.
From Customer Code
Enter the first code in the range of customer codes to include in the report.
To Customer Code
Enter the last code in the range of customer codes 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 displays 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 to include in the report.
To Branch
Enter the code for the last branch in the range of branches to include in the report. To report on a single branch, enter a code in the From Branch field and leave this field empty.
Leaving the Branch Code From field empty and entering zzzzzz in this field includes 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 to include in the report.
To Currency
Enter the code for the last currency in the range of currencies to include in the report. To include a single currency code in the report, enter a code in the From Currency field and leave this field empty.
Leaving the From Currency field empty and entering zzz in this field includes all currencies in the report.
Note: 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 Desktop
combine both parent and child transactions in a pre-sort, so that they
are printed in combined date order.
- AR Module Control
- Overdue Interest Code Maintenance
- Customer Defaults
- Parent/Child Output Option
- Generic Reporting Options