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 (.)

SOLUTION:
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 = ','

4 comments:

Anonymous said...

thank you

ingranajones said...

Hello,
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