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}

Post correlati	Risposte	Visualizzazioni
¿Cómo llamar a JetBlue desde República Dominicana?【JetBlue﹂𝓐irlines﹁Number】(@@irline @yuda) accounting	0 set 25	5
Shareholders Equity (common stock) missing from default chart of accounts (United Kingdom) accounting	4 set 25	1135
Access rights management on Odoo 15 Community accounting	3 set 25	297
Analytic Account field disabled in saved Sales Order accounting	1 ago 25	228
PEPPOL compliant with BNPP rules for invoicing? accounting	1 ago 25	303

La domanda è stata contrassegnata

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!

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