Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Cannot rehire past worker

Posted on by 5

Hello,

i`m trying to rehire past worker and i`m getting error, any clue why? Error below

Cannot create a record in Worker payroll information (HcmWorkerPayrollInfo). Worker: Xxx Xxx, 023. The record already exists.

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: Cannot rehire past worker

    You need to create a custom script with logic of deleting a record in the "hcmworkerpayrollinfo" table.

    Thanks,

    Girish S.

  • martinggN Profile Picture
    martinggN 5 on at
    RE: Cannot rehire past worker

    Yes, its production, delete button via table browser is grayed 

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: Cannot rehire past worker

    Hi martinggN,

    I don't know how the values are inserted into the "hcmworkerpayrollinfo" table. There is not much information available about this table.

    You can directly delete the record using table browser link.

    environment.cloudax.dynamics.com/

    If its in production or uat server you need to write a script to delete the record in the table.

    Thanks,

    Girish S.

  • martinggN Profile Picture
    martinggN 5 on at
    RE: Cannot rehire past worker

    is it possible somehow to delete it? I have no clue how its working but i see that record in that table and becasue of it i`m not able to rehire that person

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: Cannot rehire past worker

    Hi,

    Error says that rehiring worker is already there in the "HcmWorkerPayrollInfor" table. This error occurs because of unique index in the  "HcmWorkerPayrollInfor" table.

    Thanks,

    Girish S.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans