Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006941Openbravo ERPZ. Otherspublic2009-01-15 14:032009-01-25 22:41
networkb 
gorkaion 
immediateminoralways
closedfixed 
5
2.40 
2.40MP2 
Core
No
0006941: It is not possible to deactivate a product which has an ordered quantity of zero.
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.
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).
comsup_sprint4
blocks defect 0006912 closed gorkaion It is not possible to deactivate a product which has an ordered quantity of zero. 
Issue History
2009-01-16 11:14rafarodaTypedefect => backport
2009-01-16 11:14rafarodafix_in_branch => 2.40
2009-01-16 11:14rafarodaAssigned Torafaroda => gorkaion
2009-01-20 11:28svnbotCheckin
2009-01-20 11:28svnbotNote Added: 0012384
2009-01-20 11:28svnbotStatusscheduled => resolved
2009-01-20 11:28svnbotResolutionopen => fixed
2009-01-20 11:28svnbotsvn_revision => 12053
2009-01-23 11:33gorkaionTag Attached: comsup_sprint4
2009-01-25 22:41psarobeStatusresolved => closed

Notes
(0012384)
svnbot   
2009-01-20 11:28   
Repository: openbravo
Revision: 12053
Author: gorkaion
Date: 2009-01-20 11:28:51 +0100 (Tue, 20 Jan 2009)

Fixed bug 6941. Fixed the C_ORDER_POST1 procedure to properly manage the reserved quantity in the M_Storage_Pending table.

---
U branches/r2.40/src-db/database/model/functions/C_ORDER_POST1.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12053&sc=1 [^]