I see this topic is quite old but I'd like to understand how you used multiple, separate servers. Were you using 50? I have a customer who needs to consolidate financials for multiple DBs on multiple servers. …"
I am not familiar with Sage 50 but in other Sage products, standard BI consolidation reports can be generated using the Report Manager Consolidations. You need tha connector module to run standard reports. If connector…"
A standard report is created for each database and link them together in a Union Report. I brought all values on Sheet 1, this appends the records accordingly. Note that all standard reports have exactly the same…"
Should you choose to run a consolidated Financial Report Designer report, the default layout generated will be a combination of all companies chosen for your consolidation at run time. You can then decide if you want to see the individual…"
"I did one from Sage 100 ERP for a Balance Sheet with Company A in column 1, Company B in column 2, and the total in Column 3. I used the Designer and there was a Group By in the upper right and I chose Company Code there, so it automatically…"