hello community,
we are loading our historical transaction (GL transaction), we were able to load our all our entries without issue. However when we try to load it adding some analytical account for our P&L accounts, we cannot pass the "test" before import.
here is our format :
Date | Journal | Reference | Journal Items / Account | journal item name | Ecritures comptables - libellé | Journal Items / Debit | Journal Items / Credit | analytic_account_id |
01.01.24 | HIST | Batch-JAN24 | 3400 | Ventes de prestations | confidential - deleted | 435330 | 7 | |
2200 | TVA due | confidential - deleted | 35261,73 | |||||
2301 | Produits encaissés d’avance | confidential - deleted | 470591,73 |
the entry is balance and pass the load without the analytical code, however when we try to load with analytical code and trying to link it to different connector in Odoo, we have error message. The "7" correspond to analytical code ID in Odoo.
please let me know which field should we use and if we need to specify the distribution (in example 100%) and the format for load.
thanks a lot in advance for your precious help
Export an entry with the "import-compatible export" option to understand the format that Odoo expects.
The "analytic_account_id" does not exist, you need to import via "analytic_distribution" which you will see in your export.