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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008242
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformmajorhave not tried2009-03-17 19:042009-05-28 19:01
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.40MP4
StatusclosedFix in branch2.40Fixed in SCM revisionf508619622ad
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008242: Calculations done by XmlEngine (i.e. sum) are done using double. which leads to calculation errors.

DescriptionXmlEngine can do some calculations when rendering i.e. a report. Example total sum of some values shown in the rows.

This calculations are done using double which leads to errors. Depending on the output-formatting these errors are sometimes 'hidden' as the rounded value is by accident the correct value.
Steps To Reproduce- Use the Payment Aging Balance report as example [1].
- Enter data to be shown in the report to either only show ten lines of Value '0.1' in some column or to include ten extra lines of value '0.1'. One way of entering data for this is to follow the description in the page ag [2]
- edit the config/Format.xml to change autoInform formatting to the following '#,##0.####################'
- See that the total value shown in the report is incorrect.


[1] Financial Management || Receivables & Payables || Analysis Tools || Payment Aging Balance || Payment Aging Balance
[2] http://wiki.openbravo.com/wiki/Talk:Demo_Script/Op01_Pending_receivables_by_date_ranges [^]
Proposed SolutionChange XmlEngine internal representation from double -> BigDecimal
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0008177 closedshuehner Calculations done by XmlEngine (i.e. sum) are done using double. which leads to calculation errors. 

-  Notes
(0014893)
hgbot (developer)
2009-03-24 12:38

 Repository: erp/stable/2.40
Changeset: f508619622ad1705bfa651d8cc729b77661e9366
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Mar 24 12:38:24 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/f508619622ad1705bfa651d8cc729b77661e9366 [^]

Fixed 8242: change xmlEngine calculations from using double -> BigDecimal

---
M src-core/src/org/openbravo/xmlEngine/FunctionAddValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionDivideValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionEqualValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionGtValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionLtValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionMaxValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionMedValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionMinValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionModuleValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionMultiplyValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionSubtractValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionSumValue.java
M src-core/src/org/openbravo/xmlEngine/FunctionTemplate.java
---

- Issue History
Date Modified Username Field Change
2009-03-23 19:30 shuehner Type defect => backport
2009-03-23 19:30 shuehner fix_in_branch => 2.40
2009-03-24 12:38 hgbot Checkin
2009-03-24 12:38 hgbot Note Added: 0014893
2009-03-24 12:38 hgbot Status scheduled => resolved
2009-03-24 12:38 hgbot Resolution open => fixed
2009-03-24 12:38 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/f508619622ad1705bfa651d8cc729b77661e9366 [^]
2009-05-10 19:37 psarobe Fixed in Version => 2.40MP4
2009-05-28 19:01 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker