Delete Company User Error

ERP 10
,
1

Version 10.2.600.9

I’m running into a problem that is preventing me from deleting a company. When I try to delete the company out via the admin console, I am getting the ‘Delete not allowed. Referenced by at least one user’ error(First screenshot). Some users have employee records, which have Labor Head records, both are preventing me from deleting the user out of the company to then proceed to delete the company out of the database(2nd and 3rd screenshots). I ran the labor purge process but I can only delete those out prior to18 months from today’s date which didn’t really help me because we still have labor records from 2020 in the database. We’ve got about 30 epicor users that are tied to employee records in the company we are trying to delete, other than manually going in one by one to delete out everything per user, is there another quick way of deleting the users and employee records with labor head records out to then delete the company?

Thanks for any ideas and help!
-B

image

image

image

2

No screenshots.

3

Ha! That would help eh? I added them and thanks for pointing that out. Oof!

4

@SpeedOfLight I think when I ran into this it was that there was still one user id with that company assigned.

5

I was able to figure this out. In the employee maintenance screen under the ‘Production Info’ tab, there is a field called ‘User Name’ that links the employee record to the epicor user, once I deleted the epicor user out and saved it, I was able to delete the epicor user. I believe this breaks the link between the Epicor User ID and the Employee ID and therefore disconnects any Labor details from the Epicor User. Since I had about 50 users to delete that was giving me the Labor Head error, I just set the DcdUserID = ‘’ in the EmpBasic table for all 50 users inside of SSMS. This cleared out the ‘User Name’ field for all of them and I was then able to delete the users, and then finally the company.

image

1 Like