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

Gerelateerde posts	Antwoorden	Weergaven
how can i handel the import error product import importerror	0 mrt. 25	1052
Importing .webp images using URL import products importerror v17	4 aug. 25	2360
Missing required value for the field 'Model' (model_id) when trying to import Fields (text, date and integer) Opgelost import database importerror v18	2 nov. 24	1434
Import extra price on variants and exclude for attributes import importerror importing data from excel file Importingissue	0 apr. 24	1406
[v10 community] Can I replace installed chart of accounts ? community coa odoo10 chartofaccounts	1 jun. 17	3647

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!