Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Update HR Status fields

Update HR Status fields

(0) Share

Report

Posted on by Community Member

Hello,

When our GP instance was set up a while back they started using the HR Status “Separated” for employees who were let go, and “Terminated” for employees who left voluntarily. This is obviously backwards and our HR department would like to flip these. So any employee who has an HR Status as Separated they would now like to have them Terminated and vice versa. Are there any issues I would need to be aware of with just a SQL Update on the UPR00100 table as well as the position history window? I'm not sure what table exactly the position history window is pulling from but I’ll find it. We would like to eliminate having to manually update all the employees through GP windows.

Thanks!

*This post is locked for comments