How do you change the currency field dropdown value from "Symbol" to "Code"?

[nicksoltis]

Can anyone tell me the best way to change the dropdown of a currency field to show currency.code (EUR, JPY, USD) rather than currency.symbol ($...)?

I have changed the dictionary display value of the "code" to "TRUE" which should fix this issue, however, it is still displaying the symbol.

I could simply change the label value for currency.symbol for the easy solution, but this would need to be done every time a new currency is added.

Please let me know if you have a solution to this.

Thanks!

[Soumita3]

Then could you check the attributes of the sm_order table if there are any currency defined for that particular table?

[nicksoltis]

No, there are no dictionary entries for the table=sm_order, type=currency

[nicksoltis]

The currency fields are custom on the custom extended table.

[Sanjay Bagri1]

Hi,

Please follow this link ::  Currency Code and Symbol

https://community.servicenow.com/community?id=community_question&sys_id=1f208761db98dbc01dcaf3231f961978&view_source=searchResult

Thanks
Sanjay Bagri

[nicksoltis]

Hi Sanjay,

Thanks for the response!

I have come across that post in my earlier research for this issue. The proposed solution for this post is to simply change the value of the Symbol field on the fx_currency table. While this is one way to solve my issue temporarily, it still proposes other complications such as managing the currency record every time they want to add/activate a new currency to use. Also, as seen below, it causes other complications with calculated currency fields.

If possible, I would like to keep the "Symbol" value and somehow override the dropdown to show "Code" value instead of "Symbol".

Thanks!