Customer Statements (Open Item)

This report is a formatted open item statement of all outstanding repair invoices, sales invoices, and credit notes for each customer account (see Customers, and Invoicing).

The report may be sorted by customer account number or customer name. And it may be filtered by customer, business location, and customer language. A start date and cut-off date may optionally be specified. And items that have not yet been returned to the customer may also optionally be excluded from the statement.

While the customer statement is actually a standard report, it may be configured like a form including standard form printing options (see Statement, and Statement Form Options).

Report Option Fields

Field	Description
Customer	Enter an assigned customer account number for which to generate the report, 0 for miscellaneous customer accounts, or leave blank for all customers. Optionally, select the customer name for which to generate the report. Only customer accounts that allow printing of statements will be included in the dropdown selection list (see Customer - Billing Address/Info Tab).
Bus. Location	Enter or select the business location for which to generate the report or leave blank for all business locations. This report option is not available in the Repair Lite and Repair Micro editions.
Language	Select the desired language group to include on the report, either all languages (the system default), English customers, English/French customers, or English/Spanish customers.
Start Date	Enter or select the starting date for records to include on the report or leave blank for all records before the cut-off date. The date range is based on the invoice or credit note date. For approved repair orders the invoice date is the same as the repair completed date, while for refused repair orders the invoice date is the same as the estimate refused date.
Cut-off Date	Enter or select the cut-off date for records to include on the report or leave blank for all records after the starting date. The date range is based on the invoice or credit note date. For approved repair orders the invoice date is the same as the repair completed date, while for refused repair orders the invoice date is the same as the estimate refused date.
Sort by	Select the desired sort order, either by customer account number, or by customer name (the system default).
Include items that are still Awaiting Return	Check this box (the system default) to include items that are still waiting to be returned to the customer, or uncheck this box to only include items that have already been returned to the customer.

Only customer accounts that allow printing of statements will be included on the report (see Customer - Billing Address/Info Tab). Sales invoices are included on the report when the amount paid is different from the grand total. If the Include items that are still Awaiting Return report option is selected then Repair invoices are included on the report when they are set to any repair invoice status (see Repair Invoice Statuses) and the amount paid is different from the grand total. If the Include items that are still Awaiting Return report option is not selected then Repair invoices are included on the report when they are set to a repair status equivalent to either “(Repaired) Returned”, “(Refused by Customer) Returned”, or “(Refused by Technician) Repaired” and the amount paid is different from the grand total. And credit notes are included on the report when the amount applied is different from the grand total.

The Our Number column is the sales invoice number, repair order number, or credit note number. The Your Number column is the Reference 1 field from the corresponding record. And the Other Reference column is the Reference 2 field from the corresponding record. The Amount column and the taxes are all calculated after any discounts have been applied.

The aging periods are determined by calculating the difference between today’s date and the invoice or credit note date, and they do not take into account the payment terms. For approved repair orders the invoice date is the same as the repair completed date, while for refused repair orders the invoice date is the same as the estimate refused date. The payment terms displayed are the payment terms associated with the customer account, and may not be the same as the individual payment terms recorded with each individual invoice.

For licensed users of version 2.2 and higher, this report is also available in combined English/French and English/Spanish in addition to English (see Language of Communication).

Customers Over Their Credit Limit