Forum Discussion

xtensibilitybro's avatar
xtensibilitybro
New Contributor III
2 years ago

Currency Overrides on Movements

Hi All, We are looking for a way to put a currency override on movement flow member (ex. dividends, redemptions, etc...). The current override logic which was provided was OneStream is leveraging t...
Methodology
  • ChrisLoran's avatar
    ChrisLoran
    2 years ago

    I would first model what you are trying to do , in an Excel worksheet, and make that part of your design document, so you can always refer back to that Excel model if a customer says "this isn't the result I was expecting" when it comes to UAT.
    Usually you would put special equity events (e.g. issue of share capital, dividend payments, acquisitions, etc) as flow (movement) members, with a duplicate set of flow members (e.g. dividend_USD ) which are currency override and do not translate.  Then when such an event happens, the local amounts are loaded and the dollar override (or EUR override or whatever currency the holding company is) and you calculate the FX/CTA based on the difference : i.e. (Local Amt translated at closing rate) - (override amount).

    But trying to explain this is a design document in a wordy way usually has misinterpretations, which is why I'm always in favour of embedding simple Excel sheets into the design doc to explain the requirements.

ChrisLoran's avatar
ChrisLoran
Valued Contributor
2 years ago

I would first model what you are trying to do , in an Excel worksheet, and make that part of your design document, so you can always refer back to that Excel model if a customer says "this isn't the result I was expecting" when it comes to UAT.
Usually you would put special equity events (e.g. issue of share capital, dividend payments, acquisitions, etc) as flow (movement) members, with a duplicate set of flow members (e.g. dividend_USD ) which are currency override and do not translate.  Then when such an event happens, the local amounts are loaded and the dollar override (or EUR override or whatever currency the holding company is) and you calculate the FX/CTA based on the difference : i.e. (Local Amt translated at closing rate) - (override amount).

But trying to explain this is a design document in a wordy way usually has misinterpretations, which is why I'm always in favour of embedding simple Excel sheets into the design doc to explain the requirements.