Skip to Content
Odoo Menu
  • Prihlásiť sa
  • Vyskúšajte zadarmo
  • Aplikácie
    Financie
    • Účtovníctvo
    • Fakturácia
    • Výdavky
    • Tabuľka (BI)
    • Dokumenty
    • Podpis
    Predaj
    • CRM
    • Predaj
    • POS Shop
    • POS Restaurant
    • Manažment odberu
    • Požičovňa
    Webstránky
    • Tvorca webstránok
    • eShop
    • Blog
    • Fórum
    • Živý chat
    • eLearning
    Supply Chain
    • Sklad
    • Výroba
    • Správa životného cyklu produktu
    • Nákup
    • Údržba
    • Manažment kvality
    Ľudské zdroje
    • Zamestnanci
    • Nábor zamestnancov
    • Voľné dni
    • Hodnotenia
    • Odporúčania
    • Vozový park
    Marketing
    • Marketing sociálnych sietí
    • Email marketing
    • SMS marketing
    • Eventy
    • Marketingová automatizácia
    • Prieskumy
    Služby
    • Projektové riadenie
    • Pracovné výkazy
    • Práca v teréne
    • Helpdesk
    • Plánovanie
    • Schôdzky
    Produktivita
    • Tímová komunikácia
    • Schvalovania
    • IoT
    • VoIP
    • Znalosti
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Managament
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Výroba
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware and Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Komunita
    Vzdelávanie
    • Tutoriály
    • Dokumentácia
    • Certifikácie
    • Školenie
    • Blog
    • Podcast
    Empower Education
    • Vzdelávací program
    • Scale Up! Business Game
    • Visit Odoo
    Softvér
    • Stiahnuť
    • Porovnanie Community a Enterprise vierzie
    • Releases
    Spolupráca
    • Github
    • Fórum
    • Eventy
    • Preklady
    • Staň sa partnerom
    • Services for Partners
    • Register your Accounting Firm
    Služby
    • Nájdite partnera
    • Nájdite účtovníka
    • Meet an advisor
    • Implementation Services
    • Zákaznícke referencie
    • Podpora
    • Upgrades
    ​Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Získajte demo
  • Cenník
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Účtovníctvo
  • Sklady
  • PoS
  • Projektové riadenie
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
Pomoc

I am trying to set up a mass BOM edit. My Python code is giving forbidden opcode(s) error. Odoo 18

Odoberať

Get notified when there's activity on this post

This question has been flagged
developmentconfiguration
2 Replies
1014 Zobrazenia
Avatar
Mahmood

Basically I was adding 2 fields to the form view: Material to replace and Replacement material, then I would give the option to select multiple BOMs and each of them will replace the material selected with the replacement material. My problem was when I tried adding the code, It gives me forbidden opcode(s) error.

Im using odoo studio btw.

This is the code:

from odoo.exceptions import UserError


# Get the material to replace and the replacement material from the FIRST selected record

if records:

    first_record = records[0]

    material_to_replace = first_record.x_studio_material_to_replace_1

    replacement_material = first_record.x_studio_replacement_material_1


    if not material_to_replace or not replacement_material:

        raise UserError("Please specify both 'Material to Replace' and 'Replacement Material' in the first selected BOM.")


    # Loop through the selected BOMs

    for bom in records:

        # Loop through the BOM lines

        for line in bom.bom_line_ids:

            # Check if the material matches the one to replace

            if line.product_id == material_to_replace:

                # Replace the material

                line.product_id = replacement_material

                line.product_qty = line.product_qty #This line is added to force the recomputation of values

else:

    raise UserError("No BOMs selected.")


And this is the error:  forbidden opcode(s) in 'from odoo.exceptions import UserError\n\n# Get the material to replace and the replacement material from the FIRST selected record\nif records:\n    first_record = records[0]\n    material_to_replace = first_record.x_material_to_replace\n    replacement_material = first_record.x_replacement_material\n\n    if not material_to_replace or not replacement_material:\n        raise UserError("Please specify both \'Material to Replace\' and \'Replacement Material\' in the first selected BOM.")\n\n    # Loop through the selected BOMs\n    for bom in records:\n        # Loop through the BOM lines\n        for line in bom.bom_line_ids:\n            # Check if the material matches the one to replace\n            if line.product_id == material_to_replace:\n                # Replace the material\n                line.product_id = replacement_material\n                line.product_qty = line.product_qty #This line is added to force the recomputation of values\nelse:\n    raise UserError("No BOMs selected.")': IMPORT_NAME, IMPORT_FROM, STORE_ATTR

0
Avatar
Zrušiť
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Please refer to the code:


if not records:

    raise UserError("No BOMs selected.")


first_record = records[0]

material_to_replace = first_record.x_studio_material_to_replace_1

replacement_material = first_record.x_studio_replacement_material_1


if not material_to_replace or not replacement_material:

    raise UserError(

        "Please specify both 'Material to Replace' and 'Replacement Material' in the first selected BOM.")


# Loop through the selected BOMs

for bom in records:

    for line in bom.bom_line_ids:

        if line.product_id == material_to_replace:

            # Use write() instead of direct assignment

            line.write({

                "product_id": replacement_material.id,

            })


Hope it helps.

0
Avatar
Zrušiť
Ray Carnes (ray)

You should use assignment and let the ORM manage the database updates.

Avatar
Ray Carnes (ray)
Best Answer

You cannot import any libraries, UserError is already available.

All record assignments must be in the form:

record['field'] = value
0
Avatar
Zrušiť
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrácia
Related Posts Replies Zobrazenia Aktivita
Dynamic Dashboard Background and Text on Dark/Light Theme Switch in Odoo 16 sh
development configuration
Avatar
Avatar
1
nov 25
207
Bulk PDF download error
development configuration
Avatar
0
okt 25
516
Google Calendar Sync - Odoo Calendar
development configuration
Avatar
Avatar
Avatar
3
aug 25
1916
Timesheets multiple days
development configuration
Avatar
Avatar
Avatar
3
júl 25
1246
How to set up contacts to require confirmation from a significant person when saving a new contact?
development configuration
Avatar
Avatar
Avatar
2
júl 25
1875
Komunita
  • Tutoriály
  • Dokumentácia
  • Fórum
Open Source
  • Stiahnuť
  • Github
  • Runbot
  • Preklady
Služby
  • Odoo.sh hosting
  • Podpora
  • Vyššia verzia
  • Custom Developments
  • Vzdelávanie
  • Nájdite účtovníka
  • Nájdite partnera
  • Staň sa partnerom
O nás
  • Naša spoločnosť
  • Majetok značky
  • Kontaktujte nás
  • Pracovné ponuky
  • Eventy
  • Podcast
  • Blog
  • Zákazníci
  • Právne dokumenty • Súkromie
  • Bezpečnosť
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo je sada podnikových aplikácií s otvoreným zdrojovým kódom, ktoré pokrývajú všetky potreby vašej spoločnosti: CRM, e-shop, účtovníctvo, skladové hospodárstvo, miesto predaja, projektový manažment atď.

Odoo prináša vysokú pridanú hodnotu v jednoduchom použití a súčasne plne integrovanými biznis aplikáciami.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now