Use the Run Tasks form to run calculations within your consolidation system. You can specify different parameters based on the task type selection, before running a calculation successfully.

Note: Calculations don't run against any closed period/scenario combinations when using the run tasks form. The only exception is the Rollover – Open Period. When running the open period rollover, the rollover runs even if there are closed periods within the selected year.

Overview

These tasks can be run from within the Run Tasks form:

TaskPurpose
Run All Tasks

Runs a defined set of calculations. This includes:

  • Calculation
  • Variation
  • Conversion
  • Consolidation
  • Variation First
  • Calculation
  • CYNI
  • Periodic
Pre-CalculationsRuns the calculation process for any calculation defined as calculation first. You can run this task before all other defined calculations.
CalculationsRuns the calculation process for any calculation not defined as calculation first, such as the cash flow calculations.
Current Year Net Income (CYNI)Runs the CYNI process to copy the net income to current earnings.
ConversionRuns the conversion, foreign exchange process.
RolloverRuns either the copy opening or month end rollover, depending on the type selected.
Copy JournalsRuns the process to copy recurring journal entries.
ConsolidationRuns the consolidation process. This includes intercompany eliminations, EQP, and NCI calculations.
VariationRuns the variation process to ensure the continuity schedule is in balance.
Variation Year 1Runs the variation first process to plug variation year 1 for elimination entities in year 1.
Periodic

Runs the process to calculate ‌periodic values from year-to-date (YTD) values and YTD values from periodic values.

Periodic and YTD data load can be defined on the scenario with the property Input_Periodic (TRUE, FALSE)

RatiosRuns the process to calculate the defined ratios in the system.
Different Fiscal Year EndRuns the process to calculate if an Entity has a different year-end then the Group.

Access the form

To access the form:

  1. Select the Explorer module.
  2. Expand Global > Consolidation > Maintenance.
  3. Right-click the Run Calculations form and select Open.
    Alternatively, double-click the form to open.

Note: Your administrator may have moved the form to another place, or it may be started as part of a process.

Use the form

Within the Run Tasks form:

  1. Select the task you wish to run from the Select Task dropdown.
  2. Depending on the task selected, certain parameters must be filled in.
  3. Select Run Task to run the specific tasks once all required parameters have been populated.

These columns must be populated depending upon the task selected:

ParameterApplies ToPurpose
ModelAll TasksSpecify the name of the model to run the task against. It defaults to the main Consolidation model in your system. 
ScenarioAll TasksSpecify the scenario to run the task against. 
Rollover TypeRollover

Specify the type of rollover to run:

  • CopyOpening: A Year must be defined.
  • RollOver Month: A Period must be defined. 

When CopyOpening is selected, a Year must be defined. When RollOver Month is selected, a Period must be defined.

PeriodAll Tasks (excluding Rollover – CopyOpening)Enter the period to run the task against. Select multiple periods by choosing a parent period.
YearRollover – CopyOpeningEnter the year to run the task against. 
EntityAll TasksEnter the Entity to run the task against. 
Calculation TypeRun All Calculations

Define whether to:

  • Run All Calculations or
  • Pre-Calculations: These are the calculations that have been defined as CalculationFirst. 

Selecting Calculations as the task and only Pre-Calculations as the Calculation Type is the same as selecting to run the Pre-Calculations task. 

Source ScenarioRollover - CopyOpeningSelect the source Scenario to copy from when running a copy opening rollover.
Use Audit ConversionRun All and ConversionIf True, data is logged in a table for use in conversion audit reports. 
Use Audit ConsolidationRun All and ConsolidationIf True, data is logged in a table for use in consolidation audit reports. 
Use European Equity PickupRun All and ConversionIf True, the European Equity Pickup method is used. 
Source AuditDifferent Fiscal Year EndIt defines the source Audit member for the Different Fiscal Year End calculation. 
Target AuditDifferent Fiscal Year EndIt defines the target Audit member for the Different Fiscal Year End calculation. 
Elimination DimensionRun All and Consolidation

This field is optional. 

It can be used to define an additional dimension to eliminate, such as, Business Units.

DataViewCurrent Year Net Income (CYNI)

It determines the DataView the CYNI calculation will run on. Possible options are:

  • Value
  • Conversion
  • Consolidation
  • All