Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029111Openbravo ERP04. Warehouse managementpublic2015-03-03 13:392015-04-01 08:47
Reporterumartirena 
Assigned Toumartirena 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelCoding ( Testing )
Regression date2015-02-12
Regression introduced in release3.0PR15Q1.1
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/1ea341e8c283 [^]
Triggers an Emergency PackNo
Summary0029111: Valued Stock Report does not display data while filtering by Product Category
DescriptionValued Stock Report does not display data while filtering by Product Category. An erroneous extra line without Product Category is displayed also.
Steps To ReproduceIn live.builds:

Go to Valued Stock Report. Enter a Date, Warehouse and Currency. Press html format. Notice that data is shown. An erroneous extra line without Product Category is displayed.

Now add a value in Product Category('Alcohol'). Press html format.
Notice that no values are displayed. The erroneous extra line without Product Category is also displayed.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by defect 0028890 closed umartirena Valued stock report is showing wrong qty after a manual cost adjustment 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-03 13:39umartirenaNew Issue
2015-03-03 13:39umartirenaAssigned To => Sandrahuguet
2015-03-03 13:39umartirenaOBNetwork customer => No
2015-03-03 13:39umartirenaModules => Core
2015-03-03 13:39umartirenaTriggers an Emergency Pack => No
2015-03-03 13:39umartirenaAssigned ToSandrahuguet => umartirena
2015-03-03 13:43umartirenaRegression level => Coding ( Testing )
2015-03-03 13:43umartirenaRegression date => 2015-02-12
2015-03-03 13:43umartirenaRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/1ea341e8c283 [^]
2015-03-03 13:43umartirenaDescription Updatedbug_revision_view_page.php?rev_id=7826#r7826
2015-03-03 13:43umartirenaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=7828#r7828
2015-03-03 13:43umartirenaRegression introduced in release => 3.0PR15Q1.1
2015-03-03 16:06dmitry_mezentsevRelationship addedcaused by 0028890
2015-03-04 18:23vmromanosStatusnew => scheduled
2015-03-04 18:23vmromanosfix_in_branch => pi
2015-03-04 18:26hgbotCheckin
2015-03-04 18:26hgbotNote Added: 0075169
2015-03-04 18:26hgbotStatusscheduled => resolved
2015-03-04 18:26hgbotResolutionopen => fixed
2015-03-04 18:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f06d7018a52bbc85ff4be3a2894c90efcfdbf2f4 [^]
2015-03-04 18:26vmromanosReview Assigned To => vmromanos
2015-03-04 18:26vmromanosNote Added: 0075170
2015-03-04 18:26vmromanosStatusresolved => closed
2015-03-05 17:01hudsonbotCheckin
2015-03-05 17:01hudsonbotNote Added: 0075209
2015-04-01 08:05hgbotCheckin
2015-04-01 08:05hgbotNote Added: 0076196
2015-04-01 08:05hgbotStatusclosed => resolved
2015-04-01 08:05hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f06d7018a52bbc85ff4be3a2894c90efcfdbf2f4 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/d83bb42ad90335b8202c37f88361ae2d071174f8 [^]
2015-04-01 08:47priyamStatusresolved => closed
2015-04-01 08:47priyamNote Added: 0076279

Notes
(0075169)
hgbot   
2015-03-04 18:26   
Repository: erp/devel/pi
Changeset: f06d7018a52bbc85ff4be3a2894c90efcfdbf2f4
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Tue Mar 03 13:57:53 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f06d7018a52bbc85ff4be3a2894c90efcfdbf2f4 [^]

Fixes bug 29111: Valued Stock report filter properly by Product Category

A new language parameter was added in the issue that has caused the regression, but in wrong order, causing not to be able to filter by Product Category.
Also a left join was being done instead of inner join, so the query was displaying an wrong extra line with a sum up of all not necessary m_transaction records.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
---
(0075170)
vmromanos   
2015-03-04 18:26   
Code review + testing OK
(0075209)
hudsonbot   
2015-03-05 17:01   
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/2369c54c9f14 [^]
Maturity status: Test
(0076196)
hgbot   
2015-04-01 08:05   
Repository: erp/backports/3.0PR15Q2
Changeset: d83bb42ad90335b8202c37f88361ae2d071174f8
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Tue Mar 03 13:57:53 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/d83bb42ad90335b8202c37f88361ae2d071174f8 [^]

Fixes bug 29111: Valued Stock report filter properly by Product Category

A new language parameter was added in the issue that has caused the regression, but in wrong order, causing not to be able to filter by Product Category.
Also a left join was being done instead of inner join, so the query was displaying an wrong extra line with a sum up of all not necessary m_transaction records.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
---
(0076279)
priyam   
2015-04-01 08:47   
closed again, as the status changes due to merge of tag 15Q1.2 to backport repo Q2