Sage 100

Is it possible to add a UDF to the SY_ZipCode table?

Looks like you would need a hack.

Nope. I dont believe you can add UDFs to any system tables

Hmm, thanks @NicoleRonchetti. This customer prints a routing for their deliveries. Yes, we could go into each customer/ship-to code and select the appropriate 'quadrant' but they thought it would be easier to assign it to the zip code ""in case we change the routing"" in which case, they could simply go into Zip Code maintenance and change it there. I told them I could hard code it into the report but then they would have to let me know of any changes.

Sounds like a good time to show them a route delivery package..... I have a client that delivers six days a week and customer could be on multiple days/routes. I created a UDF in the customer master for each day of the week (validated with a UDT). Then created an SO script that assigns a SO route UDF based on the delivery date. They are happy with it.

Their's isn't that complicated. They have four drivers and they literally go through the deliveries and initial who gets what delivery. It is based on location, e.g. one driver gets the east metro area, one gets the south, etc.

UDT?

Hmm, you mean, enter in all the appropriate zip codes with the appropriate zone?? It has possibilities @WayneSchulz

Export zips out of Sage , VI into UDT. I don't think the zips should change that much.

Are they using Sales Order? Can you piggy back the change onto Shipping Rate Maintenance? It looks like it takes a UDF.