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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0031176
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2015-10-19 19:052015-11-23 21:16
ReporterVictorVillarView Statuspublic 
Assigned Todmiguelez 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisione1c26dc9a819
ProjectionnoneETAnoneTarget Version3.0PR16Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Tovmromanos
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0011075 newTriage Omni OMS Warehouse/storage bin: selecting warehouse at the header, doesn't restrict storage bins in the lines 
causes defect 0033382 closedSanjota Wrong Storage Bin in Goods Receipt Lines 

-  Notes
(0081111)
dmiguelez (developer)
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 (developer)
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 (developer)
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 (manager)
2015-10-28 12:21

Code review + testing OK
(0082162)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2015-10-19 19:05 VictorVillar New Issue
2015-10-19 19:05 VictorVillar Assigned To => Triage Finance
2015-10-19 19:05 VictorVillar Modules => Core
2015-10-19 19:05 VictorVillar Resolution time => 1445464800
2015-10-19 19:05 VictorVillar Triggers an Emergency Pack => No
2015-10-19 19:18 VictorVillar Relationship added related to 0011075
2015-10-20 10:05 dmiguelez Note Added: 0081111
2015-10-23 14:03 dmiguelez Note Added: 0081261
2015-10-26 09:57 dmiguelez Status new => scheduled
2015-10-27 12:15 psanjuan Note Edited: 0081111 View Revisions
2015-10-27 13:18 psanjuan Note Edited: 0081261 View Revisions
2015-10-27 13:21 psanjuan Note Edited: 0081261 View Revisions
2015-10-27 13:36 psanjuan Note Edited: 0081261 View Revisions
2015-10-28 11:03 vmromanos Assigned To Triage Finance => dmiguelez
2015-10-28 12:21 hgbot Checkin
2015-10-28 12:21 hgbot Note Added: 0081378
2015-10-28 12:21 hgbot Status scheduled => resolved
2015-10-28 12:21 hgbot Resolution open => fixed
2015-10-28 12:21 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e1c26dc9a8193314108653fbb3088f98cf89a677 [^]
2015-10-28 12:21 vmromanos Review Assigned To => vmromanos
2015-10-28 12:21 vmromanos Note Added: 0081379
2015-10-28 12:21 vmromanos Status resolved => closed
2015-11-23 21:16 hudsonbot Checkin
2015-11-23 21:16 hudsonbot Note Added: 0082162
2016-06-30 12:51 aferraz Relationship added causes 0033382


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker