Cash Flow Supplier Group Maintenance

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

Purpose

Maintain cash flow supplier groups.

Overview

Use Cash Flow Supplier Group Maintenance to create, edit, copy, and delete cash flow supplier groups, which are groups of suppliers 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 sent to suppliers in the group.

Note All suppliers must be assigned to a single cash flow supplier group.

Cash Flow Supplier Group Maintenance includes the following tabs:

Tab

Description

Vouchers

View and set up cash flow rules for vouchers that are not on hold.

Credit Memos

View and set up cash flow rules for credit memos that are not on hold.

Offsets

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

On Hold

View and set up cash flow rules for accounts payable transactions that are on hold.

Purchase Orders

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

Purchase Forecast

View and set up cash flow rules for purchase actual planned receipts used by DRP.

Suppliers

View, add, and remove suppliers included in the selected cash flow supplier group.

Creating Cash Flow Supplier Groups

To create a cash flow supplier 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 vouchers, credit memos, purchase orders, and purchase forecasts.

  5. Click the Suppliers tab.

  6. Click the Show Data button in the ribbon.

  7. Enter a supplier code or name in the Supplier Code or Name field.

  8. Click the Add button.

  9. Repeat steps 7-8 for all suppliers you want to include in the group.

  10. Click the OK button in the ribbon. The cash flow supplier group is created.

Ribbon Home Tab Buttons

Button

Description

Exit

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

New

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

Update

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

Copy

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

Delete

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

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

Show Data

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

Hide Data

Click this button to hide suppliers on the Suppliers tab, which are assigned to the selected cash flow supplier group. This button is only available after you click the Show Data button in the ribbon.

Note Hiding suppliers 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 supplier group.

Prev

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

Next

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

Last

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

Supplier

Click this button to display Supplier Maintenance, which allows you to view and maintain supplier information.

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

If a supplier is selected on the Suppliers tab, information for that supplier is displayed.

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 supplier group code, or click the Lookup button to select a cash flow supplier group code.

Name (Cash Flow Supplier Group)

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

Default Group

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

Vouchers Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an outflows type cash flow category code to associate with vouchers for suppliers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an outflows type cash flow category name to associate with vouchers for suppliers 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 vouchers for suppliers 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 vouchers for suppliers 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 sent for vouchers of suppliers in the group. Select one of the following:

  • Due Date - The due date of the voucher

  • Expected Payment Date - The earliest of the due date or discount due date (if applicable)

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).

Credit Memos Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an outflows type cash flow category code to associate with credit memos for suppliers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an outflows type cash flow category name to associate with credit memos for suppliers 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 credit memos for suppliers 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 credit memos for suppliers 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 sent for credit memos of suppliers in the group. Select one of the following:

  • Due Date -  The due date of the credit memo

  • Expected Payment Date - The earliest of the due date or discount due date (if applicable)

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).

Offsets Tab Fields and Buttons

Field or Button

Description

Category Code

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

Name (Category)

Enter an outflows type cash flow category name to associate with offsets for suppliers 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 suppliers 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 suppliers 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).

On Hold Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an outflows type cash flow category code to associate with on hold purchase orders for suppliers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an outflows type cash flow category name to associate with on hold purchase orders for suppliers 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 on hold purchase orders for suppliers 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 on hold purchase orders for suppliers 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).

Purchase Orders Tab Fields and Buttons

Field or Button

Description

Category Code

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

Name (Category)

Enter an outflows type cash flow category name to associate with open purchase orders for suppliers 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 purchase orders for suppliers 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 purchase orders for suppliers 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 sent for open purchase orders of suppliers in the group. Select one of the following:

  • Due Date -  The due date of the purchase order

  • Expected Payment Date - The earliest of the due date or discount due date (if applicable)

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).

Purchase Forecast Tab Fields and Buttons

Field or Button

Description

Category Code

Enter an outflows type cash flow category code to associate with purchase forecasts for suppliers in the group, or click the Lookup button to select a cash flow category code.

Name (Category)

Enter an outflows type cash flow category name to associate with purchase forecasts for suppliers 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 purchase forecasts for suppliers 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 purchase forecasts for suppliers 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 sent for purchase forecasts of suppliers in the group. Select one of the following:

  • Due Date -  The due date of the purchase forecast

  • Expected Payment Date - The earliest of the due date or discount due date (if applicable)

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).

Suppliers Tab Fields and Buttons

Field or Button

Description

Supplier Code

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

Add

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

Name

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

Remove

Click this button to remove the supplier selected in the Suppliers grid from the cash flow supplier group.

Remove All

Click this button to remove all suppliers in the Suppliers grid from the cash flow supplier group.

Suppliers

This grid displays suppliers in the selected cash flow supplier 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.