The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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?

7 Replies

  • chul's avatar
    chul
    Icon for OneStream Employee rankOneStream Employee

    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
    Icon for OneStream Employee rankOneStream Employee

    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