Finance | Project Operations, Human Resources, ...

Is there an issue with checkbook inquiry in GP 18.3.1200?

(0) Share

Report

Posted on by Richard Wheeler

75,852 Moderator

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?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Isaac Olson Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

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

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No