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 ...
  • gkeushkerian's avatar
    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.