Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006912
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersminoralways2009-01-15 14:032009-05-22 16:39
ReporternetworkbView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision2e1e60273c9a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionIf 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 ReproduceThe 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).
Tagscomsup_sprint4
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0006941 closedgorkaion It is not possible to deactivate a product which has an ordered quantity of zero. 
depends on backport 0009119 closedgorkaion It is not possible to deactivate a product which has an ordered quantity of zero 
has duplicate defect 0006910 closedgorkaion Shadow reservations for products after re-activating the sales order 

-  Notes
(0012381)
svnbot (reporter)
2009-01-20 11:15

Repository: openbravo
Revision: 12052
Author: gorkaion
Date: 2009-01-20 11:15:11 +0100 (Tue, 20 Jan 2009)

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

---
U trunk/src-db/database/model/functions/C_ORDER_POST1.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12052&sc=1 [^]
(0012871)
networkb (developer)
2009-01-30 10:46

Gorkaion,

It happens the same in Purchase orders. It should be fixed as well
(0016590)
hgbot (developer)
2009-05-22 16:39

Repository: erp/stable/2.3x
Changeset: 2e1e60273c9a03bcbd4d1adb1656886056ff67f5
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri May 22 16:39:08 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.3x/rev/2e1e60273c9a03bcbd4d1adb1656886056ff67f5 [^]

Fixed bug 9119.Applied patch of issue 6912.

---
M database/model/functions/C_ORDER_POST1.xml
---

- Issue History
Date Modified Username Field Change
2009-01-15 14:03 networkb New Issue
2009-01-15 14:03 networkb Assigned To => rafaroda
2009-01-15 14:03 networkb sf_bug_id 0 => 2509846
2009-01-15 14:03 networkb Regression testing => No
2009-01-15 17:51 networkb version => 2.40
2009-01-16 11:14 rafaroda Status new => scheduled
2009-01-16 11:14 rafaroda Assigned To rafaroda => gorkaion
2009-01-16 11:14 rafaroda fix_in_branch => trunk
2009-01-20 10:46 rafaroda Relationship added related to 0006910
2009-01-20 11:15 svnbot Checkin
2009-01-20 11:15 svnbot Note Added: 0012381
2009-01-20 11:15 svnbot Status scheduled => resolved
2009-01-20 11:15 svnbot Resolution open => fixed
2009-01-20 11:15 svnbot svn_revision => 12052
2009-01-20 11:27 gorkaion Relationship replaced has duplicate 0006910
2009-01-23 11:33 gorkaion Tag Attached: comsup_sprint4
2009-01-30 10:46 networkb Note Added: 0012871
2009-02-06 01:17 gorkaion Tag Attached: comsup_sprint5
2009-02-06 01:18 gorkaion Tag Detached: comsup_sprint5
2009-04-21 12:39 psarobe Status resolved => closed
2009-05-21 10:56 rafaroda Relationship added related to 0009119
2009-05-21 10:57 rafaroda Relationship replaced depends on 0009119
2009-05-22 16:39 hgbot Checkin
2009-05-22 16:39 hgbot Note Added: 0016590
2009-05-22 16:39 hgbot Fixed in SCM revision 12052 => http://code.openbravo.com/erp/stable/2.3x/rev/2e1e60273c9a03bcbd4d1adb1656886056ff67f5 [^]


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker