Skip to Content
0
Former Member
Jan 22, 2011 at 06:05 PM

Currency Translation - Rolling Forecast

60 Views

Hi,

Scenario is: We're doing 13 months rolling forecast which goes beyond one year. When currency translation happens, as part of default logic, it converts the records only for the year of forecast (selected in current view) and not beyond the current view year.

For instance, if selected forecast period 2011.JAN, we expect user to input numbers from 2011.JAN through to 2012.JAN. System run the currency conversion package and translate records for periods 2011.JAN - 2011.DEC, and doesn't convert 2012.JAN because it is the next year (not selected in current view).

Following is the code I'm using in the FX Conversion package:

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %VERSION_SET%

CURRENCY = USD

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

OTHER = ENTITY=%CURRENCY_SET%

*ENDRUN_PROGRAM

Can you please suggest any resolution, i.e. how I can enhance the code to convert records whatever I get from runtime (template) and not just restricted to CV Year?

Many thanks,

Shabbar