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

Rutger's avatar
Rutger
New Contributor III
3 years ago

How to remove currency #EUR and keep #Local amount

Hi, We have a non-euro company that initially reported on input_level. That local amount has been translated to EUR. Later on in the process the local amount was removed, however the converted EUR ...
Consolidation
FX Rates
SamRichards's avatar
SamRichards
Icon for OneStream Employee rankOneStream Employee
3 years ago

Hey Rutger,

Is there an override that is creating that balance in the EUR? Usually, the force translate would clear it if there is no local unless it is getting put there by a calculation.

Thanks,

Sam

  • Rutger's avatar
    Rutger
    New Contributor III
    3 years ago

    No Idea! do not know where to look. Further it is in the whole P&L and it is the only company that is 'infected'

    • SamRichards's avatar
      SamRichards
      Icon for OneStream Employee rankOneStream Employee
      3 years ago

      I don't think it would be an override in the traditional sense if you are seeing across the P&L the usual overrides are only on the balance sheet. Are you loading both currencies for that entity? Is this entity a parent or a base entity?

      • Rutger's avatar
        Rutger
        New Contributor III
        3 years ago

        This company is a parent (ownertype 'Holding' in the legal-tree and 'Full consolidation' in the management-tree). The currency setting in the member properties is SEK. The upload is done through excel template and is in/on LOCAL.