Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021264Openbravo ERP06. Material requirement planning (MRP)public2012-07-31 13:132012-08-09 13:07
ReporterVictorVillar 
Assigned Tojecharri 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP13 
Target Version3.0MP14Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket16195
Regression levelProduction - Confirmed Stable
Regression date2012-04-02
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/367f4c3538f72d90e2461a213f4795f3a9b5e72f [^]
Triggers an Emergency Packyes
Summary0021264: Module script DeleteInventoryLines is incomplete and the processes related
DescriptionModule script DeleteInventoryLines is incomplete because it is deleting m_storage_detail records but is not taking into account that these lines can be referenced in table m_stock_proposed.
Also the processes related to this attempt to erase the m_storage_detail registers with m_attributeset_id = 0
Steps To ReproduceAs group admin role,
Go to Attribute window,
   Org: España
   Name: Color
   List: YEs
   Mandatory: No
Go to Attribute Set window,
 Org: España
 Name: lote
 Require At Least One Value: NO

   Assigned Attribute tab
      Attribute: Color

Go to Planning method window,
   create new register
      Org: España
      name: taka
    Go to Lines tab: create:
       Pending Purchase Order
       Material requirement
       Sales Forecast
       Pending Sales Order
Go to Product window,
Create a new one with an attribute set: Lote
    name: test
  Go to Price tab:
     two new registers: for Tarifa de Ventas and Tarifas Bebidas Alegres
  Go to Purchasing plan:
     Business Partner: Bebidas Alegres
  Go to Manufacturing plan:
     Organization: España
     Storage bin: RN-0-0-0
     Planning method: taka
     Safety Stock: 20
Go to Goods Receipt window,
     create a new register
        Org: españa
      Lines tab:
         Product: test
         Qty: 10
Go to Purchasing plan window,
     Create a new register:
       Org: España
       name: propuesta
       Product: test
  Process Purchase Plan

Go to Goods Shipment window,
    Create new register
      Lines tab,
        Product: test
        qty: 10
Complete it

Go to Attribute window,
   select Color register
   List: YEs
   Mandatory: YEs
Go to Attribute Set window,
 select lote register
 Require At Least One Value: YES

Go to Goods Shipment window,
    Create new register
     Org: España
      Lines tab,
        Product: test
        qty: 10
Save it. try to select the Attribute.
This record cannot be deleted because it is associated with other existing elements. Please see Linked Items.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00211993.0MP14 closed jecharri Module script DeleteInventoryLines is incomplete 
related to defect 00201593.0MP11 closed jecharri Product with mandatory attribute should not generate lines without attribute in m_storage_detail 
related to defect 0021285 closed mirurita Creating Inventory count process in Physical Inventory does not create Lines 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-07-31 13:13VictorVillarNew Issue
2012-07-31 13:13VictorVillarAssigned To => jecharri
2012-07-31 13:13VictorVillarModules => Core
2012-07-31 13:13VictorVillarOBNetwork customer => Yes
2012-07-31 13:13VictorVillarSupport ticket => 16195
2012-07-31 13:13VictorVillarIssue Monitored: networkb
2012-07-31 13:26VictorVillarRegression level => Production - QA Approved
2012-07-31 13:28VictorVillarRelationship addedrelated to 0021199
2012-07-31 13:29VictorVillarRelationship addedrelated to 0020159
2012-07-31 13:35VictorVillarRegression levelProduction - QA Approved => Production - Confirmed Stable
2012-07-31 13:51eintelauIssue Monitored: eintelau
2012-08-01 10:55hgbotCheckin
2012-08-01 10:55hgbotNote Added: 0051048
2012-08-01 10:55hgbotStatusnew => resolved
2012-08-01 10:55hgbotResolutionopen => fixed
2012-08-01 10:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b0701ee555932c6795648df10054f3610dbba6cf [^]
2012-08-01 12:12hgbotCheckin
2012-08-01 12:12hgbotNote Added: 0051050
2012-08-01 12:23gorkaionNote Added: 0051051
2012-08-01 14:37VictorVillarNote Added: 0051067
2012-08-01 14:37VictorVillarStatusresolved => closed
2012-08-02 08:54jecharriStatusclosed => new
2012-08-02 08:54jecharriResolutionfixed => open
2012-08-02 08:54jecharriResolution time => 1343772000
2012-08-02 08:54jecharriRegression date => 2012-04-02
2012-08-02 08:54jecharriRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/367f4c3538f72d90e2461a213f4795f3a9b5e72f [^]
2012-08-02 08:54jecharriStatusnew => scheduled
2012-08-02 08:54jecharrifix_in_branch => pi
2012-08-02 08:54jecharriStatusscheduled => resolved
2012-08-02 08:54jecharriResolutionopen => fixed
2012-08-02 08:55jecharriStatusresolved => closed
2012-08-09 13:07hudsonbotCheckin
2012-08-09 13:07hudsonbotNote Added: 0051205
2012-08-09 13:07hudsonbotCheckin
2012-08-09 13:07hudsonbotNote Added: 0051207
2012-09-04 13:06shuehnerRelationship addedrelated to 0021285

Notes
(0051048)
hgbot   
2012-08-01 10:55   
Repository: erp/devel/pi
Changeset: b0701ee555932c6795648df10054f3610dbba6cf
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Aug 01 10:54:53 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b0701ee555932c6795648df10054f3610dbba6cf [^]

Fixes issue 21264: Module script DeleteInventoryLines is incomplete and the processes related

---
M src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml
M src-db/database/model/functions/M_UPDATE_INVENTORY.xml
M src-db/database/model/functions/M_UPDATE_STOCKAUX.xml
M src-util/modulescript/build/classes/org/openbravo/modulescript/DeleteInventoryLinesData.class
M src-util/modulescript/src/org/openbravo/modulescript/DeleteInventoryLines_data.xsql
---
(0051050)
hgbot   
2012-08-01 12:12   
Repository: erp/devel/pi
Changeset: dfffc79d08765b906d8618928f7d74c1b9ae79b1
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Aug 01 12:11:25 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/dfffc79d08765b906d8618928f7d74c1b9ae79b1 [^]

issue 21264: Module script DeleteInventoryLines is incomplete and the processes related

---
M src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml
---
(0051051)
gorkaion   
2012-08-01 12:23   
code review done
(0051067)
VictorVillar   
2012-08-01 14:37   
Verified steps to reproduce and done test cases related to it, as launch physical inventory
(0051205)
hudsonbot   
2012-08-09 13:07   
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/ef9a070edd19 [^]

Maturity status: Test
(0051207)
hudsonbot   
2012-08-09 13:07   
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/ef9a070edd19 [^]

Maturity status: Test