Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005888Openbravo ERP04. Warehouse managementpublic2008-11-09 19:552009-03-03 17:16
Reporterzaccoz 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpensuse 10.3
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005888: Function BOM_QTY_ONHAND. Leaf mode error.
DescriptionThe function bom_qty_onhand not allowed to return the amount of stock stored in a BOM with more than one level, because it breaks it's recursion.

original post in spanish: https://sourceforge.net/forum/forum.php?thread_id=2496505&forum_id=827795 [^]
Steps To Reproducecreate a NOT stocked BOM product and put as item another NOT stocked BOM product, with have almost one item with stock, the stock in product selector of high level BOM is always cero.
Proposed SolutionThis restores the recursion:

Original line:
IF (CUR_BOM.ProductType = 'I' AND CUR_BOM.ProductType = 'I') THEN
 
Proposal:
IF (CUR_BOM.ProductType = 'I' AND CUR_BOM.IsBOM = 'N') THEN
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0005875 closed gorkaion Function BOM_QTY_ONHAND. Leaf mode error. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-09 19:55psarobeNew Issue
2008-11-09 19:55psarobeAssigned To => rafaroda
2008-11-09 19:55psarobeStatusnew => scheduled
2008-11-10 15:34rafarodaAssigned Torafaroda => gorkaion
2008-11-28 17:02svnbotCheckin
2008-11-28 17:02svnbotNote Added: 0010819
2008-11-28 17:02svnbotStatusscheduled => resolved
2008-11-28 17:02svnbotResolutionopen => fixed
2008-11-28 17:02svnbotsvn_revision => 10745
2008-12-02 13:06svnbotCheckin
2008-12-02 13:06svnbotNote Added: 0010884
2008-12-02 13:06svnbotsvn_revision10745 => 10848
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0010819)
svnbot   
2008-11-28 17:02   
Repository: openbravo
Revision: 10745
Author: gorkaion
Date: 2008-11-28 17:02:17 +0100 (Fri, 28 Nov 2008)

Fixed bug 5888. Modified if clause to properly manage recursivity on BOM_QTY_ONHAND function.

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

https://dev.openbravo.com/websvn/openbravo/?rev=10745&sc=1 [^]
(0010884)
svnbot   
2008-12-02 13:06   
Repository: openbravo
Revision: 10848
Author: villind
Date: 2008-12-02 13:06:23 +0100 (Tue, 02 Dec 2008)

Merged r10745. Fixed bug 5888. Modified if clause to properly manage recursivity on BOM_QTY_ONHAND function.

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
U branches/bonware/r2.40/src-db/database/model/functions/BOM_QTY_ONHAND.xml
_U branches/bonware/r2.40/update.database.launch
---

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