0032408: Reservation header associated to a sales order line should be removed when the line is deleted

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0032408

Openbravo ERP

04. Warehouse management

public

2016-03-04 13:34

2017-12-26 09:27

Reporter

ngarcia

Assigned To

collazoandy4

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

vmromanos

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0032408: Reservation header associated to a sales order line should be removed when the line is deleted

Description

Reservation header associated to a sales order line should be removed when the line is deleted

Steps To Reproduce

As group admin role:
   Set the Enable Stock Reservations preference
   Log out and log in
   Create a sales order for a product with stock
   Click on Manage Reservation and select a line
   Go to Stock Reservation window and check a header and a line have been created
   Go to the Sales Order again
   Click on Manage Reservation and undo the selection
   Go to Stock Reservation window and check the header still remains but without line:
      Reserved Qty: 0
      Released Qty: 0
      Status: Draft
   Reactivate the order
   Try to delete the line and check the following error is raised:
      You cannot delete the sales order line because it has a related Reservation. Delete the Reservation first. See Linked Items.

Proposed Solution

The reservation header could be deleted when the sales order line is deleted. the foreign key constraint m_reservation_orderline could be ON DELETE CASCADE

Additional Information