Odoo Help


no customer or product has account but won't delete

odimegwu david
on 7/23/13, 7:43 AM 3,447 views

an asset or liability account cannot be deleted when already set on a customer or product. I have such a case. I have gone through all the suppliers and products I have and tried deleting the entries. Despite that, I still have the same error report. Is it possible to do a dependency check or filter in order to know the specific problem, because no customer or product has the account entry again.

On 1/19/17, 5:06 AM

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


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.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
On 7/23/13, 1:00 PM

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

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

odimegwu david
on 7/24/13, 6:46 AM

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?

Ray Carnes
on 7/24/13, 3:09 PM

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

odimegwu david
on 7/25/13, 7:32 AM

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.

Ray Carnes
on 7/25/13, 1:21 PM

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.

odimegwu david
on 7/25/13, 5:03 PM

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?).

Ray Carnes
on 7/25/13, 5:44 PM

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.

Practichem, Nicholas DeMarco
on 7/10/16, 7:34 AM

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 E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 7/23/13, 7:43 AM
Seen: 3447 times
Last updated: 1/19/17, 5:06 AM