ZIP populates City/State field with wrong info

We have several ZIP codes in my area that only deliver mail to PO Boxes. I ran some queries prior to generating a mailing list to identify addresses in these ZIP codes that had non-PO Box address info. Once I identified them, I used another query to move the address data to Customer.Address2 and populated Customer.Address with "GET VALID MAILING ADDRESS" so that the next time the customer comes in that the cashier can update the customer record. The queries ran flawlessly as far as I could tell.

After this, for some unknown reason, when creating a new customer at POS the City & State fields are being auto-filled with incorrect information and saving a new customer with the correct information does not correct the problem.

Any ideas how I can fix this? Where is this auto-fill data stored?

Tom

Reply to
Terrible Tom
Loading thread data ...

From my understanding the "auto-fill data" is stored in your customer database. What happens is when you add the ZIP code the system will do a quick query and find the first match and return the City and State.

You might want to try doing your own query on a couple of known problem ZIP codes and see if the first record returned is what is being pulled at the POS.

Of course I could be talking out of my a$$ and be completely out to lunch it has been a long time since I had to support RMS. :)

Robert

"Terrible Tom" wrote:

Reply to
Robert Armstron

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.