Financial Consolidation and Close

Get Involved. Join the Conversation.


    Steven Getze, CMA
    FCCS Amount Overrides
    Topic posted August 14, 2019 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Balance Sheet, Consolidation, Data Integration, Dimensions, Eliminations, Income Statement, Translations 
    60 Views, 3 Comments
    FCCS Amount Overrides
    Is documentation/instruction available, including form construction?

    Does anyone have clear documentation on how best to create FCCS forms for loading "amount" overrides?  I need to adjust USD values.   I tried building the forms using the correct POV, I inputting the zero into the entity currency column and input the incremental change into the Data Input column, but the results are wildly wrong. 

    See attachment showing specific details.   Any/all guidance will be appreciated.



    • Michel Schoolenaar

      Hi Steven,


      here's the link to the documentation:

      There is a standard "Override Rates" form available by default.

      To enter override rates:

      1. On the Home page, click Data.
      2. From the Forms list, click Override Rates.
        All accounts specified as Historical Rate accounts are listed in the rows.
      3. From the POV, select a Scenario, Year, and Entity.
      4. For an account, enter the amount or rate for the override, and click Save.





    • Keith Glide

      Keep in mind that FCCS translates level 0 members and not parent members... so override entries must be applied to level 0 members only (for example, level 0 movements, level 0 data source members, level 0 Departments etc.).

      For the currency dimension, enter to the "Input Currency" member (so USD and not USD_Reporting). For the Consolidation dimension, enter to either the "FCCS_Rate Override" or "FCCS_Amount Override" member (depending on the Exchange Rate setting on the account). As Michel notes, the seeded "Override Rates" form provides an example with valid dimensionality.

      Also note that you can only enter Rate or Amount overrides to "Historical" Exchange Rate accounts (Historical Rate Override or Historical Amount Override) and not to "No Rate" accounts... so these Historical accounts are those for which the FX Variance is transferred to CTA / CICTA. If you need to override a "No Rate" account, you could use the Translation Override rules in combination with a new global or local Exchange Rate account. In this case you could create a rule that translates your movements at the required exchange rate entered to the new rate account.

    • Paul Wilcock

      One other thing to note you need to enter the override amount in an entity that immediately translates in to the parent currency.

      If you have, for example, an entity denominated in EUR that consolidates in to another EUR entity any overrides entered in the base entity will have no effect.  In this example you would need to enter the override in to the parent entity (assuming the parent entity consolidates in to an entity with denominated the override currency).