Difference between the table itfm_fx_rate and fx_rate.

[Shreya2]

We are using the ITBM module for the first time and starting with the Project portfolio management. We have a requirement to use different currencies while we are submitting the cost plan for the project. The exchange rate used for the conversion is derived from itfm_fx_rate table which is empty. The scheduled job that loads the exchange rates from the ECB website populates the table "fx_rate". How can I co-relate both these tables?

[bernyalvarado]

I hope this helps 🙂

[Shreya2]

Hi Berny,

Thanks for replying. 

I had looked that up. The property  com.snc.resource_management.use_budget_reference_rates controls the exchange rate usage for "Resource Plans" only. In case I would want to add a cost plan directly to a project the exchange rate used to convert the "Entered currency" to "Functional Currency" comes from the Budget reference table (itfm_fx_rate). 

Exchange rate

Rate in effect for the period corresponding to the cost plan breakdown. When the period corresponding to the cost plan break down has multiple rates, the rate in effect on the first date of that period is used. Exchange rate is used to convert entered cost into functional cost. It is obtained from the itfm_fx_rate [budget_reference_rates] table.

Link for reference: https://docs.servicenow.com/bundle/london-it-business-management/page/product/project-management/concept/cost-plan-breakdown.html 

Now, unlike the fx_rate table, itfm_fx_rate table is not populated via a scheduled job and I don't believe populating it manually would be an efficient way.  

[Lennart]

3 years down the road, I'm now wondering about the same. Why don't we just have ONE place to maintain exchange rates? Now we have to create code to move exchange rates from one table to another.