Multiple BOM (formulas) support for mfg-light

Description

Original request from hiep:
https://groups.google.com/forum/#!topic/idempiere/UvrwPagIR58

Implementation:

  1. Copy existing data from M_Product_BOM to PP_Product_BOM and PP_Product_BOMLine

  2. Rename table M_Product_BOM to M_Product_BOM_Old

  3. Re-create M_Product_BOM as view that build on top of PP_Product_BOM and PP_Product_BOMLine

  4. Change mfg-light to use PP_Product_BOM and PP_Product_BOMLine

    1. add PP_Product_BOM_ID to M_Production

    2. add PP_Product_BOM_ID parameter to Production Create process

  5. With the potential of multiple BOM for a product, BOM with BOM Use=Master and BOM Type = “Current” is use as the default BOM of a product (and for M_Product_BOM view).

Environment

all

Activity

Heng Sin Low November 11, 2021 at 6:45 AM

Chuck Boecking October 5, 2021 at 4:02 PM

This solution works quite well for me. No need to change windows or code.

Anna Fadeeva May 9, 2020 at 7:20 PM

  1. The table M_Product_BOM rename to M_Product_BOMLine

  2. Create new table M_Product_BOM as header of BOM (see for example LiberoMFG)

  3. In Production add field M_Product_BOM_ID IsMandatory = Yes

  4. Then need change all functional for this new DB structure

Anna Fadeeva May 9, 2020 at 7:20 PM

Reproduced by in 7.1

Carlos Ruiz November 11, 2013 at 6:06 PM

Reopening this ticket for mfg-light

Fixed

Details

Assignee

Reporter

Tested By

Anna Fadeeva

Components

Fix versions

Affects versions

Priority

Created August 5, 2013 at 4:32 PM
Updated February 1, 2022 at 12:53 PM
Resolved October 6, 2021 at 3:46 PM