How to remove currency #EUR and keep #Local amount
Hi, We have a non-euro company that initially reported on input_level. That local amount has been translated to EUR. Later on in the process the local amount was removed, however the converted EUR amount remains in the system. i have done a force calculate, force translate, (force) consolidate. Nothing seems to remove the EUR amount!? Question: how to remove the EUR amount without touching the Local amounts. thanks!
Functional currency not Translating correctly to Reporting currency
Hi All, For some reason, local entities are translating incorrectly to reporting entity - they are not using the FX rates given. The FX setting are to use scenario FX rate setting (see screenshot), not the cube. When doing the recon - I identified the differences when translating (see screenshot). Additional, it's taking amount not reported in local entity, and reporting it to reporting entity. What could be the problem?
My client has all sorts for FX rate types attached to different scenarios (Actual, Budget, AOC, LE1, LE2, LE3...). Some of these FX rate types are updated during the year.
Originally posted by Rob Dessureault 1/23/2019 My client has all sorts for FX rate types attached to different scenarios (Actual, Budget, AOC, LE1, LE2, LE3...). Some of these FX rate types are updated during the year. Besides updating them as follows: Manually adjusting them in the FX Rates table or Exporting to Excel, manipulating the file and then loading it back in or Using Excel XF functions Are there other ways that people have come up with?
IC Elimination and USD Overrides
Our Currency Override formula in the Flow Dim (EndBal_Input) has been working great, no issues. We have been using IC Elim's on all of our Balance Sheet accounts except Equity/Investments. All of our E/I accounts are Currency overrides. We turned this IC on in January and are now noticing that the Elim amt is the FX calc'ed value and not the Currency Override value. Thus not zeroing out at O#:Top. Not sure how to adjust the O#Elimination member at the parent level for IC members. Any suggestions on how I might go about fixing. Not sure if I need to include a fourmla in the Flow Dim to handle different Origins or if it is handled elsewhere. Just looking for ideas to think about. In my example below you can see the Elim amount is using the Closing FX rate and not the Fixed USD amt or rate. ClarkeCopy FXRates
Originally posted by Diane Rochford Has anyone copied FXRates from prior month Closing FXRate to current month Average FXRate? In HFM, I can copy last period in year closing FXRates, Actual scenario,to both current closing and current average rate, constant $ scenario.I was also able to copy the prior month closing rate to all future period closing rate and average rate within the Forecast scenario. I would expect I can do these copied within OneStream, I just cannot find where, or how, I can accomplish this task. Help is greatly appreciated. Thanks Diane
