• Registered: 02/12/2013
  • Posts: 4

Topic: Getting Consolidated Reports

I have a requirement to get the consolidated reports for 2 or more companies.
We have multiple company set up in FA for example
Company 1 and Company 2 are the 2 companies i have set up.
If i want to take the Consolidated reports for Both the companies how can be done?
Currently we are login in as company 1 export the report into a spreadsheet and this activity has to repeated for every company and manually consolidated?
Can any body help us find out if there is any easier way of consolidating these multiple company reports through the tool itself?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Getting Consolidated Reports

Are they actually the same company with different profit centres or are they a Parent and subsidiary? If the former, then use Tags and / or Dimensions.

apmuthu's Website

  • Registered: 02/12/2013
  • Posts: 4

Re: Getting Consolidated Reports

Hi apmuthu Sorry for the delayed reply. i was working on a different issue.
In this case the companies are different and they are parent and Subsidiary companies. We are not finding a way to get the combined reports for different companies.
We want to generate the consolidated trial balances across all the companies.

4 Reply by apmuthu (edited by apmuthu 04/08/2013 03:00:43 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Getting Consolidated Reports

Dimensions and Tags may solve your issues.

Otherwise, a federated table structure may help outside of FA.

Creating UNIONised VIEWS (with apporpiately prefixed primary keys) of corresponding tables from all companies into a read-only consolidated virtual company's database will enable FA to do what you want.

apmuthu's Website

  • Registered: 08/17/2013
  • Posts: 7

Re: Getting Consolidated Reports

lavanyakashyap,

Look into "reportico" report maker, all you need is :
1) very basic sql
2) run through the tutorial of less than 2 hours
3) know FA's database schema