Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031997Openbravo ERP04. Warehouse managementpublic2016-01-21 10:392016-01-25 12:13
Reporterngarcia 
Assigned ToTriage Omni WMS 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR16Q1Fixed 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
Summary0031997: 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.0PR16Q1
2016-01-25 12:13hgbotCheckin
2016-01-25 12:13hgbotNote Added: 0083584
2016-01-25 12:13hgbotStatusscheduled => resolved
2016-01-25 12:13hgbotResolutionopen => fixed
2016-01-25 12:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR16Q1/rev/0c25b9239c06ee7ff9d7393a5bba2f28a91c1c6d [^]
2016-01-25 12:13hgbotCheckin
2016-01-25 12:13hgbotNote Added: 0083585
2016-01-25 12:13dmiguelezReview Assigned To => dmiguelez
2016-01-25 12:13dmiguelezNote Added: 0083586
2016-01-25 12:13dmiguelezStatusresolved => closed

Notes
(0083584)
hgbot   
2016-01-25 12:13   
Repository: erp/backports/3.0PR16Q1
Changeset: 0c25b9239c06ee7ff9d7393a5bba2f28a91c1c6d
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.0PR16Q1/rev/0c25b9239c06ee7ff9d7393a5bba2f28a91c1c6d [^]

Fixes issue 31997: 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
---
(0083585)
hgbot   
2016-01-25 12:13   
Repository: erp/backports/3.0PR16Q1
Changeset: dcf1c4b75dd28bb5a84f2be13a71dc4441e3aeaa
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jan 25 12:12:46 2016 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR16Q1/rev/dcf1c4b75dd28bb5a84f2be13a71dc4441e3aeaa [^]

Related to Issue 31997. Changed license year.

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