Run consolidation is used to execute various consolidation-related calculations and automatic postings, including intercompany elimination, minority interest/non-controlling interest posting, equity accounting entries, dividend eliminations, and more. This is required to arrive at ‌consolidated results for a group as per required accounting standards.

Ensure that the variation and the conversion calculations are run before running the consolidation calculation.

Available ways to run the consolidation process include:

  • Stand-alone calculation using the Run Task Form.
  • Run All calculation using the Run Task Form.
  • Workflow

Consolidation (Stand-Alone)

The conversion calculation can be run stand-alone using the Run Task form. When Conversion is selected, the form adapts dynamically to make the required selections obvious.

To run a consolidation task:

  1. Navigate to the Explorer module, expand the Global > Consolidation > Maintenance
  2. Double-click Run Calculations and open the downloaded form.
  3. Select Consolidation from the Select Task dropdown.
  4. Fill in the parameter details for the fields that are in yellow:
ParameterValue
ModelSpecify the model to use for consolidation.
ScenarioSpecify the scenario being consolidated. For example, Actual, Budget, or Forecast.
Rollover TypeDisplays the type of rollover. For example: 2021 P12 represents a year and period.
PeriodSpecify the period to consolidate.
YearDisplays the year to consolidate. 
EntityEnter the entity or entities to include in the consolidation. For example: a specific company, or a group of companies.
Calculation TypeDisplays the type of calculation used during consolidation. 
Use Audit ConversionThe value True or False value indicates the audit conversion used.
Use Audit ConsolidationSelect True or False to indicate the use of Audit Consolidation option.
Use European Equity PickupDisplays the True or False value indicates the use of European Equity Pickup option.
Source ScenarioDisplays the source scenario for the consolidation.
Source AuditDisplays the source audit.
Target AuditDisplays the target audit. 
Elimination DimensionSpecify the elimination dimension. 
DataviewDisplays the Dataview to use.
  1. Select Run Task to execute the consolidation.
    Ensure you select the correct values based on your requirements. Missing values may result in errors.

Run All

The conversion calculation can also be run as part of the Run All process. This process runs several calculations, including:

  • Pre-Calculations, that is, calculation on Value member in local currency.
  • Variation
  • Conversion
  • Consolidation
  • Calculation (Cash Flow)
  • Periodic Calculation from YTD

With the Run Tasks form open, to Run All process:

  1. Select Run All Tasks from the Select Task dropdown.
  2. Fill in the parameter details.
    All parameters are similar to the form for the Consolidation task.
  3. Select Run Task to execute the consolidation.
    Ensure you select the correct values based on your requirements. Missing values may result in errors.