Skip to main content
WillVitale
Contributor
Jan 26, 2024 6:26 PM UTC
Solved

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

gkeushkerianAnswer
Member
Jan 27, 2024 12:42 PM UTC

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

gkeushkerian_0-1706359069619.png

Apply the following configuration for the created members:

gkeushkerian_1-1706359202582.png

 

gkeushkerian_2-1706359244219.png

 

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

gkeushkerian_3-1706359362279.png

 

 

View in thread

2 replies

gkeushkerianAnswer
Member
Jan 27, 2024 12:42 PM UTC

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

gkeushkerian_0-1706359069619.png

Apply the following configuration for the created members:

gkeushkerian_1-1706359202582.png

 

gkeushkerian_2-1706359244219.png

 

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

gkeushkerian_3-1706359362279.png

 

 

    WillVitaleAuthor
    Contributor
    Jan 29, 2024 4:30 PM UTC

    Thank you for the help to the solution!

    Terms & ConditionsAccessibility statement