Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Sort Kanban by Drag'n Drop like in TreeView

Multiple files (images) upload

Analytic distribution / Analytic tags - Impact on journal items

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.

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.

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.

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.