Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032943Openbravo ERP04. Warehouse managementpublic2016-05-12 13:262018-01-26 10:51
Reporterngarcia 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032943: 'Fix Stock QuantityOrder Process' should round the Order quantity of the opening physical inventory to the std precision
Description'Fix Stock QuantityOrder Process' should round the Order quantity of the opening physical inventory to the std precision. That value is obtained from the qtyorderonhand column of m_storage_detail table in the getDetails function
Steps To ReproduceInstall the org.openbravo.fix.stock.qtyorderonhand module
Launch the Fix Stock QuantityOrder Process from the menu
Check through database there are records with more decimals in the qtyorderonhand column of the m_storage_detail table and the records created by the process in the m_inventoryline and m_transaction tables related with the opening inventories
Proposed SolutionAttached a possible patch that should be reviewed
Additional Information
TagsFix Stock
Relationships
related to defect 00304813.0PR15Q4 closed AtulOpenbravo Wrong quantity conversion in goods receipts under some circumstancies 
related to defect 0032951 closed alostale Fix Stock process rounds the quantities to 6 decimals and it should not 
related to defect 0032935 closed markmm82 Data is pending to be created in M_STORAGE_PENDING by the Fix Stock process 
related to defect 0032934 closed markmm82 Wrong definition of convertUOM function in RestoreStockValue_data.xsql 
Attached Filesdiff FixOrderStock.diff (3,276) 2016-05-12 13:26
https://issues.openbravo.com/file_download.php?file_id=9401&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-05-12 13:26ngarciaNew Issue
2016-05-12 13:26ngarciaAssigned To => Triage Finance
2016-05-12 13:26ngarciaFile Added: FixOrderStock.diff
2016-05-12 13:26ngarciaModules => Core
2016-05-12 13:26ngarciaResolution time => 1466200800
2016-05-12 13:26ngarciaTriggers an Emergency Pack => No
2016-05-12 13:26ngarciaIssue Monitored: networkb
2016-05-12 14:06aferrazAssigned ToTriage Finance => markmm82
2016-05-16 11:06ngarciaRelationship addedrelated to 0030481
2016-05-16 13:26aferrazRelationship addedrelated to 0032951
2016-05-16 13:26aferrazRelationship addedrelated to 0032935
2016-05-16 17:38aferrazRelationship addedrelated to 0032934
2016-05-17 13:43ngarciaSummary'Fix Stock QuantityOrder Process' should round the qtyorderonhand column of m_storage_detail table to the std precision => 'Fix Stock QuantityOrder Process' should round the Order quantity of the opening physical inventory to the std precision
2016-05-17 13:43ngarciaDescription Updatedbug_revision_view_page.php?rev_id=12134#r12134
2016-05-17 13:43ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12136#r12136
2016-05-17 16:59markmm82Statusnew => scheduled
2016-05-24 13:58hgbotCheckin
2016-05-24 13:58hgbotNote Added: 0086704
2016-05-24 13:58hgbotStatusscheduled => resolved
2016-05-24 13:58hgbotResolutionopen => fixed
2016-05-24 13:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.fix.stock.qtyorderonhand/rev/fe003df5355b662edf859d3cf4056e291168e3fd [^]
2016-05-24 13:58hgbotCheckin
2016-05-24 13:58hgbotNote Added: 0086705
2016-05-24 13:58hgbotCheckin
2016-05-24 13:58hgbotNote Added: 0086706
2016-05-24 13:59aferrazReview Assigned To => aferraz
2016-05-24 13:59aferrazNote Added: 0086707
2016-05-24 13:59aferrazStatusresolved => closed
2018-01-26 10:51ngarciaTag Attached: Fix Stock

Notes
(0086704)
hgbot   
2016-05-24 13:58   
Repository: erp/pmods/org.openbravo.fix.stock.qtyorderonhand
Changeset: fe003df5355b662edf859d3cf4056e291168e3fd
Author: Mark <markmm82 <at> gmail.com>
Date: Tue May 17 11:06:09 2016 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.fix.stock.qtyorderonhand/rev/fe003df5355b662edf859d3cf4056e291168e3fd [^]

Fixes issue 32943: FixStockQtyOrderProcess rounds orderqty to std precision

'Fix Stock QuantityOrder Process' rounds the Order quantity of the opening physical inventory to the std precision

---
M src/org/openbravo/fix/stock/qtyorderonhand/FixStockQtyOrderProcess.java
---
(0086705)
hgbot   
2016-05-24 13:58   
Repository: erp/pmods/org.openbravo.fix.stock.qtyorderonhand
Changeset: 526ada0e898085542bd291b4b84649ac90213332
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue May 24 13:30:07 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.fix.stock.qtyorderonhand/rev/526ada0e898085542bd291b4b84649ac90213332 [^]

Related to issue 32943: Code review improvements

---
M src/org/openbravo/fix/stock/qtyorderonhand/FixStockQtyOrderProcess.java
---
(0086706)
hgbot   
2016-05-24 13:58   
Repository: erp/pmods/org.openbravo.fix.stock.qtyorderonhand
Changeset: 1d270fcdceea0a32de9722f92888cd1aa312a6d6
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue May 24 13:52:37 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.fix.stock.qtyorderonhand/rev/1d270fcdceea0a32de9722f92888cd1aa312a6d6 [^]

Related to issue 32943: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0086707)
aferraz   
2016-05-24 13:59   
Code review + Testing OK