Issue while Importinng french chart of accounts (PCG / COA)

Dear All,

Since a while i faced an odd issue but i found a fix and i would like to share it here.

Each time i tried to import the french chart of accounts, there was an error.
I tried this on Axelor 7.2, 7.3, 8.2 and 8.3.

Here is what i did:





And here you can see the error log:

I have to say that i created the company from scratch, so not imported or so.

So, what i found is that when you create a company from scratch, the « import id » field is defined as « NULL » (pretty obvious right?).


But most of the configurations are based on « company id » or « import id ».
And for COA (PCG), the accounting batch import is based on « import id », so in order to make this work, we have to update the value from « NULL » to « 1 » in « base_company » table in the POSTGRESQL database.

And try again: