Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030679Openbravo ERP04. Warehouse managementpublic2015-08-26 14:232015-09-07 11:53
Reporteraferraz 
Assigned Toaferraz 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target Version3.0PR15Q4Fixed 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
Summary0030679: Order by should be improved in some querys inside Cost Adjustment process
DescriptionMany querys inside Cost Adjustment process retrieve results from M_Transaction table, ordering only by transaction process date.

In case of creating many transactions inside an automated process (like in TestCosting tests), results can be retrieved in different order in different executions, as transaction process date will be the same for them.

To retrieve results always in the same order, order by should be improved in some querys inside Cost Adjustment process.
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks design defect 0028625 closed aferraz QA Process requests should be called directly instead of using a request in TestCosting 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-08-26 14:23aferrazNew Issue
2015-08-26 14:23aferrazAssigned To => aferraz
2015-08-26 14:23aferrazModules => Core
2015-08-26 14:23aferrazTriggers an Emergency Pack => No
2015-08-26 14:29aferrazRelationship addedblocks 0028625
2015-09-04 09:28hgbotCheckin
2015-09-04 09:28hgbotNote Added: 0080069
2015-09-04 09:28hgbotStatusnew => resolved
2015-09-04 09:28hgbotResolutionopen => fixed
2015-09-04 09:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a14df06b6122c618dfcfdda4e919381f19f7c7f2 [^]
2015-09-04 09:28hgbotCheckin
2015-09-04 09:28hgbotNote Added: 0080070
2015-09-04 09:28hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a14df06b6122c618dfcfdda4e919381f19f7c7f2 [^] => http://code.openbravo.com/erp/devel/pi/rev/9c0a20844216c967bac3a707a3fc1b936abea55d [^]
2015-09-04 09:28hgbotCheckin
2015-09-04 09:28hgbotNote Added: 0080071
2015-09-04 15:46hudsonbotCheckin
2015-09-04 15:46hudsonbotNote Added: 0080127
2015-09-04 15:46hudsonbotCheckin
2015-09-04 15:46hudsonbotNote Added: 0080128
2015-09-04 15:46hudsonbotCheckin
2015-09-04 15:46hudsonbotNote Added: 0080129
2015-09-07 11:53dmiguelezReview Assigned To => dmiguelez
2015-09-07 11:53dmiguelezNote Added: 0080179
2015-09-07 11:53dmiguelezStatusresolved => closed

Notes
(0080069)
hgbot   
2015-09-04 09:28   
Repository: erp/devel/pi
Changeset: a14df06b6122c618dfcfdda4e919381f19f7c7f2
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Sep 02 13:45:19 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a14df06b6122c618dfcfdda4e919381f19f7c7f2 [^]

Fixes issue 30679: Improve orderby in CostAdjustmentProcess.getNextLine query

---
M src/org/openbravo/costing/CostAdjustmentProcess.java
---
(0080070)
hgbot   
2015-09-04 09:28   
Repository: erp/devel/pi
Changeset: 9c0a20844216c967bac3a707a3fc1b936abea55d
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Sep 02 13:46:53 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9c0a20844216c967bac3a707a3fc1b936abea55d [^]

Fixes issue 30679: Improve orderby in LandedCostProcess.generateCostAdjustment query

---
M src/org/openbravo/costing/LandedCostProcess.java
---
(0080071)
hgbot   
2015-09-04 09:28   
Repository: erp/devel/pi
Changeset: 9054fa451525a28ad92b66216e519b7d4f24456f
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Aug 26 20:06:13 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9054fa451525a28ad92b66216e519b7d4f24456f [^]

Related to issue 30679: Change order of cost adjustments assert in LC101LC201 test

---
M src-test/src/org/openbravo/test/costing/TestCosting.java
---
(0080127)
hudsonbot   
2015-09-04 15:46   
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/2c27fe2e93a9 [^]
Maturity status: Test
(0080128)
hudsonbot   
2015-09-04 15:46   
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/2c27fe2e93a9 [^]
Maturity status: Test
(0080129)
hudsonbot   
2015-09-04 15:46   
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/2c27fe2e93a9 [^]
Maturity status: Test
(0080179)
dmiguelez   
2015-09-07 11:53   
Code Review + Testing Ok