How to make export analytic_distribution using display name instead in journal items?

Question

I want to export journal items. In the table, the value shown was from name_get method
Image [1]

But when I export to xlsx, it became like this.
Image [2]
I understand that the format is
{ "id":percentage}
But I want to see the value from name_get in the xlsx export

[1] data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEASABIAAD/4QCuRXhpZgAASUkqAAgAAAAHABIBAwABAAAAAQAAABoBBQABAAAAYgAAABsBBQABAAAAagAAACgBAwABAAAAAgAAADEBAgANAAAAcgAAADIBAgAUAAAAgAAAAGmHBAABAAAAlAAAAAAAAABIAAAAAQAAAEgAAAABAAAAR0lNUCAyLjE

Andry Ang · Answer

Hi Dimas,
There are limitation to this, but there are alternatives like
If you only want to know the accounts, you can try "Distribution Analytic Account" If you want to know the account and the amount, make sure you confirm/post the journal and you can try "Analytic Lines"  Hope this helps

BRAHIM El-houcine · Answer

In the wizard of the export, instead of exporting *Analytical Distribution,* try with* Distribution Analytic Account/Display Name.
*I hope this answers to you question!

İlgili Gönderiler	Cevaplar	Görünümler
How can I import Journal Entries with Analytic Distributions in Odoo 18 Çözüldü accounting analyticdistribution	2 Eyl 25	1587
Odoo 17 - Update Journal Items journal_item odoo17	2 Tem 24	86
Required Fields For Journal Entry journal_entry journal_item	0 Kas 23	2324
Inline editable treeview Çözüldü treeview journal_item	1 Eki 23	45864
Cannot create unbalanced journal entry. Ids: Differences debit - credit Error when trying to create an invoice line Çözüldü journal_entry journal_item	4 Ara 22	23836

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!