Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021301 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | major | always | 2012-08-03 10:27 | 2012-08-06 12:34 | |||
| Reporter | VictorVillar | View Status | public | |||||
| Assigned To | jecharri | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 2e8e573599ec | ||||
| Projection | none | ETA | none | Target Version | 3.0MP15 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP13 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0051105) hgbot (developer) 2012-08-06 09:00 |
Repository: erp/devel/pi Changeset: 2e8e573599ece5ee92498e60918574af0e113203 Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Mon Aug 06 08:59:46 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/2e8e573599ece5ee92498e60918574af0e113203 [^] Fixes issue 21301: It is not possible to create a BOM production in some circunstancies --- M src-db/database/model/functions/M_PRODUCTION_RUN.xml --- |
|
(0051108) hgbot (developer) 2012-08-06 11:43 |
Repository: erp/devel/pi Changeset: 457e8fcdfe227cd3bc8c8981bda5f7338996abc9 Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Mon Aug 06 11:42:59 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/457e8fcdfe227cd3bc8c8981bda5f7338996abc9 [^] issue 21301: It is not possible to create a BOM production in some circunstancies --- M src-db/database/model/functions/M_PRODUCTION_RUN.xml --- |
|
(0051112) VictorVillar (developer) 2012-08-06 12:34 |
Verified |
|
Notes |
|
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 | View Revisions |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |