Database Consolidation

[Former Member]

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

[Former Member]

An XL reporter addon is available for Consolidating Financial Reports. I have used the Solver product XL Consolidation for over a year and it works extremely well. My experience with the support response has been great. The web page is www.solverusa.com. but you may get better information and a faster response if you contact Allan Bacero at Solver (310) 691-5322. (This post does not allow email addesses) I've used this add on with SAP Business One versions 2005 and 2007 SP00 pl46. Good luck with your search.

[Former Member]

Hi

What you are looking for is a Consolidation (multi branch) solution.

As mentioned before there are partners that provided that solution, one company with an add-on like this is CitiXsys. You can try contact them or look for another one that provides a solution that fits your requirements.

Paulo Calado

SAP Business One Forums Team

[Former Member]

There are add-on vendors specialized in consolidation. You can check Add-on forum to find out more. One of them is from Citrix.

Thanks,

Gordon

[reno1]

Hi Siddesh,

What you are trying to accomplish is a very complex configuration and a lot of issues would be there in it. The major being in terms of TDS. So Its advisible to go for Single Company and with Project Selection option. This is fairly simple to get reports based on Projects, etc.

Also there are Addons for this purpose available but dont know how far will your TDS issue solve!!!

I strongly recomend you to use only single company and not multiple companies to avoid complications.

Regards

Reno