10-21-2014 06:02 AM - edited 10-21-2014 06:10 AM
We do not need any number of places after decimal point, so I revised the following fields in products database, and reduced the number of places to the right of decimal separator to zero.
When I create a new opportunity, and want to add a product, a red exclamation mark is shown to the right of these fields. On mouse over to this icon, it shows "value is not decimal"
10-21-2014 08:18 AM
I believe that message indicates a SQL data mismatch. Those fields are used in internal calculations and likely need to store a decimal value.
10-21-2014 08:48 AM
Not necessarily because of the internal calculations. This becomes an issue of how SQL treats data types and decimal ranges. If the internal calculations create a decimal value and the target field doesn't allow decimals, you would get a data mismatch error which is what I suspect is happening.