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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005888
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementminoralways2008-11-09 19:552009-03-03 17:16
ReporterzaccozView Statuspublic 
Assigned Togorkaion 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision10848
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.5.11
OS VersionOpensuse 10.3Database version8.2.6Ant version1.7
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

0005888: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0005875 closedgorkaion Function BOM_QTY_ONHAND. Leaf mode error. 

-  Notes
(0010819)
svnbot (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-11-09 19:55 psarobe New Issue
2008-11-09 19:55 psarobe Assigned To => rafaroda
2008-11-09 19:55 psarobe Status new => scheduled
2008-11-10 15:34 rafaroda Assigned To rafaroda => gorkaion
2008-11-28 17:02 svnbot Checkin
2008-11-28 17:02 svnbot Note Added: 0010819
2008-11-28 17:02 svnbot Status scheduled => resolved
2008-11-28 17:02 svnbot Resolution open => fixed
2008-11-28 17:02 svnbot svn_revision => 10745
2008-12-02 13:06 svnbot Checkin
2008-12-02 13:06 svnbot Note Added: 0010884
2008-12-02 13:06 svnbot svn_revision 10745 => 10848
2009-03-03 17:16 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker