fx_currency_instance

[saif4]

For every currency field in any of the servicenow tables (like alm_asset.cost or pm_project.budget_cost) if multiple currency model is implemented, then we can get the local & global currency values and currency codes from fx_currency_instance table. The understanding is that for every Asset / Project record, there will be 1 row in fx_currency_instance for each field. But in one of our instance , we see few transaction having multiple currency instance records created for each transaction. Is this a valid scenario? And if yes, is this achieved by some configuration?

Ex:

Asset record with sys_id = 5t3uegw11db4bekeqjep81olimker0qz in alm_asset table has 8 corresponding records in fx_currency_instance like below. Everything other than FCI sys_id and metadata columns is same.

id	field	table	sys_id	sys_created_on	sys_created_by	reference_currency	currency	reference_amount	amount
5t3uegw11db4bekeqjep81olimker0qz	cost	alm_hardware	wbq2238078hdhvfvidxasplo9a2p0o0z	5/26/2017 16:03	user1	USD	USD	0	0
5t3uegw11db4bekeqjep81olimker0qz	cost	alm_hardware	gm7uf3l5l69sba39z0yvt49aw2mw06e1	5/27/2017 22:46	user2	USD	USD	0	0
5t3uegw11db4bekeqjep81olimker0qz	depreciated_amount	alm_hardware	iq3dehluq18jokorsigtzby1b2e5ahbz	5/26/2017 16:03	user1	USD	USD	0	0
5t3uegw11db4bekeqjep81olimker0qz	depreciated_amount	alm_hardware	tot2nfkpydt6bwggy5u2agqd918lt3q2	5/27/2017 22:46	user2	USD	USD	0	0
5t3uegw11db4bekeqjep81olimker0qz	residual	alm_hardware	iu2dosk9hk7j46kisa5ok2m5v7ucgtq9	5/26/2017 16:03	user1	USD	USD	0	0
5t3uegw11db4bekeqjep81olimker0qz	residual	alm_hardware	nh8sfyy8qejit592bkez9yezd932v7j2	5/27/2017 22:46	user2	USD	USD	0	0
5t3uegw11db4bekeqjep81olimker0qz	salvage_value	alm_hardware	tpaa8q6pk8c7o7b9jpqgk1am8woys8v0	5/26/2017 16:03	user1	USD	USD	0	0
5t3uegw11db4bekeqjep81olimker0qz	salvage_value	alm_hardware	x5l5nm6y3ic2abkghiije7e8rb05w3ez	5/27/2017 22:46	user2	USD	USD	0	0

[laddhamahesh]

I have the same question. We are using Financial Management and can see multiple entry in fx_currency_instance table.

In rate cards and currency is not getting automatically updated with the conversion rate before we run the job for creation of Expense line.

We need to write code to update reference currency as per currency exchange rate before creating expense.

We need to know if we need to create entry in fx_currency_instance table to achieve this? and also want to know the logic of multiple record as which one to update in case we write some manual job.