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