Openbravo Issue Tracking System - Modules
View Issue Details
0035281ModulesWarehouse Pickingpublic2017-02-15 20:042017-03-24 14:17
ngarcia 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
 
 
aferraz
0035281: Picking list is created with stock of a on hand warehouse if there exists some stock in the warehouse of the sales order header
Picking list is created with stock of a on hand warehouse if there exists some stock in the warehouse of the sales order header
As group admin role:
   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 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 5 units of the previously created product to it
   Complete it
   Try to Generate Picking List and check an error message is shown:
      "There is not enough available stock"
   The log shows:
      ERROR org.openbravo.base.exception.OBException - There is not enough available stock
org.openbravo.base.exception.OBException: There is not enough available stock
    at org.openbravo.warehouse.pickinglist.Utilities.processOrder(Utilities.java:180)
    at org.openbravo.warehouse.pickinglist.CreateActionHandler.doCreate(CreateActionHandler.java:265)
    at org.openbravo.warehouse.pickinglist.CreateActionHandler.execute(CreateActionHandler.java:84)


   Create a goods receipt in Region Norte warehouse, add 2 units of the previously created product and complete it
   Go to the previously created sales order and Generate Picking List
   Check 2 units have been taken from Region Norte and 3 for Region Sur warehouse
   Process it
   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
Analyze which of the following three options is the suitable one:

1. Get the stock only from the sales order header warehouse

2. Get the stock from all the on hand warehouses of the sales order header organization, prioritizing the one defined in the sales order header, but getting it from a different warehouse in case there is not stock in the header organization. Bug reported in this ticket. In this case, one goods shipment and one picking list should be created for each warehouse.

3. Make the process configurable by a preference in order to work as in 1 or in 2
No tags attached.
related to defect 0035647 scheduled AtulOpenbravo Picking list is created with stock of a on hand warehouse other than Warehouse in Sales Order Header 
related to defect 0039820 closed AtulOpenbravo Picking list is created with stock from a warehouse different than the order's warehouse if reservation without warehouse exists 
Issue History
2017-02-15 20:04ngarciaNew Issue
2017-02-15 20:04ngarciaAssigned To => Triage Finance
2017-02-15 20:04ngarciaResolution time => 1488927600
2017-02-15 20:04ngarciaIssue Monitored: networkb
2017-02-16 14:00ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14617#r14617
2017-02-16 14:00ngarciaProposed Solution updated
2017-02-16 15:04markmm82Assigned ToTriage Finance => AtulOpenbravo
2017-02-20 05:38AtulOpenbravoStatusnew => scheduled
2017-03-20 18:25dmitry_mezentsevNote Added: 0095435
2017-03-21 12:22aferrazNote Added: 0095464
2017-03-24 14:14hgbotCheckin
2017-03-24 14:14hgbotNote Added: 0095558
2017-03-24 14:14hgbotStatusscheduled => resolved
2017-03-24 14:14hgbotResolutionopen => fixed
2017-03-24 14:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/4b3fce984919dd9dfb4b620a1eac2120c1ee0c75 [^]
2017-03-24 14:14hgbotCheckin
2017-03-24 14:14hgbotNote Added: 0095559
2017-03-24 14:17aferrazReview Assigned To => aferraz
2017-03-24 14:17aferrazNote Added: 0095560
2017-03-24 14:17aferrazStatusresolved => closed
2017-03-30 11:42AtulOpenbravoRelationship addedrelated to 0035647
2018-12-17 13:51ngarciaRelationship addedrelated to 0039820

Notes
(0095435)
dmitry_mezentsev   
2017-03-20 18:25   
Ping.
1 month without any progress.
Thanks.
(0095464)
aferraz   
2017-03-21 12:22   
Proposed solution: Get the stock only from the sales order header warehouse.
(0095558)
hgbot   
2017-03-24 14:14   
Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: 4b3fce984919dd9dfb4b620a1eac2120c1ee0c75
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Mar 23 23:51:18 2017 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/4b3fce984919dd9dfb4b620a1eac2120c1ee0c75 [^]

Fixes issue 35281: Get stock only from order warehouse when creating a picking

Set warehouse to created reservation from order line before calling to M_Reservation_Post.
M_Reservation_Post process will call to M_Rerserve_Stock_Auto, which will reserve stock in every on hand warehouse of reservation organization (order organization) in case reservation warehouse is null.

---
M src/org/openbravo/warehouse/pickinglist/Utilities.java
---
(0095559)
hgbot   
2017-03-24 14:14   
Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: 58ef2ce5bc4e3cb62bd780b3fb151a7da6324819
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Mar 24 14:12:52 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/58ef2ce5bc4e3cb62bd780b3fb151a7da6324819 [^]

Related to issue 35281: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0095560)
aferraz   
2017-03-24 14:17   
Code review + Testing OK