Using ChartField Value Sets

Use ChartField Value Sets to define sets of ChartFields used in consolidation and equitization processes. You can specify individual values, select values from specified tree levels and nodes, or use ranges of detail values. You should use trees or ranges whenever possible to reduce future maintenance if ChartField values change.

You can set up ChartField Value Sets with the same name but different SetIDs for different groups of business units, if ChartField values as part of the consolidation rules are different by business units. For example, Parent Investment on the Minority Interest Set Definition page is specified as a ChartField value set entry. You can define two ChartField value sets both named ACCT_INVESTMENT, but one under SetID SHARE and one under SET01 with each having its own set of accounts specified. The SetID for the ChartField Value Set is resolved at runtime, based on the TableSet Control for Record Group FS_12, for each business unit processed.

You can set up ChartField Value Sets for either detail ledgers or summary ledgers. Specify the summary ledger name, as well as the ledger template. You cannot use a tree to select values for summary ledgers.