Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027680Openbravo ERP07. Sales managementpublic2014-09-25 10:462014-12-22 19:07
Reporterjonalegriaesarte 
Assigned Tofsoto82 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket31290
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027680: Error not human readable when removing a sales order line with a reservation assigned
DescriptionError not human readable when removing a sales order line with a reservation assigned
Steps To Reproduce- Activate stock reservation: http://wiki.openbravo.com/wiki/Stock_Reservation [^]
- Create sales order
- Create a sales order line, with automatic reservation
- book it
- Reactivate it
- Try to delete de line:

Error
Document already Processed. Where: SQL statement "DELETE FROM m_reservation WHERE m_reservation_id = v_reservation_id" PL/pgSQL function "c_orderline_trg" line 92 at SQL statement

Proposed SolutionApart from the message that needs to be improved, the best soultion would be to be able to remove the sales order line without removing the reservation first
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0026511 closed umartirena Impossible to delete a order line after removing the picking list and reservation 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-09-25 10:46jonalegriaesarteNew Issue
2014-09-25 10:46jonalegriaesarteAssigned To => dmiguelez
2014-09-25 10:46jonalegriaesarteOBNetwork customer => Yes
2014-09-25 10:46jonalegriaesarteModules => Core
2014-09-25 10:46jonalegriaesarteSupport ticket => 31290
2014-09-25 10:46jonalegriaesarteResolution time => 1417906800
2014-09-25 10:46jonalegriaesarteTriggers an Emergency Pack => No
2014-10-31 13:09dmitry_mezentsevAssigned Todmiguelez => Sandrahuguet
2014-11-21 23:31fsoto82Statusnew => scheduled
2014-11-21 23:31fsoto82Assigned ToSandrahuguet => fsoto82
2014-11-21 23:31fsoto82fix_in_branch => pi
2014-11-21 23:36fsoto82Note Added: 0071899
2014-11-26 15:08fsoto82Relationship addedrelated to 0026511
2014-12-22 19:06umartirenaReview Assigned To => umartirena
2014-12-22 19:06umartirenaNote Added: 0072778
2014-12-22 19:06umartirenaStatusscheduled => closed
2014-12-22 19:06umartirenaResolutionopen => duplicate
2014-12-22 19:07umartirenaRelationship replacedduplicate of 0026511

Notes
(0071899)
fsoto82   
2014-11-21 23:36   
- Activate stock reservation
- Create sales order
- Create a sales order line, with automatic reservation
- book it
- Reactivate it
- Try to delete de line

Now an error is displayed if the line have a reservation assigned.
(0072778)
umartirena   
2014-12-22 19:06   
Issue duplicate of https://issues.openbravo.com/view.php?id=26511 [^]