Configurable Calculation Rules

You manage configurable calculation rules from the Consolidation Process page.

Sample Consolidation Process page

Multi-Currency Applications

If you have a multi-currency application, the Consolidation Process page displays three tabs: Local Currency, Translated, and Consolidated.

The tabs depict the consolidation flow that Financial Consolidation and Close follows. It first performs calculations for base-level members in their local currency, then performs the translation to parent currency, and finally performs the consolidation.

Single Currency Applications

If you have a single currency application, the Consolidation Process page displays two tabs: Local Currency and Consolidated.

Calculation Rows

Each of the tabs on the Consolidation Process page displays multiple rows that depict in order, the flow of calculations that are performed. Each row is marked by one of these icons:

  • System rule icon— System. Represents that this calculation is done by Financial Consolidation and Close.
  • Human icon— Insertion point for user-defined rule. Represents the point in the process where you can insert your calculations from Calculation Manager.

When you select any of the rules in the list, the system displays a Properties panel on the right with information such as the rule name, the consolidation members for which the rule would be processed, and any override specifications, if applicable.

When you click on a row where you can insert a user-defined calculation, Calculation Manager opens in a separate tab in the browser.

Example:

  1. From the Local Currency tab, click on either After Opening Balance Carry Forward or Final Calculations.

    The system opens Calculation Manager.

  2. Expand the "Planning" folder on the left side until you see the FCCS Consol seeded rules in Calculation Manager, for example:

    • FCCS_10_After Opening Balance Carry Forward_LocalCurrency

    • FCCS_20_Final Calculations_LocalCurrency

  3. The Calculation Manager rules correspond to the Configurable Calculation rows. For example:

    • The Calculation Manager rule: FCCS_10_After Opening Balance Carry Forward_LocalCurrency

      corresponds to the: After Opening Balance Carry Forward row, where you can add your own calculations. These are calculations to be performed after the Opening Balance Carry Forward calculations, but before balancing the Balance Sheet.

    • The Calculation Manager rule: FCCS_20_Final Calculations_LocalCurrency

      corresponds to the Final Calculations row, where you can add your own additional calculations to be performed after the Balance Sheet is balanced.

The following table lists the Financial Consolidation and Close rows for each tab and the corresponding Calculation Manager rules.

Summary of Configurable Calculation Rules

Table 18-3 Multi-Currency Calculations

FCCS Tab FCCS Row Rule in Calculation Manager
Local Currency After Balance Carry Forward FCCS_10_After Opening Balance Carry Forward
Local Currency Final Calculations FCCS_20_Final_Calculations

Local Currency insertion rules are restricted to: Entity Currency / Entity Input / Entity Elimination Adj / Entity Consolidation.

In addition to Entity Input for the Consolidation dimension, you can also specify FCCS_Amount Override or FCCS_Rate Override as a valid Consolidation member.

If you want to use FCCS_Amount Override or FCCS_Rate Override, you must first set the following substitution variable for the Consol cube to enable it.

CONFCALC_ENABLE_RATE_AMOUNT_OVERRIDE = True

See Creating and Assigning Values to Substitution Variables.

   
Translated Before Foreign Exchange (FX) Calculations FCCS_25_Before FX_Calcs
Translated After Opening Balance Carry Forward FCCS_30_After Opening Balance Carry Forward
Translated Final Calculations FCCS_40_Final_Calculations

Note:

Translated insertion rules are restricted to: Parent Currency / Entity Input / Entity Elimination Adj / Entity Consolidation

   
Consolidated After Opening Balance Carry Forward FCCS_50_After Opening Balance Carry Forward
Consolidated Final Calculations FCCS_60_Final_Calculations

Note:

Consolidated insertion rules are restricted to: Parent Currency / Elimination.

   

Table 18-4 Single Currency Calculations

FCCS Tab FCCS Row Rule in Calculation Manager
Local Currency After Balance Carry Forward FCCS_110_After Opening Balance Carry Forward
Local Currency Final Calculations FCCS_120_Final_Calculations
Consolidated After Balance Carry Forward FCCS_130_After Opening Balance Carry Forward
Consolidated Final Calculations FCCS_140_Final_Calculations