Sage 100

Has anyone found a way to turn off Zip code validation since it doesn't allow non US zip codes? Any good work arounds? (As of version 4.4)

Excellent question Jim, i'm very interested too. It allows the non US zips you just have to build or import them, right?

yep...But that is a LOT of extra work.....

Are you talking about in Customer/Vendor Maint? If so, what if you hid the standard Zip Code field and used a UDF instead?

That would probably be an option. That seems like a lot of extra work that shouldn't be necessary. How about a system preference that doesn't verify zip codes or at the very least warns you that the zip code isn't on file but let's you use it anyway.

Well yeah, @BrettLyder, if you want to think logically and reasonably. :)

lol, yeah...my bad! Sorry.

Could you script this on the pre-validate event, so that if there is no ZIP code, that it prompts you to add the ZIP code to the file, or does it automatically?

Hmmm. That sounds good. Can you write BOI code that would be capable of writing a new record to the zip code file in an inline script?

Are these Canadian zip codes by any chance? If so, I've the complete table of them along with a VI job, if you'd like to use it.

Thanks Moira that is AWESOME!!!, UInfortunately in my case, we have a client going international so they will be receiving orders world wide and Zip is not alway a known field. I was wondering if anyone had found a work around.

Oh - some countries have no zip code, so for that just change the tab order of the forms to go directly to the city and skip the zip. For the rest, when you type in a non-existent zip code it will ask if you want to add it, so give the user permissions to zip code maintenance. Also, I think its best to have the true international country codes on file, so I've attached that list for you. It's an easy import, but if you need a copy, let me know.

@MoiraGoggin Do you import these country codes with every new isntall?

Pretty much - I drives me nut when I see user's ""create"" their own country codes. Like BRI for Britain, which is actual GBR. This way keeps them neat and tidy.

Thanks for the codes . Although I believe if you ship international with FedEx you need the 2 digit codes (ISO-3166) Here is the file I have used in the past.

Thanks @JimWoodhead - the codes I got where ISO too, ISO 3166-1 alpha-3, didn't know FedEx uses only two.

Thanks @MoiraGoggin, pre-loading the Canadian zips will solve 95% of my zip code issues.

Holy Cow! I just looked at that file. Are there any performance issues accessing a 700k plus record zip code file?

No @BrettLyder I've not seen any issues. I've no idea why there are so many postal codes in Canada, I'm sure some of these are for areas completely uninhabited. I realized I didn't strip out the extra stuff in the other file. Here's one that is only the postal code, city, province, etc. Make sure you use the ""~"" tilde as the delimiter on the import.

Does anyone have a newer zip code table for the US? It doesn't seem as if Sage updates their table very often (if ever).

I'll get them for you @JeffSchwenk , but do you need the plus four too (i.e., #####-####)?

I think the five digit zip will suffice.

Well good, the other one is very hard to find in my price range (*free*). This one is form around 2010. I cleaned it up a bit, if you want the full file, let me know. I know you'll remember but a reminder for anyone else, if you open this in Excel it will truncate the leading zeros on the zip codes, best to open with something else.

I just imported 837,376 Canadian zip codes into my local 4.5 system. Took a little over 2.50hr. Zip Code file now has 879,249 recs (192mb). Before the import it was about 42k recs, about 10mb. In Zip Code Maint, performance seems fine: - typing in a zip code immediately brings up record - searching for a city immediately brings up records In Customer Maint, performance seems fine: - typing in a zip code immediately brings in city,state,country Now we'll have to see how this all works on the client's system (Sage 100 4.5 Adv).

The files Moira sent ware working well a the client I installed them at last March. Thanks again @MoiraGoggin

My pleasure @JeffSchwenk

Just imported those 837,376 Canadian zip codes into the client's 4.5 system. It took 3.75hr on the client's server (whereas it took about 2.50hr on my local system). Performance seems just as good as it was before the import of all these addt'l records.