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

Related Posts	Replies	Views
how can i handel the import error product import importerror	0 Mar 25	1851
Importing .webp images using URL import products importerror v17	4 Aug 25	3883
Missing required value for the field 'Model' (model_id) when trying to import Fields (text, date and integer) Solved import database importerror v18	2 Nov 24	2162
Import extra price on variants and exclude for attributes import importerror importing data from excel file Importingissue	0 Apr 24	2212
[v10 community] Can I replace installed chart of accounts ? community coa odoo10 chartofaccounts	1 Jun 17	4188

This question has been flagged

Enjoying the discussion? Don't just read, join in!