PLM in Odoo 19:
Engineering Change Orders & BoM Versioning

# Install PLM module from the command line
./odoo-bin -c /etc/odoo/odoo.conf \
  -d your_database \
  -i mrp_plm \
  --stop-after-init

# Verify installation
./odoo-bin shell -c /etc/odoo/odoo.conf -d your_database <<EOF
plm = env['ir.module.module'].search([
    ('name', '=', 'mrp_plm'),
    ('state', '=', 'installed')
])
print(f"PLM installed: {{bool(plm)}}")
EOF

# Create custom ECO types via shell or migration script
EcoType = env['mrp.eco.type']

eco_types = [
    {
        'name': 'BoM Change',
        'sequence': 10,
    },
    {
        'name': 'New Product Introduction',
        'sequence': 20,
    },
    {
        'name': 'Quality Corrective Action',
        'sequence': 30,
    },
    {
        'name': 'Cost Optimization',
        'sequence': 40,
    },
]

for vals in eco_types:
    existing = EcoType.search([
        ('name', '=', vals['name'])
    ])
    if not existing:
        EcoType.create(vals)
        print(f"Created ECO type: {{vals['name']}}")
    else:
        print(f"ECO type exists: {{vals['name']}}")

  [New]          [In Review]        [Validated]        [Applied]
    |                |                   |                  |
    v                v                   v                  v
 Engineer       Approval Gate:      Approval Gate:     BoM version
 drafts the     Engineering Lead    Production Mgr     auto-activates.
 change and     reviews technical   confirms shop      Old revision
 attaches       feasibility.        floor readiness.   is archived.
 documents.
                If rejected:        If rejected:
                back to [New]       back to [In Review]
                with comments.      with comments.

# Retrieve all BoM revisions (active and archived)
product = env['product.template'].search([
    ('default_code', '=', 'PROD-ASSEMBLY-X1')
], limit=1)

# Include archived BoMs with context
all_boms = env['mrp.bom'].with_context(
    active_test=False
).search([
    ('product_tmpl_id', '=', product.id)
], order='version asc')

for bom in all_boms:
    status = "ACTIVE" if bom.active else "archived"
    eco_ref = bom.eco_ids[:1].name if bom.eco_ids else "N/A"
    print(
        f"V{{bom.version}} | "
        f"{{status}} | "
        f"Components: {{len(bom.bom_line_ids)}} | "
        f"ECO: {{eco_ref}} | "
        f"Date: {{bom.write_date.strftime('%Y-%m-%d')}}"
    )

# Example output:
# V1 | archived | Components: 12 | ECO: N/A            | Date: 2025-06-15
# V2 | archived | Components: 12 | ECO: ECO-00042      | Date: 2025-09-20
# V3 | ACTIVE   | Components: 13 | ECO: ECO-00067      | Date: 2026-01-10

from datetime import date

eco = env['mrp.eco'].browse(eco_id)

# Schedule BoM activation for Q2 product refresh
eco.write({
    'effectivity': 'date',
    'effectivity_date': date(2026, 4, 1),
})

# When the date arrives, a scheduled action
# activates the new BoM and archives the old one.
# Manufacturing orders created after April 1
# automatically use the new revision.

# Find manufacturing orders using non-current BoMs
MO = env['mrp.production']
BoM = env['mrp.bom']

# Get all active (current) BoM IDs
active_bom_ids = BoM.search([
    ('active', '=', True)
]).ids

# Find in-progress MOs on archived BoMs
outdated_mos = MO.search([
    ('state', 'in', ['confirmed', 'progress']),
    ('bom_id', 'not in', active_bom_ids),
    ('bom_id', '!=', False),
])

if outdated_mos:
    print(f"WARNING: {{len(outdated_mos)}} MOs on "
          f"outdated BoM versions:")
    for mo in outdated_mos:
        print(
            f"  {{mo.name}} | "
            f"Product: {{mo.product_id.display_name}} | "
            f"BoM V{{mo.bom_id.version}} | "
            f"State: {{mo.state}}"
        )
else:
    print("All in-progress MOs are on current BoMs.")

# Compare components between current and new BoM
eco = env['mrp.eco'].browse(eco_id)
current_bom = eco.bom_id
new_bom = eco.new_bom_id

current_lines = {
    line.product_id.id: line.product_qty
    for line in current_bom.bom_line_ids
}
new_lines = {
    line.product_id.id: line.product_qty
    for line in new_bom.bom_line_ids
}

# Added components
for pid in set(new_lines) - set(current_lines):
    product = env['product.product'].browse(pid)
    print(f"  + ADDED: {{product.display_name}} "
          f"(qty: {{new_lines[pid]}})")

# Removed components
for pid in set(current_lines) - set(new_lines):
    product = env['product.product'].browse(pid)
    print(f"  - REMOVED: {{product.display_name}}")

# Changed quantities
for pid in set(current_lines) & set(new_lines):
    if current_lines[pid] != new_lines[pid]:
        product = env['product.product'].browse(pid)
        delta = new_lines[pid] - current_lines[pid]
        sign = "+" if delta > 0 else ""
        print(
            f"  ~ CHANGED: {{product.display_name}} "
            f"{{current_lines[pid]}} -> "
            f"{{new_lines[pid]}} "
            f"({{sign}}{{delta}})"
        )