For years I have avoided demonstrating the very nice feature in GP that allows you to correct or copy a posted general journal entry, because the look up to find the subject journal entry took forever. But I was recently presenting a demo, and I felt lucky; so I thought I'd try it. No luck.
However, this morning John Crahan, one of our consultants, steered me toward KnowledgeBase article #925326. Within that article is a SQL script that creates indexes in two tables that speed things up tremendously.
I added the indexes to my demo system in less than a minute. Works great!
posted by Steve Chapman @ Monday, August 10, 2009
3 Comments
3 Comments:
Steve,
You are correct. I posted similar article last month. It works pretty well. Not sure why this is not getting included in the service packs
http://janakirammp.blogspot.com/2009/07/correct-option-general-entry-takes.html
Just had someone call about this same issue. Said GP kept crashing (was really just thinking for an awfully long time). Thanks for the tech doc reference. It made me look super smart.
Thanks for the post, Steve. I just had a customer ask about this issue and a quick search led me here. Will post a link here on my own blog as well. Thanks again.
Post a Comment
<< Home