Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Month-End Processing Running Long

(0) ShareShare
ReportReport
Posted on by 5

Our Month-End aging report for AP is running excessively long (3+ hours) since the upgrade to 2019 version.

It seems to be processing non-current items,

Is there a way to limit processing to only current work.

Categories:
  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Month-End Processing Running Long

    If you were to run this process at the end of the day when no one else is in GP and then run SQL Profiler on your server do you see it processing anything?

  • David-222 Profile Picture
    5 on at
    RE: Month-End Processing Running Long

    We are running from GP version 18.3.1290.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Month-End Processing Running Long

    What was your previous version of GP? What is your current version? There is no GP 2019. It will be GP 18.x.xxxx. You can click on the '?' in the upper right-hand corner and them About Dynamics.

  • David-222 Profile Picture
    5 on at
    RE: Month-End Processing Running Long

    FYI

    Yes, I see there is an "Open" option.

    Accounting says they have always run the "All" option and only since the upgrade has it gone from a minute or so to 3 hours.

    Thanks again

  • David-222 Profile Picture
    5 on at
    RE: Month-End Processing Running Long

    MY apologies...

    Accounting gave me the wrong report.

    Correct report screenshot follows:

    unnamed2.png

    Thank you.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Month-End Processing Running Long

    When was the last time this utility was run? This is a very disk intensive utility as it moves documents from the open tables to the historical tables. It is often a good idea to perform a backup before running it. I also always suggest they advance the check date one month in the event of any NSF checks.

  • David-222 Profile Picture
    5 on at
    RE: Month-End Processing Running Long

    Here is a screen shot of the problem report:

    unnamed.png

    We are running from GP version 18.3.1290

    If you need more information I will work with our accounting people to get it for you.

    I don't run the report myself.

     

    Thanks again,

    David Leatherman

    Server Admin

    YWAM Tyler

    217-318-1784

  • Nicole Hellerud Profile Picture
    1,712 on at
    RE: Month-End Processing Running Long

    Hi David-

    Thank you for your post.

    Are you running the AP HATB report? Is this being run from GP or SSRS?

    What report filters are being used? Could you include a screen capture?

    *NOTE Forums are available to the public so do not include any personal information. *

    What build of GP is being used?

    Best Regards,

    Nicole Sutton

    Support Engineer

    Microsoft Dynamics

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans