Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005875Openbravo ERP04. Warehouse managementpublic2008-11-07 13:122009-04-21 11:06
Reporterzaccoz 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpensuse 10.3
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005875: 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
depends on backport 0005888 closed gorkaion Function BOM_QTY_ONHAND. Leaf mode error. 
Attached Files? Función bom_qty_onhand.sql (5,101) 2008-11-07 13:12
https://issues.openbravo.com/file_download.php?file_id=400&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-11-07 13:12zaccozNew Issue
2008-11-07 13:12zaccozAssigned To => rafaroda
2008-11-07 13:12zaccozsf_bug_id0 => 2234029
2008-11-07 13:12zaccozFile Added: Función bom_qty_onhand.sql
2008-11-09 19:55psarobeStatusnew => scheduled
2008-11-09 19:55psarobeNote Added: 0010098
2008-11-09 19:55psarobefix_in_branch => trunk
2008-11-10 15:33rafarodaAssigned Torafaroda => gorkaion
2008-11-28 17:03svnbotCheckin
2008-11-28 17:03svnbotNote Added: 0010821
2008-11-28 17:03svnbotStatusscheduled => resolved
2008-11-28 17:03svnbotResolutionopen => fixed
2008-11-28 17:03svnbotsvn_revision => 10747
2009-04-21 11:06psarobeStatusresolved => closed

Notes
(0010098)
psarobe   
2008-11-09 19:55   
Reminder to engineers: Please write the steps and the issues to verify when the bug is fixed so QA team can check if the fixed is correct
(0010821)
svnbot   
2008-11-28 17:03   
Repository: openbravo
Revision: 10747
Author: gorkaion
Date: 2008-11-28 17:03:10 +0100 (Fri, 28 Nov 2008)

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

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

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