1. Working with Tax Reporting
  2. Working with National Tax Process
  3. Working with National FX Rates
  4. Working with Amount Override and Rate Override for Tax Accounts
  5. Updating User-Customized Artifacts After Amount and Rate FX Override Migration
  6. Updating FX Rates Override (Historical Override Book Accounts) Form

Updating FX Rates Override (Historical Override Book Accounts) Form

For FX Rates Override (Historical override accounts), in all integrations referencing Consolidation dimension for all the accounts descendants of FCCS_Amount Override Accounts, update Consolidation dimension member from FCCS_Entity Input to FCCS_Rate Override and Data Source dimension member from FCCS_AmountOverride to FCCS_No Data Source.

For all the accounts descendants of FCCS_Rate Override Accounts, update Consolidation dimension member from FCCS_Entity Input to FCCS_Rate Override and Data Source dimension from FCCS_AmountOverride to FCCS_No Data Source.

Example: Updating User-Customized Form

As this new feature supports FX amount/rate override by Movement/Multi-GAAP/Data Source/Intercompany/Jurisdiction, hence you must update the customized form with all these dimensions as you can select in the form.

FX_Rates_Override_Existing_Form

Change to:

  • Movement: [FCCS_Movements].[TRCS_BookClosing],[FCCS_Movements].[TRCS_TBClosing]
  • DataSource: ILvl0Descendants([FCCS_Total Data Source].[FCCS_TotalInputAndAdjusted])
  • Multi-GAAP: ILvl0Descendants(Multi-GAAP)
  • Intercompany: ILvl0Descendants(Intercompany)
  • Jurisdiction: ILvl0Descendants(Jurisdiction) Excluding selection: [Jurisdiction].[TRCS_No Jurisdiction],[TRCS_Total Jurisdiction].[TRCS_No Jurisdiction]

FX_Rates_Override_Modified_Form

Example: Updating Data Load File (.csv, .txt, and others)

Assuming SalesBook is set to use Historical Rate Override and ProfitsBook is set to use Historical Amount Override:

FX_Rate_Override_Update_Data_Load_File