Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031176Openbravo ERP07. Sales managementpublic2015-10-19 19:052015-11-23 21:16
ReporterVictorVillar 
Assigned Todmiguelez 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR16Q1Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031176: it is possible to select wrong storage bins in the goods shipment lines
Descriptionit is possible to select wrong storage bins in the goods shipment lines
Steps To ReproduceAs group admin role,
 Go to Organization window,
    Warehouse tab: remove España región sur
 Go to Goods Shipment window,
    Create a new for España.
   create a new line and realise that you can select a storage bin (sur) which is not a warehouse on hand of this organization
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0011075 new Triage Omni OMS Warehouse/storage bin: selecting warehouse at the header, doesn't restrict storage bins in the lines 
causes defect 0033382 closed Sanjota Wrong Storage Bin in Goods Receipt Lines 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-10-19 19:05VictorVillarNew Issue
2015-10-19 19:05VictorVillarAssigned To => Triage Finance
2015-10-19 19:05VictorVillarModules => Core
2015-10-19 19:05VictorVillarResolution time => 1445464800
2015-10-19 19:05VictorVillarTriggers an Emergency Pack => No
2015-10-19 19:18VictorVillarRelationship addedrelated to 0011075
2015-10-20 10:05dmiguelezNote Added: 0081111
2015-10-23 14:03dmiguelezNote Added: 0081261
2015-10-26 09:57dmiguelezStatusnew => scheduled
2015-10-27 12:15psanjuanNote Edited: 0081111bug_revision_view_page.php?bugnote_id=0081111#r9910
2015-10-27 13:18psanjuanNote Edited: 0081261bug_revision_view_page.php?bugnote_id=0081261#r9916
2015-10-27 13:21psanjuanNote Edited: 0081261bug_revision_view_page.php?bugnote_id=0081261#r9917
2015-10-27 13:36psanjuanNote Edited: 0081261bug_revision_view_page.php?bugnote_id=0081261#r9918
2015-10-28 11:03vmromanosAssigned ToTriage Finance => dmiguelez
2015-10-28 12:21hgbotCheckin
2015-10-28 12:21hgbotNote Added: 0081378
2015-10-28 12:21hgbotStatusscheduled => resolved
2015-10-28 12:21hgbotResolutionopen => fixed
2015-10-28 12:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e1c26dc9a8193314108653fbb3088f98cf89a677 [^]
2015-10-28 12:21vmromanosReview Assigned To => vmromanos
2015-10-28 12:21vmromanosNote Added: 0081379
2015-10-28 12:21vmromanosStatusresolved => closed
2015-11-23 21:16hudsonbotCheckin
2015-11-23 21:16hudsonbotNote Added: 0082162
2016-06-30 12:51aferrazRelationship addedcauses 0033382

Notes
(0081111)
dmiguelez   
2015-10-20 10:05   
(edited on: 2015-10-27 12:15)
The solution would be to create a new selector for Locators based on ObUiSelSelecors.
This selector should take into account On Hand Warehouses (for Sales) that are available for the selected Organization.
It is be only needed to change the selector of this Window.
(0081261)
dmiguelez   
2015-10-23 14:03   
(edited on: 2015-10-27 13:36)
As group admin role,
  
  Go to Goods Shipment Window
    Create a new Goods Shipment for Organization US and Warehouse US East Coast
    Create a new Goods Shipment Line
    Check that the default Storage Bin selected is EC-0-0-0
    Click on the magnifying glass and check that the records are pre-filtered using US East Coast
    Remove the filter and check that it is possible to select records from US West Coast also
    Check that the fields can be filtered and sorted

  Go to Goods Receipt Window
    Create a new Goods Receipt for Organization US and Warehouse US East Coast
    Create a new Goods Receipt Line
    Check that the default Storage Bin selected is EC-0-0-0
    Click on the magnifying glass and check that the records are pre-filtered using US East Coast
    Remove the filter and check that it is possible to select records from US West Coast also
    Check that the fields can be filtered and sorted
    
 Go to Organization window and select US Organization,
    Warehouse tab: remove West Coast Warehouse

 Go to Goods Shipment window,
    Select the previously created Goods Shipment
    Create a new Goods Shipment Line
    Click on the magnifying glass of the Storage Bin selector
    Remove the filter and check that only Storage Bins from East Coast are selected

 Go to Goods Receipt window,
    Select the previously created Goods Receipt
    Create a new Goods Shipment Line
    Click on the magnifying glass of the Storage Bin selector
    Remove the filter and check that it is possible to select records from US West Coast also

 Go to Organization window and select US Organization,
    Warehouse tab: Add a new Record for West Coast with Priority 10

 Go to Warehouse and Storage Bins Window
    Set West Coast as not active
    Create a new Storage Bin for East Coast and set it as not active

  Go to Goods Shipment window,
    Select the previously created Goods Shipment
    Create a new Goods Shipment Line
    Click on the magnifying glass of the Storage Bin selector
    Remove the filter and check that Storage Bins from West Coast and the new created Storage Bin are not available

 Go to Goods Receipt window,
    Select the previously created Goods Receipt
    Create a new Goods Shipment Line
    Click on the magnifying glass of the Storage Bin selector
    Remove the filter and check that Storage Bins from West Coast and the new created Storage Bin are not available

 Go to Warehouse and Storage Bins Window
    Set West Coast as active
    Set also as active the new storage bin created for East Coast.

Go to Organization window and select US Organization,
    Warehouse tab: set West Coast Warehouse as Active = No

 Go to Goods Shipment window,
    Select the previously created Goods Shipment
    Create a new Goods Shipment Line
    Click on the magnifying glass of the Storage Bin selector
    Remove the filter and check that only Storage Bins from East Coast are selected, including the new one created.

 Go to Goods Receipt window,
    Select the previously created Goods Receipt
    Create a new Goods Shipment Line
    Click on the magnifying glass of the Storage Bin selector
    Remove the filter and check that it is possible to select records from US West Coast also
(0081378)
hgbot   
2015-10-28 12:21   
Repository: erp/devel/pi
Changeset: e1c26dc9a8193314108653fbb3088f98cf89a677
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Fri Oct 23 13:28:16 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e1c26dc9a8193314108653fbb3088f98cf89a677 [^]

Fixes Issue 31176. Changes old selector with new one in M_InoutLine Table.

Replaces the old selector for Storage Bins with a new OBUISEL_Selector
in M_InoutLine Table.
In Sales flow it shows only Storage Bins that are available to the selected
Organization and that are also On Hand Warehouses.
In the Purchase flow it shows Storage Bins that are available to the selected
Organization.
Also, the selector is pre-filtered using the Warehouse in the Document Header
and it has as a default value a Storage Bin of that Warehouse.

---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
---
(0081379)
vmromanos   
2015-10-28 12:21   
Code review + testing OK
(0082162)
hudsonbot   
2015-11-23 21:16   
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/7b56bebaaa88 [^]
Maturity status: Test