Sage 100

Is there no way to add UDF's to the System tables in Sage 100 Advanced? Need to add a Region Code to the Country and Zip Code Tables. TIA

What is the purpose of the region code? Would it be easier just to add a region UDF to what ever table you are trying to populate?

Already added the Region code to the customer master file. They want to minimize data entry and increase accuracy by having the Region Code automatically populate when a country is entered for a new customer. They do a lot of international shipping

How about a script?

That was the idea. But i need to match the country to a region first. I was going to add a region UDF to country table. I guess it will have to be a UDT

How about a UDT and script?

Diane, I guess it will have to be a UDT since I see no way of adding UDF's to the country or zip code tables. Thank you.

Well, at least the good news is that you can export the country codes into Excel then import into the UDT. A script will make it painless to the client.