Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039820ModulesWarehouse Pickingpublic2018-12-17 13:512019-01-09 13:19
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Support ticket
OBNetwork customer
Regression introduced in release
Summary0039820: Picking list is created with stock from a warehouse different than the order's warehouse if reservation without warehouse exists
DescriptionPicking list is created with stock from a warehouse different than the order's warehouse if reservation without warehouse exists
Steps To ReproduceAs group admin role:
   Apply module's dataset
   Set the Enable Stock Reservations preference to Y
   Log out and log in

   Create a new product in F&B España, S.A.
   Add Region Norte and Region Sur warehouses as on hand warehouses to F&B España, S.A. organization
   Create a goods receipt in Region Norte warehouse, add 10 units of the previously created product and complete it
   Create a goods receipt in Region Sur warehouse, add 10 units of the previously created product and complete it
   Create a Sales Order for F&B España S.A. and Region Norte warehouse
   Add 15 units of the previously created product to it
   Complete it
   Manage Reservation and reserve 10 units from Region Norte warehouse
   Generate Picking List and check the pending 5 units have been taken from Region Sur warehouse. This is wrong

   Process the picking list
   Check a goods shipment for Region Norte warehouse has been created with a storage bin of Region Norte and another storage bin for Region Sur. This is also wrong
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0035281 closed AtulOpenbravo Picking list is created with stock of a on hand warehouse if there exists some stock in the warehouse of the sales order header 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-12-17 13:51ngarciaNew Issue
2018-12-17 13:51ngarciaAssigned To => Triage Finance
2018-12-17 13:51ngarciaIssue Monitored: networkb
2018-12-17 13:51ngarciaRelationship addedrelated to 0035281
2018-12-17 13:52ngarciaResolution time => 1546815600
2018-12-17 16:57SandrahuguetAssigned ToTriage Finance => AtulOpenbravo
2018-12-18 10:16PracticsIssue Monitored: Practics
2018-12-27 12:38SandrahuguetAssigned ToAtulOpenbravo => markmm82
2018-12-27 17:31markmm82Statusnew => scheduled
2019-01-02 17:22markmm82Note Added: 0108788
2019-01-08 16:08SandrahuguetReview Assigned To => Sandrahuguet
2019-01-08 16:08SandrahuguetNote Added: 0108857
2019-01-08 16:08SandrahuguetStatusscheduled => closed
2019-01-08 16:08SandrahuguetResolutionopen => no change required
2019-01-08 16:27ngarciaNote Added: 0108858
2019-01-08 16:27ngarciaStatusclosed => new
2019-01-08 16:27ngarciaResolutionno change required => open
2019-01-08 17:32SandrahuguetAssigned Tomarkmm82 => Triage Finance
2019-01-08 18:05SandrahuguetAssigned ToTriage Finance => markmm82
2019-01-09 08:20SandrahuguetAssigned Tomarkmm82 => AtulOpenbravo
2019-01-09 08:46AtulOpenbravoStatusnew => scheduled
2019-01-09 13:17hgbotCheckin
2019-01-09 13:17hgbotNote Added: 0108868
2019-01-09 13:17hgbotStatusscheduled => resolved
2019-01-09 13:17hgbotResolutionopen => fixed
2019-01-09 13:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/af2a4819feded0c77a6a73f5e11d78c4cfcfa023 [^]
2019-01-09 13:19SandrahuguetNote Added: 0108869
2019-01-09 13:19SandrahuguetStatusresolved => closed

Notes
(0108788)
markmm82   
2019-01-02 17:22   
As group admin role:
   Apply module's dataset
   Set the Enable Stock Reservations preference to Y
   Log out and log in

   Create a new product in F&B España, S.A.
   Add Region Norte and Region Sur warehouses as on hand warehouses to F&B España, S.A. organization
   Create a goods receipt in Region Norte warehouse, add 10 units of the previously created product and complete it
   Create a goods receipt in Region Sur warehouse, add 10 units of the previously created product and complete it
   Create a Sales Order for F&B España S.A. and Region Norte warehouse
   Add 15 units of the previously created product to it
   Complete it
   Manage Reservation and reserve 10 units from Region Norte warehouse
   Generate Picking List and check that just the 10 units have been taken from Region Nortewarehouse. Notice a message is also shown:
"Picking List created successfully
PL338
There is not enough stock in warehouses to create the whole Picking List. : [PL338]"

   Process the picking list
   Check a goods shipment for Region Norte warehouse has been created with a storage bin of Region Norte.
(0108857)
Sandrahuguet   
2019-01-08 16:08   
Expected behavior, picking process takes the on-hand warehouses of the order header.
The behavior is homogeneous in manage reservation and picking list.

Workaround:
Set in the reservation the warehouse desired.

As group admin role:
   Apply module's dataset
   Set the Enable Stock Reservations preference to Y
   Log out and log in

   Create a new product in F&B España, S.A.
   Add Region Norte and Region Sur warehouses as on hand warehouses to F&B España, S.A. organization
   Create a goods receipt in Region Norte warehouse, add 10 units of the previously created product and complete it
   Create a goods receipt in Region Sur warehouse, add 10 units of the previously created product and complete it
   Create a Sales Order for F&B España S.A. and Region Norte warehouse
   Add 15 units of the previously created product to it
   Complete it
   Manage Reservation and reserve 10 units from Region Norte warehouse
   Navigate to Stock Reservation and set Region Norte warehouse
   Generate Picking List check that just the 10 units have been taken from Region Norte warehouse.
   Notice a message is also shown:
   Picking List created successfully
   There is not enough stock in warehouses to create the whole Picking List
(0108858)
ngarcia   
2019-01-08 16:27   
Picking list was designed to get the stock for the order's warehouse. Creating a goods shipment with Region Norte warehouse and Region Sur storage bin is wrong
(0108868)
hgbot   
2019-01-09 13:17   
Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: af2a4819feded0c77a6a73f5e11d78c4cfcfa023
Author: Sandra Huguet <sandra.huguet <at> openbravo.com >
Date: Wed Jan 09 15:38:06 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/af2a4819feded0c77a6a73f5e11d78c4cfcfa023 [^]

Fixes Issue 39820: Picking list is created with stock from a warehouse
different than the order's warehouse if reservation without warehouse
exists

Before getting unclosed reservation from orderline, set orderline
warehouse to it.

---
M src/org/openbravo/warehouse/pickinglist/Utilities.java
---
(0108869)
Sandrahuguet   
2019-01-09 13:19   
code review + testing OK