Auto update budget reference rates ( itfm_fx_rate) from Exchange Rates (fx_rate) weekly

Farfara
Tera Contributor

Hi everyone,

 

I have a requirement to  auto-populate and update the budget reference rates table to convert for example cost plan currency.

Can you help on this topic please ?

 

Regards,

 

FF

6 REPLIES 6

Dhiren Aghera
Tera Guru

Hi @Farfara If you want the rates to be updated daily then please use the fx_rate table rather than budget reference rate. The budget reference rate table is used for multicurrency and its not recommended to update the rate daily as these will cause the cost fluctuations and you wont be able to track it.

Farfara
Tera Contributor

Hi @Dhiren Aghera, Yes but the cost plan fields ( Unit cost and Cost in functional currency) will not be updated with new data from ECB. The currency conversion does not work with fx_rate but with itfm_fx_rate. 

Hi @Farfara That's correct for multicurrency to work properly itfm_fx_rate is used. As mentioned earlier its not recommended to update the rates very frequently as it will create cost (planned/Actual) mismatch.

In our organization we update the budget reference rates every Fiscal Year.

Farfara
Tera Contributor

@Dhiren Aghera You updated the budget reference rates every Fiscal Year manually or automatically ?