- CRM 4 Closed opportunity actual revenue not correct displayed
- Posted by W. Groothand on June 9th, 2008
Hello,
When selecting the screen opportunities with closed opportunities the
display format of the Actual Revenue is not correct. We run a dutch format
setup in with english as language.
when opening the screen the actual revenue is correctly displayed
IE 88.000 --> 880.000.000,00
Any Ideas
- Posted by Donna on June 9th, 2008
Hi,
Have you checked your Pricing Decimal Precion under Administration, System
Settings?
Regards,
Donna
"W. Groothand" wrote:
- Posted by W. Groothand on June 9th, 2008
I checked it is set to 2.
Problem is only with the closed opportunites screen. Not with any other
screen. So if you open the closed Opportunity (the browse) and you to into
the details then the actual revenue displays the correct ammount.
"Donna" wrote:
- Posted by Steven Biesterbos on June 18th, 2008
Unfortunately, we have the same problem occurring. € 29.900 becomes €
299.000.000. This also comes up in Reports.
Kind regards,
Steven
"W. Groothand" wrote:
- Posted by Steven Biesterbos on June 18th, 2008
The following worked for me (http://www.crmwatcher.com):
To correct this issue you've to run a query via SQL Server Management Studio:
UPDATE UserSettingsBase SET DecimalSymbol = ','
regards,
Steven
"Steven Biesterbos" wrote:
- Posted by W. Groothand on June 19th, 2008
Steven,
thx for the reaction. But this is not our issue. I've done a select from
usersettingsbase and alle decimalsymbols are ','. So no problems here. The
point with our actual revenue in the opportunity is that when you close the
opportunity via a creation of an order the value of the actual revenue is
mutliplied by 10000. And it happens only with this value.
Best regards
Wilco
"Steven Biesterbos" wrote:
- Posted by Munk on June 25th, 2008
Hi
This is an error on the users proberties. Even you on the server have set
the decimal point ',' correct it will not change the users settings. So
please check the users setting for the decimal sign.
Go to the users settings in Outlook. CRM->Properties and then go to
the Format pane.
Hope this will help
"W. Groothand" wrote:
- Posted by W. Groothand on June 26th, 2008
Could be the problem if I used the outlook client. But I don't (have
technical errors with it).
I will check the personal settings. But it is strange that I have it only in
one screen and not application wide. I really think it is a bug in the
software.
Wilco
"Munk" wrote:
- Posted by W. Groothand on June 26th, 2008
Hello,
we dropped the problem at the Microsofts support desk and the confirm it is
a bug.
It happens with a english install with a european setting.
Microsoft will investigate the problem.
Best regards
Wilco
"W. Groothand" wrote:
- Posted by Markus Schmidt on July 4th, 2008
I have the same probleme, too.
Unfortunately due to this bug the customer cannot continue working with CRM
after I have made the Update von v3 to v4 yesterday!
*******************************
The bug is NOT only opportunity-related
but it relates to __every float attribute with decimal >0 (no matter which
entity)__ and it __prevents the customer from editing/adding records__!!!
*******************************
I have a German install on German settings!
However, the SQL Server is an English version.
IT WOULD BE GREAT IF WE COULD HEAR ABOUT A SOLUTION FOR THAT --- HERE IN
THIS NEWSGROUP!!
Markus Schmidt
(from Germany)