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
Steps:.
- 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
...
- .