Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024509Openbravo ERP04. Warehouse managementpublic2013-08-08 00:322013-10-16 19:46
Reporterumartirena 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP29Fixed in Version3.0MP29 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket23345
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024509: Reservation Consupmtion doesn't work on certain cases
DescriptionUsing Reservations, the consumption and release of the reservations doesn't work in certain cases. "Can not consume all the stock" error happens.
Steps To Reproduce0. Access "Preferences" window and enable "Enable Stock Reservations" preference
1. Create "productLot" with attribute set "Lot" and define sales price list for it
2. Register Physical Inventory:
  * 2 units for "productLot" and attribute LA
  * 4 units for "productLot" and attribute LB
Process inventory
3. Register Sales Order adding line of 4 unit of "productLot" and set "Stock Reservation"=Manual and process order
4. Press "Manage Reservation" button in sales order line and reserve 2 units of "productLot" attribute LA and 2 units of "productLot" attribute LB, both not allocated.
5. Register Sales Order adding line of 2 unit of "productLot" and set "Stock Reservation"=Manual and process order
6. Press "Manage Reservation" button in sales order line and reserve 2 units of "productLot" attribute LB, not allocated
7. Create Goods Shipment header for same BP and "Create Lines From" selecting the first order with line qty 4. Access Shipment line and open product selector to select "productLot" attribute LB. Try to process shipment an error "Cannot consume all the stock of Product: productLot, Attribute Set Instance: LB, UOM: X and Storage Bin: X" will be obtained

It should be able to process the shipment because there is available stock and the reservations are not allocated.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-08-08 00:32umartirenaNew Issue
2013-08-08 00:32umartirenaAssigned To => dmiguelez
2013-08-08 00:32umartirenaModules => Core
2013-08-08 00:32umartirenaOBNetwork customer => No
2013-08-08 00:32umartirenaTriggers an Emergency Pack => No
2013-09-11 18:30jonalegriaesarteOBNetwork customerNo => Yes
2013-09-11 18:30jonalegriaesarteSupport ticket => 23345
2013-09-11 18:30jonalegriaesarteTarget Version => 3.0MP28
2013-09-11 18:30jonalegriaesarteAssigned Todmiguelez => jecharri
2013-09-17 16:42umartirenaNote Added: 0061197
2013-09-30 16:31jonalegriaesarteNote Added: 0061489
2013-09-30 16:32jonalegriaesarteTarget Version3.0MP28 => 3.0MP29
2013-10-04 14:50hgbotCheckin
2013-10-04 14:50hgbotNote Added: 0061554
2013-10-04 14:50hgbotStatusnew => resolved
2013-10-04 14:50hgbotResolutionopen => fixed
2013-10-04 14:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4d91babc9e09d74179e0d0906bab9aa2c6491a9b [^]
2013-10-14 18:44umartirenaReview Assigned To => umartirena
2013-10-14 18:44umartirenaNote Added: 0061663
2013-10-14 18:44umartirenaStatusresolved => closed
2013-10-14 18:44umartirenaFixed in Version => 3.0MP29
2013-10-16 19:46hudsonbotCheckin
2013-10-16 19:46hudsonbotNote Added: 0061726

Notes
(0061197)
umartirena   
2013-09-17 16:42   
I've noticed that in F%B Sample data, the issue is not happening for F&B España - región Norte, but is happening for F&B US, inc.
(0061489)
jonalegriaesarte   
2013-09-30 16:31   
Moved to MP29 but we are working on it with maximum priority
(0061554)
hgbot   
2013-10-04 14:50   
Repository: erp/devel/pi
Changeset: 4d91babc9e09d74179e0d0906bab9aa2c6491a9b
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Fri Oct 04 14:50:09 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4d91babc9e09d74179e0d0906bab9aa2c6491a9b [^]

Fixes issue 24509: Reservation Consupmtion doesn't work on certain cases

---
M src-db/database/model/functions/M_RESERVATION_CONSUMPTION.xml
---
(0061663)
umartirena   
2013-10-14 18:44   
Issue verified
(0061726)
hudsonbot   
2013-10-16 19:46   
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/51315988909a [^]

Maturity status: Test