0021946: Using a BOM product in sales management document is not possible to reactivate the document

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0021946

Openbravo ERP

04. Warehouse management

public

2012-10-16 11:04

2012-10-18 17:55

Reporter

VictorVillar

Assigned To

jonalegriaesarte

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

unable to reproduce

Platform

OS Version

Product Version

Target Version

3.0MP17

Fixed in Version

Merge Request Status

Review Assigned To

VictorVillar

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0021946: Using a BOM product in sales management document is not possible to reactivate the document

Description

Using a BOM product in sales management document is not possible to reactivate the document

Steps To Reproduce

As 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 reactivate it, realise that an error appears "null value in column "m_product_id" violates not-null constraint" because the 'parent' product is not there.

The same thing happens in sales invoice window.

Proposed Solution

Do not remove the product in the 'parent' line and check in the callout that if the stock flag of the product is NO and the Bill of materials: YES, then the unit price and the line net amount should be 0.

Additional Information