Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026511Openbravo ERP04. Warehouse managementpublic2014-05-12 12:252014-12-30 23:28
Reporterjecharri 
Assigned Toumartirena 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket28478
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026511: Impossible to delete a order line after removing the picking list and reservation
DescriptionImpossible to delete a order line after removing the picking list and reservation
Steps To Reproduce-Create a sales order with a line
-mark the line as manual reservation
-Book it and create the picking list

Go to window stock reservation window:
-Select the reservation
-Press in "Put on Hold" and reactivate the reservation
-Delete the header
-Go to Picking list and cancel it

Go to order and reactivate it:
-you should be able to delete the line, but when you try it, you will receive error "Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1"

The problem is that when you cancel the picking list, this is creating a record in window stock reservation but without any reservation
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00276803.0PR15Q1 closed fsoto82 Error not human readable when removing a sales order line with a reservation assigned 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-05-12 12:25jecharriNew Issue
2014-05-12 12:25jecharriAssigned To => caristu
2014-05-12 12:25jecharriOBNetwork customer => Yes
2014-05-12 12:25jecharriResolution time => 1402696800
2014-05-12 12:25jecharriSupport ticket => 28478
2014-06-26 16:23jonalegriaesarteResolution time1402696800 => 1403906400
2014-11-26 15:08fsoto82Relationship addedrelated to 0027680
2014-12-22 19:07umartirenaRelationship replacedhas duplicate 0027680
2014-12-22 19:16hgbotCheckin
2014-12-22 19:16hgbotNote Added: 0072783
2014-12-22 19:16hgbotStatusnew => resolved
2014-12-22 19:16hgbotResolutionopen => fixed
2014-12-22 19:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/57da281af0de6af09bf2849f608cda4484d1964b [^]
2014-12-23 10:00umartirenaAssigned Tocaristu => Sandrahuguet
2014-12-23 10:57SandrahuguetAssigned ToSandrahuguet => umartirena
2014-12-29 15:22SandrahuguetReview Assigned To => Sandrahuguet
2014-12-29 16:36SandrahuguetProjectModules => Openbravo ERP
2014-12-29 16:37SandrahuguetModules => Core
2014-12-29 16:37SandrahuguetTriggers an Emergency Pack => No
2014-12-29 16:37SandrahuguetCategoryWarehouse Picking => 04. Warehouse management
2014-12-29 16:38SandrahuguetNote Added: 0072854
2014-12-29 16:38SandrahuguetStatusresolved => closed
2014-12-29 16:38SandrahuguetFixed in Version => 3.0PR15Q1
2014-12-30 23:28hudsonbotCheckin
2014-12-30 23:28hudsonbotNote Added: 0073259

Notes
(0072783)
hgbot   
2014-12-22 19:16   
Repository: erp/devel/pi
Changeset: 57da281af0de6af09bf2849f608cda4484d1964b
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon Dec 22 19:12:07 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/57da281af0de6af09bf2849f608cda4484d1964b [^]

Fixes Issue 26511: Display correct error message while deleting the orderline.

The problem on this issue is that the trigger is not able to delete the related reservation of the orderline and the given error is displayed. So in this case the error message displayed has been improved to warn the user that needs to remove the reservation manually before deleting the Sales Order Line.

---
M src-db/database/model/triggers/C_ORDERLINE_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0072854)
Sandrahuguet   
2014-12-29 16:38   
Code review + testing OK
(0073259)
hudsonbot   
2014-12-30 23:28   
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/6525fe229e06 [^]
Maturity status: Test