Customer Statements Report

Using this form, you can produce customer statements that list the amount customers owe. Typically, you print statements on a weekly, monthly, and/or quarterly basis. The statement cycle you assign to a customer determines when that customer's statements are printed. The report is sorted by customer.

The statements list the open item transactions and the total amount each customer owes, along with the customer's amount due in each of the five aging buckets. The report also lists the Apply to Invoice number when printing payments, debit memos, and credit memos that are not open.

The report displays (Unapplied) Finance Charges first, followed by Open (Unapplied) Credit Memos, Debit Memos, and Payments, and lastly, Invoices in descending order. Each Invoice is followed by Credit Memos, Debit Memos, Finance Charges, and Payments applied toward the individual Invoice.

You can print statements for particular cycles and for ranges of customers. You can elect to include or exclude zero balance and credit balance customers. You can also elect to omit invoices that are older than a specific number of days. In addition, you can elect to print:

• Aged totals
• Open payments
• Active transactions only
• Euro totals
• All posted transactions or only old ones

Transactions are displayed in the transaction currency and total amounts are displayed in the customer currency.

You can produce the statements for a particular site group's customers, or for customers in all site groups. You can also select the aging basis for the statements by invoice date or by due date, and can specify the date of the statements.

If an invoice has multiple due date payment terms, a line will print for each scheduled payment that has not been completely paid.