How to Mass Update Employee Rates

All values in the below examples are fictitious for the following example.

Update the province and save the below script in a text file.

In the script the province is Manitoba (MB). If province is Alberta replace MB with AB. User must update tax_province, pay category, and rate.

SELECT

  [Master paycards].RATE

FROM

  EMPLOYEES Employees

  INNER JOIN EMPLOYEES_MASTER_PAYCARD [Master paycards] ON (Employees.ID = [Master paycards].ID_EMPLOYEE)

  INNER JOIN PAYROLL_CATEGORIES [Payroll categories] ON ([Master paycards].ID_PAYROLL_CATEGORY = [Payroll categories].ID)

WHERE

  ([Master paycards].[YEAR] = 2017) AND

  (Employees.TAX_PROVINCE = 'MB') AND

  ([Payroll categories].NUMBER = '102') AND

  ([Master paycards].RATE < 13.60) AND

  (Employees.STATUS = 'A')

 

How to Update:

Steps:

  1. Go to Utilities > Mass update.
  2. Close error message > Next in the Mass update window
  3. Select the group of records > Next.
  4. Click Load query to upload the query saved earlier..
  5. Select the file > click Open > the script is now visible in the right panel > click Next.
  6. Select the target > click Next.
  7. Select the field > Next.
  8. Select the operation, update type and enter the updated amount > click Next.
  9. Click Next.
  10. Select year > click Next.
  11. See the update > click Next.
  12. Confirm the mass update > click Finish.

  13. Review employee master pay card: Employee > master pay card > locate the pay category.
 
112 review(s) | Add your review