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

Consolidation accounts in Odoo 9.

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

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

Thanks.

4

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

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. 

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

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

3 follower(s)

Stats

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