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

Unable to assign a company to a newly created product

Subscribe

Get notified when there's activity on this post

This question has been flagged
inventoryproduct.productaccess_error
1 Reply
982 Views
Avatar
Kevin Stallard

I am an admin for our odoo instance.  I am using a multi-company database.  There is no hierarchical relationship between the two companies in the database.  They are treated a separate companies.

When I try to add a company to a new product, Odoo complains with:

Access Error

Uh-oh! Looks like you have stumbled upon some top-secret records. Sorry, <user> (id=2) doesn't have 'read' access to: - Product Variant, Service on Timesheets (product.product: 2) Blame the following rules: If you really, really need access, perhaps you can win over your friendly administrator with a batch of freshly baked cookies.

A couple of things:

1.  The product id of the new product I added is 131, not 2.  I don't know what this has to do with "Service on Timesheets" service product.  So there appears to be some strange relationship with the new product I just added and "Service on Timesheets".

2.  I have read access to Service on Timesheets, I can open it and read and even change things and save it.

3.  The product I just added has no inventory and has not been involved with any stock moves.

4.  I've tried changing the Record Rules for Product ("Product multi-company") and changed:

['|', ('company_id', 'parent_of', company_ids), ('company_id', '=', False)]

to

['|', ('company_id', 'in', company_ids), ('company_id', '=', False)]

But that doesn't fix it and it mess up the product list in that you can no longer filter on Company.

Any help understanding why this error is being displayed would be appreciated.   I figure there is a rule somewhere that needs tweaking.... 

Thanks,
Kevin



0
Avatar
Discard
Himani

Hello Kevin Stallard
can you show example for which product you are trying to add company and configuration of your users (from which user you are trying to add company)? 

Also can you check how many companies you are selected on top right ?
Maybe after that i can help.

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

The error occurs because Odoo enforces multi-company record rules on all products, even when you’re creating a new one. In your case, the rule touches the “Service on Timesheets” product, which has a company assignment that your user cannot fully access, causing the access error. This happens because the standard product multi-company rule uses hierarchical (parent_of) logic, which doesn’t work properly in a flat multi-company setup. Simply changing parent_of to in can fix access but breaks the company filter in product lists. The correct approach is to either set company_id=False for products that should be accessible across companies and/or create a custom record rule using ['|', ('company_id', 'in', user.company_ids.ids), ('company_id', '=', False)] applied to relevant user groups. This ensures that users can create and manage products across multiple independent companies without triggering access errors or losing the ability to filter products by company.


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
Database fetch misses ids ((<NewId origin=56101>,)) and has extra ids ((56101,)), may be caused by a type incoherence in a previous request Solved
inventory product.product v15
Avatar
Avatar
1
Sep 24
4313
How to add products to order in inventory app
inventory help product.product newbie
Avatar
0
Feb 22
2955
Odoo Inventory Valuation Report
inventory
Avatar
Avatar
Avatar
Avatar
3
Nov 25
7330
Inventory rotation or inventory turnover
inventory
Avatar
Avatar
1
Oct 25
1710
Lot/Serial Number Solved
inventory
Avatar
Avatar
Avatar
2
Sep 25
924
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