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.
Announcements
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.
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?
We are running from GP version 18.3.1290.
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.
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
MY apologies...
Accounting gave me the wrong report.
Correct report screenshot follows:
Thank you.
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.
Here is a screen shot of the problem report:
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
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
Martin Dráb
601
Most Valuable Professional
Abhilash Warrier
416
Adis
384
Super User 2025 Season 1