0029417: [Cost Adjustment] Adjustment amounts of more than 2 decimal precision are being created in costing background

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0029417

Openbravo ERP

04. Warehouse management

public

2015-03-26 08:34

2015-03-31 00:07

Reporter

umartirena

Assigned To

umartirena

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0PR15Q2

Fixed in Version

Merge Request Status

Review Assigned To

aferraz

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

0029417: [Cost Adjustment] Adjustment amounts of more than 2 decimal precision are being created in costing background

Description

While running Costing Background process with the functionality of Cost Adjustments, in certain cases adjustment are being created of amount with more than two decimal precision, and this is wrong, as an amount always has to has at most two decimal precision. Two cases detected are while using orphan lines or negative amount shipments.

Steps To Reproduce

In live.builds

As System Admin:
* Change costing precision and price precision to 4 for EUR Currency.

In F&B:
* Enable "RM Allow Orphan Line" preference.
* Have a valid average costing rule for F&B España org.
* Create a Product
* Add a Costing Record:
  - Org: F&B España
  - Cost: 5.5555
  - Cost Type: Average
  - Starting Date: 01/01/2014
  - Ending Date: 31/12/9999
* Create a Goods Shipment:
  - Org: F&B España
  - Business Partner: Alimentos y Supermercados
  - Movement Date: 10/02/2015
* Add a Line:
  - Product: The new product
  - Qty: 10.257
  - Storage Bin: RN 0-0-0
* Complete it
* Go to Return from Customer window
* Create a Header:
  - Org: F&B España
  - Business Partner: Alimentos y Supermercados
  - Order Date: 05/02/2015
* Click on "Insert Orphan Line":
  - Product: The new product
  - Returned: 5.236
  - Unit Price: 12.33
  - Tax: Arrendamiento 21% (Cobros) - IVA Normal
* Click OK and Book it
* Go to Return Material Receipt:
* Create a Header:
  - Org: F&B España
  - Business Partner: Alimentos y Supermercados
  - Movement Date: 05/02/2015
* Click on Pick/Edit Lines:
* Select the line created in previous Return from Customer
  - Received: 5.236
  - Storage Bin: RN 0-0-0
* Click Done and Complete it
* Go to Process Request window
* Run Costing Background process

* In pgadmin run the following query: "select * from m_costadjustmentline order by created desc"

Realize that an adjustment line of amount -0.0045 has been created, what is wrong because it should have been of 0.00 amount.

Proposed Solution

Additional Information