You can report on employee salary changes using the IQ Report, Payroll Employee Salary Changes. This report lists rate change events, it shows when a salary or rate was modified, not what the rate was at any given point in time.
Go to Common, IQ, and locate IQB-Emp009 - Payroll Employee Salary Changes.
Import Payroll Employee Salary Changes.xml
If you can't find IQB-Emp009 - Payroll Employee Salary Changes IQ report, download and import the report following the instructions below:
Download and save the zip file to your desktop - Payroll Employee Salary Changes.zip download file
Unzip the file to your desktop.
Log into MicrOpay and select a Payroll Database.
Go to Common, IQ.
From the toolbar, select Import.
Browse to your desktop and select the Payroll Employee Salary Changes.xml and click Open.
Click Import, then click OK when the import is complete.
Run the Payroll Employee Salary Changes Report
Go to Common, IQ.
Double-click on IQB-EMP009 - Payroll Employee Salary Rate Changes.
In the Parameter screen, enter 1. Date From and 2. Date To.
Enter either 0 for false or 1 for true in Include Terminated.
Click OK to run the IQ Query.
When the IQ Query is run, the results will show in a separate grid window.
To refine the results returned, you can edit the IQ Query so that only relevant data fields are retrieved.
Note: If the report is blank, no rate changes occurred for the employees within the date range. This is expected as the report only lists when the change occurred. If you want to see what an employee's rate was at a specific period, review the rate used in a transaction.
Alternative reports
There are other reports that you can use as an alternative to the IQ.
Database Audit Log Report
You will need to have Admin access to run this report.
The report is located in Access MicrOpay Evo Administration, System Configuration. Filter the data to rate changes only by:
Selecting _iptblEmployee as Logged Tables.
Logged Fields will become available. Select the required rates.
fAutoPayAmount
fAwardRate
fDoubleRate
fNormalRate
fOtherRate
fTimeHalfRate
fYearlySalary
Database Audit Log Viewer
You will need to have Admin access to use this.
The report is located in Access MicrOpay Evo Administration, System Configuration. To view the data:
Select _iptblEmployee from Audited Tables on the left.
Enter the From Date and To Date, then click Load.
Use Field to filter the required data.
AutoPay Amount
Award Rate
Double Rate
Normal Rate
Other Rate
Time Half Rate
Yearly Salary
Employee Enquiries
Go to Payroll, Enquiries, Employee Enquiries. Select a single employee, set both the From Date and To Date to the date you want to check, and open the Rate Changes tab.