Best Approach to Correct Country Description in Epicor?

Kinetic ERP
,
1

Hello EpicUser,

Issue in Epicor where the system is not allowing me to change the country description in the Country Maintenance module. I would appreciate your expertise in advising on the best approach to correcting this.

Considering the situation, I’m thinking about two possible solutions:

  1. Create a New Country: Create a new country entry with the correct description and update relevant records accordingly.
  2. Updateable BAQ: Directly update the country description in the database to reflect the accurate information.

Could you kindly guide me on the preferred and more effective method between these two options, or if there is an alternative approach you would recommend?

Best Regards
Dnyanraj Patil

1 Like
2

Have you tried a uBAQ? You could also try BL-Tester or go in through Swagger to use the business objects.

3

UNLIKE practically every other record type in Epicor, the Country record type uses the Description field as its index field and thus is not changeable. Why this is so baffles me, but there you are.

Rule Number 1: Never change the database directly. Doing so can cause a world of hurt in the most unanticipated places, and it also voids your license agreement with Epicor.

Create the new country, change all your existing customers/suppliers/parts/et cetera.

1 Like
4

Hello @Ernie

My solution is the same as you said. I’m just wondering if anyone has another workaround, and I appreciate the solution’s valuable comment.

5

If you’re fine with the risk mentioned above, you can use Epicor’s Rest API (If you have access).

Go to
https://[your-domain]/[your-environment]/api/help/v1/

Navigate to “Service List: BO Namespace”
Find “Erp.BO.CountrySvc” or go directly to it by adding this to your url
odata/Erp.BO.CountrySvc/index

Use the [PATCH] /Countries({Company},{CountryNum})
Hit “Try it yourself”
enter your company and country num (you can get those using a BAQ)
input params:

{
   "Description": "<enter your new description here>"
}

Hit execute.
Should be updated now if you receive a code “204” (or any 200 code)

Please keep in mind this approach can cause a lot of damage if you don’t know what you’re doing!

6

Hello @masuphiber,

Thanks for your suggestion, as Ernie suggested that it should be an index column. I have analyzed the numerous tables that include the country description, and it is possible that this is the cause of the problem.