Month-End Processing Running Long

(0) Share

Report

Posted on by David-222

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:

Microsoft Dynamics GP

I have the same question (0)

All responses (8)

Answers (0)

Nicole Hellerud 1,712 on at

Like (0)

Report

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

Was this reply helpful? Yes No
David-222 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
David-222 5 on at

Like (0)

Report

MY apologies...

Accounting gave me the wrong report.

Correct report screenshot follows:

Thank you.

Was this reply helpful? Yes No
David-222 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
David-222 5 on at

Like (0)

Report

We are running from GP version 18.3.1290.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No