Use this screen to print customer statements that inform your customers of the detailed activity on their accounts for a given period of time. Summary information on invoices, payments, discounts, account adjustments, and balances prior to the selected time period are also printed.
If a customer account has been placed on "Hold" status, this information can display on the statement.
Report print options include:
Option to print a range of customer statements
Option to print detailed activity on the statements for a specified date range
Option to print statements with one customer to a page and sort by either customer account or name
Option to print statements that display a customer status of "Hold"
Option to suppress a statement if it contains no current activity
Option to include finance charge information
Option to print statements with invoices only for customers whose invoices are over a specified number of days old
Option to choose the "Remit To:" address that you want to display on the statements
This screen consists of five blocks that can be used as follows:
Use the Identification block to enter a parameter ID and description.
Use the Selection Ranges block to specify which customers will have statements printed and what date range will be used to display detailed activity for those customers.
Use the Options block to further specify which statements will print and what will print on the statements.
Use the Sort By block to choose the order in which the statements will print.
Use the Generate block to select a valid remittance address that will print on the statements.
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.
|
|
Note: Org security can be applied to this function. This optional feature allows you to grant or remove rights to view and/or update specific organizations to users. |
Use the fields in this block to create a new parameter ID or to retrieve a previously-saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously-saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen.
When you save your record, all the selections you made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously-defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Customer
Use this drop-down box to select the range that determines which customers will have customer statements printed.
The statements will be ordered by customer account or customer name, depending on your selection in the Sort By block.
Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the customer account ID that will be the start of the range you want to include in the report.
If you select "All" or "From Beginning" in the Option drop-down box, this field will be unavailable. The customer account ID entered here will be validated against data in the Customers screen (Accounting\Maintain\Customers).
Enter, or use Lookup to select, the end of the range you want to include in the report.
If you select "All," "One," or "To End" in the Option drop-down box, this field will be unavailable. The customer account ID entered here will be validated against data in the Customers screen (Accounting\Maintain\Customers).
Date *
This non-editable field displays a value of "Range."
Enter, or use Calendar Lookup to select, the starting date of the report.
This date will display at the top of the report and will serve as the beginning date for the statement activity. The date selected will be compared to the invoice date and receipt date to determine what detail activity to include in the report.
Any invoice dates or receipt dates before the selected start date will be summarized in the report.
Enter, or use Calendar Lookup to select, the ending date of the report.
This date will display at the top of the report and will serve as the ending date for the statement activity.
The date selected will be compared to the invoice date and receipt date to determine what detail activity to include in the report.
You have the ability to put customers on hold in the Customers screen (Accounting\Maintain\Customers).
If you select this option, any customers who have a status of "Hold" in the Customers screen, will have the status of "On Hold" printed in the header of the statement.
Suppress Statements if No Current Activity
If you select this checkbox, any customer statements that have no invoices, receipts, or finance charges within the selected date range will not print.
If this checkbox is not selected and there are no invoices, receipts, or finance charges within the selected date range, the statement will print but will show only summary activity of the previous balance due.
Include Finance Charge Information
Select this checkbox to include finance charges on your outstanding invoices.
In order to get finance charges to appear on the statements, your customers must be set up to accept finance charges in the Credit Info tab of the Customers screen and those finance charges must have been computed during the Compute Finance Charges process. In this process, you must specify the subperiod in which the finance charges will be computed.
The ending date of the subperiod is stored in the AR Finance Charge table and will be compared against the date range to determine whether or not the finance charges will be included.
Print Statements with Invoices Over days old
Select this checkbox 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.
1st Sort *
Select one of the following options from the drop-down box:
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 ID.
Customer Name - If you select this option, the statements will print one-to-a-page, sorted by the long name set up in the Customers screen (Accounting\Maintain\Customers).
Please note that the address code that has been designated as the default ("D") in the Bill Code field in the Customers screen will be the address shown on the statement. If no address code has been designated as the default, no address will print.
Remit To *
Enter, or use Lookup to select, a valid remittance address as found in the Remittance Addresses screen (Projects\Configure\Billing).
This selection will print on the header of each customer statement.
* A red asterisk denotes a required field.
Customer information on this report comes from the CUST (Customer) and the CUST_ADDR (Customer Address) tables.
Invoice and payment information is taken from the AR_HDR_HS (A/R Header History) and the AR_DETL_HS (A/R Detail History) tables.
The finance charges are taken from the AR_FIN_CHARGES (A/R Finance Charges) table. In addition, the previous and total activity amounts are calculated.
