I have a customer who has entered incorrect cities and state abbreviations that are tied to zip codes. This false information keeps coming up by default when he enters the zip codes. Is there a way to change this?
I thought entering a new city and state to correspond with the correct zip code when creating a new customer would rectify this, but it again reverts to the originally and incorrectly entered zip, city, and state.
Thanks for your time.
The way this funtionality works, is it reads the first available record that matches the entered ZIP code. Therefore if you have been entering in a specific city for a certain ZIP then every time you enter that ZIP it will automatically fill in the City and State for you. But if you manually update the City or State with an incorrect value and that happens to be the first record that is returned when RMS searchs the Customer table then that is the value that RMS auto fills for you. SO in order to fix this you can run the SQL Statement below from SO Admin. UPDATE Customer SET City = 'Beverly Hills', State = 'CA' WHERE ZIP = '90210'
Rob
Ben,
Rob's suggestion if you are comfortable with SQL
OR
Run the attached Customer List Detail for the wrong zip code, double click on the Account Number and change the Zip Code and/or City.
Copy the report into your \Program Files\Microsoft Retail...\Store Op...s\Reports folder and then find it in the Custom section of the Reports menu.
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.