0011188: Decimal format: Amounts not well calculate if decimal rounds is not properly setup

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0011188

Openbravo ERP

A. Platform

public

2009-10-30 12:28

2009-11-06 00:00

Reporter

psarobe

Assigned To

dbaz

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

2.50MP9

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

0011188: Decimal format: Amounts not well calculate if decimal rounds is not properly setup

Description

If you are working with 3 or 4 decimal for pricing but the format.xml is not properly setup in order to allow to have 3 or 4 decimal then there is an inconsistent between price x quantity and the result amount

Scenario
========
Format.xml setup for just having 2 decimals. You create a sales invoice and you enter the price: 1.888; quantity:55 amount:103.84
But after leaving the focus in the price field you have 1.89. So finally you have in the DB:
price:1.89
quantity:55
amount:103.84
But 1.89 x 55= 103.95

So the inconsistency is clear

Steps To Reproduce

1. Login as Openbravo/openbravo
2. Create a sales invoice
3. Move to lines and enter for quantity 55
4. Enter for price 1.888
5. the amount will be 1.888x55

But as in the DB will be stored 1.89 (because of the format.xml) the amount should be 1.89x55

Proposed Solution

The call-out should take into the format and what the final quantity, price will be.

Review and fix all the call-outs in the ERP

Additional Information