Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Update HR Status fields

(0) ShareShare
ReportReport
Posted on by

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

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 >

Featured topics

Product updates

Dynamics 365 release plans