Thursday, July 10, 2008

Correct Journal Entry window Performance Problems

I saw a problem recently when a user had trouble while trying to load up entry list in the Correct Journal Entry Window. I gave up after about 10 minutes. I then remembered having read about this in the newsgroups.

I checked and their is a KB article (925326 - Microsoft Dynamics GP takes a long time to display the entry list after you open the "Original Journal Entries" window) out there that fixes the issue. The article provides a small script which adds a non clustered index to the GL30000 and the GL20000 tables.

Also, this problem occurs when the back-end is SQL 2005.

No comments: