PRINT CUSTOMER STATEMENT

Use this screen to print Customer Statements, which are activity reports that can be distributed to your individual customers. This will allow you to inform your customers of the detailed activity on their accounts for a given period of time. Summary information on YTD invoices, YTD payments, and balances for both before and after the selected time period are also printed. If a customer account has been placed on Hold status, this information can be displayed on the statement. The statements are designed so that they can be folded in thirds and inserted into a standard window envelope.

Report print options include:

Print these statements whenever you want to send account activity statements to your customers, or whenever you want a printed copy of a customer's account activity.

These statements are not part of the system audit trail and need not be retained. However, you may want to retain reference copies of statements that were mailed to customers.

Select Customer Account

Range Option

Use this drop-down list to select the range that determines which customers will be included in the report. The range will be sorted by customer account or customer name, depending on your selection in the Sort By group box. Valid options are All, One, Range, From Beginning, and To End. The default for this field is All.

From

Enter, or use to select, the start of the range you want to include in the report. If you select All or From Beginning in the Range Option field, this field will be unavailable. If you are sorting by account, your entry here will be validated against data in the Maintain Customer screen.

To

Enter, or use to select, the end of the range you want to include in the report. If you select All, One, or To End in the Range Option field, this field will be unavailable. The account here will be validated against data in the Maintain Customer screen.

Print Options

Show The 'On Hold' Status

Select this check box to print records for those customers who are On Hold. The phrase Status: ON HOLD will be printed on the header of the report. Please note that the Hold option in the Maintain Customer screen must also be selected for this option to work.

Suppress Statements if No Current Activity

If this check box is selected, any customer statements that have no current period activity (either invoices or payments) will not print. If this check box is not selected and there is no current period activity, the statement will print but will show only the before and after YTD invoices, YTD payments, and balances.

Include Finance Charge Information

Select this check box to include finance charges on your outstanding invoices.

Print Statements with Invoices over      days old

Select this check box to print statements only for customers with invoices over a specified number of days old. You will need to enter the number of days before you can print a statement.

Sort By

Use this group box to choose the sort criterion for your report.

Customer Account

This choice is the default setting for this screen. If you select this option, the statements will print one-to-a-page, sorted by the customer account entered in the Maintain Customer screen.

Customer Name

If you select this option, the statements will print one-to-a-page, sorted by the customer name entered in the Maintain Customer screen. Please note that the address code that has been designated as the default (D) in the Bill Code column in the Maintain Customer screen will be the address shown on the statement. If no address code has been designated as the default, no address will be printed.

Select Date Range

Starting Date

Enter the starting date of the report. This date will be displayed at the top of the report and will serve as the beginning date for the activity report.

Ending Date

Enter the ending date of the report. This date will be displayed at the top of the report and will serve as the ending date for the activity report.

Remit To

Use this drop-down list to select a valid remittance address as found in the Remittance Addresses screen in Costpoint Billing. This selection will print on the header of the report.

Table Information

Customer information on this report comes from the Customer and Customer Address tables. Invoice and payment information is taken from the A/R Invoice History and A/R Detail History tables (AR_HDR_HS and AR_DETL_HS). The Balance, YTD Invoices, and YTD Payments totals are calculated.