Menu Path: Cash Management Module Setup Cash Flow Customer Group Maintenance
Maintain cash flow customer groups.
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 |
View and set up cash flow rules for invoices that are not disputed. |
|
View and set up cash flow rules for debit memos that are not disputed. |
|
View and set up cash flow rules for resolved chargebacks that are not disputed. |
|
View and set up cash flow rules for unresolved chargebacks that are not disputed. |
|
View and set up cash flow rules for finance charges that are not disputed. |
|
View and set up cash flow rules for non-sufficient funds transactions that are not disputed. |
|
View and set up cash flow rules for credit memos, on-account transactions, unapplied payments, prepayments, and return orders. |
|
View and set up cash flow rules for disputed accounts receivable transactions. |
|
View and set up cash flow rules for open sales orders. |
|
View and set up cash flow rules for sales forecasts used by DRP. |
|
View, add, and remove customers included in the selected cash flow customer group. |
To create a cash flow customer group:
Click the New button in the ribbon.
Enter a unique code for the group in the Group Code field.
Enter a name for the group in the Name field.
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.
Click the Customers tab.
Click the Show Data button in the ribbon.
Enter a customer code/name or billing customer code/name in the Customer Code, Billing Customer Code, or Name field.
Click the Add button.
Repeat steps 7-8 for all customers and/or billing customers you want to include in the group.
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.
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. |
Field or Button |
Description |
Enter a cash flow customer group code, or click the Lookup button to select a cash flow customer group code. |
|
Enter a cash flow customer group name, or click the Lookup button to select a cash flow customer group name. |
|
This check box is selected for the default cash flow customer group. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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. |
|
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). |
|
Enter a number of past due days for which you want to enter a percent collectible. |
|
Enter a percentage you expect to collect for the entered past due days. |
|
Click this button to add a record to the Past Due Collectability grid. |
|
Click this button to remove the selected record from the Past Due Collectability grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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. |
|
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). |
|
Enter a number of past due days for which you want to enter a percent collectible. |
|
Enter a percentage you expect to collect for the entered past due days. |
|
Click this button to add a record to the Past Due Collectability grid. |
|
Click this button to remove the selected record from the Past Due Collectability grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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). |
|
Enter a number of past due days for which you want to enter a percent collectible. |
|
Enter a percentage you expect to collect for the entered past due days. |
|
Click this button to add a record to the Past Due Collectability grid. |
|
Click this button to remove the selected record from the Past Due Collectability grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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). |
|
Enter a number of past due days for which you want to enter a percent collectible. |
|
Enter a percentage you expect to collect for the entered past due days. |
|
Click this button to add a record to the Past Due Collectability grid. |
|
Click this button to remove the selected record from the Past Due Collectability grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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. |
|
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). |
|
Enter a number of past due days for which you want to enter a percent collectible. |
|
Enter a percentage you expect to collect for the entered past due days. |
|
Click this button to add a record to the Past Due Collectability grid. |
|
Click this button to remove the selected record from the Past Due Collectability grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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. |
|
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). |
|
Enter a number of past due days for which you want to enter a percent collectible. |
|
Enter a percentage you expect to collect for the entered past due days. |
|
Click this button to add a record to the Past Due Collectability grid. |
|
Click this button to remove the selected record from the Past Due Collectability grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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). |
|
Enter a number of past due days for which you want to enter a percent collectible. |
|
Enter a percentage you expect to offset for the entered past due days. |
|
Click this button to add a record to the Past Due Offset grid. |
|
Click this button to remove the selected record from the Past Due Offset grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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). |
|
Enter a number of past due days for which you want to enter a percent collectible. |
|
Enter a percentage you expect to collect for the entered past due days. |
|
Click this button to add a record to the Past Due Collectability grid. |
|
Click this button to remove the selected record from the Past Due Collectability grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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). |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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:
|
|
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). |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
Enter a customer code you want to add to the cash flow customer group, or click the Lookup button to select a customer code. |
|
Click this button to add the customer to the cash flow customer group. |
|
Enter a customer name you want to add to the cash flow category name, or click the Lookup button to select a customer name. |
|
Click this button to remove the selected customer in the Customers grid from the cash flow customer group. |
|
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. |