Forum Discussion

WillVitale's avatar
WillVitale
Contributor
11 months ago

Loading in USD and Translating to Local

Hello,

We're building our Planning module and was wondering we have management fees that we get from our corporate office. They come in as USD. Is there a way that we can load in USD and translate them back in to Local Currency for the entities?

This is a one time yearly load and didn't know if it was possible or if we have to calculate it to local currency and then load it?

Thanks,

Will

Consolidation
FX Rates
Planning
  • gkeushkerian's avatar
    gkeushkerian
    11 months ago

    You can use Alternate Input currency OOB functionality.

    Create two members in the Flow dimension:

    • Input_USD: used to input data in USD
    • LC_USD: used to translated from USD into Entity assigned functional currency

    Apply the following configuration for the created members:

     

     

    OneStream will run reverse translation from Input_USD into LC_USD when calculating Data Unit.

     

     

  • gkeushkerian's avatar
    gkeushkerian
    New Contributor II
    11 months ago

    You can use Alternate Input currency OOB functionality.

    Create two members in the Flow dimension:

    • Input_USD: used to input data in USD
    • LC_USD: used to translated from USD into Entity assigned functional currency

    Apply the following configuration for the created members:

     

     

    OneStream will run reverse translation from Input_USD into LC_USD when calculating Data Unit.