You’re offline. This is a read only version of the page.
Complete newbie with respect to SL (working with 2015), inheriting an install.
Have a situation where a group of companies (5 operating units with their own databases) installed on SQL Server in the same instance.
(each operating company is in different jurisdiction/country,, hence different accounting rules/time frames, tax regimes etc), but my understanding is that consolidated reporting is critical.
What are best practices in regards to this: All on the same instance, or create a separate SQL instance for each db/company.
What are the pro and cons of these 2 approaches ?
Is there any references/links to official Microsoft best practices/write ups that you can share; so far, has not had much luck finding same. ?
with best regards
*This post is locked for comments
I have the same question (0)
You will most likely use Management Reporter to do the Consolidated Reporting.
You would use the Financial Statement translation module to translate the different operating units to a common currency then use Management Reporter to build the financial reports.
Management Reporter will require all the SL databases to be in the same SQL instance so that eliminates the option of multiple SQL instances.
The client will mostly need another SL company setup to record intercompany eliminations.
Share
Report
All responses (
Answers (
660
