Every morning when we open the Box Office, we have an employee run a report for newly created accounts. We then run through and clean-up all the new accounts (mostly created online) so they actually look nice.
Our website allows the creation of an account without saving a physical mailing address, and as such we have it set to list the addresses for those accounts as "INVALID ADDRESS", with our local city, state and the zip code of "11111" (this for development purposes, so mailings do not get printed with these as they obviously would not be delivered).
The problem is that 99% of the time when we search for one of these accounts by the given account number, we get a timeout error message, and the account is not found. The only solution we have found, which is inconvenient when you're trying to quickly run down a list of 50 newly created accounts to clean up, is to load the order module, insert the account number, and use the Ctrl + G shortcut to load the account. Is there a way to eliminate this search timeout?
Thanks,
John A. Moskal II