When viewing records within a list view the data is not displayed for currency.price fields and fields and columns afterwards


Description

When viewing records within a list view the data is not displayed for currency fields and the fields after it.

In the following screenshots you can see that the data is not loaded:

Expected:

Actual:

Cause

This issue can be caused by having a NULL exchange rate within the system.

Whenever a price or currency fields loads within a list it will be displayed in a globe this will include your session based currency, the entered amount and the reference amount
The system requires a valid exchange rate to be used to calculate the session-based currency.

Resolution

1) Navigate to the following URL and amend the rate field for any records discovered to a valid amount.

https://<instance-name>.service-now.com/fx_rate_list.do?sysparm_query=rateISEMPTY&sysparm_view=

Note iconNote: If you do not locate any exchange rates with null entries please consider raising a case with ServiceNow support to investigate further.