Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Ayeshan Peiris
    FCCS_Mvmts_Total of base entities doesn't aggregates to...
    Topic posted September 24, 2019 by Ayeshan PeirisSilver Medal: 2,000+ Points, tagged Consolidation, Dimensions, Smart View 
    101 Views, 7 Comments
    Title:
    FCCS_Mvmts_Total of base entities doesn't aggregates to FCCS_Mvmts_Total of parent entity only for Aug
    Content:

    Hi All,

    I have come across an issue where FCCS_Mvmts_Total of base entities doesn't aggregate to the FCCS_Mvmts_Total of parent entity only for the month of Aug. Prior months are aggregating correctly. I have tried all the operations such as running force/regular consolidation,refresh database, clearing out all the data for the month and reload then consolidate,but didn't resolve the issue.

    Note: consolidation operator for the all the entities have set to "Ignore"

    Why is that? any settings I have missed? appreciate your help on this matter.

    Please refer the screenshot

    Regards,

    Ayeshan

    Image:

    Comment

     

    • Keith Glide

      You need to look at the progression (or not) of the data in the Consolidation dimension from Entity Input / Entity Currency (EC) of the level 0 entities to Entity Consolidation / Entity Currency of the parent in order to determine where the problem occurs. So for example, the Entity Input / Entity Currency data, Entity Input / Parent Currency data, Proportion / Parent Currency data and Contribution / Parent Currency data of the level 0 entities.

      That would then help in determining whether there is a translation issue (have exchange rates been entered and calculated? This is currently required even when Entity Currency = Parent Currency and the exchange rate is "1"), a proportionalization issue (if there is Entity Input / PC data but no Proportion data then there might be a Consolidation % of zero) or some other cause. I would also suggest looking at least one level 0 movement member rather than just Total Movements (which will include Movements Subtotal and FX Variance).

    • Ayeshan Peiris

      Hi Keith,

      we only use USD in the application and entity currency =parent currency.  We had not entered 1 against any of base entities in a exchange rate form and after entering 1 for all the base entities, it did aggregate to the parent. Please confirm on the approach. Do we have to enter 1 for all the base entities for all the  months going forward also?

      Regards,

      Ayeshan

      • Keith Glide

        Your application was created as a multi-currency application so exchange rate entry / calculation is currently required because Entity Currency (EC) is always "translated" to Parent Currency (PC). You don't need to enter the rate of "1" but you must at least run the "ComputeRates" business rule. This rule is attached to the seeded exchange rate data entry forms but can also be run directly from the Rules card. This rule will automatically populate all currency-to-same-currency exchange rates as "1".

        In the 19.11 version update (all release timing caveats apply), we will be changing the logic of "translating" EC to PC when PC = EC to simply copy data from EC to PC rather than translating at a rate of "1". Then there will be no rate computation requirements if you use only one currency.

         

        • Ayeshan Peiris

          Hi Keith,

          Does "ComputeRates" business rule execute within the same process "Consolidation" as a sub process? or do we have to run it separately in addition to "consolidation"?

          Good to know about the change of logic for PC = EC in future releases. Thanks for the update.

          Regards,

          Ayeshan

          • Keith Glide

            "ComputeRates" must be run at least once per period in order to populate the currency-to-same-currency rates and any other indirect / triangulated rates based on direct rate entry... and is not part of the consolidate process which is typically run much more frequently.

    • Karandeep Vashisht

      Hi Ayeshan,

      "Compute Rates" is required to run separately than 'Consolidation'.

      Cheers

      Karan