FrontAccounting forum — Getting Consolidated Reports

Re: Getting Consolidated Reports

null@example.com (rave88729) — Thu, 24 Jul 2014 02:52:59 +0000

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

Re: Getting Consolidated Reports

null@example.com (apmuthu) — Mon, 08 Apr 2013 14:56:24 +0000

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.

Re: Getting Consolidated Reports

null@example.com (lavanyakashyap@gmail.com) — Mon, 08 Apr 2013 05:43:46 +0000

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.

Re: Getting Consolidated Reports

null@example.com (apmuthu) — Wed, 13 Feb 2013 09:06:03 +0000

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.

Getting Consolidated Reports

null@example.com (lavanyakashyap@gmail.com) — Wed, 13 Feb 2013 06:31:25 +0000

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?