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
...
(Employees.STATUS = 'A')
Start Clarity and login into company you want to 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