Odoo Help

1

no customer or product has account but won't delete

By
odimegwu david
on 7/23/13, 7:43 AM 3,022 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.

0
Pravitha
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


0
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?

Bista Solutions US, 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.

Bista Solutions US, 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?).

Bista Solutions US, 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.

Register

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)

Stats

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