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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0008177

Openbravo ERP

A. Platform

public

2009-03-17 19:04

2009-04-22 00:01

Reporter

shuehner

Assigned To

shuehner

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

2.50

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

XmlEngine 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 Solution

Change XmlEngine internal representation from double -> BigDecimal

Additional Information

Tags

No tags attached.

Relationships

depends on	backport	0008242		closed	shuehner	Calculations done by XmlEngine (i.e. sum) are done using double. which leads to calculation errors.
related to	defect	0008098		closed	shuehner	Double representation should not be used for numbers as it is inprecise
related to	defect	0012100	2.50MP14	closed	dbaz	Firefox doesn't add numbers correctly in Sales Management