Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031998Openbravo ERP04. Warehouse managementpublic2016-01-21 10:392016-01-25 12:09
Reporterngarcia 
Assigned ToTriage Omni WMS 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q4.3Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031998: Costing Migration Process:Cost of products in closing inventory is calculated by taking into account only shipments and receipts
DescriptionCosting Migration Process:Cost of products in closing inventory is calculated by taking into account only shipments and receipts.

The problem is that insertTrxCost function is making an inner join between the M_TRANSACTION AND M_INOUTLINE tables
Steps To ReproduceCheck that after launching the first phase of the Costing Migration process the average cost of the products in the closing inventories is calculated only with the values of the transactions related with goods shipments and goods receipts
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0031972 closed aferraz Costing Migration Process:Cost of products in closing inventory is calculated by taking into account only shipments and receipts 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-01-22 14:51aferrazTypedefect => backport
2016-01-22 14:51aferrazTarget Version => 3.0PR15Q4.3
2016-01-25 12:08hgbotCheckin
2016-01-25 12:08hgbotNote Added: 0083578
2016-01-25 12:08hgbotStatusscheduled => resolved
2016-01-25 12:08hgbotResolutionopen => fixed
2016-01-25 12:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q4.3/rev/16c01a9e0bdefb04f299d79e7e236a8634b819b9 [^]
2016-01-25 12:08hgbotCheckin
2016-01-25 12:08hgbotNote Added: 0083579
2016-01-25 12:09dmiguelezReview Assigned To => dmiguelez
2016-01-25 12:09dmiguelezNote Added: 0083580
2016-01-25 12:09dmiguelezStatusresolved => closed

Notes
(0083578)
hgbot   
2016-01-25 12:08   
Repository: erp/backports/3.0PR15Q4.3
Changeset: 16c01a9e0bdefb04f299d79e7e236a8634b819b9
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Jan 21 14:27:39 2016 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q4.3/rev/16c01a9e0bdefb04f299d79e7e236a8634b819b9 [^]

Fixes issue 31998: Wrong cost calculation in Costing Migration Process

HQL in insertTrxCosts method in CostingMigrationProcess class was doing an inner join between m_transaction and m_inoutline instead of a left join.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0083579)
hgbot   
2016-01-25 12:08   
Repository: erp/backports/3.0PR15Q4.3
Changeset: 5d784a9454eb7e33e6ed13cc97e14f852367c8be
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jan 25 12:08:18 2016 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q4.3/rev/5d784a9454eb7e33e6ed13cc97e14f852367c8be [^]

Related to Issue 31998. Changed License year.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0083580)
dmiguelez   
2016-01-25 12:09   
Code Review + Testing Ok