Changing a country name that is being 'used'

To meet the new UN agreed designation of Turkey as now Turkiye I have been looking at how to change this in Epicor.

Not as trivial as one might think.
I tried a UBAQ to edit the description field in the Country table, but this is only part of the ‘story’
There are plenty of tables where the country name Erp.Country.Description is copied into another table field. For example; Erp.Customer.Country.

1 Like

I wonder if creating a new country and then updating countynum on any related tables would be cleaner?

You should try contacting Tech Support. They may have a tool that will help to properly fix the Country table. As for any other tables that store the description, that legacy data (what I am calling teh data that happened before the change) would stay the same unless you forced a change (much like the Part Description in a sales order doesnt change when you change the part description in the part table).
But I would think that you would not need to change the old orders for Turkiye, but only active/new orders, invoices, etc.

Country and CountryNum are often both stored in tables for some reason. I’m surprised that because there is a numeric key behind the actual country that the name is not serviceable by default.

1 Like

yes, and not only that, the Country table has been my nemesis for years… when setting up a multi-company environment, that shares customers, you need to make sure that all the COUNTRY tables are 100% matched across all companies, or your data gets skewered. Since the Country NUMBERS are Automatically assigned in the sequence you add the country, you have to be very careful.

3 Likes

Out of curiosity why aren’t these maintained by Epicor as a global. They are what they are why are we required to even enter them manually at all?

1 Like

Blockquote
yes, and not only that, the Country table has been my nemesis for years… when setting up a multi-company environment, that shares customers, you need to make sure that all the COUNTRY tables are 100% matched across all companies, or your data gets skewered. Since the Country NUMBERS are Automatically assigned in the sequence you add the country, you have to be very careful.

Yup, found that out the hard way once.

1 Like

For our setup, we were told Avatax requires the country’s two-letter ISO code in the description field (I don’t know if that’s true, but that’s what we were told), so that’s what we did. (That’s how our previous ERP was set up too, anyway, so that made data migration easier.) I’ve recently added a separate Country.LongDescription_c UD field as they want the actual name of the country visible and updateable and translatable for our European branch we’re adding to Epicor. Then it was mostly just a matter of adding a customization to several forms to change the display member of any country combo box, and force-refresh the combo box right after loading. We’ll probably deploy this for our other companies in Epicor, too, because having the name of the country looks a lot better.

1 Like

It is curious why there is a per-company country table… perhaps future-proofed against the discovery other inhabited planets or alternate universes?
:smiley:

I think the idea is that you don’t have to put every country in the world in the Country table. You could just put the countries you do business with. Then if you have multiple companies that only do business with certain countries, they would use different Country tables. I think the only time that doesn’t work is when using intercompany processes, in which case all involved companies will need to have the exact same countries in the same order (same Country.CountryNum and Country.Description at least, probably). But I think you could still have another company/other companies not using intercompany processes with a different Country table.

Maybe a better question is, “Why isn’t there a separate GlbCountry table for intercompany processes like there is for every other table?”