Odoo Help


9 Answers
17. 1. 19. 오전 5:06

I had a similar issue with the 'account receivable' and 'account payable' accounts.It was a fresh DB without demo data and a custom COA but the default 'accounts was not getting deleted.

Solution is:

Goto Settings -->Technical -->Parameters --> Company Properties

Select the appropriate properties and inside the form you can see a 'Value' field:

Value    | account.account,17

The number at the end gives the reference to the default account. Change it to the new account's "id" you have in your custom COA by referring the database table 'account.account'.

Hope this helps you

1 Comment
Bill Ennals
19. 5. 11. 오전 1:50

Thanks. That's very helpful.


Ray Carnes

--Ray Carnes--
| 10 7 11
Greater Los Angeles, United States
--Ray Carnes--

Business Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0, 11.0 and 12.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
13. 7. 23. 오후 1:00

Once an account has Journal Entries (credits and debits), it cannot be deleted.

odimegwu david
13. 7. 24. 오전 6:46

what about at period end or end of accounting period? openerp should have a condition set for such. thanks

Ray Carnes
13. 7. 24. 오후 3:09

I don't understand. OpenERP won't allow you to delete (or edit) any Journal Entry from a period that is closed - is that what you mean?

odimegwu david
13. 7. 25. 오전 7:32

I can cancel journal entries but an account that was a receivable set on a customer refuses to be changed and won't even delete. up my wits end

Ray Carnes
13. 7. 25. 오후 1:21

The account either (1) has journal entries, (2) is as a property on a journal, (3) is set as a property of a company, (4) set as a property on an account template or (5) set as an account on another consolidated account.

odimegwu david
13. 7. 25. 오후 5:03

I'll keep this comment for reference. The account has journal entries and once validated, even if set to draft state, cannot be deleted but can be re-modified. Also, it has a view account (template?) as its parent and the only other options are views. Will allow it to survive, but learned a little today.

Ray Carnes
13. 7. 25. 오후 5:44

It is reconciled with another Journal entry? What is the error message you get when you try to delete? (ie: what does "cannot be deleted" mean?).

Practichem, Nicholas DeMarco
16. 7. 10. 오전 7:34

Then the message should read:

"Accounts with relations cannot be removed or deactivated: journal entries, journal property, company property, account template property, another consolidated account's account.

Or it should read "Accounts with relations cannot be removed or deactivated."

Regardless, the current message is wrong. It's not a big deal for experienced developers, but it is a misleading message.

Ask a Question
Keep Informed
0 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Odoo Training Center

Access to our eLearning platform and experience all Odoo Apps through learning videos, use cases and quizzes.

Test it now