February 28, 2008

Error at decimal field display format (4.0)

When upgrading a German version of CRM 3.0 to version 4.0, a strange thing happened. All decimal, float or money fields behaved very strange.

Example: User enters a value 2. After clicking save button, the number changes to 200.00 and then immediately to 20.000.00.

Then I noticed that a decimal separator and a thousands separator were the same. Therefore I checked organization settings where everything looked fine.

The problem lied in user settings where both separators were set to dot (.)

Change must be made for each user. Set the decimal separator to comma (,).
Update the CRM database to affect all users: UPDATE UserSettingsBase SET DecimalSymbol = ','


Anonymous said...

thank you

ingranajones said...

i noticed that, in despite of the update you suggested, the problem remains when you create an order from a quote and select "close opportunity" with revenue calculation from the quotes...
Have you faced also this problem?

Dejan Dular said...

No, I didn't otice this problem. Please check also global system settings, not just the user settings.

ingranajones said...

Hi Dejan,
the org setting (settings, system settings) is correct.
I think there's something strange in data update occurring when an opportunity is closed automatically and the "effective revenues" field is also automatically calculated