Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0023353Openbravo ERP04. Warehouse managementpublic2013-03-20 16:462013-05-02 19:03
VictorVillar 
Sandrahuguet 
urgentmajoralways
closedfixed 
5
pi 
3.0MP23 
Core
No
0023353: Not possible to create BOM production
If one product belongs to two BOM lists, and you have not got stock of this product, when the user launches the BOM production for 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 or next_product should be TRUE in this cases. 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"
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,

Go to Product window,
   Select Vino tinto 075L
   Check as Bill of Material
 Go to BOM tab,
    Assign: Limonade qty= 1
            Agua sin gas, qty = 1
Click in Verify BOM button

 Go to the header again
    Select Cerveza Ale 0.5 L
    Check as Bill of Material
 Go to BOM tab,
     Assign Cerveza Larger qty= 1
            Agua sin gas, qty = 1
Click in Verify BOM button

* Cerveza lager, agua sin gas and limonade should be stocked

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:15, Storage bin: RN - DEV-0-0
                        Vino Tino 0.75L, Qty: 15, 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"
No tags attached.
Issue History
2013-03-20 16:46VictorVillarNew Issue
2013-03-20 16:46VictorVillarAssigned To => dmiguelez
2013-03-20 16:46VictorVillarModules => Core
2013-03-20 16:46VictorVillarResolution time => 1364767200
2013-03-20 16:46VictorVillarTriggers an Emergency Pack => No
2013-03-20 16:46VictorVillarIssue Monitored: networkb
2013-03-20 20:39dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-04-02 18:51jonalegriaesarteTarget Version3.0MP22 => 3.0MP23
2013-04-25 10:43jonalegriaesarteAssigned Tojonalegriaesarte => dmiguelez
2013-04-29 17:10SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4632#r4632
2013-04-29 17:54SandrahuguetAssigned Todmiguelez => Sandrahuguet
2013-04-30 13:22SandrahuguetStatusnew => scheduled
2013-04-30 13:22Sandrahuguetfix_in_branch => pi
2013-04-30 18:08hgbotCheckin
2013-04-30 18:08hgbotNote Added: 0058355
2013-04-30 18:08hgbotStatusscheduled => resolved
2013-04-30 18:08hgbotResolutionopen => fixed
2013-04-30 18:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/803b4ef3b58441660f69552a9abe2bf0fd4821da [^]
2013-04-30 19:03dmiguelezNote Added: 0058360
2013-04-30 19:03dmiguelezStatusresolved => closed
2013-05-02 19:03hudsonbotCheckin
2013-05-02 19:03hudsonbotNote Added: 0058436

Notes
(0058355)
hgbot   
2013-04-30 18:08   
Repository: erp/devel/pi
Changeset: 803b4ef3b58441660f69552a9abe2bf0fd4821da
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Apr 30 15:13:16 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/803b4ef3b58441660f69552a9abe2bf0fd4821da [^]

Fixed bug 23353 Not possible to create BOM production

---
M src-db/database/model/functions/M_PRODUCTION_RUN.xml
---
(0058360)
dmiguelez   
2013-04-30 19:03   
Code Review + Testing Ok
(0058436)
hudsonbot   
2013-05-02 19:03   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b67b46460127 [^]

Maturity status: Test