Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005875 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | minor | always | 2008-11-07 13:12 | 2009-04-21 11:06 | |||
| Reporter | zaccoz | View Status | public | |||||
| Assigned To | gorkaion | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 10747 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.5.11 | |||
| OS Version | Opensuse 10.3 | Database version | 8.2.6 | Ant version | 1.7 | |||
| Product Version | 2.40 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005875: Function BOM_QTY_ONHAND. Leaf mode error. | |||||||
| Description | The 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 Reproduce | create 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 Solution | This 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Función bom_qty_onhand.sql [^] (5,101 bytes) 2008-11-07 13:12 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0010098) psarobe (viewer) 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 (viewer) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-11-07 13:12 | zaccoz | New Issue | |
| 2008-11-07 13:12 | zaccoz | Assigned To | => rafaroda |
| 2008-11-07 13:12 | zaccoz | sf_bug_id | 0 => 2234029 |
| 2008-11-07 13:12 | zaccoz | File Added: Función bom_qty_onhand.sql | |
| 2008-11-09 19:55 | psarobe | Status | new => scheduled |
| 2008-11-09 19:55 | psarobe | Note Added: 0010098 | |
| 2008-11-09 19:55 | psarobe | fix_in_branch | => trunk |
| 2008-11-10 15:33 | rafaroda | Assigned To | rafaroda => gorkaion |
| 2008-11-28 17:03 | svnbot | Checkin | |
| 2008-11-28 17:03 | svnbot | Note Added: 0010821 | |
| 2008-11-28 17:03 | svnbot | Status | scheduled => resolved |
| 2008-11-28 17:03 | svnbot | Resolution | open => fixed |
| 2008-11-28 17:03 | svnbot | svn_revision | => 10747 |
| 2009-04-21 11:06 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |