Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Slowness of a Consolidating Balance Sheet

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello:

We are running Management Reporter 2012 CU13, with the Legacy Provider.  Most of our financials run pretty quickly.

But, we have a consolidating balance sheet that pulls data from twenty companies in GP and contains a tree that points to the row definitions row links.  (Different links in the row definition reference several of these twenty companies.)

In my opinion, it's normal for a statement like this to take at least twenty minutes, even though we are running it just at the "Financial" level. 

Others, however, are alarmed by this "slowness".

I doubt that there is much that can be done, about this.  But, does anyone have any ideas on how we can "speed up" such a statement?

With all that we have going on, including testing a move of SQL to a new instance and many Scribe projects, we don't have time to put on a new service pack for Management Reporter nor are we going to migrate to the Data Mart, at this time.

Any thoughts, though, are truly appreciated!

Thank you!

John

*This post is locked for comments

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans