Cannot create a record in Employment Id constraint (HCM Employmentidconstraint) The record already exist

(1) Share

Report

Posted on by SILVIA RUIZ

Hello! When I try to create a new employee I have the message "Cannot create a record in Employment Id constraint (HCM Employmentidconstraint) The record already exist" and I can´t find what is causing this problem because the employee doesn´t exist yet.

The data is very basic: Name, Last name, ID number, employment date and position

Thanks in advance on any comment or sugestion in this case

Regards,

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Charlotte X on at

Like (0)

Report

RE: Cannot create a record in Employment Id constraint (HCM Employmentidconstraint) The record already exist

Hi SILVIA RUIZ,

The question mentioned in this thread is very similar to yours, and its answer is verified and may also solve your problem.

Error :Cannot create a record in . The record already exists In D365 Finance and Operations - Dynamics 365 Finance Forum Community Forum

Best Regards,

Charlotte Xu

Was this reply helpful? Yes No
Suggested answer

Dynamics365 Finance... 76 on at

Like (2)

Report

RE: Cannot create a record in Employment Id constraint (HCM Employmentidconstraint) The record already exist

Hi SILVIA RUIZ,

Please make sure that you are not creating a duplicate Employee ID. If personnel number is set to auto-generated based number sequence you will need to check the number sequence settings.

Was this reply helpful? Yes No
SILVIA RUIZ 87 on at

Like (0)

Report

RE: Cannot create a record in Employment Id constraint (HCM Employmentidconstraint) The record already exist

Hi

The sequence number is not set to auto generate, is set to Manual, so I am sure the ID doesn´t exist

Thanks anyway

Kind regards,

Was this reply helpful? Yes No
Dynamics365 Finance... 76 on at

Like (0)

Report

RE: Cannot create a record in Employment Id constraint (HCM Employmentidconstraint) The record already exist

If some orphan records exist then number sequence status list may help even in this case too. But could you please confirm by filtering employee id on workers list page in Human resource management.

Was this reply helpful? Yes No
Community member 6 on at

Like (0)

Report

Cannot create a record in Employment Id constraint (HCM Employmentidconstraint) The record already exist

Hi any update on how this was resolved? I am experiencing the same issue and have run the steps below with no luck on being able to resolve. Mine is also a manual number sequence

Was this reply helpful? Yes No