Sage 100

Customer on Sage 100 ERP Standard v4.4 - has 3 character country codes setup. Wants to change them to be 2 characters. They've manually added the 2 character country codes. I can import to AR_Customer to set the new 2 character code. I'm sure the question will come up about: a. Can they delete from Country Code Maintenance - the old 3 character codes My opinion = no because those codes are also in history b. If not - how to keep employees from using the old three character codes? My opinion = probably scripting Any other viewpoints?

You can also change the country description on the 3-letter codes. CAN Canada - DO NOT USE !!!

How about preceding the Phone Code field with an X, and filtering those records out of the ALE? It won't prevent someone from using it, but they won't see it as a choice. Otherwise you can still do the X and let the script reject it.

So many good ideas!

You can delete country codes even if they are in history in my opion. I just did to migrade someone on to CRM and country codes were setup all over the place. If they print country on the invoices then maybe not but if they do not I see no big deal. Do they use CRM - there is mapping going on. Also do not forget to fix AR_CustomerContacts and SO_ShipToaddress along with Warehouse maintenance and PO ship to addresses.

The x won't work in the Phone Code field (it's looking for numeric values). Maybe an X at end of country name?

I decided to keep mine, as some web stores use 2 digit county codes while others use 3 digits. Can't win.

Here's a list - thanks @JohnnyPabian - that I pulled together of where I think the country code also needs to be changed (probably not as much an issue leaving these as-is if the customer leaves the old 3 character codes in place) AR_CustomerContacts AR Salesperson SO_ShipToaddress Warehouse maintenance PO ship to addresses AP Vendor Contacts

One of the things I have started doing is to import the three digit country code file that Moira provided a while back for new installs. The minimized the amount of data entry that the client has to do which goes a long way in keeping data consistent..... and if they do business in Canada, I import the Canadian zip codes compliments of Moira.......

Potential additions to the list: Vendor Maintenance (AP_Vendor) Bank Code Maintenance (GL_Bank) RMA Return To Address Maintenance ( RA_ReturnToAddressCode)