How can I import Journal Entries with Analytic Distributions in Odoo 18

Question

I tried to import journal entries with analytic distribution, I tried to put them in a JSON form but when I made the import the analytic distribution was empty
this form I tried:
{"analytic account name": percentage}

here is an example

01/04/2025
JV
Tax invoice# CR-13531
Materials
& Raw Materials
625.00
{"Al Khan G + 15 -
211": 100}

Vat 5%
31.25

Suppliers & Creditors
Al Dammam Elect. & Sanit. Ware Trdg.
656.25

what should I do so the analytic distribution is imported correctly

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,

In Odoo, analytic distributions must be imported using the analytic account’s external ID or database ID, not its name. When you tried {"Al Khan G + 15 - 211": 100}, Odoo couldn’t match the name, so the distribution was left empty. To fix this, you should first get the external ID of the analytic account (via Settings → Technical → External Identifiers), then use that in the JSON field, for example {"analytic_al_khan_211": 100}. If you need to split across multiple accounts, you can add mor

Ray Carnes (ray) · Answer

The most reliable and dependable way to understand how to import anything in Odoo is to first create a record representing what you want to import and EXPORT it first.
You will then see that the format of the Analytic Distribution field is the ID (ie: 90) of the Analytic Account:
{"90", 100.0}

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Invoice Printing Error in Odoo V19 – GCC/Saudi Localization accounting	0 marrask. 25	142
After Odoo 18 to Odoo 19 upgrade - how do I manage Bills for products that already posted to the interim account? - مشكلة بعد الترقية من Odoo 18 إلى Odoo 19. accounting	1 marrask. 25	188
I found a small typo in the Odoo 19 Chart of Accounts — and it made my day 😆 Ratkaistu accounting	2 marrask. 25	350
Invoice-Digitize-Individual Line Items accounting	1 marrask. 25	493
How can I manipulate the email template when sending an email in Accounting so that my PDF with the XML is inserted instead of the standard view with XML? accounting	1 marrask. 25	372

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

01/04/2025	JV	Tax invoice# CR-13531	Materials & Raw Materials	625.00		{"Al Khan G + 15 - 211": 100}
			Vat 5%		31.25
			Suppliers & Creditors	Al Dammam Elect. & Sanit. Ware Trdg.		656.25