Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026054ModulesWarehouse Pickingpublic2014-03-21 08:202014-06-10 22:24
Reporterjecharri 
Assigned Torafaroda 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket27337
OBNetwork customerOBPS
Regression introduced in release
Summary0026054: Reservations are not deleted
DescriptionReservations are not deleted
Steps To Reproduce-Enable reservations --> http://wiki.openbravo.com/wiki/Stock_Reservation [^]
-Create a product
-Create a sales order with that product
-Choose "automatic" stock reservation
-Book it
-Try to create a picking list
You will get not enought stock error and this is fine

-Reactivate the order
-Change a product with stock
-Book it and try to create picking list
You will get not enought stock error and this is wrong

The problem is that the reservation is still related with not stocked product
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0027452 closed AtulOpenbravo Openbravo ERP Regression in 0026054: c_orderline_trg has invalid sql 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-03-21 08:20jecharriNew Issue
2014-03-21 08:20jecharriAssigned To => naiaramartinez
2014-03-21 08:20jecharriOBNetwork customer => Yes
2014-03-21 08:20jecharriResolution time => 1401314400
2014-03-21 08:20jecharriSupport ticket => 27337
2014-05-05 13:43jonalegriaesarteAssigned Tonaiaramartinez => pramakrishnan
2014-06-05 09:54rafarodaAssigned Topramakrishnan => rafaroda
2014-06-05 09:54rafarodaStatusnew => scheduled
2014-06-06 12:53rafarodaNote Added: 0067806
2014-06-10 08:22hgbotCheckin
2014-06-10 08:22hgbotNote Added: 0067833
2014-06-10 08:22hgbotStatusscheduled => resolved
2014-06-10 08:22hgbotResolutionopen => fixed
2014-06-10 08:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5596aec8b534a9690f16dea0323ff48567daf178 [^]
2014-06-10 08:29AtulOpenbravoNote Added: 0067835
2014-06-10 08:29AtulOpenbravoStatusresolved => closed
2014-06-10 22:24hudsonbotCheckin
2014-06-10 22:24hudsonbotNote Added: 0067891
2014-08-24 14:03shuehnerRelationship addedcauses 0027452

Notes
(0067806)
rafaroda   
2014-06-06 12:53   
Problem here is that you were allowed to change the product in order lines related to reservations in complete status, when you should not be allowed.

Steps to test:

1) Install Warehouse Picking and Enable Reservations http://wiki.openbravo.com/wiki/Projects:Warehouse_picking/User_Guide [^]

2) Create a sales order and a line with Stock Reservation = Automatic

3) Book this order and Generate Picking List

4) See that a reservation is created for this order line and product in Stock reservation window in status Completed

5) Go to the sales order and Reactivate it: you will be allowed to change the quantities of the sales order line but not the product. Error displays: The Order Line is related to a Reservation. It is not possible to change its Product.

If the Stock reservation is in Draft status, you will be allowed to change also the product of the order line: stock reservation product for this order line will be updated and reservations lines deleted.
(0067833)
hgbot   
2014-06-10 08:22   
Repository: erp/devel/pi
Changeset: 5596aec8b534a9690f16dea0323ff48567daf178
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Sat Jun 07 17:01:54 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5596aec8b534a9690f16dea0323ff48567daf178 [^]

Fixes issue 26054 Not allowing to change product of order lines related to completed reservations

---
M src-db/database/model/triggers/C_ORDERLINE_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0067835)
AtulOpenbravo   
2014-06-10 08:29   
Verified
(0067891)
hudsonbot   
2014-06-10 22:24   
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/763f16c2ad2e [^]
Maturity status: Test