We are hosted, single tentant running 10.2.0.41.
I need to find a way to change an Epicor Employee ID from a 3 digit code to a 4 digit code so it matches what is in our external Payroll system. I was able to do that, but unfortunately the Employee history does not transferring to the new record and we need it to.
What I did to change the record:
-
Had to x out the Social Security Number field on the original record because Epicor was throwing a “duplicate Social Security number” error.
-
Checked Inactivate for the Old 3 digit ID for this employee.
-
Created a new “4 digit” employee ID and record that was exactly the same as the original.
-
Had to create and link a new person/contact because I could not disconnect and reconnect the existing contact to the New one.
All of the above seemed to work, but the employee’s “history” did not follow the new record. When I submitted a ticket with EMS for help, they are saying:
“The changes described on this request would entail creating a data fix, which the custom solutions group is not able to create today. The reason is that modifying the data as described would require to override the pre established business logic, which might get the system on state where data integrity is compromised. As such, the CSG cannot assist with creating such a solution.”
Was hoping with the coding guru’s out here, someone might have ran across a similar situation and have a suggestion on how it could be done. Seems to me a fix via SQL could resolve this, but I don’t have access to that in a hosted situation as far as I know (I am a little new to this sort of environment). Any suggestions on how to change the ID and retain history would be greatly appreciated. Thanks!
Becky