Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0021301 | Openbravo ERP | 04. Warehouse management | public | 2012-08-03 10:27 | 2012-08-06 12:34 |
| Reporter | VictorVillar | ||||
| Assigned To | jecharri | ||||
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | 3.0MP13 | ||||
| Target Version | 3.0MP15 | Fixed in Version | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0021301: It is not possible to create a BOM production in some circunstancies | ||||
| Description | It is not possible to create a BOM production in some circunstancies. If one product belongs to two BOM lists, and you have the product only in one storage bin, when the user launches the BOM production for the both BOM products, the function m_production_run function works wrong, Please check the m_production_run function between lines 286 and 361. It should be necessary to assign False to CUR_STOCK_ISOPEN in the second loop (line 359) when not found more registers after statement FETCH the CUR_STOCK in the second loop. Now if the user tries to create the production plan an error is showed: " Error: null value in column "m_locator_id" violates not-null constraint" | ||||
| Steps To Reproduce | Display all the fields/tabs/windows related with BOM production (check http://wiki.openbravo.com/wiki/ERP_2.50:How-to_BOM_Production#BOM_Product [^]) As Group admin role, Go to Physical inventory window, Remove all the stock for Agua sin gas 1L product for all the warehouses and storage bins, except for one storage bin, for instance RN DEV-0-0, Quatity: 5 Go to Product window, Select Vino tinto 075L Check as Bill of Material Go to BOM tab, Assign Agua sin gas 1L and other product Go to the header again Select Cerveza Ale 0.5 L Go to BOM tab, Assign Agua sin gas 1L and other product Click in Verify BOM button Go to Bill of materials Production window Create a new register name: test Go to Production plan tab: add two regiters : Cerveza Ale 0.5L, Qty:50, Storage bin: RN - DEV-0-0 Vino Tino 0.75L, Qty: 20, Storage bin: RN - DEV-0-0 Click in Create/Process production button Do not check the "Product quantity must be on stock" Click Ok. An error appears: "Error: null value in column "m_locator_id" violates not-null constraint" | ||||
| Proposed Solution | It should be necessary to assign False to CUR_STOCK_ISOPEN in the second loop (line 359) when not found more registers after statement FETCH the CUR_STOCK in the second loop. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2012-08-03 10:27 | VictorVillar | New Issue | |||
| 2012-08-03 10:27 | VictorVillar | Assigned To | => mirurita | ||
| 2012-08-03 10:27 | VictorVillar | Modules | => Core | ||
| 2012-08-03 10:27 | VictorVillar | Resolution time | => 1378418400 | ||
| 2012-08-03 10:27 | VictorVillar | Target Version | 3.0MP14 => 3.0MP15 | ||
| 2012-08-03 10:27 | VictorVillar | Issue Monitored: networkb | |||
| 2012-08-03 10:34 | VictorVillar | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=3698#r3698 | ||
| 2012-08-03 10:43 | VictorVillar | Assigned To | mirurita => jonalegriaesarte | ||
| 2012-08-03 10:48 | jonalegriaesarte | Assigned To | jonalegriaesarte => jecharri | ||
| 2012-08-06 09:00 | hgbot | Checkin | |||
| 2012-08-06 09:00 | hgbot | Note Added: 0051105 | |||
| 2012-08-06 09:00 | hgbot | Status | new => resolved | ||
| 2012-08-06 09:00 | hgbot | Resolution | open => fixed | ||
| 2012-08-06 09:00 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/2e8e573599ece5ee92498e60918574af0e113203 [^] | ||
| 2012-08-06 11:43 | hgbot | Checkin | |||
| 2012-08-06 11:43 | hgbot | Note Added: 0051108 | |||
| 2012-08-06 12:34 | VictorVillar | Note Added: 0051112 | |||
| 2012-08-06 12:34 | VictorVillar | Status | resolved => closed | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||