Contributors

hmm... i can see a problem with this method: not compatible with v13, where the invoice model is merged with journal entry model:

migrating a database with this module may be... complicated.

beside, having a journal entry where the lines do not match the invoice lines seems risky to me, for example when you want to do your tax reporting.

my 2 cents,

regards 

On Wed, 18 Nov 2020 at 10:42 PM, Vandamme, Guillaume <guillaume.vandamme@acsone.eu> wrote:

Hello Juan José,

Excellent, this is exactly what I was looking for. Many thanks! 

Do you accept that we propose this module to OCA?

The name of the module should be changed though, as the name account_analytic_distribution is already used for another module.

It could be changed to something like account_analytic_distribution_move_lines

Thanks,

Guillaume

On Tue, 17 Nov 2020 at 17:01, Juan José Scarafía (ADHOC) <scarafia.juanjose@gmail.com> wrote:

Hi Guillaume,

We have the same needs and think similar to you.

Before the existence of analytic tags (and analytic tags distributions) we have this module "account_analytic_distribution" that works this way:

* on an invoice you choose the "distribution analytic account" on each line (it is a normal analytic account with distribution lines as the new analytic tags of odoo)

* when validating the invoice, the account.move was created but account.move.line where splitted if you're using analytic distribution

That way, the distribution works for analytic and accounting reports.

We haven't migrated or found an approach for v13+ yet. On v13, with the removal of account.invoice, I was thinking in something similar but perhaps more "manual" on the invoice, a button to split lines, but you won't have a way to go back to the distribution.

Ing. Juan José Scarafía

(+54 9 341) 3 278039

twitter: @jjscarafia

github: @jjscarafia

On Tue, Nov 17, 2020 at 9:57 AM Vandamme, Guillaume <guillaume.vandamme@acsone.eu> wrote:

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.

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

Email : guillaume.vandamme@acsone.eu

Acsone sa/nv

Waterloo Atrium | 167, Drève Richelle | B-1410 Waterloo 

www.acsone.eu

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

--

Guillaume Vandamme
Business Analyst

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

Email : guillaume.vandamme@acsone.eu

Acsone sa/nv

Waterloo Atrium | 167, Drève Richelle | B-1410 Waterloo 

www.acsone.eu

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

--

Dominique KON-SUN-TACK  [Project Manager]

Elico Solutions (Singapore/Shanghai/Shenzhen) 

Odoo Gold Partner, best Odoo Partner 2014 for APAC

Mobile: + 65 8502 2399

Skype: dominique_elico

Email: dominique.k@elico-corp.com.sg

Website: www.elico-corp.com

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Hi Guillaume,

We have the same needs and think similar to you.

Before the existence of analytic tags (and analytic tags distributions) we have this module "account_analytic_distribution" that works this way:

* on an invoice you choose the "distribution analytic account" on each line (it is a normal analytic account with distribution lines as the new analytic tags of odoo)

* when validating the invoice, the account.move was created but account.move.line where splitted if you're using analytic distribution

That way, the distribution works for analytic and accounting reports.

We haven't migrated or found an approach for v13+ yet. On v13, with the removal of account.invoice, I was thinking in something similar but perhaps more "manual" on the invoice, a button to split lines, but you won't have a way to go back to the distribution.

Ing. Juan José Scarafía

(+54 9 341) 3 278039

twitter: @jjscarafia

github: @jjscarafia

On Tue, Nov 17, 2020 at 9:57 AM Vandamme, Guillaume <guillaume.vandamme@acsone.eu> wrote:

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.

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

Email : guillaume.vandamme@acsone.eu

Acsone sa/nv

Waterloo Atrium | 167, Drève Richelle | B-1410 Waterloo 

www.acsone.eu

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

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.

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

Email : guillaume.vandamme@acsone.eu

Acsone sa/nv

Waterloo Atrium | 167, Drève Richelle | B-1410 Waterloo 

www.acsone.eu

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe