Odoo Help

1

Consolidation accounts in Odoo 9.

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

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

Thanks.

4

Ray Carnes

--Ray Carnes--
16773
| 9 7 9
Atlanta, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0.

Completed Odoo Functional and Technical Training.

Major Skills:

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

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: 2277 times
Last updated: 10/6/16, 2:25 AM