Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026132Openbravo ERPA. Platformpublic2014-04-01 11:172014-05-07 18:11
ReporterVictorVillar 
Assigned Toguillermogil 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR14Q3Fixed in Version3.0PR14Q3 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026132: wrong visualization value of quantity fields with very small numbers
Descriptionwrong visualization value of quantity fields with very small numbers
Steps To ReproduceChange the Format.xml as follow:

   <Number name="qtyRelation"
       decimal="." grouping="," formatOutput="#,##0.#######" formatInternal="#0.0000000" />
   <Number name="qtyEdition"
       decimal="." grouping="," formatOutput="#0.#######" formatInternal="#0.0000000" />
   <Number name="qtyExcel"
       decimal="." grouping="," formatOutput="#,##0.#######" formatInternal="#0.0000000" />

As group admin role:
  Go to Sales Order
    create a new one
   Go to Sales Order line:
     qty: 0.0000007
first error: the visualization is 7e-7, should be 0.0000007

second error: qty 0.00000078
     after that, change the focus to another field, realise that the qty = 0 and if you try to save it, you receive the following error: Saving failed. Exception while trying to convert value:-->0.-7<-- null

third error:
    introduce via database the folloing qty value: 0.0000000435678489841651
 you can see in the application quantity: 4.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0028561 closed caristu OB.Utilities.Number.ScientificToDecimal does not work properly with numbers with leading zeros 
related to defect 0028720 closed alostale System is not saving big numbers properly 
related to defect 0029709 closed NaroaIriarte Cannot save a physical inventory line with a negative small number in the Book Quantity field 
related to defect 0030014 closed NaroaIriarte The function OB.Utilities.Number.OBMaskedToOBPlain is not working properly with negative big numbers 
causes defect 00285523.0PR15Q2 closed alostale Purchase Invoice amount gets truncated upon saving, when the amount is big 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-04-01 11:17VictorVillarNew Issue
2014-04-01 11:17VictorVillarAssigned To => AugustoMauch
2014-04-01 11:17VictorVillarModules => Core
2014-04-01 11:17VictorVillarResolution time => 1397685600
2014-04-01 11:17VictorVillarTriggers an Emergency Pack => No
2014-04-01 11:18VictorVillarIssue Monitored: networkb
2014-04-02 15:14alostaleTarget Version => PR14Q3
2014-04-03 12:08guillermogilAssigned ToAugustoMauch => guillermogil
2014-04-03 12:09guillermogilReview Assigned To => shankarb
2014-04-03 12:09guillermogilIssue Monitored: shankarb
2014-04-08 10:49hgbotCheckin
2014-04-08 10:49hgbotNote Added: 0066228
2014-04-08 10:49hgbotStatusnew => resolved
2014-04-08 10:49hgbotResolutionopen => fixed
2014-04-08 10:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/28afef8656512aeae764101425d2e46cd7b9d051 [^]
2014-04-16 07:54shankarbNote Added: 0066474
2014-04-16 07:54shankarbStatusresolved => closed
2014-04-16 07:54shankarbFixed in Version => PR14Q3
2014-05-07 18:11hudsonbotCheckin
2014-05-07 18:11hudsonbotNote Added: 0066901
2015-01-09 14:10alostaleRelationship addedcauses 0028552
2015-01-12 11:07AugustoMauchRelationship addedrelated to 0028561
2015-01-22 10:39alostaleRelationship addedrelated to 0028720
2015-04-27 16:43ngarciaRelationship addedrelated to 0029709
2015-05-26 13:22NaroaIriarteRelationship addedrelated to 0030014

Notes
(0066228)
hgbot   
2014-04-08 10:49   
Repository: erp/devel/pi
Changeset: 28afef8656512aeae764101425d2e46cd7b9d051
Author: Guillermo Gil <guillermo.gil <at> openbravo.com>
Date: Tue Apr 08 10:48:24 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/28afef8656512aeae764101425d2e46cd7b9d051 [^]

Fixed issue 26132: wrong visualization value of quantity fields with very small numbers

Created function to show always decimal notation instead scientific notation

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/utilities/ob-utilities-number.js
---
(0066474)
shankarb   
2014-04-16 07:54   
Code reviewed and verified in pi changeset c25c56618b6d.
(0066901)
hudsonbot   
2014-05-07 18:11   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/02ca2648bcdc [^]
Maturity status: Test