Currency Fields Have a 14-Character Limit That I Can't Change

[Rick Forristall]

Good day fellow ServiceNow developers,

I'm working on a custom scoped app to manage budgeting. I'm using the currency field type on several tables and I found that I can't add more than 14 characters in US currency when I'm entering values into any currency field. I increased the max length value to 40 and still can't enter more than 14 characters into the currency field.

The tables all extend the core task table.

What am I missing?

Is this a limitation of ServiceNow or is there some configuration I'm missing that would allow me to enter more than 14 characters?

Thanks,

Rick Forristall
ServiceNow Practice Lead
Chainbridge Solutions

[Yousaf]

Hi,

Could this be limitation of the MySQL database that Service Now is hosted on 

Mark Correct or Helpful if it helps.


 

[Enea]

Did you ever find a solution to this? I have a currency field that is populated by a client script. When any number greater than 9,999,999 is calculated in it, it automatically changes it to something that looks like this: $2.4598.
If the calculation is anything below 10 million it works perfectly.
I don't understand how the limit could be so low for a currency field. We deal with values of billions and these fields can't hold them.

[Rick Forristall]

Unfortunately no - it is a limitation of the database structure. We ended up measuring our risk and talking to the client about the sort of numbers they would be entering. We decided it was OK as.