A historical salary query will show the employee's most recent salary update, not necessarily the salary they currently have.
To create a report on historical salary information:
Click Access Button
then click HR Admin.
Click Queries then click the plus + icon.
From the first column, select Salary Details then select Salary Effective Date and Salary Amount.
Click Next then select the relevant filters.
Click Next then enter a name, description and category.
Click Options then click Show History and click Save.
📌Note: If you want to view what salary a user had at a certain point in time, you can use the As-At filter. This will return the salary that was in effect on the date selected.
Example: To see what salary users had as of 01/04/2023, apply the filter As-At to Salary Effective Date for 01/04/2023.