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 zo

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
会計
在庫
PoS
プロジェクト
MRP

All apps

全てのポスト人々バッジ

タグ (全て表示)

odoo accounting v14 pos v15

このフォーラムについて

ヘルプ

Odoo 10 - How to delete these accounts from Chart of accounts COA

coa chartofaccount odoo9.0 odoo10.0

1 返信

10783 ビュー

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

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

Ermin Trevisan

最善の回答

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

youta

著作者

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.

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！

今すぐアカウントを作成して、限定機能を利用したり、素晴らしいコミュニティと交流しましょう！

登録

関連投稿	返信	ビュー
Chart of Account Advise coa chartofaccount	0 9月 22	2601
How to configure Chart of account for each companies 解決済 coa chartofaccount	3 10月 21	13302
How to enable twitter login for odoo 10 odoo9.0 odoo10.0	1 6月 18	4551
Chart of accounts customization coa chartofaccount COA	1 8月 24	2680
How to get a product price in Picking Operations qWeb? 解決済 stock_picking odoo9.0 odoo10.0	1 1月 20	5871

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！