Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031999Openbravo ERP04. Warehouse managementpublic2016-01-21 10:392016-01-25 12:11
Reporterngarcia 
Assigned ToTriage Omni WMS 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3.6Fixed 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
Summary0031999: 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.0PR15Q3.6
2016-01-25 12:11hgbotCheckin
2016-01-25 12:11hgbotNote Added: 0083581
2016-01-25 12:11hgbotStatusscheduled => resolved
2016-01-25 12:11hgbotResolutionopen => fixed
2016-01-25 12:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q3.6/rev/a25dd05a43f98424bab24804407b528385c0825c [^]
2016-01-25 12:11hgbotCheckin
2016-01-25 12:11hgbotNote Added: 0083582
2016-01-25 12:11dmiguelezReview Assigned To => dmiguelez
2016-01-25 12:11dmiguelezNote Added: 0083583
2016-01-25 12:11dmiguelezStatusresolved => closed

Notes
(0083581)
hgbot   
2016-01-25 12:11   
Repository: erp/backports/3.0PR15Q3.6
Changeset: a25dd05a43f98424bab24804407b528385c0825c
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.0PR15Q3.6/rev/a25dd05a43f98424bab24804407b528385c0825c [^]

Fixes issue 31999: 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
---
(0083582)
hgbot   
2016-01-25 12:11   
Repository: erp/backports/3.0PR15Q3.6
Changeset: f2d89cfb895d1765e496a72ecbad9bb9f8115072
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jan 25 12:10:28 2016 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q3.6/rev/f2d89cfb895d1765e496a72ecbad9bb9f8115072 [^]

Related to Issue 31999. Changed license year.

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