Value in Field Currency in EUR, conversion error when update from List View

[marco.disco]

In any Version of SugarCRM (Professional, Enterprise and CE)
The error with a Currency Field in any module, and/or with exist currency field in Contract module, Quotes module (Pro or Ent), when update record from "list view" with "mass update", the value of this field change from right value to wrong value.

This is the steps for reproduce the error:

- Admin->Locale Settings->Default Currency:
Currency: Euro
Currency Symbol: ?
ISO 4217 Currency Code: EUR
1000s Separator: .
Decimal Symbol: ,

- In "MyModule" add a new record and set "MyAmount" Value : 10,00, set Currecy: Euro
- Save Record
- From "List View" select record and change the "some field" with mass update
- Now the "MyAmount" have the wrong number = Eur 10.000.000,00

Note: If record edited single from "Edit View" the number not change

Help!

[marco.disco]

I done another test with Opportunities module,
in this case, doing mass update, no error in amount field.

I saw in Opportunities there is 2 field for amount:
- amount (Unconverted amount of the opportunity)
- amount_usdollar (Formatted amount of the opportunity)

In "Edit View" form there is only amount, instead in "List View" form is there amount_usdollar field.

In custom module I tried that situation but not functioned.

I'm very confused, please someone help me.

Marco

[toughy]

Hey folks,

I have a similar Problem. (involved versions: 5.5.0, 5.2.0k) Whenever I update my "Opportunities" by a mass update, the "amount" fields of the corresponding database entries will lose their decimal dot. However, the field "amount_usdollar" stays the same.

So whenever this "Opportunity" entry will be saved again, e.g. by another "mass update", the field "amount_usdollar" will be altered according to the new "amount" value and so the data will be corrupted.

- my locale settings -
currency: EUR €
1000s separator: .
decimal separator: ,

Additionally I discovered, that the "DetailView" displays the Amount value of the database field "amount" and the list view ("index") shows the Amount by the database field "amount_usdollar". Due to this inconsistence you can see the "bug" in action:

• First create or alter an existing entry and set an amount value like 500,50
• then go to the list view, mark the item, and change e.g. the close date by a mass update.
• Now, the entry should display the correct amount value on the list view (database field "amount_usdollar": 500,50),...
• but it should display the wrong amount (database field "amount": 50050,00) on the DetailView.
• When you save the item again, i.e. by another mass update, the entry gets also a wrong amount value on the list view.

There was a similar error a few years ago: http://www.sugarcrm.com/forums/showthread.php?t=30818

I think it's still the same or an identical error, where the clean up of incoming data will be executed twice. But this time it only occurs on mass updates!?

Theoretical routine description:
First the 1000s separator will be stripped of and a comma becomes a dot. Then the routine will be done again and the new dot will be stripped of, cause the program assumes it is a 1000s separator.

I'm in a need of a fix of it so a hot fix or something similar would be great!

Best regards
Jean

[hdanielb]

I am using 5.2k, and have the same problem. Not only in opportunities module, but also in other modules. It seems that sugarcrm is using always "." as decimal point internally, and for some reason, when we use 20,00 for example, for a field, it beleives that "," is thousands separator.

This is happening in standard modules, in custom modules, and in custom fields. My setting are, currency: dollar, decimal point "," thousands separator ".".

I've tried to go back, and interchange , and . in settings, but this aggravate the problem, with data already recorded (10,000,000,000,000,000.00)

Any idea or patch please?

[jackbq]

I'm having exactly the same problem.
especially in the opportunities field, which we use daily...

please fix...

[jackbq]

Any comment from the SugarCRM on this problem?
Is it a known bug?

for our system it's quite a tough one to work with.
We have a lot of chances in our pipeline, and multiple times a day someone messes it up due to this bug.
In such a case our pipeline is suddenly multiplied bij aprox. 1000

So it's obvious something went wrong, but it's still quite anoying...

please patch / help or give us some information where to look, so we can try to solve this bug.

[marco.disco]

Hey folks,
finally after 5 months of the first bugs about this problem, and after several reminders to SugarCRM Inc. I had the answers:

Ran Zhou has updated a bug:

Bug Number: 34893
Subject: Currency fields are incorrectly updated during mass updates when using a non-default currency such as Euro
Priority: High
*Status: Assigned
Type: Defect
*Fixed in Release: _6.0.Beta
Resolution:

(*) denotes an updated field

You may communicate with the engineer assigned to this Bug by posting a Note here:
http://www.sugarcrm.com/crm/index.ph...8-4b465c568316

and

Ran Zhou has updated a bug:

Bug Number: 33115
Subject: Contract Amount in List View not right in EUR
Priority: Urgent
Status: Assigned
Type: Defect
*Fixed in Release: _6.0.Beta
Resolution:

(*) denotes an updated field

You may communicate with the engineer assigned to this Bug by posting a Note here:
http://www.sugarcrm.com/crm/index.ph...a-4ab3b8a019fb

:-(

Marco

[toughy]

Hey,

we struggled some days to find a solution for this miserable state. Due to that circumstances, that sugarcrm does not seems to solve their problems in a consecutive way, we checked some of the more or less poor code for ourselfs. We found out, that the amarican notation of the currency ( "," for thousends separator and "." for decimal separator) seems to work (more) stable.

So to solve this as a lil workaround try switching the currency delimiters for EACH user and for the default locale settings. Mass updates should work then and no magically multiplication should appear.

Be well!