Odoo Help

1

Consolidation accounts in Odoo 9.

By
bhavik-browseinfo
on 4/2/16, 4:21 AM 2,943 views

How can i create consolidated accounts in multi-company environment in odoo-9 ?

Thanks.

4
Ray Carnes
On 4/3/16, 1:02 PM

UPDATE:

I have since discovered that this isn't necessary if all child companies are 100% owned by the Parent and the Charts are identical.  With different charts, this still may work just fine because of 'tags' that instruct Odoo which 'section' accounts are part of - but I have only tested with matching charts.

With this structure:


And these transactions:



The P&L for MyCo- USA is:


The P&L for MyCo - SKA is:


The P&L for MyCo - Global is:


(Since there are no transactions).  To see the 'consolidated' report, turn on all companies, or the combination you want to see:



Now for MyCo - Global, you see:



No customization of financial reports was needed.  No configuration of financial reports was needed.  With 100% ownership of child companies by the parent, and identical charts, this 'just works' as expected.


ORIGINAL ANSWER:

You need to customize the reports.

For the parent company, add a line for each "consolidation account" and then add each child account to the "children lines" section.  This will calculate (roll up) the balance from the individual accounts from the other companies into the consolidation account.

https://www.odoo.com/documentation/user/9.0/accounting/others/reporting/customize.html

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

3 follower(s)

Stats

Asked: 4/2/16, 4:21 AM
Seen: 2943 times
Last updated: 10/6/16, 2:25 AM