Skip to main content
W
WillVitale
January 26, 2024
Solved

Loading in USD and Translating to Local

  • January 26, 2024
  • 1 reply
  • 2 views

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

Best answer by gkeushkerian

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

 

 

1 reply

G
gkeushkerianAnswer
January 27, 2024

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

 

 

W
WillVitaleAuthor
January 29, 2024

Thank you for the help to the solution!

Terms & ConditionsAccessibility statement