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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031972
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2016-01-21 10:392016-03-17 10:55
ReporterngarciaView Statuspublic 
Assigned Toaferraz 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0159f66bd6e0
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression levelProduction - Confirmed Stable
Regression date2014-12-18
Regression introduced in release3.0PR15Q1
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/8dd8af8a26e5 [^]
Triggers an Emergency PackNo
Summary

0031972: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00319973.0PR16Q1 closedTriage Omni WMS Costing Migration Process:Cost of products in closing inventory is calculated by taking into account only shipments and receipts 
depends on backport 00319983.0PR15Q4.3 closedTriage Omni WMS Costing Migration Process:Cost of products in closing inventory is calculated by taking into account only shipments and receipts 
depends on backport 00319993.0PR15Q3.6 closedTriage Omni WMS Costing Migration Process:Cost of products in closing inventory is calculated by taking into account only shipments and receipts 
caused by defect 0028450 closedumartirena [Costing] Costing Migration Process fails 
related to defect 0031979 closedaferraz Costing Migration Process: processed column of m_transaction table is not set as Y for records with its cost calculated 

-  Notes
(0083587)
hgbot (developer)
2016-01-25 12:14

 Repository: erp/devel/pi
Changeset: 0159f66bd6e0d64d86b01b9a8a501fd048c20019
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Jan 21 14:27:39 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0159f66bd6e0d64d86b01b9a8a501fd048c20019 [^]

Fixes issue 31972: 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
---
(0083588)
dmiguelez (developer)
2016-01-25 12:14

 Code Review + Testing Ok
(0085079)
hudsonbot (developer)
2016-03-17 10:55

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b22fb0500156 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-01-21 10:39 ngarcia New Issue
2016-01-21 10:39 ngarcia Assigned To => Triage Finance
2016-01-21 10:39 ngarcia Modules => Core
2016-01-21 10:39 ngarcia Triggers an Emergency Pack => No
2016-01-21 10:40 ngarcia Issue Monitored: networkb
2016-01-21 10:40 ngarcia Relationship added caused by 0028450
2016-01-21 11:50 ngarcia Relationship added related to 0031979
2016-01-21 13:02 ngarcia Resolution time => 1456009200
2016-01-21 16:11 ahernandezgil Issue Monitored: ahernandezgil
2016-01-22 14:51 aferraz Status new => scheduled
2016-01-22 14:51 aferraz Assigned To Triage Finance => aferraz
2016-01-22 15:08 aferraz Regression level => Production - Confirmed Stable
2016-01-22 15:08 aferraz Regression date => 2014-12-18
2016-01-22 15:08 aferraz Regression introduced in release => 3.0PR15Q1
2016-01-22 15:08 aferraz Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/8dd8af8a26e5 [^]
2016-01-25 12:14 hgbot Checkin
2016-01-25 12:14 hgbot Note Added: 0083587
2016-01-25 12:14 hgbot Status scheduled => resolved
2016-01-25 12:14 hgbot Resolution open => fixed
2016-01-25 12:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0159f66bd6e0d64d86b01b9a8a501fd048c20019 [^]
2016-01-25 12:14 dmiguelez Review Assigned To => dmiguelez
2016-01-25 12:14 dmiguelez Note Added: 0083588
2016-01-25 12:14 dmiguelez Status resolved => closed
2016-03-17 10:55 hudsonbot Checkin
2016-03-17 10:55 hudsonbot Note Added: 0085079

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker