Collection Statement Group Maintenance

Menu Path: Credit and Collections $Images\bluerarw.gif$ Module Setup $Images\bluerarw.gif$ Collection $Images\bluerarw.gif$ Collection Statement Group Maintenance

Purpose

Add, update, or delete collection statement groups.

Overview

Use Collection Statement Group Maintenance to create new collection statement groups. The format and content of a collection statement for a customer are determined by the collection statement group. For more information on printing collection statements, see Collection Statement Print.

Note If a collection statement is printed for a customer without an assigned collection statement group (for example, directly from Customer Open Accounts Receivable Management), the Default statement group rules are used.

For database information for this window, see Collection Statement Group Maintenance Database Information.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the Collection Statement Group Maintenance window.
New	Click this button to create a new collection statement group.
Update	Click this button to update the selected collection statement group.
Delete	Click this button to delete the selected collection statement group.
OK	Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
Cancel	Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
First	Click this button to display the first collection statement group.
Prev	Click this button to display the previous collection statement group.
Next	Click this button to display the next collection statement group.
Last	Click this button to display the last collection statement group.

Fields and Buttons

Field or Button	Description
Statement Group Code	Enter a collection statement group code, or click the Lookup button to select a collection statement group code.

Main Tab Fields and Buttons

Field or Button	Description
Statement Group Name	Enter the name of the collection statement group.
Display Currency	Click the Lookup button to select the currency for displayed amounts in this window. This defaults to the default general ledger currency. You cannot change the display currency if you are creating, updating, or deleting a collection statement group.
Sort Sequence	Enter a number to indicate the sequence in which the collection statement group appears in Lookup windows.
Statement Option	Click the Lookup button to select one of the following collection statement options to determine whether collection statements print in Collection Statement Print: Always - Always print a statement for customers in this group regardless of the balance or past due condition. Never - Never print a statement. Customers are excluded from statement printing. Non-Credit Balance - Only print a statement if the customer’s Adjusted Accounts Receivable balance is greater than or equal to the amount entered in the Minimum Balance field. Past Due Balance - Only print a statement if there are past due accounts receivable transactions and the Adjusted Accounts Receivable balance is greater than or equal to the amount entered in the Minimum Balance field.
Minimum Balance	Enter an amount that the Adjusted Accounts Receivable balance must be greater than to qualify for printing a collection statement. This field is only enabled if you select Non-Credit Balance or Past Due Balance in the Statement Option field.
Statement Type	Click the Lookup button to select a statement type. Select one of the following options: Balance Forward - Display a beginning balance, a list of all of the transactions, then the ending balance (similar to a credit card statement). This option works in conjunction with the Statement Frequency and Balance Forward # of Weeks fields. Open Item - Display open accounts receivable transactions as of a specific date on the collection statement.
Statement Frequency	Click the Lookup button to select how often customers receive collection statements. Select one of the following options: Weekly - Customers receive statements based on one or more weekly cycles (for example, every two weeks). Monthly - Customers receive statements every calendar month-end. This field is only enabled if you select Balance Forward in the Statement Type field.
Balance Forward # of Weeks	Enter the number of weeks back that the balance forward starts. This field is only enabled if you select Balance Forward in the Statement Type field and Weekly in the Statement Frequency field.
Aging Basis	Click the Lookup button to select an aging basis for the collection statement group. Select one of the following options: Due Date - Use the due date to calculate the aging buckets. Reference Date - Use the reference date to calculate the aging buckets.
Sorting	Click the Lookup button to select a method of sorting for the collection statement group. You can sort by reference number, reference date, or due date.
Exclude Credit Memos - Days Prior	Enter a number of days to exclude any credit memos older (based on comparing the statement date and the reference date) than this number of days from statement printing. Example You enter 90 in this field. A statement is run as of 12/31/2020 for Customer A. There are credit memos for $100 dated 2/10/2020 and $300 dated 11/30/2020. The credit memo for $100 dated 2/10/2020 is excluded from Customer A’s statement. Note If you always want credit memos to be printed on statements regardless of how old they are, enter 9999 in this field.
Offset Unapplied Payments	Select this check box to offset unapplied payments against the oldest past due invoices to determine whether there is a past due balance. This rule works with the Past Due Balance statement option. Example There are two past due invoices totaling $2,000. There are three unapplied payments totaling $1,800. If this check box is selected, then the past due balance is considered to be $200, otherwise it is $2,000.
Offset Credit Memos	Select this check box to offset credit memos against the oldest past due invoices to determine whether there is a past due balance. This rule works with the Past Due Balance statement option. EXAMPLE There are two past due invoices totaling $2,000. There are three credit memos totaling $1,800. If this check box is selected, then the past due balance is considered to be $200, otherwise it is $2,000.
Offset On-Accounts	Select this check box to offset on-account amounts against the oldest past due invoices to determine whether there is a past due balance. This rule works with the Past Due Balance statement option. EXAMPLE There are two past due invoices totaling $2,000. There are three on-account transactions totaling $1,800. If this check box is selected, then the past due balance is considered to be $200, otherwise it is $2,000.
Include Chargebacks	Select this check box to include chargebacks (reference type of CB) for printing and for the calculation of Adjusted Accounts Receivable balance.
Include Disputed Invoices	Select this check box to include disputed invoices for printing and for the calculation of Adjusted Accounts Receivable balance.
Include C.O.D. Invoices	Select this check box to include C.O.D. invoices for printing and for the calculation of Adjusted Accounts Receivable balance.