Contributors mailing list archives

contributors@odoo-community.org

Avatar

Analytic distribution / Analytic tags - Impact on journal items

by
Acsone SA/NV, Guillaume Vandamme
- 17/11/2020 13:51:44
Hello everyone,

I'm currently facing an issue with the analytic distribution functionality of Odoo. I would like to share it with you as some may have faced the same issue recently and may be able to help. I'm working on Odoo V12, but the same situation occurs on different versions as well. 

When checking the 'Analytic Distribution' box on an analytic tag, this analytic tag can be used to allocate a certain percentage of an expense or an income on several analytic accounts.
Example: On the picture below, the 'Analytic distribution key 1' analytic tag will allocate 50% of the expense/income on the 'Administrative' analytic account and the remaining 50% on the 'Commercial & Marketing' analytic account.

image.png

When validating a simple vendor bill of 100 euros with this 'Analytic distribution key 1' selected, Odoo is generating a journal entry with three journal items: payable account, tax account and an expense account (100 euros) which is linked to the 'Analytic distribution key 1' analytic tag. My two analytic accounts (Administrative + Commercial & Marketing) don't appear here.

image.png

Besides that, Odoo is also generating two analytic items in the 'Accounting --> Analytic items' menu to divide the total amount of the expense (100 euros) according to the distribution key (50% for both analytic accounts). These analytic lines can also be found in the 'Analytic Lines tab' on the expense journal item.

image.png

My problem is that this breakdown on both analytic accounts doesn't appear in the journal items/entries, it only appears in the analytic items. This makes reporting based on journal items much more complicated (ex: Mis Report to generate a P&L by analytic account).

I would rather prefer that the breakdown on both analytic accounts applies directly on the journal entry. Hence, instead of having one expense journal item (100 euros) related to the analytic tag, we would have two expense journal items (50 euros each),both related to their analytic account (Administrative or Commercial&Marketing). This would probably make things much easier.

image.png



Any thoughts on this?
Does this 'problem' sound familiar for some of you? Has anyone ever found a solution for this?

Thank you very much for your help,

Regards,


Guillaume Vandamme




--
Guillaume Vandamme
Business Analyst

Phone : +32 2 888 31 31
Mobile : +32 475 49 88 27

Acsone sa/nv
Waterloo Atrium | 167, Drève Richelle | B-1410 Waterloo 

Follow-Ups