Hello, is it possible to have 2 subsidiaries with ...
# general
p
Hello, is it possible to have 2 subsidiaries with the same currency and different historical consolidated exchange rates? we are running into a situation where our historical exchange rates are different for 2 subsidiaries. how do you deal with this situation?
s
Not possible unless you managed to setup some sort of parent child relationship where consolidated exchange rate is derived rate. Not sure how you do that though.
p
both subs end up rolling up to the same subsidiary but we have a different historical exchange rate beginning in march for the same currency between the 2 subsidiaries
j
if they roll up to the same subsidiary and that subsidiary has a different currency, then you should be able to specify different rates. If it's the same currency, then you can't. Note if these differences in rates are arising from ancient history, it might be possible to just put the historical entries in different periods before you went live in Netsuite and force the rate that way. If that doesn't work, you need an intermediary parent with a different currency for one of the subs - Netsuite can help with setting this up - or you can post elimination entries to achieve the consolidated fx outcome you need, or you can get a third party consolidation tool
p
we do not want the subsidiaries to be at a different rate. we are looking for them to be at the same exchange rate. for some reason there is a difference that started with the last period. what can we do to fix the difference
j
are you autocalculating your rates? You would expect to have a difference if you are (Netsuite weighted-averages out the transactions of each type to determine the rate). If you don't want the system to do this, just overwrite them manually