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.

0

Analytical accounts with more then 1 dimension

By
Jamie Novick
on 7/14/16, 5:23 AM 239 views

We're doing a project for a non profit organisation in London to setup Odoo 9 and they have a requirement for 2 "dimensions" of analytical accounting. These would be:

1) By project

and

2) By department

For example a line on a bill could be attributed both to a Project and then also to a Department. The idea being that they can look at a project budget and see how that is progressing, or to look at a Departmental budget and see how close they are to hitting budget there too. In the invoice you can only attribute a cost to 1 analytic account. So if I create a project budget account then this means I cannot see the cost as part of a department.

So a particular expense would be say "£1000" for food for an event, say "DB awards night". This should be attributed to the Food costs for that event (a project), but should also be attributed to a department (lets say events department).

We don't expressively need the budgeting functionality on both dimensions (although that would be nice) but we really need to be able to run a report of some form against both the Department costs and also the Project costs and have the £1000 appear in both.

My thought was that we might be able to use the Analytical Account labels to be able to have this multidimensional reporting but I don't seem to see how we can do it or report on them.

Any suggestions anyone has would be gratefully received.

Maybe this is something for you. It maybe not so flexible but worth a look.

https://www.odoo.com/apps/modules/9.0/analytic_department/

Lara
on 7/14/16, 11:43 AM

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: 7/14/16, 5:23 AM
Seen: 239 times
Last updated: 7/14/16, 5:24 AM