Specifying Default Translation Settings
You can configure default translation settings for each consolidation cube. When additional cubes are enabled, select the cube on the Consolidation Process page before opening the translation configuration. The default settings apply to the selected cube unless a relevant translation override exists.
Note:
Any changes to the default translation settings impact existing data in the application. The calculation status changes from OK to System Change, and the status for all reporting currency changes to Needs Translation. This applies to both locked and unlocked entities.- Only Service Administrators can modify Default Translation Settings.
- Power Users can view Default Translation Settings.
- Users and Viewers cannot modify Default Translation Settings.
System Default Translation Settings
When an application is first created, the system creates the following settings by default.
Balance account
- Translation method: Periodic
- Rate Account: Ending
Flow account
- Translation method: Periodic
- Rate Account: Average
Enabling Year-to-Date FX Variance Translation Calculations
For Flow accounts, by default, FX Variance calculations are executed on a Periodic basis.
You can set the FX Method to Year-to-Date to enable the Year-to-Date calculation of FX Opening and FX Movements. You must first enable the YTDFXCalculation consolidation setting. The FX Method option will then be displayed on the Default Translation Methods page for Flow Account, and you can select Year-to-Date.
Note:
YTDFX Calculation is only available for Consolidation, and not supported for Reporting Currency translation.When you enable YTD FX calculations, you must reconsolidate data from the starting year of the application.
Note that for the first year, Financial Consolidation and Close will use Periodic calculations.
In a non-DSO application, when YTD Translation is
enabled while FX Method is Periodic, the FX_Movement member is translated using YTD
instead of Periodic when the FCCS_Mvmts_Subtotal member is missing. To change this
behavior, add a substitution variable named FXTranslationFix
substitution variable and set the value to True.
In an application with YTD FX
Variance Translation calculations enabled, in some circumstances, extremely large
numbers may occur in OBFXCTA/OBFXCICTA members. To resolve this issue, the
YTDFXRatioThreshold substitution variable is set by default to
True. To disable this behavior, change the substitution variable value to
False.
The YTDFXRevised consolidation setting controls Year-to-Date FX calculation logic on Historical accounts in the consolidation script for Movements. When the account is Historical, no adjustment is made for the prior period FX on Opening Balance and FX on Movements for all individual accounts, FCCS_OBFXCTA, FCCS_OBFXCICTA, and FCCS_Retained Earnings Prior. By default, the setting is False. To enable this behavior, change the consolidation setting to True.
Note: YTDFX will be enabled for the first year, so for the first year (except for the first period), Financial Consolidation and Close will use YTD FX calculations.
To specify default translation settings: