Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Detailed Trial Balance is super slow.

(0) ShareShare
ReportReport
Posted on by

I have noticed that since we closed the year in Financials the Detailed Trial Balance is taking a very long time to pull. We have not noticed an issue until we closed 2013. The report is taking upwards of 20-30 to pull a months worth of informationt that usually only requires a few minutes. Do any of you have suggestions on what may be causing this? I appreciate your input.

*This post is locked for comments

  • Ian Richardson Profile Picture
    4,150 on at
    RE: Detailed Trial Balance is super slow.

    in the first post you say the

    Detailed Trial Balance

    is running slowly.

    In this post you say its the historical trial balance.

    Which report is it?  

    Current year detailed trial balance?

    Historical trial balance meaning prior year g/l or some sort of a/r or a/p historical trial balance?

    I am GP 2010 I closed F2013 yesterday and

    my current year detailed trial balance produces 1113 pages in about 20 seconds

    historical detailed trial balance has generated over 1000 pages in about 20 seconds and is still going.

    If it is one of these two reports it could be the modified / corrupt report that are in prior selections.

    Ian

  • Community Member Profile Picture
    on at
    RE: Detailed Trial Balance is super slow.

    Scotty

    We am getting the same issue. have you got any working resolution.

    Thanks

    Humayun

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Detailed Trial Balance is super slow.

    Are any other GP processes running slowly?  If not, the report may be corrupted.  If it's not a modified report, try recreating the Reports Dictionary per these steps - support.microsoft.com/.../850465.

  • Community Member Profile Picture
    on at
    RE: Detailed Trial Balance is super slow.

    There did not seem to be any issues during the close. We are running Dynamics GP 2010. Everything else seems to be fine it is just the Historical Trial Balance.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Detailed Trial Balance is super slow.

    Did you encounter any issues during the close or was it normal?  What version are  you on?

  • Suggested answer
    soma Profile Picture
    24,410 on at
    RE: Detailed Trial Balance is super slow.

    Before running the report verify the date both starting and ending range. If more number of transactions available for selected range, it will take more hours to run this report.

    Hope this helps!!!

  • Community Member Profile Picture
    on at
    RE: Detailed Trial Balance is super slow.

    Is it a modified report? Revert to the original version and see if it makes a difference.

    Ian.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans