Skip to Content
0
Former Member
Mar 31, 2009 at 12:24 PM

Database Consolidation

26 Views

Hi,

Scenario - HO + Company 1 + Company 2

Transaction - Invoices are booked in Company 1 and 2

Payment is done by HO

How to achieve this when HO , Company 1 & Company 2 are all separate SBO databases.

The above is a simple scenario.

The requirement is Mapping COA of HO/Company 1/Company2 and getting Consolidated P&L/Balance sheet and Trial Balance report for HO (which will include Company 1 and Company 2 postings)

i.e. If you create Sales Invoice in Company 1 and Company 2 database the Revenue account of Company 1 and Company 2 would be affected in their respective database. But at HO level the Revenue = Revenue Company 1 + Revenue company 2. How do I consolidate these figures to get the Revenue figure for HO

ps - HO , Company 1 & Company 2 are all separate SBO databases

Is it possible in Standard SBO (or) Is there any Add on developed for this for Transferring data of Company 1 & Company 2 to HO. Also please note not only the Financial entries but is it possible to also get the SALES/PURCHASE?INVENTORY reports for HO

Regards,

Sid