10-27-2010 07:09 AM
is it possible to insert a negative number in a SLX (web client) numeric field?
I would like to store negative numbers, using the automatic formatting of the numeric field.
01-24-2011 05:45 AM
We think that all standard fields negative numbers can be stored in are text fields.
We now created a workaround using a textfield and restricting the entry of characters by client-side code.
01-24-2011 08:47 AM
At the risk of sounding repetitive, did you try what I suggested? If so, what happened?
It works, without a doubt.
Account.Revenue is a decimal(17,4) field. I entered -444 in the field. It saved to the database as -444.0000.
04-14-2011 07:03 AM
From a post elsewhere.
NB I have not tried this myself.
Just answered my own question. In 7.5.3, you need to modify sage-controls.js - line 17. Add an ASCII 45 ("-") to the conditions in that if statment and you'll be able to read and write negative numbers.
Professional Services Consultant