1. Administering Financial Consolidation and Close
  2. Consolidating Data
  3. Calculation Status

Calculation Status

Financial Consolidation and Close maintains the calculation status for each Scenario, Period, Entity and Parent entity combination. The calculation status indicates whether data needs to be translated or consolidated. The calculation status can change as a result of several actions:

  • Changing the organization structure

  • Adding or deleting accounts

  • Modifying entity attributes

  • Entering data in data grids, or loading data from external sources

  • Posting or unposting journals

  • Reloading rules

  • Changing percent consolidation

  • Changing currency rates

  • Changing override amount data

Table 18-1 Consolidation Statuses

Status Description
OK Data is OK - none of the data for the specified dimensions has changed.
No Data No data exists for the specified dimensions.
Impacted Data has changed since last generated, which requires a reconsolidation to change its status to OK. This occurs when a change to a base entity data impacts a parent entity.
Needs Translation The selected dimension member is not the entity’s default currency and its translated values may not be current.
System Change A change has occurred that may affect the data for the specified dimensions. For example, a new rules file or metadata file has been loaded, or the currency rate has changed.

You can view the calculation status in forms and grids and then take action as necessary. The following tables list available actions for forms and grids.

Table 18-2 Entity Input/ Entity Currency - Base Entity

Status Description Action
No Data No data has been entered or generated. None
OK None of the data has changed. None

Table 18-3 Entity Consolidation / Entity Currency - Parent Entity

Status Description Action
OK None of the data has changed. None
Impacted A parent entity has been impacted by a change to a child entity. Consolidate

Table 18-4 Entity Input/ Reporting Currency - Base Entity

Status Description Action
OK None of the data has changed. None
Needs Translation Data needs to be translated because it has never been translated or data has changed since the last translation. Translate

Table 18-5 Entity Consolidation/ Reporting Currency - Parent Entity

Status Description Action
OK Consolidation has been done, and data has been translated. None
Needs Translation Data needs to be translated for the following reasons:

  1. Parent entity needs consolidation first to generate the Entity Consolidation data and then translate.

  2. Parent entity needs to reconsolidate first because child data has changed and then translate.

  3. Parent entity data is OK so only need to translate.

Translate

  1. The system will first consolidate and then translate.

  2. The system will first consolidate and then translate.

  3. Translation is required by user.

Table 18-6 Proportion or Elimination / Parent Currency - Base Entity

Status Description Action
No Data No data has been generated from Consolidation. Consolidate
OK Data is OK. None
Impacted Data has changed since last generated, which requires reconsolidation to change its status to OK. Consolidate

Table 18-7 Proportion or Elimination / Reporting Currency - Base Entity

Status Description Action
No Data No data has been generated from Consolidate and no translation has been done. Translate
OK Proportion and Elimination data has been generated from Consolidation and data has also been translated. None
Need Translation Data needs to be translated for the following reasons:

  1. Proportion data needs to be re-generated before translation.

  2. Proportion data has been generated and is OK, but translation has not been run.

  1. The system will reconsolidate and then translate data.

  2. The system will translate only the Proportion data.