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]

Hi, 

itfm_fx_rate are budget reference rates, while fx_rate are for exchange rates. 

Thanks,

Berny

[bernyalvarado]

Which one is used is controlled by the following property: com.snc.resource_management.use_budget_reference_rates

Thanks,

Berny

[bernyalvarado]

As quoted in the docs: 

Use budget reference rates to calculate the Resource requested/allocated cost (com.snc.resource_management.use_budget_reference_rates)

When the property is set to Yes, budget reference rates [itfm_fx_rate] are used to calculate the resource requested or allocated cost. When the property is set to No, exchange rates [fx_rate] are used to calculate the resource requested or allocated cost. For upgraded customers, the property is by default set to No.

[bernyalvarado]

The default value is Yes; in other words itfm_fx_rate is used. See more information here: https://docs.servicenow.com/bundle/london-it-business-management/page/product/resource-management/reference/r_ResourceProperties.html