Defining ChartField Value Sets

This section provides an overview of ChartField value sets and discusses how to establish ChartField value sets.

Pages Used to Define ChartField Value Sets

Page Name	Definition Name	Navigation	Usage
ChartField Value Set	GC_CF_VALUE_SET	select Global Consolidations, then select Define Consolidations, then select Common Definitions, then select ChartField Value Set	Define a group of ChartField values.
ChartField Value Set - Notes	GC_CFV_SET_NOTES	select Global Consolidations, then select Define Consolidations, then select Common Definitions, then select ChartField Value Set, then select Notes	Enter details about a ChartField value set.

Page Name

Definition Name

Navigation

Usage

ChartField Value Set

GC_CF_VALUE_SET

select Global Consolidations, then select Define Consolidations, then select Common Definitions, then select ChartField Value Set

Define a group of ChartField values.

ChartField Value Set - Notes

GC_CFV_SET_NOTES

select Global Consolidations, then select Define Consolidations, then select Common Definitions, then select ChartField Value Set, then select Notes

Enter details about a ChartField value set.

Understanding ChartField Value Sets

A ChartField value set is a group of related ChartField values (specific accounts, departments, and so on) that you use as when defining many of the rules that drive consolidations. They enable you to specify a set of ChartField values, instead of specifying each ChartField individually.

You define which ChartField values comprise a ChartField value set by selecting a tree node, a range of values, or a set of individual values. For example, you can define a ChartField value set for all of your equity accounts, based on an account rollup tree. Later, if you need to change the ChartField values included in that set, simply update it once in the ChartField value set definition; you don't need to update every consolidation rule that uses the ChartField Value Set.

Note: You must set up the trees upon which you base the ChartField value sets before you can use those trees within your ChartField value set definitions.

ChartField Value Set Page

Use the ChartField Value Set page (GC_CF_VALUE_SET) to define a group of ChartField values.

Navigation

select Global Consolidations, then select Define Consolidations, then select Common Definitions, then select ChartField Value Set

Image: ChartField Value Set page

This example illustrates the fields and controls on the ChartField Value Set page . You can find definitions for the fields and controls later on this page.

Select the Ledger Template associated with this ChartField value set. This should be the same ledger template that you use for your consolidation ledger. The ledger template controls which ChartFields are valid.

In the Values by ChartFields group box, specify the specific values to include in this ChartField value set. Insert multiple rows as needed to define all the ChartField values that comprise the ChartField value set that you are defining. You can specify the ChartField values by using a tree or by selecting specific values from a list. The method by which you specify the ChartField values depends on your selection in the How Specified field, as do the active fields in the grid:

In the Field Name drop-down list box , select which ChartField to use for this ChartField value set.

This setting limits lookups to valid values from this ChartField.

In the How Specified, drop-down list box, select the method you want to use to specify the values to include, then specify your values by using the fields in the Select Values/Nodes grid. Select from these options:

Detail - Selected Parents

Use this option to specify values by using parent nodes of a specific tree. If you select this option, the Tree ID field becomes active. Select the tree that contains the values to include. When you select this option, the Select Values/Nodes grid contains a single Select Value field, in which you select the tree node that you want to include. Insert an additional row for each tree node that you want to include in the ChartField Value Set

Range of Values

Use this option to specify a range of values to include. When you select this option, the Select Values/Nodes grid contains both a Select Value field (the beginning value to include in the range) and a To Value field (the last value to include in the range). Insert an additional row for each range of values that you want to include in the ChartField Value Set.

Selected Detail Values

Use this option to specify individual detail values to include. When you select this option, the Select Values/Nodes grid contains a single Select Value field. Insert an additional row for each value that you want to include in the ChartField Value Set

Specify values by using the fields in the Select Values/Nodes grid, by selecting a value or a tree node.

Click the Detail button to select the value from the list of available values. You can use this button to select a tree node or a specific value.

Click the Tree button to open an interactive view of the tree specified in the Tree ID field. Expand the nodes as needed to view the parent that you want to insert. Click the node description to insert it into the Select Values/Nodes grid.

Click the Refresh button to update your tree view. For example, if you change the tree ID, you need to click this button.