Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032281ModulesWarehouse Pickingpublic2016-02-18 18:192016-06-17 19:37
ReporterVictorVillar 
Assigned Torqueralta 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket40714
OBNetwork customerOBPS
Regression introduced in release
Summary0032281: wrong movement quantity of the picking list without enough stock available
Descriptionwrong movement quantity of the picking list without enough stock available
Steps To ReproduceAs group admin role,
   Create a new product
      Add a sales price list
   Go to Physical Inventory window,
      add 2 units of this product
   Process it.
Go to Sales order and create a new line of this new product. Qty= 10
 Process it.
Add the manual reservation, qty = 2

Generate Picking List.
Go to Warehouse Picking List and realize that the movement qty is 4. It should not be possible because you have only 2 units available.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032469 closed collazoandy4 Not possible to create a partial "Outbound" Picking List if there is not a line that can be completely shipped 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-02-18 18:19VictorVillarNew Issue
2016-02-18 18:19VictorVillarAssigned To => Triage Finance
2016-02-18 18:19VictorVillarResolution time => 1458687600
2016-02-18 18:19VictorVillarSupport ticket => 40714
2016-02-18 18:19VictorVillarOBNetwork customer => Yes
2016-02-18 18:33heccamIssue Monitored: heccam
2016-02-25 18:48rqueraltaNote Added: 0084525
2016-02-25 18:50rqueraltaStatusnew => scheduled
2016-02-25 18:50rqueraltaAssigned ToTriage Finance => rqueralta
2016-03-11 14:10psanjuanNote Added: 0084914
2016-03-11 14:48psanjuanNote Edited: 0084525bug_revision_view_page.php?bugnote_id=0084525#r11416
2016-03-11 14:52psanjuanNote Added: 0084916
2016-03-11 15:02psanjuanNote Edited: 0084916bug_revision_view_page.php?bugnote_id=0084916#r11418
2016-03-14 13:44psanjuanNote Edited: 0084916bug_revision_view_page.php?bugnote_id=0084916#r11421
2016-03-14 13:51psanjuanNote Edited: 0084916bug_revision_view_page.php?bugnote_id=0084916#r11422
2016-03-14 14:07psanjuanNote Edited: 0084916bug_revision_view_page.php?bugnote_id=0084916#r11423
2016-03-14 14:08psanjuanNote Added: 0084950
2016-03-14 14:17psanjuanNote Edited: 0084916bug_revision_view_page.php?bugnote_id=0084916#r11424
2016-03-14 14:24psanjuanNote Edited: 0084916bug_revision_view_page.php?bugnote_id=0084916#r11425
2016-03-14 14:24psanjuanRelationship addedrelated to 0032469
2016-04-05 10:03hgbotCheckin
2016-04-05 10:03hgbotNote Added: 0085428
2016-04-05 10:03hgbotStatusscheduled => resolved
2016-04-05 10:03hgbotResolutionopen => fixed
2016-04-05 10:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fc9de8940c8e0ac2cd5a7124f9532de8acc9c3fb [^]
2016-04-05 10:03hgbotCheckin
2016-04-05 10:03hgbotNote Added: 0085429
2016-04-05 10:41aferrazReview Assigned To => aferraz
2016-04-05 10:41aferrazNote Added: 0085432
2016-04-05 10:41aferrazStatusresolved => closed
2016-04-21 17:38ngarciaIssue Monitored: ngarcia
2016-04-21 19:28hgbotCheckin
2016-04-21 19:28hgbotNote Added: 0085852
2016-04-21 19:35aferrazStatusclosed => new
2016-04-21 19:35aferrazResolutionfixed => open
2016-04-21 19:35aferrazStatusnew => scheduled
2016-04-22 09:39hgbotCheckin
2016-04-22 09:39hgbotNote Added: 0085874
2016-04-22 09:40aferrazStatusscheduled => resolved
2016-04-22 09:40aferrazResolutionopen => fixed
2016-04-22 09:40aferrazNote Added: 0085875
2016-04-22 09:40aferrazStatusresolved => closed
2016-06-17 19:36hudsonbotCheckin
2016-06-17 19:36hudsonbotNote Added: 0087418
2016-06-17 19:36hudsonbotCheckin
2016-06-17 19:36hudsonbotNote Added: 0087419
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087481
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087483

Notes
(0084525)
rqueralta   
2016-02-25 18:48   
(edited on: 2016-03-11 14:48)
Test Plan

As F&B Internationa Group Admin
  
  Go to Product window
    Create a new product
    Add a sales price list
  
  Go to Physical Inventory window
    Add 2 units of this product
    Process it.

  Go to Sales Order window
    Create a new Sales Order
    Add line of this new product. Qty = 10
    Book it.
  
  Go to Sales order || Reserved Stock tab
    Add the Manage Reservation. Qty = 2

  Go to Sales Order window main tab
    Generate Picking List
    
  Go to Warehouse Picking List
    Realize that the movement qty is 2
(0084914)
psanjuan   
2016-03-11 14:10   
Issue verified.
(0084916)
psanjuan   
2016-03-11 14:52   
(edited on: 2016-03-14 14:24)
Scenario 1

As F&B International Group Admin
  
  Go to Product window
    Create a new product (ie. Product 32281 Test 1)
    Add a sales price list (Tarifa Ventas)
    Add a purchase price list (Tarifa Bebidas Alegres)
  
  Go to Good Receipts window
    Receipt 2 units of this product, from vendor Bebidas Alegres
    WH = España Region Norte, RN-1-0-0
    Complete it.

  Go to Sales Order window
    Create a new Sales Order for BP = Alimentos y Supermercados
    Add line of this new product. Qty = 10
    Book it.
  
  Go to Lines, select the product line and click on Manage Reservation.
  Click Done
 
  Go to Reserved Stock tab and check there is a stock reservation for Qty =2

  Go to Sales Order window main tab
    Generate Picking List
    Choose "Direct Picking List to Customer"
    Not group criteria. Press OK.

  Check that a message is shown which is OK.
  "PL302 there is not enough stock in WH to create the whole picking list".
    
  Go to Warehouse Picking List
     Check that a new one has been created in Draft status for a movement qty=2
     Process it
     Check that a goods shipment for 2 units has been created.

Scenario 2

As F&B International Group Admin
  
  Go to Product window
    Create a new product (ie. Product 32281 Test 2)
    Add a sales price list (Tarifa Ventas)
    Add a purchase price list (Tarifa Bebidas Alegres)
  
  Go to Good Receipts window
    Receipt 2 units of this product, from vendor Bebidas Alegres
    WH = España Region Norte, RN-1-0-0
    Complete it.

  Go to Sales Order window
    Create a new Sales Order for BP = Alimentos y Supermercados
    Add line of this new product. Qty = 10
    Book it.
  
  Go to Sales Order window main tab
    Generate Picking List
    Choose "Direct Picking List to Customer"
    Not group criteria. Press OK.

  Check that an allocated reserved stock has been automatically created.

  Check that a message is shown which is OK.
  "PL303 there is not enough stock in WH to create the whole picking list".
    
  Go to Warehouse Picking List
     Check that a new one has been created in Draft status for a movement qty=2
     Process it
     Check that a goods shipment for 2 units has been created.

Scenario 3

As F&B International Group Admin
  
  Go to Product window
    Create a new product (ie. Product 32281 Test 3)
    Add a sales price list (Tarifa Ventas)
    Add a purchase price list (Tarifa Bebidas Alegres)
  
  Go to Good Receipts window
    Receipt 2 units of this product, from vendor Bebidas Alegres
    WH = España Region Norte, RN-1-0-0
    Complete it.

  Go to Sales Order window
    Create a new Sales Order for BP = Alimentos y Supermercados
    Add line of this new product. Qty = 10
    Book it.
  
  Go to Lines, select the product line and click on Manage Reservation.
  Click Done
 
  Go to Reserved Stock tab and check there is a stock reservation for Qty =2

  Go to Sales Order window main tab
    Generate Picking List
    Choose "Outbound Picking List"
    España Region Norte: RN-DEV (Outbound bin)
    Press OK

  Check that a message is shown: There is not enough available stock.
  This is another issue. See issue related:32469
(0084950)
psanjuan   
2016-03-14 14:08   
Test Plan verified.

Issue can be code reviewed and closed.
(0085428)
hgbot   
2016-04-05 10:03   
Repository: erp/devel/pi
Changeset: fc9de8940c8e0ac2cd5a7124f9532de8acc9c3fb
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Thu Feb 25 09:46:02 2016 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/fc9de8940c8e0ac2cd5a7124f9532de8acc9c3fb [^]

Fixed issue 32281: Wrong movement quantity of the picking list without enough stock available

Now, movement quantity of the picking list if stock available is not enough is equal to stock avilable - manual reservation qty

---
M src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
---
(0085429)
hgbot   
2016-04-05 10:03   
Repository: erp/devel/pi
Changeset: a8bef035c93ced4b7065777533b7f1104e75a869
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Apr 04 18:22:09 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a8bef035c93ced4b7065777533b7f1104e75a869 [^]

Related to issue 32281: Add coalesce to avoid null value in v_reservationqty

---
M src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
---
(0085432)
aferraz   
2016-04-05 10:41   
Code review OK
(0085852)
hgbot   
2016-04-21 19:28   
Repository: erp/devel/pi
Changeset: f0f766d86fef89977e044d27c44394e82f36185c
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Apr 21 19:24:51 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f0f766d86fef89977e044d27c44394e82f36185c [^]

Related to issue 32281: Backout changeset a8bef035c93c and fc9de8940c8e

---
M src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
---
(0085874)
hgbot   
2016-04-22 09:39   
Repository: erp/devel/pi
Changeset: 1ab098a071150b2a52f21ebfd11de19abde33251
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Apr 22 09:38:01 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1ab098a071150b2a52f21ebfd11de19abde33251 [^]

Related to issue 32281: Wrong picking list quantity when no stock available

Send p_reservation_id as null when calling M_GET_STOCK_PARAM from M_RESERVE_STOCK_AUTO in order to check reserved quantity from any reservation.

---
M src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
---
(0085875)
aferraz   
2016-04-22 09:40   
Code review OK
(0087418)
hudsonbot   
2016-06-17 19:36   
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/0dc7be081b1c [^]
Maturity status: Test
(0087419)
hudsonbot   
2016-06-17 19:36   
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/0dc7be081b1c [^]
Maturity status: Test
(0087481)
hudsonbot   
2016-06-17 19:37   
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/0dc7be081b1c [^]
Maturity status: Test
(0087483)
hudsonbot   
2016-06-17 19:37   
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/0dc7be081b1c [^]
Maturity status: Test