I've already tried the DRS VIP Zone - it worked great, but they want $50 per cashier for every RMS database. I have five stores, sixty cashiers in the collective databases, and am not paying $3K + maintenance for VIP Zone. If I could pay for my registers and an office PC or two per location, I'd be all over it.
I have used the KB queries to merge duplicate customers but it is a tedious process in an HQ environment. After you've indentified the duplicate accounts you must check HQ to see which store(s) the customer has shopped at before merging the customer records in the appropriate store ops databases. Then you need to wait for a WS401 to run at both stores before deleting the empty record at HQ.
What I'm looking for is a simple little utility or script for merging duplicate customers - preferably one that was developed by some enterprising soul that doesn't mind giving it away.
Tom