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

Sale invoice cannot find chart of accounts for the company

Subscribe

Get notified when there's activity on this post

This question has been flagged
salesaccountingcompanies
4 Replies
23734 Views
Avatar
Hunter Pavers

I'm working with Odoo CE 10.0
I have multiple companies

I have created chart of accounts.

I create a sale order.
I create an invoice.

The creation failes:
Cannot find a chart of accounts for this company, You should configure it.
As I already created several charts of account for the company for every possible type in the drop down list, I don't know what causes the model to not be able to read the chart of account. Traceback shows the error happens in:
File "/usr/lib/python2.7/dist-packages/odoo/addons/account/models/account_invoice.py", line 478, in _onchange_partner_id
rec_account = p.property_account_receivable_id

            pay_account = p.property_account_payable_id

            if not rec_account and not pay_account:

                action = self.env.ref('account.action_account_config')

              msg = _('Cannot find a chart of accounts for this company, You should configure it. \nPlease go to Account Configuration.').

Guess it's another bug. Any idea how to fix it or any workaround or what I'm doing wrong? Thanks in advance.

0
Avatar
Discard
Hunter Pavers
Author

Bump!

Avatar
Hunter Pavers
Author Best Answer

Here is how I fixed it:
We are using multi-company mode.

I went to Accounting> Configuration> Settings> Install More chart templates

Installed a chart template.

executed query:
select * from account_chart_template

To get installed template ID. Couldn't find any other way to get that.

executed query:
update res_company set chart_template_id = <ID i got from previous step>

Went to the sale order.

Clicked on customer name.
Clicked Edit

Accounting Tab

Selected something for Account Receivable

Selected something for Account Payable

Saved the customer.

Went to the product in sale order.

Clicked on product name until it opened product in background. Closed the dialog and in the opened product page clicked Edit.

Invoicing Tab

Selected something for Income Account

Selected something for Customer Taxes

Now invoicing works!

3
Avatar
Discard
Avatar
abdoReem adam ahmed
Best Answer

hello 

i think my friend @Fans is right

  
try this 
Select the partner you needs to set up, click "Edit" button and in accounting tab set Account Receivable and Account Payable.

0
Avatar
Discard
Avatar
Khamid
Best Answer

Hello.

The fields Account Receivable and Account Payable are company depended fields.

Therefore you needs to set up this field for every allowed company.

----------

If you use multi-company mode you have to set "Allowed Companies" in Settings -> Users -> Administrator 

In this field you have to fill all companies allowed for Administrator.

After that you will be able to change company by selecting in top-right corner of the screen.

Select the partner you needs to set up, click "Edit" button and in accounting tab set Account Receivable and Account Payable.

After that select another company in top menu and again set Account Receivable and Account Payable. You needs to repeat this operation for all companies from allowed companies list.

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
which module for Peppol
sales accounting
Avatar
Avatar
Avatar
Avatar
Avatar
5
Oct 25
1941
Warehouse on Product lines level
sales accounting
Avatar
Avatar
Avatar
2
Oct 25
620
Confusion regarding Product Categories and E-commerce Categories
sales accounting
Avatar
Avatar
Avatar
3
Oct 25
715
Can I use custom fields and Python to calculate Sales Tax? Solved
sales accounting
Avatar
Avatar
2
Aug 25
1202
Cambio de moneda en la factura, no funciona.
sales accounting
Avatar
Avatar
1
Aug 25
815
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