Skip to main content
Dynamics 365 Community / Forums / Human Resources forum / Cannot create a record...
Human Resources forum
Suggested answer

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

editSubscribe (1) ShareShare
ReportReport
Posted on by 75

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,

Categories:
  • 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
  • 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.

  • SILVIA RUIZ Profile Picture
    SILVIA RUIZ 75 on at
    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,

  • Suggested answer
    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. 

     pastedimage1657022965923v1.png

  • Suggested answer
    Charlotte X Profile Picture
    Charlotte X on at
    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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans