Decimal fields problem when upgrading to CRM 4.0

I don't know if it's a bug on the upgrade procedure or what, but on two different systems I've experienced a problem on decimal and money fields after an upgrade from Microsoft CRM 3.0 to Microsoft CRM 4.0 (Italian language).

The problem appears curious: when you enter a value on a money or decimal field (for example 7) and you try to save the record, the number changes to 700.00 and it's multiply by 100 on every record save.

My firstĀ  idea was to check the Organization Setting for the number format (and money format) but here the decimal separator was OK.

After different checks, I've discovered that the problem lies on the user settings table (UserSettingBase), where the decimal separator and thousand separators was wrong (both set to dot).

In order to correct the bug, you've to launch via SQL Server Management Studio this query:

UPDATE UserSettingsBase SET DecimalSymbol = ','

So strange...

Print | posted on Friday, April 25, 2008 1:30 PM

Comments on this post

# re: Decimal fields problem when upgrading to CRM 4.0

Requesting Gravatar...
Hello,
i noticed that, 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?
Left by Ingranajones on May 21, 2008 1:59 PM

Your comment:

 (will show your gravatar)
 
Please add 1 and 7 and type the answer here: