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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0036793
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajoralways2017-09-04 11:492017-09-05 18:19
ReporterngarciaView Statuspublic 
Assigned Tomarkmm82 
PriorityurgentResolutionfixedFixed in Version3.0PR17Q3
StatusclosedFix in branchFixed in SCM revision32cdec7e132d
ProjectionnoneETAnoneTarget Version3.0PR17Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036793: Amounts in Invoice lines and taxes are rounded to price precision instead of standard precision in Create Lines From process

DescriptionAmounts in Invoice lines and taxes are rounded to price precision instead of standard precision in Create Lines From process

In CreateFrom class, the price precision is used for rounding amounts instead of standard precision
Steps To ReproduceChange the Format.xml to accept 3 decimals in prices

As System Admin role:
   Set Price Precision of EUR currency to 3

   Create a new sales price list, do not set it as Price Includes Tax
   Add 4 products to it with the following prices:
      101.15
      176.715
      8.33
      35.105

   Create a Sales Order
   Set the previously created price list
   Add the previously created 5 products (one unit of each, 2 units of the one with 101.15 price)
   Complete it
   Set its Invoice Terms as Immediate

   Create a Sales Invoice header
   Set the previously created price list
   Click on Create Lines From
   Add the 4 lines of the sales order with a price different from 0

   Check the total net amount (422.45) does not match with the sum of the Line Net Amount values in invoice lines (202.30 + 176.72 + 8.33 + 35.11 = 422.46)
      
   Check through database that the linenetamt is not rounded to standard precision but to priceprecision
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0036776 closedmarkmm82 Amounts in Invoice lines and taxes are rounded to price precision instead of standard precision in Create Lines From process 

-  Notes
(0098850)
hgbot (developer)
2017-09-05 18:18

Repository: erp/backports/3.0PR17Q3
Changeset: 32cdec7e132daa2b844d52d3e12e5d9c878602b1
Author: Mark <markmm82 <at> gmail.com>
Date: Mon Sep 04 12:44:00 2017 -0400
URL: http://code.openbravo.com/erp/backports/3.0PR17Q3/rev/32cdec7e132daa2b844d52d3e12e5d9c878602b1 [^]

Fixes issue 36793: Amounts in invoice lines and taxes rounded to price precision
instead of standard precision in Create Lines From process.

In CreateFrom class, the price precision was used for rounding amounts instead of
standard precision and it was causing differences with totals when invoices were
created from orders or shipments.

Now all prices are rounded with the price precision of it currency and amounts
with standard precision.

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
---
(0098851)
hgbot (developer)
2017-09-05 18:18

Repository: erp/backports/3.0PR17Q3
Changeset: bd2c37a633fc46c45de8859a2c109383fb98dbd9
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Sep 05 12:37:04 2017 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR17Q3/rev/bd2c37a633fc46c45de8859a2c109383fb98dbd9 [^]

Related to issue 36793: Code review improvements

Retrieve currency standard precision instead of price precision in selectFromPO, selectFromPOUpdate, selectFromPOUpdateSOTrx and selectPriceList methods.
Do not round price actual with price precision when calculating line net amount.
Remove unused priceprecision variable.
Use data variable to retrieve currency standard precision when creating invoice from order and dataAux variable when creating invoice from receipt/shipment.

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
---
(0098852)
aferraz (developer)
2017-09-05 18:19

Code review + Testing OK

- Issue History
Date Modified Username Field Change
2017-09-05 16:41 aferraz Type defect => backport
2017-09-05 16:41 aferraz Target Version => 3.0PR17Q3
2017-09-05 18:18 hgbot Checkin
2017-09-05 18:18 hgbot Note Added: 0098850
2017-09-05 18:18 hgbot Status scheduled => resolved
2017-09-05 18:18 hgbot Resolution open => fixed
2017-09-05 18:18 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/ef2a84e698c4c76bef4f8ef984d4055c64b6d862 [^] => http://code.openbravo.com/erp/backports/3.0PR17Q3/rev/32cdec7e132daa2b844d52d3e12e5d9c878602b1 [^]
2017-09-05 18:18 hgbot Checkin
2017-09-05 18:18 hgbot Note Added: 0098851
2017-09-05 18:19 aferraz Review Assigned To => aferraz
2017-09-05 18:19 aferraz Note Added: 0098852
2017-09-05 18:19 aferraz Status resolved => closed
2017-09-05 18:19 aferraz Fixed in Version => 3.0PR17Q3


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker