Import COA Errors

Question

I would like to delete all the unnecessary accounts in my chart of accounts (there are over 1200.....)

I have exported and deleted a few (haven't added or changed any names or codes, just deleted about 300 accounts). I then tried to import the file again (just to check it works, before i continue to delete the rest).

And these two errors came up:
*The file contains blocking errors (see below)*
*You can not change the code of an account. at multiple rows*

Like I said, I have not changed any na

Marc De Costa · Accepted Answer

Hi Katrin,
The best practice to avoid using unnecessary accounts is to deprecate the accounts. It is a boolean field inside the chart of accounts so you can export the field and mark it as TRUE for all the accounts and import it back.
image [1]

[1] /web/image/52102058-8c02f55c/image.png?access_token=0137e90a-bbdf-4cd4-94f3-b3a116fa7205

Luke · Answer

Regardless of the error, this will not work. You can't delete records using export/import. The system will only update the lines that are imported and do nothing with the other lines you deleted.
But you could do a a workaround like adding an active-state or renaming the records you want to delete and then bulk delete them by name from the treeview.
Regards

相关帖文	回复	查看
how can i handel the import error product import importerror	0 3月 25	1045
Importing .webp images using URL import products importerror v17	4 8月 25	2348
Missing required value for the field 'Model' (model_id) when trying to import Fields (text, date and integer) 已解决 import database importerror v18	2 11月 24	1425
Import extra price on variants and exclude for attributes import importerror importing data from excel file Importingissue	0 4月 24	1391
[v10 community] Can I replace installed chart of accounts ? community coa odoo10 chartofaccounts	1 6月 17	3632

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！