Sage 100

Any suggestions about how best to add missing zip codes to Sage 100?

Library Master > Setup > Zip Code Manager Or using VI > SY_Zipcode. Will that work for you?

I forgot about LM. Thanks! When was the last time Sage updated that table?

We had a client running Sage 100 Premium. We pushed rows directly into the SY_ZipCode table in SQL. It is a simple table with no foreign keys so it was straight forward and didn't seem to have any downsides to importing. Took about 15 minutes to add several hundred zip codes. (We write row to the table when importing new vendors if the zip code on the vendor address does not exist in the SY_ZipCode table before we import vendor record via VI.

Thanks, Shawn. We haven't had this issue come up in years. I think the new zips are generally in residential areas, and our customers are mainly b2b. Now we know.

You can probably get an updated listing from the PO and upload yourself. @MoiraGoggin sent me a pretty comprehensive list for Canada a couple years back. Took a while to import, but client was happy. Don't see why something like that can't be done for the US codes.

@JeffSchwenk didn't I send the US ones too? I thought I'd included both. Here's the US zips from a 2013 file I prepared. Careful not to open in Excel, unless you use a custom format, since it will strip leading zeros.

Why, yes you did @MoiraGoggin now that I dug deeper..... My bad. I just used the country codes and Canadian zip information that you sent. Included in this zipped file are the Canadian Zip, Country codes, US PO Zip and two VI imports.

@MoiraGoggin and @JeffSchwenk , thank you for sharing the zip code import list and VI job definitions. This is the spirit of sharing at it's best.

Just pay it forward.

That was a good find @JeffSchwenk - I forgot that I bundled up all those files, zip codes, country codes and sample import together. Just note @ShawnSlavin and anyone else, the VI job is just a place to get started, you may need to tweak it. Also, @JimWoodhead pointed out that the country list included in this zipped file is the 3 digit ones, he recommends the two digit ones since they are what is compatible with UPS and FedEx.

These are great. Well beyond my immediate problem, but handy for the future. Thanks, all!

I stuck them all up on the Evernote KB for future reference.

IMPORTANT: Be sure whether you need two character or three character country codes. The attached file has THREE character codes which may or may not be usable with third party systems -- ie UPS, e-commerce. Don't mix and match two and three character country codes or you will have users entering them different ways and potentially cause problems with integrations.