CRM 4 Closed opportunity actual revenue not correct displayed

W. Groothand

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

Donna

Hi,

Have you checked your Pricing Decimal Precion under Administration, System
Settings?

Regards,
Donna

"W. Groothand" wrote:

> 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

W. Groothand

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:

> Hi,
>
> Have you checked your Pricing Decimal Precion under Administration, System
> Settings?
>
> Regards,
> Donna
>
> "W. Groothand" wrote:
>
> > 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

Steven Biesterbos

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:

> 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:
>
> > Hi,
> >
> > Have you checked your Pricing Decimal Precion under Administration, System
> > Settings?
> >
> > Regards,
> > Donna
> >
> > "W. Groothand" wrote:
> >
> > > 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

Steven Biesterbos

The following worked for me (

To correct this issue you've to run a query via SQL Server Management Studio:

UPDATE UserSettingsBase SET DecimalSymbol = ','

regards,
Steven

"Steven Biesterbos" wrote:

> 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:
>
> > 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:
> >
> > > Hi,
> > >
> > > Have you checked your Pricing Decimal Precion under Administration, System
> > > Settings?
> > >
> > > Regards,
> > > Donna
> > >
> > > "W. Groothand" wrote:
> > >
> > > > 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

W. Groothand

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:

> The following worked for me (
>
> To correct this issue you've to run a query via SQL Server Management Studio:
>
> UPDATE UserSettingsBase SET DecimalSymbol = ','
>
> regards,
> Steven
>
> "Steven Biesterbos" wrote:
>
> > 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:
> >
> > > 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:
> > >
> > > > Hi,
> > > >
> > > > Have you checked your Pricing Decimal Precion under Administration, System
> > > > Settings?
> > > >
> > > > Regards,
> > > > Donna
> > > >
> > > > "W. Groothand" wrote:
> > > >
> > > > > 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

Munk

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:

> 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:
>
> > The following worked for me (
> >
> > To correct this issue you've to run a query via SQL Server Management Studio:
> >
> > UPDATE UserSettingsBase SET DecimalSymbol = ','
> >
> > regards,
> > Steven
> >
> > "Steven Biesterbos" wrote:
> >
> > > 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:
> > >
> > > > 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:
> > > >
> > > > > Hi,
> > > > >
> > > > > Have you checked your Pricing Decimal Precion under Administration, System
> > > > > Settings?
> > > > >
> > > > > Regards,
> > > > > Donna
> > > > >
> > > > > "W. Groothand" wrote:
> > > > >
> > > > > > 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

W. Groothand

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:

> 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:
>
> > 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:
> >
> > > The following worked for me (
> > >
> > > To correct this issue you've to run a query via SQL Server Management Studio:
> > >
> > > UPDATE UserSettingsBase SET DecimalSymbol = ','
> > >
> > > regards,
> > > Steven
> > >
> > > "Steven Biesterbos" wrote:
> > >
> > > > 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:
> > > >
> > > > > 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:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Have you checked your Pricing Decimal Precion under Administration, System
> > > > > > Settings?
> > > > > >
> > > > > > Regards,
> > > > > > Donna
> > > > > >
> > > > > > "W. Groothand" wrote:
> > > > > >
> > > > > > > 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

W. Groothand

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:

> 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:
>
> > 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:
> >
> > > 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:
> > >
> > > > The following worked for me (
> > > >
> > > > To correct this issue you've to run a query via SQL Server Management Studio:
> > > >
> > > > UPDATE UserSettingsBase SET DecimalSymbol = ','
> > > >
> > > > regards,
> > > > Steven
> > > >
> > > > "Steven Biesterbos" wrote:
> > > >
> > > > > 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:
> > > > >
> > > > > > 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:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > Have you checked your Pricing Decimal Precion under Administration, System
> > > > > > > Settings?
> > > > > > >
> > > > > > > Regards,
> > > > > > > Donna
> > > > > > >
> > > > > > > "W. Groothand" wrote:
> > > > > > >
> > > > > > > > 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

Unregistered

any news from microsoft? did update rollup 2 solve this problem?