web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Cannot create a record...
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 SILVIA RUIZ 108

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

    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

  • Suggested answer
    Dynamics365 Finance and Operations blog Profile Picture
    Dynamics365 Finance... 76 on at

    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

  • SILVIA RUIZ Profile Picture
    SILVIA RUIZ 108 on at

    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,

  • Dynamics365 Finance and Operations blog Profile Picture
    Dynamics365 Finance... 76 on at

    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.

  • Community member Profile Picture
    Community member 6 on at
    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 464 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans