Customizing for Multiperiod Consolidation

Purpose

You perform these Customizing steps to enable the use of multiperiod consolidation.

Process Flow

A. Activate Multiperiod Consolidation

  1. Go to the process view of the Consolidation Workbench and select the appropriate consolidation area.

  2. On the Settings tab page in the Consolidation Monitor group box, select the indicator for multiperiod consolidation.

  3. Save the consolidation area.

    The entry Consolidation Cycle now appears under Start of the navigation path Data Model Next navigation step Periodicity End of the navigation path in the process view of the workbench.

B. Define the Consolidation Cycle

  1. Choose the entry Consolidation Cycle under Start of the navigation path Data Model Next navigation step Periodicity End of the navigation path in the process view of the workbench.

  2. Create a new consolidation cycle and give it a name.

  3. Define the delta year 00 as the starting year (this is mandatory), and assign a consolidation frequency.

  4. If needed, define additional delta years and assign a consolidation frequency to each delta year.

    Note Note

    The delta years must be consecutive (they must not have gaps).

    An example of valid delta years of a consolidation cycle is: 00, 01, 02, 03.

    End of the note.

  5. Save the consolidation cycle.

C. Assign Consolidation Cycles to a Version Combination

Now you need to assign all of the consolidation cycles you want to use to a version combination. The assignment is time-dependent.

  1. Go to the process view of the workbench, choose Start of the navigation path Master Data Next navigation step Versions End of the navigation path , and choose Customizing for version combinations.

  2. Specify the consolidation cycle and the starting period and year for each version combination you want to use in multiperiod consolidation.

    (If you do not want to use a version combination for multiperiod consolidation, specify only a consolidation frequency.)

    For multiperiod consolidation, a starting period is required, but a starting year is optional. For the starting period, select a period that is valid for the consolidation frequency you have assigned to delta year 00 in the consolidation cycle Customizing settings.

    If you do not specify a starting year, the consolidation cycle must span only one year. This means that the Customizing settings for the consolidation cycle must have an entry for delta year 00 only.

    If you do not specify a starting year, the system uses the year presently set in the permanent parameters. In this case, you can use the version combination in the subsequent years without needing to manually adjust the starting year.

  3. Save the version combination.

See also the example below.

Result

Now you are able to use the functions of multiperiod consolidation in the consolidation monitor and in the consolidation workbench.

The title bar of the consolidation monitor now displays Monitor for Multiperiod Consolidation , and the buttons for navigating among the periods of the consolidation cycle appear on the screen.

In the consolidation workbench, the Execute in Remaining Periods indicator now appears on the selection screen for executing task groups. (You can select this option only in update mode.) The indicator is ready for input only if a consolidation cycle is assigned to the current version combination.

Example

The following table illustrates an example of the assignment of consolidation cycles and (alternatively) consolidation frequencies to version combinations.

Assignment of Consolidation Cycles to Version Combinations

DataSlice

VersionNumber

AccountingStandards

DataCategory

ConsolidationFrequency

ConsolidationCycle

Start period

Start year

…

92

100

US GAAP

actual

Yearly

…

92

200

US GAAP

Plan

U.S. Annual Cycle

001

2006

…

92

001

IFRS

actual

Monthly

…

92

002

IFRS

Target

IFRS Semi-Annual Target

001

2007

…

92

010

German GAAP

actual

Quarterly

…