Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028052Openbravo ERP04. Warehouse managementpublic2014-11-03 11:212015-02-04 20:33
ReporterVictorVillar 
Assigned Toumartirena 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR15Q2Fixed in Version3.0PR15Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028052: Wrong error message processing a Goods Shipment if you have a partial reservation
DescriptionWrong error message processing a Goods Shipment if you have a partial reservation
Steps To ReproduceReservations are disabled by default. To be able to use them please insert a new Preference using property Enable Stock Reservations with value Y.
http://wiki.openbravo.com/wiki/Stock_Reservation [^] [^]

As group Admin role,
Go to Client window and verify that negative stock is not allowed.

Go to Physical inventory and remove the stock for Cerveza Lager. Keep 700 units in Warehouse España Región Norte 0-0-0
Go to Sales Order window,
  Org: España
Lines:
 Cerveza Lager: qty: 900
 Stock Reservation: blank
Book it.
Once you select the line, you will see Manage Reservations button. Click on it, and indicate you would like to reserve 400 units. Click on Done.

Check that there is not any reservation for this product.

Go to Stock reservation window.
Realise that the register created indicates 700 units, but the user said 400. That is wrong. This is other issue: https://issues.openbravo.com/view.php?id=28051 [^]

If you manage Stock again from the Stock Reservation window, and you indicate 400, now the register has the correct qty.

Then navigate to Goods Shipment window
Create a new one for Org: España same business partner as the sales order.
Create Lines from the sales order and select the line.
The qty of the sales order is populated: 900

Try to process it.

Error:
Cannot reallocate all the required quantity of Product: ES/0002, Attribute Set Instance: -, UOM: Ud and Storage Bin: RN-2-0-0

That is wrong, it should inform that there is not enough stock.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 00280513.0PR15Q2 closed umartirena Reserved quantity is not correct under certain circumstancies 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-11-03 11:21VictorVillarNew Issue
2014-11-03 11:21VictorVillarAssigned To => dmiguelez
2014-11-03 11:21VictorVillarModules => Core
2014-11-03 11:21VictorVillarResolution time => 1417647600
2014-11-03 11:21VictorVillarTriggers an Emergency Pack => No
2014-11-03 11:21VictorVillarIssue Monitored: networkb
2014-11-03 11:22VictorVillarRelationship addedrelated to 0028051
2014-12-22 17:27SandrahuguetTarget Version3.0PR15Q1 => 3.0PR15Q2
2014-12-26 15:07reinaldoguerraAssigned Todmiguelez => reinaldoguerra
2014-12-26 15:07reinaldoguerraStatusnew => scheduled
2014-12-30 16:57reinaldoguerraNote Added: 0072883
2015-01-02 13:06umartirenaReview Assigned To => Sandrahuguet
2015-01-02 15:46hgbotCheckin
2015-01-02 15:46hgbotNote Added: 0073298
2015-01-02 15:46hgbotStatusscheduled => resolved
2015-01-02 15:46hgbotResolutionopen => fixed
2015-01-02 15:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e96a15e0c289c9c1c8e96e332a9e1d9342618b0a [^]
2015-01-05 16:08SandrahuguetAssigned Toreinaldoguerra => umartirena
2015-01-07 12:13SandrahuguetNote Added: 0073328
2015-01-07 12:13SandrahuguetStatusresolved => closed
2015-01-07 12:13SandrahuguetFixed in Version => 3.0PR15Q2
2015-02-04 20:33hudsonbotCheckin
2015-02-04 20:33hudsonbotNote Added: 0074100

Notes
(0072883)
reinaldoguerra   
2014-12-30 16:57   
Test plan used:
1- Login into Openbravo ERP
2- Go to Preference window and and check that a new preference with property "Enable Stock Reservations" is created, if not then create a new record selecting Enable Stock Reservations property and setting Y as value.
3- Go to Product window and create a new one, organization España S.A
4- Go to price tab and and prices for Tarifa bebidas alegres and Tarifa de ventas price list versions
5- Go to Physical inventory window and register a new header for España Región Norte organization
6- Go to lines tab and add the created product. Select Rn-0-0-0 as Storage Bin and enter 700 as Quantity Count
7- Go to Sales Order window, create a new header also for for España Región Norte organization
8- Add a new line with created product, qtty 900 and Stock Reservation: blank
9- Book it.
10- Once you select the line, you will see Manage Reservations button. Click on it, and indicate you would like to reserve 400 units. Click on Done.
11- Go to Stock reservation window.
12- Realise that the register created now indicates 400 units (Solved issue 28051)
13- Navigate to Goods Shipment window
14- Create a new one for Org: España, same business partner as the sales order created previously.
15- Create Lines from the sales order and select the line.
16- The qty of the sales order is populated: 900
17- Try to complete the shipment.
18- A "there is not enough stock" instead of a "cannot reallocate" error is shown now.
(0073298)
hgbot   
2015-01-02 15:46   
Repository: erp/devel/pi
Changeset: e96a15e0c289c9c1c8e96e332a9e1d9342618b0a
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Fri Jan 02 13:01:06 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e96a15e0c289c9c1c8e96e332a9e1d9342618b0a [^]

Fixed bug 28052: Wrong message processing a Shipment with a partial reservation.

Reallocation function executed when trying to complete a Goods Shipment, was changed to launch a not enough stock error if the quantity pending to release exceeds the available existent in the line's storage bin.

---
M src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml
---
(0073328)
Sandrahuguet   
2015-01-07 12:13   
Code review + testing OK
(0074100)
hudsonbot   
2015-02-04 20:33   
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/f36c91d0ad63 [^]
Maturity status: Test