Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015008
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2010-10-25 10:182010-12-21 00:00
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision6fbfcf8888d6
ProjectionnoneETAnoneTarget Version2.50MP24
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP22SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015008: Wrong behaviour with 9 Decimals

DescriptionWith the Format and the Currency with 9 decimals, the number is rounded to 6 decimals

5.174174257 is rounded to 5.174174000

Reported by XME
Ticket: 9737
Steps To Reproduce- Change the Format.xml:
     <Number name="priceInform"
decimal="," grouping="." formatOutput="#,##0.#########" formatInternal="#0.000000000" />
<Number name="priceRelation"
decimal="." grouping="," formatOutput="#,##0.#########" formatInternal="#0.000000000" />
<Number name="priceEdition"
decimal="." grouping="," formatOutput="#0.000000000" formatInternal="#0.000000000" />

- As System Administrator go to General Setup || Application || Currency
- Select EUR. Standar, Costing and Price Precision: 9

- As Openbravo Admin go to Procurement Management || Transactions || Purchase Invoice
- Create a new one and go to lines.
- Select hammer.
- Net Unit Price: 5.174174257
- Save
- Realize that the number is rounded to 5.174174000

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0032951 closedalostale Fix Stock process rounds the quantities to 6 decimals and it should not 

-  Notes
(0032358)
hgbot (developer)
2010-11-02 18:09

 Repository: erp/devel/pi
Changeset: 6fbfcf8888d6210fac541d358c97e2d8e97c149f
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Nov 02 18:08:06 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/6fbfcf8888d6210fac541d358c97e2d8e97c149f [^]

Fixes issue 0015008: Wrong behaviour with 9 Decimals
It has been modified the TO_NUMBER function to accept up to 10 decimals instead of 6 decimals

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0032359)
adrianromero (manager)
2010-11-02 18:15

 * Testing the issue

Just follow the steps to reproduce and notice that now the price is not rounded

* Other areas affected

It has been modified the function TO_NUMBER in posgresql to accept up to 10 decimals. This is a very horizontal change because the TO_NUMBER function is used in all the application. But this change is very small and the only expected behavior is now that the TO_NUMBER function will accept more decimals. In Oracle the behavior has not been modified because the TO_NUMBER function is a built-in function that works as expected.
(0032448)
hudsonbot (developer)
2010-11-05 12:45

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/6fbfcf8888d6 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f2cf138fa03c [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18797.obx [^]
(0033278)
psarobe (manager)
2010-12-20 11:16

 Tested working fine

- Issue History
Date Modified Username Field Change
2010-10-25 10:18 networkb New Issue
2010-10-25 10:18 networkb Assigned To => adrianromero
2010-11-02 18:09 hgbot Checkin
2010-11-02 18:09 hgbot Note Added: 0032358
2010-11-02 18:09 hgbot Status new => resolved
2010-11-02 18:09 hgbot Resolution open => fixed
2010-11-02 18:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6fbfcf8888d6210fac541d358c97e2d8e97c149f [^]
2010-11-02 18:15 adrianromero Note Added: 0032359
2010-11-05 12:45 hudsonbot Checkin
2010-11-05 12:45 hudsonbot Note Added: 0032448
2010-12-20 11:16 psarobe Note Added: 0033278
2010-12-20 11:16 psarobe Status resolved => closed
2010-12-21 00:00 anonymous sf_bug_id 0 => 3141000
2016-05-25 11:03 alostale Relationship added related to 0032951

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker