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 = ','
Subscribe to:
Post Comments (Atom)
4 comments:
thank you
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?
No, I didn't otice this problem. Please check also global system settings, not just the user settings.
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
Post a Comment