currency field versus decimal field

[Ravish Shetty]

Hi all,

We are storing cost information of certain products in a custom table in USD.

For foreseeable future, the cost will not be in any other currency.

For now, we have stored it in decimal fields but we are considering changing the field type to currency.

What are the advantages and potential things to consider when converting the field type?

Thanks,

Ravish

[JerryJ071847183]

You can check this blog this has some best practices with respect to currency .

https://community.servicenow.com/community?id=community_blog&sys_id=f1bcea25dbd0dbc01dcaf3231f96193b I hope it gives you overall perspective .

Mark my Answer as Correct and Helpful if it helps