Microsoft Dynamics GP provides auto complete functionality that remembers previous entries and displays them to users during subsequent data entry. Users can pick the appropriate item without having to type the entire text. This is a great feature but the entries are stored per user and per field. That means that each time the system saves a vendor number that has been keyed it's saved as one entry for that user. By default, Dynamics GP is set up to hold ten thousand entries, per user, for each field.
As you can imagine, over a long period of time and in organizations with heavy entry volume, the number of entries can build up, slowing down AutoComplete's performance significantly. Additionally, the number of choices presented to users can become unwieldy. For this recipe, we will look at a two-part solution to this problem. First, we will set up a maintenance routine to clean out any entries not used over the last sixty days and...