When working in an employee query, one attendance field option that may be helpful to include is Attendance Remaining. We find this under the Employee summary section. When including the field though, some amounts may not display correctly or may display with a negative remaining amount.
We are currently evaluating this issue and will update this article when we have more information.
Steps to Duplicate
Steps to duplicate: 1. In Payroll > Query > add a new Employee Query 2. On the Output tab, select Employee Summary > Attendance Remaining 3. Select an attendance type and an effective as of date 4. Add Employee name to the output as well 6. On the results, some employees may appear with incorrect amounts which can be compared to the employee attendance summary on their record should be correct 7. In the Employee record, select the Attendance tab > select Attendance record from the drop down > select Summary 8. Change the date to as of [the same date in the query] and click refresh. 9. Notice the balance is correct where the query is incorrect