Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by 87

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,

  • Community member Profile Picture
    6 on at
    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
  • Dynamics365 Finance and Operations blog Profile Picture
    76 on at
    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
    87 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
    Dynamics365 Finance and Operations blog Profile Picture
    76 on at
    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
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Product updates

Dynamics 365 release plans