I would go into Country maintenance and remove US. Then go into ZIP code maintenance and see how many US records there are. If a lot I would export the file into Excel, remove all US records, re-init the ZIP code file and import the edited file back in.

Thank you for the suggestion. I tried looking in Country Code Maintenance to delete US, but US is listed as an "Alternate Country Code" for USA.

I utilized the Excel tool Get Data > From Other Sources > From Microsoft Query and used the Sage connection to pull the SY-ZipCode table. Filtering on CountryCode for "US" yields 128 total rows. I deleted all records and saved as a csv file.

Would my next step be to import that back into Sage via the Visual Integrator?

Thanks for your help.

Thank you for the suggestion. I tried looking in Country Code Maintenance to delete US, but US is listed as an "Alternate Country Code" for USA.

I utilized the Excel tool Get Data > From Other Sources > From Microsoft Query and used the Sage connection to pull the SY-ZipCode table. Filtering on CountryCode for "US" yields 128 total rows. I deleted all records and saved as a csv file.

Would my next step be to import that back into Sage via the Visual Integrator?

Thanks for your help.

After cleaning, extracting, and backing up the .M4L file I'll be using the instructions from "https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924250017922" to update the table. 

"re-init" from BigLouie was the key I was missing. Thank you again for your help. 

Yes I was going to post that this morning. You have to manually re-int the file and then import and you are good to go