Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • 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 Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & 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
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Customization on Quality Worksheet Templates

Subscribe

Get notified when there's activity on this post

This question has been flagged
developmentconfigurationmanufacturing
3 Replies
1128 Views
Avatar
Emre O.

Hi All,

We have a connected manufacturing process with multiple levels of BoMs:

A+B ->C

   ​C+D ->E

​ ​      E+F->Finished Good.

Due to the nature of our industry, we create three separate Manufacturing Orders (MOs) to produce the finished good.

To reduce manual paperwork, we are building quality worksheet templates for each BoM item (C, E, and the Finished Good).

To be more specific,  We have two different semi-finished products, and each requires different quality thresholds for the same component. Our goal is to set separate thresholds and create automation rules to notify the responsible manager when a check fails.


In terms of technical perspective,  During creation of automation rules we enter the model name:

For Example:

Model Description Pre-op Inspection

Model  x_quality_check_worksheet_template_8


However, the technical name of a worksheet template (e.g., "Pre-op Inspection") changes if we create another version of "Pre-op Inspection" worksheet template for the second semi finished good to be able to set different threshold and trigger a warning.  


Our implementation partner has mention that any custom development related with specific work sheet template, should require another development if threshold has changed, because quality worksheet templates have been created dynamically after MO has been confirmed unless you use the same customized worksheet templates for second product but that is not aligning with the quality requirements.


My question:

Is this truly a limitation of Odoo? Does the approach described by our implementation partner sound correct?


Odoo version 17.0+e (Enterprise Edition)


0
Avatar
Discard
Avatar
Emre O.
Author Best Answer

/

0
Avatar
Discard
Avatar
Lars Aam
Best Answer

In the spreadsheet you define one cell that say the test is success or not.  Set up the quality control point as shown here.  

You can then create a automatic action to send message based on fail in the control check.

0
Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,


Each Quality Worksheet Template is a record in quality.check.worksheet.template. When you duplicate or create a new template (even if it looks like “Pre-op Inspection v2”), it is technically a different record with a different XML/DB identifier.

→ This is why, when you create automations based on a specific template’s technical name (like x_quality_check_worksheet_template_8), that automation only applies to that one record. A second version will not automatically inherit the same rules.


The “new development” approach your partner mentioned is one way to handle it, but it’s not the only way. The core problem is that the automation is hard-linked to a template record, instead of to a more flexible configuration (like product, BoM level, or inspection type).


Alternative approaches that avoid custom dev per template version:


    Use Quality Points (quality.point model) to configure which product/BOM/operation requires which checks and thresholds. Each semi-finished product can have its own point and rules without duplicating template logic.


    Add custom fields (like tolerance/threshold values) on the worksheet or check model, and drive your automation rules from those fields instead of the template record ID.


    If you need version control of templates, you can add a custom field like “Inspection Type” (e.g., pre_op, final, etc.) that stays constant, and use that in your automation filters. That way you can create multiple versions but still group automations logically.


Hope it helps

0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

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

Sign up
Related Posts Replies Views Activity
Dynamic Dashboard Background and Text on Dark/Light Theme Switch in Odoo 16 sh
development configuration
Avatar
Avatar
1
Nov 25
323
Bulk PDF download error
development configuration
Avatar
0
Oct 25
545
I am trying to set up a mass BOM edit. My Python code is giving forbidden opcode(s) error. Odoo 18
development configuration
Avatar
Avatar
Avatar
2
Sep 25
1111
Customizing Shop Checkout (UI) in Odoo
configuration manufacturing
Avatar
Avatar
1
Aug 25
1072
Google Calendar Sync - Odoo Calendar
development configuration
Avatar
Avatar
Avatar
3
Aug 25
2048
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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 is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

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