Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040323Openbravo ERP04. Warehouse managementpublic2019-02-27 12:512019-03-06 16:34
Reporterfrancisco 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR18Q4.3Fixed in Version3.0PR18Q4.3 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2017-03-22
Regression introduced in release3.0PR17Q2
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/f840f08b67ec [^]
Triggers an Emergency PackNo
Summary0040323: Manage pre-reservation not possible
DescriptionWhen its done a pre-reservation, once it's done is not possible to manage.
It's not possible modify or eliminate.
Steps To Reproduce* In preference activate Enable Stock Reservation
* Create a purchase order Ex: Cerveza Ale 0.5L Qty:10
* Create a Sales order Ex: Cerveza Ale 0.5L QTY:5
* Go to the sales Order and click on manage reservation and modify some of the orders we have, the sale or the purchase
* Go again to manage reservation and it does not appear the purchase order
* Same is happening if you go to the Stock reservation window and click on the line, the purchase is not there so it is not possible modify or to eliminate the order
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0040284 closed AtulOpenbravo Manage pre-reservation not possible 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-03-05 16:11AtulOpenbravoTypedefect => backport
2019-03-05 16:11AtulOpenbravoTarget Version => 3.0PR18Q4.3
2019-03-06 07:04AtulOpenbravoNote Added: 0110245
2019-03-06 16:13hgbotCheckin
2019-03-06 16:13hgbotNote Added: 0110260
2019-03-06 16:13hgbotStatusscheduled => resolved
2019-03-06 16:13hgbotResolutionopen => fixed
2019-03-06 16:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR18Q4.3/rev/038c8b681054b2e1e7902fd9fe21287eccf0e337 [^]
2019-03-06 16:34SandrahuguetReview Assigned To => Sandrahuguet
2019-03-06 16:34SandrahuguetNote Added: 0110263
2019-03-06 16:34SandrahuguetStatusresolved => closed
2019-03-06 16:34SandrahuguetFixed in Version => 3.0PR18Q4.3

Notes
(0110245)
AtulOpenbravo   
2019-03-06 07:04   
Test Plan
- In preference add Enable Stock Reservation = Yes for F&B International Group client and * organization.
- Create a purchase order Ex: Cerveza Ale 0.5L Qty:10
- Create a Sales order Ex: Cerveza Ale 0.5L QTY:5
- Go to the sales Order and click on manage reservation and add previous purchase order line prereservation
- Go again to manage reservation and check stock reservation related to previous the purchase order line appears.
- Navigate to the Stock reservation window and click on the record with above sales order line, the purchase order line is shown in Stock tab.
(0110260)
hgbot   
2019-03-06 16:13   
Repository: erp/backports/3.0PR18Q4.3
Changeset: 038c8b681054b2e1e7902fd9fe21287eccf0e337
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Mar 05 19:04:20 2019 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR18Q4.3/rev/038c8b681054b2e1e7902fd9fe21287eccf0e337 [^]

Fixes Issue 0040323: Manage pre-reservation not possible

** Do not use strict join on storage bin in query used to
get selected lines to avoid skipping of reservation stock
(pre-reservation) as they do not have storage bins, hence
used left join in place.

---
M src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
---
(0110263)
Sandrahuguet   
2019-03-06 16:34   
code review + testing ok