FX conversion for several periods

29 Views

Hi,

I have a consolidation model which includes currency conversion rules. So far we have been using it for actual data, i.e. one month at a time. We now also load budget and forecast data and tried to run a currency conversion for several months. The package ran through successfully (according to the data manager) but when we looked at the data, no conversion had taken place.

For example, we have forecast data for 2016.AUG, 2016.SEP and 2016.OCT. When we run the conversion for each month individually it works, but when I then change the rate and run the conversion for all three months together, nothing changes.

I simply call the conversion as SPRUNCONVERSION([%MODEL%],[%CATEGORY_SET%],[%CURRENCY_SET%],[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%]).

Do I need to do something extra to make it work for more than one period at a time?

Thanks,

Arnold