Consolidation and Translation Rules

Tax Reporting provides pre-built calculation scripts to handle consolidation and translation. In addition, the system provides pre-built scripts and member formulas for some of the standard calculation processes. For example, these rules are provided by default:

Table 17-1 Consolidation and Translation Rules

Rule	Description
Consolidate	Executes Financial Consolidation for a given Scenario, Year, Period and Entity. Intelligently performs consolidation based on Entity's consolidation status.
Consolidate_CbCR	Executes Financial Consolidation for a given Scenario, Year, Period and Entity. Intelligently performs consolidation based on Entity's consolidation status.
ForceConsolidate	Executes the Consolidation by ignoring the internal processing flags. This operation is targeted towards Administration user to recover from a bad state.
Translate	Translates the consolidated data for a given Scenario, Year, Period, Entity and its descendants to the selected Reporting currency. If the entity is not consolidated, it is first consolidated as per the status, and then translated to the reporting currency.
Translate_CbCR	Translates the consolidated data for a given Scenario, Year, Period, Entity and its descendants to the selected Reporting currency. If the entity is not consolidated, it is first consolidated as per the status, and then translated to the reporting currency.
ForceTranslate	Executes the Translation by ignoring the internal processing flags. This operation is targeted towards the Administration user to recover the system from a bad state.
ForceTranslate_CbCR	Executes the Translation by ignoring the internal processing flags. This operation is targeted towards the Administration user to recover the system from a bad state.
DataLoad_PreProcess_Consol	Rule executed as part of pre processing operation for Data Load. This rule is not for standalone execution.
DataLoad_PostProcess_Consol	Rule executed as part of post processing operation for Data Load. This rule is not for standalone execution.
MetadataLoad_PostProcess_Consol	Rule executed as part of post processing operation for any metadata changes. This rule is not for standalone execution.
TrcsFormStatusProcessor	Rule executed as part of post processing operation for Data Form save. This rule is not for standalone execution.
RefreshDataBase_PostProcess_Consol	Rule executed as part of post processing operation for Refresh Database. This rule is not for standalone execution.
RefreshDataBase_DelegatePostProcess_Consol	This rule delegates database post processing call to Task Manager and Supplemental Data Manager modules to sync the metadata.
CopyTaxAutomationRule	This rule is used in Rollover process to copy the Tax Automation rule mapping. It copies mapping to target period from prior period.
ImpactStatusEntitiesWithData	This rule is used internally by system to update the data status of entities based on mapping defined by user in Tax Automation form. This rule is not for standalone execution.
CopyTaxRateRule	This rule is used in Rollover process to copy the Tax Rate. It copies data to target period from prior period.
Form_PreProcess_Consol	Rule executed as part of pre processing operation for Data Form save. This rule is not for standalone execution.
ComputeRates	Computes Average and Ending rates for a given Scenario, Period and Year based on direct rates entered in the system against given From and To currencies. Performs triangulation based on Application currency, in case direct rates are not entered.
CopyFXRatesRule	This rule is used in Rollover process to copy the FX Rate data. It copies data to target period from prior period.
RefreshDataBase_PostProcess_Rates	Rule executed as part of post processing operation for Refresh Database. This rule is not for standalone execution.
DataLoad_PostProcess_Rates	Rule executed as part of post processing operation for Data Load. This rule is not for standalone execution.
RefreshSDMCurrencyRates	Rule executed as part of post processing operation for Refresh Database, Data Load, Form Save. This rule is not for standalone execution.
DataLoad_PostProcess_CbCR	Rule executed as part of post processing operation for Data Load. This rule is not for standalone execution.
ImpactStatusEntitiesWithData_CbCR	This rule is used internally by system to update the data status of entities based on mapping defined by user in Tax Automation form. This rule is not for standalone execution.
MetadataLoad_PostProcess_CbCR	Rule executed as part of post processing operation for any metadata changes. This rule is not for standalone execution.
RefreshDataBase_DelegatePostProcess	This rule delegates database post processing call to Task Manager and Supplemental Data Manager modules to sync the metadata.
RefreshDataBase_PostProcess_CbCR	Rule executed as part of post processing operation for Refresh Database. This rule is not for standalone execution.
TrcsFormStatusProcessor_CbCR	Rule executed as part of post processing operation for Data Form save. This rule is not for standalone execution.