Cash Flow Customer Group Maintenance

Menu Path: Cash Management Images\bluerarw.gif Module Setup Images\bluerarw.gif Cash Flow Customer Group Maintenance

Purpose

Maintain cash flow customer groups.

Overview

Use Cash Flow Customer Group Maintenance to create, edit, copy, and delete cash flow customer groups, which are groups of customers for cash flow calculation and reporting. For each group, you can set up rules for incoming and outgoing cash flow to indicate how and when cash is received from customers in the group.

Note Each customer must be assigned to a specific cash flow customer group in Customer Maintenance.

Cash Flow Customer Group Maintenance includes the following tabs:

Tab

Description

Invoices

View and set up cash flow rules for invoices that are not disputed.

Debit Memos

View and set up cash flow rules for debit memos that are not disputed.

Resolved Chargebacks

View and set up cash flow rules for resolved chargebacks that are not disputed.

Unresolved Chargebacks

View and set up cash flow rules for unresolved chargebacks that are not disputed.

Finance Charges

View and set up cash flow rules for finance charges that are not disputed.

Non-Sufficient Funds

View and set up cash flow rules for non-sufficient funds transactions that are not disputed.

Offsets

View and set up cash flow rules for credit memos, on-account transactions, unapplied payments, prepayments, and return orders.

Disputed

View and set up cash flow rules for disputed accounts receivable transactions.

Sales Orders

View and set up cash flow rules for open sales orders.

Sales Forecast

View and set up cash flow rules for sales forecasts used by DRP.

Customers

View, add, and remove customers included in the selected cash flow customer group.

Creating Cash Flow Customer Groups

To create a cash flow customer group:

  1. Click the New button in the ribbon.

  2. Enter a unique code for the group in the Group Code field.

  3. Enter a name for the group in the Name field.

  4. Enter transaction-specific rules for the group on each of the tabs. You must select a cash flow category for each transaction type, and date methods for invoices, debit memos, resolved chargebacks, unresolved chargebacks, finance charges, non-sufficient funds, disputed transactions, sales orders, and sales forecasts. You must also specify a payment terms code for all others.

  5. Click the Customers tab.

  6. Click the Show Data button in the ribbon.

  7. Enter a customer code/name or billing customer code/name in the Customer Code, Billing Customer Code, or Name field.

  8. Click the Add button.

  9. Repeat steps 7-8 for all customers and/or billing customers you want to include in the group.

  10. Click the OK button in the ribbon. The Question dialog box appears and asks if you want to update cash flow information for existing transactions. If you do want to, click the Yes button. Otherwise, click the No button. The cash flow customer group is created.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Cash Flow Customer Group Maintenance window.

New

Click this button to create a new cash flow customer group.

Update

Click this button to update the selected cash flow customer group.

Copy

Click this button to copy the selected cash flow customer group.

Delete

Click this button to delete the selected cash flow customer group.

Note You cannot delete the All Others group, which is the default group.

Show Data

Click this button to display customers on the Customers tab, which are assigned to the selected cash flow customer group. This button is only available if you click the Customers tab.

Hide Data

Click this button to hide customers on the Customers tab, which are assigned to the selected cash flow customer group.

Note Hiding customers may increase performance in this window.

OK

Click this button to accept an action. This button is only available if you click the New, Update, Copy or Delete button in the ribbon.

Cancel

Click this button to cancel an action. This button is only available if you click the New, Update, Copy or Delete button in the ribbon.

First

Click this button to display the first cash flow customer group.

Prev

Click this button to display the previous cash flow customer group.

Next

Click this button to display the next cash flow customer group.

Last

Click this button to display the last cash flow customer group.

Customer

Click this button to display Customer Maintenance, which allows you to view and maintain customer information. If a customer is selected on the Customers tab, information for that customer is displayed.

Note If you are not authorized to use Customer Maintenance, the Customer Inquiry window appears instead, and allows you to view information for the customer.

Category

Click this button to display Cash Flow Category Maintenance, which allows you to set up and maintain cash flow categories and subcategories.

Fields and Buttons

Field or Button

Description

Group Code

Enter a cash flow customer group code, or click the Lookup button to select a cash flow customer group code.

Name (Cash Flow Customer Group)

Enter a cash flow customer group name, or click the Lookup button to select a cash flow customer group name.

Default Group

This check box is selected for the default cash flow customer group.

Invoices Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with undisputed invoices for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with undisputed invoices for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with undisputed invoices for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with undisputed invoices for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for undisputed invoices of customers in the group. Select one of the following:

Prior Months

Enter the number of prior months for date calculation. This field is only enabled if you select Average Days Past Due, Average Days to Pay, Weighted Average Days Past Due, or Weighted Average Days to Pay for the Date Method field.

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Past Due Days

Enter a number of past due days for which you want to enter a percent collectible.

Percent Collectible

Enter a percentage you expect to collect for the entered past due days.

Add

Click this button to add a record to the Past Due Collectability grid.

Remove

Click this button to remove the selected record from the Past Due Collectability grid.

Past Due Collectability

This grid displays the percent collectible for specific days invoices for the group are past due.

Example If an invoice is 30 days past due, you expect customers to pay 100% of invoice amounts, if an invoice is 60 days past due, you expect customers to pay 80% of invoice amounts, etc.

Debit Memos Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with undisputed debit memos for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with undisputed debit memos for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with undisputed debit memos for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with undisputed debit memos for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for undisputed debit memos of customers in the group. Select one of the following:

Prior Months

Enter the number of prior months for date calculation. This field is only enabled if you select Average Days Past Due, Average Days to Pay, Weighted Average Days Past Due, or Weighted Average Days to Pay for the Date Method field.

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Past Due Days

Enter a number of past due days for which you want to enter a percent collectible.

Percent Collectible

Enter a percentage you expect to collect for the entered past due days.

Add

Click this button to add a record to the Past Due Collectability grid.

Remove

Click this button to remove the selected record from the Past Due Collectability grid.

Past Due Collectability

This grid displays the percent collectible for specific days debit memos for the group are past due.

Example If a debit memo is 30 days past due, you expect customers to pay 100% of debit memo amounts, if a debit memo is 60 days past due, you expect customers to pay 80% of debit memo amounts, etc.

Resolved Chargebacks Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with resolved chargebacks for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with resolved chargebacks for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with resolved chargebacks for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with resolved chargebacks for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for resolved chargebacks of customers in the group. Select one of the following:

  • Chargeback Due Date -  The due date of the chargeback

  • Resolved Date - The date of the chargeback resolution

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Past Due Days

Enter a number of past due days for which you want to enter a percent collectible.

Percent Collectible

Enter a percentage you expect to collect for the entered past due days.

Add

Click this button to add a record to the Past Due Collectability grid.

Remove

Click this button to remove the selected record from the Past Due Collectability grid.

Past Due Collectability

This grid displays the percent collectible for specific days resolved chargebacks for the group are past due.

Example If a resolved chargeback is 30 days past due, you expect customers to pay 100% of chargeback amounts, if a resolved chargeback is 60 days past due, you expect customers to pay 80% of chargeback amounts, etc.

Unresolved Chargebacks Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with unresolved chargebacks for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with unresolved chargebacks for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with unresolved chargebacks for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with unresolved chargebacks for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for unresolved chargebacks of customers in the group. Select one of the following:

  • Chargeback Due Date -  The due date of the chargeback

  • Resolved Date - The date of the chargeback resolution

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Past Due Days

Enter a number of past due days for which you want to enter a percent collectible.

Percent Collectible

Enter a percentage you expect to collect for the entered past due days.

Add

Click this button to add a record to the Past Due Collectability grid.

Remove

Click this button to remove the selected record from the Past Due Collectability grid.

Past Due Collectability

This grid displays the percent collectible for specific days unresolved chargebacks for the group are past due.

Example If an unresolved chargeback is 30 days past due, you expect customers to pay 100% of chargeback amounts, if an unresolved chargeback is 60 days past due, you expect customers to pay 80% of chargeback amounts, etc.

Finance Charges Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with finance charges for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with finance charges for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with finance charges for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with finance charges for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for finance charges of customers in the group. Select one of the following:

Prior Months

Enter the number of prior months for date calculation. This field is only enabled if you select Average Days Past Due, Average Days to Pay, Weighted Average Days Past Due, or Weighted Average Days to Pay for the Date Method field.

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Past Due Days

Enter a number of past due days for which you want to enter a percent collectible.

Percent Collectible

Enter a percentage you expect to collect for the entered past due days.

Add

Click this button to add a record to the Past Due Collectability grid.

Remove

Click this button to remove the selected record from the Past Due Collectability grid.

Past Due Collectability

This grid displays the percent collectible for specific days finance charges for the group are past due.

Example If a finance charge is 30 days past due, you expect customers to pay 100% of finance charge amounts, if a finance charge is 60 days past due, you expect customers to pay 80% of finance charge amounts, etc.

Non-Sufficient Funds Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with non-sufficient funds transactions for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with non-sufficient funds transactions for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with non-sufficient funds transactions for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with non-sufficient funds transactions for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for non-sufficient funds transactions of customers in the group. Select one of the following:

Prior Months

Enter the number of prior months for date calculation. This field is only enabled if you select Average Days Past Due, Average Days to Pay, Weighted Average Days Past Due, or Weighted Average Days to Pay for the Date Method field.

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Past Due Days

Enter a number of past due days for which you want to enter a percent collectible.

Percent Collectible

Enter a percentage you expect to collect for the entered past due days.

Add

Click this button to add a record to the Past Due Collectability grid.

Remove

Click this button to remove the selected record from the Past Due Collectability grid.

Past Due Collectability

This grid displays the percent collectible for specific days non-sufficient funds transactions for the group are past due.

Example If a non-sufficient funds transaction is 30 days past due, you expect customers to pay 100% of non-sufficient funds transaction amounts, if a non-sufficient funds transaction is 60 days past due, you expect customers to pay 80% of non-sufficient funds transaction amounts, etc.

Offsets Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with offsets for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with offsets for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with offsets for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with offsets for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Past Due Days

Enter a number of past due days for which you want to enter a percent collectible.

Percent Offset

Enter a percentage you expect to offset for the entered past due days.

Add

Click this button to add a record to the Past Due Offset grid.

Remove

Click this button to remove the selected record from the Past Due Offset grid.

Past Due Offset

This grid displays the percent collectible for specific days offsets for the group are past due.

Example If an offset is 30 days past due, you expect customers to pay 100% of offset amounts, if an offset is 60 days past due, you expect customers to pay 80% of offset amounts, etc.

Disputed Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with disputed transactions for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with disputed transactions for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with disputed transactions for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with disputed transactions for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for disputed transactions of customers in the group. Select one of the following:

  • Disputed Invoice Date -  The date dispute was recorded

  • Original Due Date - The original due date of the transaction

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Past Due Days

Enter a number of past due days for which you want to enter a percent collectible.

Percent Collectible

Enter a percentage you expect to collect for the entered past due days.

Add

Click this button to add a record to the Past Due Collectability grid.

Remove

Click this button to remove the selected record from the Past Due Collectability grid.

Past Due Collectability

This grid displays the percent collectible for specific days disputed transactions for the group are past due.

Example If a disputed transaction is 30 days past due, you expect customers to pay 100% of disputed transaction amounts, if a disputed transaction is 60 days past due, you expect customers to pay 80% of disputed transaction amounts, etc.

Sales Orders Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with open sales orders for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with open sales orders for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with open sales orders for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with open sales orders for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for open sales orders of customers in the group. Select one of the following:

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Sales Forecast Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an inflows type cash flow category code to associate with sales forecasts for customers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an inflows type cash flow category name to associate with sales forecasts for customers in the group, or click the Lookup button to select a cash flow category name.

Subcategory Code

Enter a cash flow subcategory code to associate with sales forecasts for customers in the group, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

Name (Subcategory)

Enter a cash flow subcategory name to associate with sales forecasts for customers in the group, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you enter a cash flow category code or name in the Category Code or Name field, for which subcategories exist.

All Others Payment Terms

Enter the payment terms code for the All Others forecast group, or click the Lookup button to select a payment terms code.

Note For customers in forecast groups that are not the All Others forecast group, the payment terms code for the first customer in the forecast group is used.

Date Method

Click the Lookup button to select the date method used to calculate when cash is received for sales forecasts of customers in the group. Select one of the following:

Additional Days

Enter any additional days to add to the calculated cash flow date (or added to today's date if today is after the calculated cash flow date).

Customers Tab Fields and Buttons

Field or Button

Description

Billing Customer Code

Enter a billing customer code you want to add to the cash flow customer group, or click the Lookup button to select a billing customer code.

Add (Billing Customer)

Click this button to add the billing customer and all customers for the billing customer to the cash flow customer group.

Example If Customer A is the billing customer for customer B and customer C, when you click this button, customer A, B, and C are added to the cash flow customer group.

Name (Billing Customer)

Enter a billing customer name you want to add to the cash flow customer group, or click the Lookup button to select a billing customer name.

Remove (Billing Customer)

Click this button to remove the selected billing customer in the Customers grid and all customers for the billing customer from the cash flow customer group.

Customer Code

Enter a customer code you want to add to the cash flow customer group, or click the Lookup button to select a customer code.

Add (Customer)

Click this button to add the customer to the cash flow customer group.

Name (Customer)

Enter a customer name you want to add to the cash flow category name, or click the Lookup button to select a customer name.

Remove (Customer)

Click this button to remove the selected customer in the Customers grid from the cash flow customer group.

Customers

This grid displays customers in the selected cash flow customer group after you click the Show Data button in the ribbon.

Note This grid is cached to improve performance. You cannot sort, filter, group, graph, or summarize data in this grid.