All values in the below examples are fictive
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')
Start Clarity and login into company you want to update.
Go to Utilities > Mass update
Close error message > Next in the Mass update window
Select the group of records > Next
Click Load query to upload the query saved earlier..
Select the file > click Open > the script is now visible in the right panel > click Next
Select the target > click Next
Select the field > Next
Select the operation, update type and enter the updated amount > click Next
Click Next
Select year > click Next
See the update > click Next
Confirm the mass update > click Finish
Review employee master pay card: Employee > master pay card > locate the pay category