• From: Indonesia, Japan
  • Registered: 01/08/2014
  • Posts: 190

Topic: Multi Company Data Consolidation

Hello, I just wondering is there any method to consolidating accounting data or anything else from multiple company? I just got some use case that this FA application will be used from many branch and the accountung data must be consolidated in the main branch. Is it possible or must I modify the application? Thank you

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

Re: Multi Company Data Consolidation

Create some sort of a set of views mimicking the FA tables in another database comprising unions of data from various companies with same account master tables and keep separate ones for those whose unions are not needed and use this "views" database as a consolidated company in FA.

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: Multi Company Data Consolidation

Another option would be to print the BL and PL sheets to Excel/OO Calc for every Company and build a sheet for assembling the various Company result.

/Joe

  • Registered: 01/22/2014
  • Posts: 1

Re: Multi Company Data Consolidation

If you have just created the Company and had a few transactions in Another home currency, you could upload your favourite COA from the sql folder and make a restore to your current Company.