Why in Business Rules, set value in decimal field replace dot with comma?

(0) Share

Report

Posted on by icimasa

390

Hi,

we have a decimal field that we want to set with business rules to 0.5, the validation is OK, but when we save the business rule and reopen the rule there is an error and when we check the set value form the 0.5 value has been replaced with 0,5??

Validate before save OK

6433.pic1.png

After saving and reopen the business rule

8508.pic2.png

Can someone please help why this is happening?

regards
Martin

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Are you able to save and close, then activate it?

Although stupid, but how about some other decimal value? 0.2? 1.3?

Ultimately check whether any CRM rollup will help, or raise to Microsoft as bug.

Was this reply helpful? Yes No
icimasa 390 on at

Like (0)

Report

Hi,

thanks for the reply, and yes I have tried to save and activate it later with same result and also with different numbers. And I have the latest rollup installed so I guess I have to the microsoft on this.

regards
Martin

Was this reply helpful? Yes No
Ryno on at

Like (0)

Report

Maybe have a look at you CRM Regional settings

www.microsoft.com/.../customize-regional-options-admins.aspx

and confirm the decimal symbol you are using is correct

Was this reply helpful? Yes No
icimasa 390 on at

Like (0)

Report

Hi,

thanks for the tip but I already check on that also and it was correct setting!

Was this reply helpful? Yes No
Eckmann on at

Like (0)

Report

Hi Martin,

I've got the same problem, did you ever get a solution for this?

Best regards, Eckart

Was this reply helpful? Yes No
icimasa 390 on at

Like (0)

Report

Hi,

no very sad, I raised a ticket with Microsoft and got personal support on the issue, they were on it for about 1 month with regular contact every day and with access to our DB and CRM but they were not able to solve the issue or reproduce it in their system. And then the conversation just stopped even if i numerous times try to contact them to get some information about the issue. But no reply :(

My own thought could be that we are Sweden based and if it could be a combination of language settings or something like that.. But as I said no answer or solution..

We solved it that the 0.5 value that we were supposed to set in the business rule . we changed it to 1.. :)

if you find a solution please feel free to post your findings here..

regards

Martin

Was this reply helpful? Yes No
Eckmann on at

Like (0)

Report

Hi Martin,

thanks a lot for reply, it’s as I feared. We also assume that the problem correlates to some German settings but don’t know, where they could be. We’ve also opened a ticket to MS but I’m quite sure it will end similar to your problem.

Our consultants fear that some other problems depend on this, in our special case we have a calculation and make 2 steps *5 and /10.

I’ll just try to reproduce the problem on VMs as we think it depends on the windows installation (in an old environment all works fine).

If I get any solution I’ll post it immediately!

Gruß, Eckart

Was this reply helpful? Yes No
Verified answer

Eckmann on at

Like (3)

Report

Hi Martin,

finally the solution was found with the help from MS support. You have to check the user used for the Identytity in the Application Pool in the IIS. Connect to the server with this server and check in

Control Panel, Region, Additional settings.. and correct Decimal symbol and Digit group symbol in Numbers and Currency to dot/comma as requested.

Restart the Application Server and - in my case - the problem was solved.

Best regards, Eckart

Was this reply helpful? Yes No
icimasa 390 on at

Like (0)

Report

Thanks,

you got to a better support technician then me.. :)

thanks for posting the solution here..

regards

Martin

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Just to confirm this solution worked for me. Kudos to the tech who found it and thank you for sharing this. Meant I had a 30 minute turnaround on the problem instead of well a month.

Regards,

Johan

Was this reply helpful? Yes No