Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022906Openbravo ERP04. Warehouse managementpublic2013-01-28 10:272013-02-04 13:40
ReporterVictorVillar 
Assigned Tojecharri 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP20Fixed in Version 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket17264
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022906: Using a BOM product in sales management document is not possible to close the document
DescriptionUsing a BOM product in sales management document is not possible to close the document
Steps To ReproduceAs group admin role,
Go to product window,
  Select Cerveza Ale
      Bill of material: YEs
      Stocked: No
  Go to Bill of materials tab:
    -Agua
    - Bebida energética
Go to Sales order:
  Create a new register Org: España
  Lines tab:
     Product: Cerveza Ale
Book it.
Realise that the 'parent' product disapears (the line still there) and the 'child' lines appear: Agua and Bebidas Energéticas

Try to close it, realise that an error appears "null value in column "m_product_id" violates not-null constraint" because the 'parent' product is not there.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00219463.0MP17 closed jonalegriaesarte Using a BOM product in sales management document is not possible to reactivate the document 
related to defect 00219983.0MP19 closed ioritzCia After completing a sales order/invoice the BOM product does not appear 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-01-28 10:27VictorVillarNew Issue
2013-01-28 10:27VictorVillarAssigned To => jecharri
2013-01-28 10:27VictorVillarModules => Core
2013-01-28 10:27VictorVillarOBNetwork customer => Yes
2013-01-28 10:27VictorVillarSupport ticket => 17264
2013-01-28 10:27VictorVillarTriggers an Emergency Pack => No
2013-01-28 10:28VictorVillarIssue Monitored: networkb
2013-01-28 10:29VictorVillarRelationship addedrelated to 0021946
2013-01-28 10:29VictorVillarRelationship addedrelated to 0021998
2013-01-28 13:03hgbotCheckin
2013-01-28 13:03hgbotNote Added: 0055908
2013-01-28 13:03hgbotStatusnew => resolved
2013-01-28 13:03hgbotResolutionopen => fixed
2013-01-28 13:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/06da080dd39fbed4be8d60eb412fe0ea6694647c [^]
2013-01-31 09:53jecharriNote Added: 0055991
2013-02-01 22:28hudsonbotCheckin
2013-02-01 22:28hudsonbotNote Added: 0056069
2013-02-04 13:40VictorVillarReview Assigned To => VictorVillar
2013-02-04 13:40VictorVillarNote Added: 0056129
2013-02-04 13:40VictorVillarStatusresolved => closed

Notes
(0055908)
hgbot   
2013-01-28 13:03   
Repository: erp/devel/pi
Changeset: 06da080dd39fbed4be8d60eb412fe0ea6694647c
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Jan 28 13:03:19 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/06da080dd39fbed4be8d60eb412fe0ea6694647c [^]

Fixes issue 22906: Using a BOM product in sales management
document is not possible to close the document

---
M src-db/database/model/functions/C_ORDER_POST1.xml
---
(0055991)
jecharri   
2013-01-31 09:53   
Test cases:
-with steps to reproduce is enough
(0056069)
hudsonbot   
2013-02-01 22:28   
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/b070aa80fc76 [^]

Maturity status: Test
(0056129)
VictorVillar   
2013-02-04 13:40   
Verified