Fix for Slow Correcting JE Lookups

Archived post from 2008. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

When you do a correcting Journal Entry in GP, the lookup to find the entry to correct can be brutally slow. it’s so slow because it’s looking up every journal entry you’ve done in, like, forever. It’s so torturously slow that that the CIA is considering it for use at Guantanamo.
Well, today Jivtesh points us to a Microsoft Knowledge Base article that can help fix that. KB 925326 provides a small SQL script that adds a non-clustered index to the GL20000 and GL30000 tables.
That should help speed things up a bit. Of course, if you simply never made any mistakes, it would never be a problem.