Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

multiple analytic plans

By
Kevin McMenamin
on 3/13/13, 10:56 PM 4,067 views

My requirement is to allow any account_move_line entry to have protentially (but not always) more than one analytic account.

Looking at the above module, it seems to rely on a known distribution between any two analytic accounts. So if I have two departments (AKL, WGN) and two projects (PRO1, PRO2) I need to create distribtions as follows: AKL - ie akl only no project WGN - ie wgn only no project PRO1 - ie project1 only, no department PRO2 - ie project2 only, no department AKL PRO1 - AKL depatment revenue/costs for project1 AKL PRO2 - AKL department revenue/costs for project2 WGN PRO1 - WGN department revenue/costs for project1 WGN PRO2 - WGN department revenue/costs for project2

The correct distribution_id is then added to the account_move_line.

Is my understanding correct or is there another way of approaching this.

Also in testing this I then looked at the Chart of Analytic Accounts which had no entries despite the entries being posted and appearing in the normal chart of accounts. Is this known behaviour?

1
Melina
On 5/26/15, 10:23 AM


Dear Friend,

I setup based on what you said above, but if I create invoice in Purchases module and validate the invoice, analytic distribution not transfer to Accounting module.

What should I do for that?

1

Kevin McMenamin

--Kevin McMenamin--
804
| 5 2 6
Auckland, New Zealand
--Kevin McMenamin--
Kevin McMenamin
On 4/16/13, 6:05 PM

Thanks to OpenERP I now have an answer.

The key is to create a view only master analytic account for each split element. So using the above example: Projects View Only Project 1 Parent=Projects Project 2 Parent=Projects

Branches View Only AKL Parent=Branches WGN Parent=Branches

Setup required (same for sales & purchases): 1. In settings/purchases tick 'Use multiple accounts on purchase orders' 2. Accounting/Configuration/Analytic Accounts/Analytic Journals - add as required 3. Create the analytic accounts as shown above - having the view account is the critical element. 4. Under Accounting/Configuration/Analytic Accounting/MultiPlans/Analytic Plans create a plan and add two lines (assuming as in my case you want two distributions). For my example, plan name=projects, root account=projects(ie the parent view account), min=0, max=100. repeat for the second plan 5. Accounting/Configuration/Journals/Journal - for whatever journal you are using the analytic distribution with, you need to add both the analytic journal and the analytic plan.

Now to use - under accounting/suppliers/supplier invoices create a new. on the line click into the analytic distribution field and create new - add the distribution required and validate the invoice.

Now look in the analytic chart of accounts to confirm the posting.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 3/13/13, 10:56 PM
Seen: 4067 times
Last updated: 1/31/16, 3:58 AM