| ID: | 11662 |
| Title: | Correct Journal Entry window Performance Problems |
| URL: | http://www.jivtesh.com/2008/07/correct-journal-entry-window.html |
| Description: | 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. |
| Category: | TIPS AND TRICKS BY MODULES: GL (General Ledger) |
| Link Owner: | |
| Date Added: | June 17, 2010 06:14:42 PM |
| Number Hits: | 7 |