0009119: It is not possible to deactivate a product which has an ordered quantity of zero

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009119

Openbravo ERP

Z. Others

public

2009-05-20 19:38

2009-06-01 07:18

Reporter

networkb

Assigned To

gorkaion

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

rPath Linux

Product Version

2.35MP10

Target Version

Fixed in Version

2.35MP13

Merge Request Status

Review Assigned To

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

0009119: It is not possible to deactivate a product which has an ordered quantity of zero

Description

If we have a product which is related to a certain sales
order or purchase order it is not possible to deactivate it.

When we change the ordered quantity field to zero in the lines of a sales order or purchase order, the QTYRESERVED column should be automatically updated to zero in order to update the M_STORAGE_PENDING table.

This is not done, so, it is not possible to DEACTIVATE this product.

Steps To Reproduce

The steps to reproduce this issue are:

*Sales Management or Procurement Managenet/Sales Order:
- Create a new SO/PO and in its' lines select a product and an Ordered Quantity, save and complete. You will see the new value in QTYRESERVED column of the M_STORAGE_PENDING table.
- Reactivate the order and in the lines change the Ordered Quantity to zero, save and complete. The QTYRESERVED column of the M_STORAGE_PENDING table must change to zero, it isn't changed. The previous value remain.

*Master Data Management/Product
- Try to deactivate the product, it is not possible (red message: cannot deactivate the product because it has inventory).

Proposed Solution

Additional Information