Automate Payroll Relationships for employees moving from hourly to salary and from salary to hourly

Summary:

Content (required):

How do you configure the system to update the payroll relationships when the employee moves from a salaried job to an hourly job and vice versa? Employees are being double paid because they have two payroll relationships on their records. Any way to configure the set up to automatically end the prior relationship based on the date the employee will be starting the new job?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):