web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter in...
Microsoft Dynamics GP (Archived)

Management Reporter in GP 2016

(0) ShareShare
ReportReport
Posted on by Community Member

We are considering using Management Reporter in our 2016 GP system.  We have several companies that we use GP for.  They are all in the same database, just different instances.  Will we be able to create consolidated reports including all of the companies?

Thanks!

Dave

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter in GP 2016

    Hi Harry,

    Thank you for your response.  Yes I did word it wrong.  We have multiple companies in the Dynamics database.

    THanks!

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Management Reporter in GP 2016

    Dave -

    Not sure I am understanding your precise situation. You write "They are all in the same database, just different instances." I read "they are all on the Same SQL Server, but using different SQL instances (i.e. SQLServer1\Company1, SQLServer1\Company2, etc.).  This sounds like you're using different Dynamics (System) databases on various instances of SQL for different companies.  Please let me know if I am wrong.

    If I am right, you would encounter difficulty trying to configure more than one connection to multiple GP/SQL instances - you'll get an error that says "The integration you're trying to create already exists." When trying to connect to subsequent Dynamics databases to provision companies in Management Reporter, once the first one is configured.  In my experience you cannot configure multiple GP connections through one MR installation.

    If this is simply a matter of having multiple companies in the same Dynamics (System) database, then it works just fine.

    All that being said, our team, and I am sure a number of other partners, have done many unification projects to bring disparate system databases together to support consolidated reporting and improve multi-company processing.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans