75,730
I was just testing checkbook inquiry with a client and when we go to the checkbook inquiry screen after selecting the checkbook it sits there for about 30-60 seconds before displaying any data. I know this was a problem with earlier releases of GP but I thought this was fixed. Are there scripts I can run to correct indexes?
Isaac, I beleive this is more of a network issue. With Covid users are working from home most days and come into the office once a week. When there are at their desk in their office everything to do with GP is slow. When they remote in from home to their VDI all is normal. I will discuss this with their IT group.
Hi Richard,
I am not seeing any outstanding issues with performance in this window, back when this was an issue on GP 2015 R2 it was taking 5+ minutes to populate around 200k transactions in the window. The benchmarks are much better in Microsoft Dynamics GP 18.3. If they are very heavy users of the Bank Rec Module, it could truly just be their volume causing the slowness.
You could get a count of their bank rec tables for the checkbook that you are testing with to get an idea.
select count(*) from CM20200 where CHEKBKID = 'XXXX'
select count(*) from CM30200 where CHEKBKID = 'XXXX'
One trick that you can use if they have really high transaction counts is to enter the date range first in the window, THEN select the checkbook ID. This would make it so there are less transactions to load. If you have not range in the window, it will try to load all the transactions and thus can make it slow if they are heavy users.
I hope this helps!
Isaac Olson
Microsoft Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (