Determining Consolidation ChartFields

You can base your consolidations on the business unit or another ChartField.

This section discusses how to:

  • Consolidate on business unit.

  • Consolidate on a ChartField other than business unit.

Although you can consolidate based on any ChartField, General Ledger is delivered with consolidations enabled for the business unit. If you use a different ChartField for your consolidations, substitute that ChartField name when you see a reference to business unit.

For some organizations, the system is set up to use ChartFields such as operating unit or department instead of business unit to function as separate units. Because they are all conducting the same or similar business practice and have the same structure, all the units are under one PeopleSoft business unit setup. Transactions between these operational units are recorded and need to be eliminated for financial reporting of the business unit. General Ledger enables you to set up the consolidation among the operational units the same way you would to consolidate among business units.

For example, to consolidate on the operating unit ChartField:

  1. If you are using an affiliate field to mark interoperating unit transactions, activate the Operating Unit Affiliate field on the Standard ChartField Configuration page, and associate the Operating Unit field to it.

  2. Add operating units that function as the elimination operating units to the operating unit definition.

    Assign the attribute ELIM_UNIT equal to Y for these elimination units.

  3. Build a consolidation tree that rolls up operating unit values, including regular and elimination operating units.

  4. Set up elimination sets.

    When you define an elimination set using the Affiliate approach, do not include the ChartField on which you are consolidating.

  5. Set up the consolidation set.

    Specify Operating Unit in the Entity field, and enter the business unit for the operating units.

  6. Define and process a consolidation request.

  7. Create reports that are based on the consolidation tree to show consolidated results.

See also PeopleTools Documentation: PeopleSoft Application Engine, "Using Meta-SQL and PeopleCode"

See also PeopleTools Documentation: PeopleSoft Tree Manager, "Creating Trees"