Forum Discussion

Qiniso's avatar
Qiniso
New Contributor III
2 years ago

Functional currency not Translating correctly to Reporting currency

Hi All, 

For some reason, local entities are translating incorrectly to reporting entity - they are not using the FX rates given. The FX setting are to use scenario FX rate setting (see screenshot), not the cube. 

When doing the recon - I identified the differences when translating (see screenshot). Additional, it's taking amount not reported in local entity, and reporting it to reporting entity. 

 

What could be the problem?

  • chul's avatar
    chul
    Contributor III

    Could be many things but given you're looking at CF, take a look at your account and flow settings to ensure they're correct.

    • Qiniso's avatar
      Qiniso
      New Contributor III

      The account and flow settings are correct. What else possibly I can look at?

  • RafaelVidal's avatar
    RafaelVidal
    New Contributor III

    Let's start with basics, does AccountTypes are correct, on each account? 

  • chul's avatar
    chul
    Contributor III

    I'm unable to follow the screenshot but my suspicion is that you're using a flow account type along with flow member with the switch type set to true resulting in the account becoming a balance account type which translates at the closing rate based on your settings.

    • Qiniso's avatar
      Qiniso
      New Contributor III

      I'm using revenue account type, and switch type is set to false

    • Qiniso's avatar
      Qiniso
      New Contributor III

      For example: this below is translated to reporting currency report

      And the below is local currency report 

       

        RatesTypeRate
      Revenue and ExpensesAverageRate9.38191
      Asset and LiabilitiesClosingRate9.39572