Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035068Openbravo ERP04. Warehouse managementpublic2017-01-27 10:142017-03-15 20:19
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tomarkmm82
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket45278
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035068: Valued Stock Report is showing warehouses that do not belong to the organization included in the filter
DescriptionValued Stock Report is showing warehouses that do not belong to the organization included in the filter
Steps To ReproduceAs group admin role:
   Create a new warehouse for F&B España - Región Norte
   Add a storage bin to it
   Create a Goods Receipt for that warehouse and complete it
   Launch the Costing Background Process and check it finishes successfully
   Launch the Valued Stock report for F&B España - Región Norte organization
   Leave the warehouse filter empty (we want to get the stock of all the warehouses in F&B España Region Norte)
   Check stock for F&B España Región Sur is shown and it should not
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-01-27 10:14ngarciaNew Issue
2017-01-27 10:14ngarciaAssigned To => Triage Finance
2017-01-27 10:14ngarciaOBNetwork customer => Yes
2017-01-27 10:14ngarciaModules => Core
2017-01-27 10:14ngarciaSupport ticket => 45278
2017-01-27 10:14ngarciaResolution time => 1487286000
2017-01-27 10:14ngarciaTriggers an Emergency Pack => No
2017-01-27 10:14ngarciaIssue Monitored: networkb
2017-01-27 18:20markmm82Assigned ToTriage Finance => AtulOpenbravo
2017-02-02 08:07AtulOpenbravoStatusnew => scheduled
2017-02-02 08:07AtulOpenbravoNote Added: 0094003
2017-02-13 17:10hgbotCheckin
2017-02-13 17:10hgbotNote Added: 0094274
2017-02-13 17:10hgbotStatusscheduled => resolved
2017-02-13 17:10hgbotResolutionopen => fixed
2017-02-13 17:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/810c654d312e2e95a69eaa26a40a9fcd5fca5440 [^]
2017-02-13 17:45markmm82Review Assigned To => markmm82
2017-02-13 17:45markmm82Note Added: 0094279
2017-02-13 17:45markmm82Statusresolved => closed
2017-02-13 17:45markmm82Fixed in Version => 3.0PR17Q2
2017-02-13 19:41markmm82Statusclosed => new
2017-02-13 19:41markmm82Resolutionfixed => open
2017-02-13 19:41markmm82Fixed in Version3.0PR17Q2 =>
2017-02-13 19:42markmm82Note Deleted: 0094279
2017-02-13 20:09markmm82Statusnew => scheduled
2017-02-13 20:11hgbotCheckin
2017-02-13 20:11hgbotNote Added: 0094288
2017-02-13 20:13markmm82Statusscheduled => resolved
2017-02-13 20:13markmm82Fixed in Version => 3.0PR17Q2
2017-02-13 20:13markmm82Fixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/810c654d312e2e95a69eaa26a40a9fcd5fca5440 [^] => http://code.openbravo.com/erp/devel/pi/rev/548b15b9c37e7deb3e0cdba89a8191195fc66069 [^]
2017-02-13 20:13markmm82Resolutionopen => fixed
2017-02-13 20:14markmm82Note Added: 0094290
2017-02-13 20:14markmm82Statusresolved => closed
2017-03-15 20:19hudsonbotCheckin
2017-03-15 20:19hudsonbotNote Added: 0095179
2017-03-15 20:19hudsonbotCheckin
2017-03-15 20:19hudsonbotNote Added: 0095180

Notes
(0094003)
AtulOpenbravo   
2017-02-02 08:07   
Test Plan
- Login as Group admin role.
- Create a new warehouse for F&B España - Región Norte Org.
- Add a storage bin to it
- Create a Goods Receipt for that warehouse and complete it
- Launch the Costing Background Process and check it finishes successfully
- Launch the Valued Stock report for F&B España - Región Norte organization
- Leave the warehouse filter empty (we want to get the stock of all the warehouses in F&B España Region Norte)
- Check that report is shown for only F&B España Región Norte Org warehouses.
- Change filter Org to F&B España.
- Check that report is shown for Region Norte as well as Region Sur warehouses.
(0094274)
hgbot   
2017-02-13 17:10   
Repository: erp/devel/pi
Changeset: 810c654d312e2e95a69eaa26a40a9fcd5fca5440
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Feb 13 12:41:34 2017 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/810c654d312e2e95a69eaa26a40a9fcd5fca5440 [^]

Fixes Issue 35068: Valued Stock Report is showing warehouses that do not
belong to the organization included in the filter

Selected warehouse or list of applicable warehouse for selected
organization sent as parameter to queries fetching valued stock
data.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
---
(0094288)
hgbot   
2017-02-13 20:11   
Repository: erp/devel/pi
Changeset: 548b15b9c37e7deb3e0cdba89a8191195fc66069
Author: Mark <markmm82 <at> gmail.com>
Date: Mon Feb 13 14:06:44 2017 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/548b15b9c37e7deb3e0cdba89a8191195fc66069 [^]

Related to issue 35068: Code review improvements

Used a HQL query instead of a direct SQL query.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
---
(0094290)
markmm82   
2017-02-13 20:14   
Code review + Testing OK
(0095179)
hudsonbot   
2017-03-15 20:19   
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/54e102bef53e [^]
Maturity status: Test
(0095180)
hudsonbot   
2017-03-15 20:19   
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/54e102bef53e [^]
Maturity status: Test