Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028681Openbravo ERP03. Procurement managementpublic2015-01-19 18:012015-03-24 10:42
Reportermaite 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket33710
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028681: "Return to vendor shipment" pick/edit should only propose warehouses belonging to natural organization's tree
Description"Return to vendor shipment" pick/edit should only propose warehouses belonging to natural organization's tree
Steps To Reproduce1. Create new Role named "Norte". Define access for "España Norte" organization and "Openbravo" user
2. Register Goods Receipt for "España Sur" and "Vino tinto" product in order to ensure that there is stock available for that product in both Norte and Sur warehouses
3. Register "Return to vendor" document for "España Norte" and "Vino Tinto". Process
4. Logout and login again with "Norte" role
5. Access "Return to Vendor Shipment" and registernew document for "España Norte". Run "Pick/Edit" and realize that stock for Sur warehouse appears available when it should not.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00266623.0PR14Q3 closed AtulOpenbravo Return to Vendor Pick/edit should not filter by warehouses on hand 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-01-19 18:01maiteNew Issue
2015-01-19 18:01maiteAssigned To => dmiguelez
2015-01-19 18:01maiteOBNetwork customer => Yes
2015-01-19 18:01maiteModules => Core
2015-01-19 18:01maiteSupport ticket => 33710
2015-01-19 18:01maiteResolution time => 1421708400
2015-01-19 18:01maiteTriggers an Emergency Pack => No
2015-01-19 18:02maiteIssue Monitored: networkb
2015-01-19 18:03maiteAssigned Todmiguelez => Sandrahuguet
2015-01-19 18:03maiteRelationship addedrelated to 0026662
2015-01-21 16:37SandrahuguetAssigned ToSandrahuguet => aferraz
2015-01-22 13:08aferrazNote Added: 0073719
2015-01-22 17:40aferrazNote Edited: 0073719bug_revision_view_page.php?bugnote_id=0073719#r7521
2015-01-26 18:06aferrazNote Edited: 0073719bug_revision_view_page.php?bugnote_id=0073719#r7540
2015-01-29 10:25hgbotCheckin
2015-01-29 10:25hgbotNote Added: 0073882
2015-01-29 10:25umartirenaStatusnew => scheduled
2015-01-29 10:25umartirenafix_in_branch => pi
2015-01-29 10:26umartirenaStatusscheduled => resolved
2015-01-29 10:26umartirenaFixed in Version => pi
2015-01-29 10:26umartirenaFixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/1669f11b74c1 [^]
2015-01-29 10:26umartirenaResolutionopen => fixed
2015-01-29 10:26umartirenaReview Assigned To => umartirena
2015-01-29 10:26umartirenaNote Added: 0073883
2015-01-29 10:26umartirenaStatusresolved => closed
2015-02-04 20:34hudsonbotCheckin
2015-02-04 20:34hudsonbotNote Added: 0074196
2015-03-24 10:42ngarciaIssue Monitored: ngarcia

Notes
(0073719)
aferraz   
2015-01-22 13:08   
(edited on: 2015-01-26 18:06)
Test Plan:
- Login with group admin role
- Create and process Goods Receipt for "España Norte" and "Cerveza Lager" product, quantity 100.
- Create and process Goods Receipt for "España Sur" and "Cerveza Lager" product, quantity 200.
- Register "Return to vendor" document for "España Norte" and "Cerveza Lager". Process
- Create "Return to Vendor Shipment" for "España Norte". Run "Pick/Edit" and realize that stock from Sur warehouse doesn't appear (it only appears stock from Norte warehouse).
- Create "Return to Vendor Shipment" for "España S.A.". Run "Pick/Edit" and realize that stock from both Norte and Sur warehouses appear.
(0073882)
hgbot   
2015-01-29 10:25   
Repository: erp/devel/pi
Changeset: 1669f11b74c1c050b0f608ab6e290e3f9092dc4e
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Jan 28 14:09:37 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1669f11b74c1c050b0f608ab6e290e3f9092dc4e [^]

Fix issue 28681: Return to Vendor Shipment pick/edit shows lines of any org

An extra condition has been added to Return to Vendor Shipment Pick/Edit Lines HQL Where Clause, in order to show only lines with warehouse belonging to natural organization's tree. Also M_RM_SHIPMENT_PICK_EDIT view has been modified to add a hack, to avoid having errors with pendingqty column when querying the view in Oracle

---
M src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml
M src-db/database/sourcedata/AD_TAB.xml
---
(0073883)
umartirena   
2015-01-29 10:26   
Code review + Testing OK
(0074196)
hudsonbot   
2015-02-04 20:34   
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/f36c91d0ad63 [^]
Maturity status: Test