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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029111
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2015-03-03 13:392015-04-01 08:47
ReporterumartirenaView Statuspublic 
Assigned Toumartirena 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisiond83bb42ad903
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by defect 0028890 closedumartirena Valued stock report is showing wrong qty after a manual cost adjustment 

-  Notes
(0075169)
hgbot (developer)
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 (viewer)
2015-03-04 18:26

 Code review + testing OK
(0075209)
hudsonbot (viewer)
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 (developer)
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 (administrator)
2015-04-01 08:47

 closed again, as the status changes due to merge of tag 15Q1.2 to backport repo Q2

- Issue History
Date Modified Username Field Change
2015-03-03 13:39 umartirena New Issue
2015-03-03 13:39 umartirena Assigned To => Sandrahuguet
2015-03-03 13:39 umartirena OBNetwork customer => No
2015-03-03 13:39 umartirena Modules => Core
2015-03-03 13:39 umartirena Triggers an Emergency Pack => No
2015-03-03 13:39 umartirena Assigned To Sandrahuguet => umartirena
2015-03-03 13:43 umartirena Regression level => Coding ( Testing )
2015-03-03 13:43 umartirena Regression date => 2015-02-12
2015-03-03 13:43 umartirena Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/1ea341e8c283 [^]
2015-03-03 13:43 umartirena Description Updated View Revisions
2015-03-03 13:43 umartirena Steps to Reproduce Updated View Revisions
2015-03-03 13:43 umartirena Regression introduced in release => 3.0PR15Q1.1
2015-03-03 16:06 dmitry_mezentsev Relationship added caused by 0028890
2015-03-04 18:23 vmromanos Status new => scheduled
2015-03-04 18:23 vmromanos fix_in_branch => pi
2015-03-04 18:26 hgbot Checkin
2015-03-04 18:26 hgbot Note Added: 0075169
2015-03-04 18:26 hgbot Status scheduled => resolved
2015-03-04 18:26 hgbot Resolution open => fixed
2015-03-04 18:26 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f06d7018a52bbc85ff4be3a2894c90efcfdbf2f4 [^]
2015-03-04 18:26 vmromanos Review Assigned To => vmromanos
2015-03-04 18:26 vmromanos Note Added: 0075170
2015-03-04 18:26 vmromanos Status resolved => closed
2015-03-05 17:01 hudsonbot Checkin
2015-03-05 17:01 hudsonbot Note Added: 0075209
2015-04-01 08:05 hgbot Checkin
2015-04-01 08:05 hgbot Note Added: 0076196
2015-04-01 08:05 hgbot Status closed => resolved
2015-04-01 08:05 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/f06d7018a52bbc85ff4be3a2894c90efcfdbf2f4 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/d83bb42ad90335b8202c37f88361ae2d071174f8 [^]
2015-04-01 08:47 priyam Status resolved => closed
2015-04-01 08:47 priyam Note Added: 0076279

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker