0031812: Cannot void a goods shipment if it has more than one closed reservation associated

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0031812

Openbravo ERP

04. Warehouse management

public

2015-12-30 13:28

2016-01-07 17:51

Reporter

ngarcia

Assigned To

aferraz

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0PR16Q1

Fixed in Version

Merge Request Status

Review Assigned To

dmiguelez

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Production - QA Approved

Regression date

2015-06-22

Regression introduced in release

3.0PR15Q4

Regression introduced by commit

https://code.openbravo.com/erp/devel/pi/rev/e03c1808e1952c20ef838c8a8b976cff802d5156 [^]

Triggers an Emergency Pack

Summary

0031812: Cannot void a goods shipment if it has more than one closed reservation associated

Description

Cannot void a goods shipment if it has more than one closed reservation associated

Steps To Reproduce

As group admin role:
   Set the Enable Stock Reservations preference to Y
   Log out and log in
   Create a Sales Order, add two products with stock to it and book it
   Select each lines and create a reservation for them (Manage Reservations)
   Go to Goods Shipment window, create a header and select the previously created sales order lines and complete it
   Check the two Stock Reservation status is updated to Closed
   Try to void the Goods Shipment and check the following error message is raised:
      Internal Error: Duplicate primary key/uuid. Your record has not been saved into the table Stock Reservation

Proposed Solution

In the M_INOUT_POST database function, more than one record is being inserted in the M_RESERVATION table with the same m_reservation_id (v_uuid)

Additional Information