Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
coachartofaccountodoo9.0odoo10.0
1 Odpovědět
10779 Zobrazení
Avatar
youta

Hello, I'm trying to start a new fresh chart of accounts

when I try to delete the following accounts I get this error

 You cannot remove/deactivate an account which is set on a customer or vendor.


Here's the list of accounts:

  • 101200 Account Receivable

  • 101300 Tax Paid 

  • 111100 Account Payable

  • 111200 Tax Received

  • 200000 Product Sales

  • 220000 Expenses


when I checked the log file I got this 

odoo.sql_db: bad query: UPDATE "account_account" SET "code"='220000',"write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (68)


any help will be appreciated. Thanks


Avatar
Zrušit
Sehrish

Deprecate vs Delete Chart of Accounts in Odoo | Key Differences & Best Practices | Odoo Accounting
Confused about whether to deprecate or delete an account in Odoo? In this video, we explain the key differences between deprecating and deleting a Chart of Accounts in Odoo with real-world examples to help you make the right choice.

https://youtu.be/fRSmzNxo2dw

Avatar
Ermin Trevisan
Nejlepší odpověď

You have to delete/change the related objects (customers, products etc.) first.

Avatar
Zrušit
youta
Autor

I installed only accounting module.. however when I checked the customers which are listed under Accounting module, it didn't allow me to delete the accounts parameters listed under my company. Anyways I had to erase these data from postgresql manually.

Ermin Trevisan

It is not recommended to do that in the database directly. Even if you only install the accounting module, you should check the usual suspects for relationships and apply appropriate filters in order to find and change/delete corresponding entries.

Ermin Trevisan

"Usual suspects" are for example:

- partner, contacts, employees, users, products, fiscal positions, taxes etc.

Related Posts Odpovědi Zobrazení Aktivita
Chart of Account Advise
coa chartofaccount
Avatar
0
zář 22
2600
How to configure Chart of account for each companies Vyřešeno
coa chartofaccount
Avatar
Avatar
Avatar
Avatar
3
říj 21
13295
How to enable twitter login for odoo 10
odoo9.0 odoo10.0
Avatar
Avatar
1
čvn 18
4549
Chart of accounts customization
coa chartofaccount COA
Avatar
Avatar
1
srp 24
2675
How to get a product price in Picking Operations qWeb? Vyřešeno
stock_picking odoo9.0 odoo10.0
Avatar
Avatar
1
led 20
5864