The Payment Deduction Report has been enhanced with three improvements: a new Deduction Code grouping option organizes results by deduction type with subtotals; archival data is now included alongside current data so historical deductions are no longer missing from report results; and a Person ID column has been added to the report output for easier cross-referencing.
How to Use
Running the Report with Deduction Code Grouping
Navigate to Reports, then open the Payment Deduction Report.
Enter the required parameters:
Date Type — select the date basis for the report.
Start Date — the beginning of the date range.
End Date — the end of the date range.
Name / Person ID — optionally filter by a specific employee name or ID.
In the Group By field, select one of the available options:
Office — groups results by office (existing behavior, unchanged).
Deduction Code — groups results by deduction code (new option).
None — no grouping applied (existing behavior, unchanged).
Click Run (or Generate) to produce the report.
Reading Deduction Code–Grouped Results
When Deduction Code is selected in the Group By field:
Report rows are organized into sections, one per deduction code. → Each section is labelled: Deduction Code: [Name of the Deduction Code].
At the end of each section, a subtotal row shows the total deduction amount for that code: → Label: Subtotal for Deduction Code ([Name of the Deduction Code]).
The Deduction Code column is hidden in the output — the code name is shown in the group header instead.
Notes
Archival data included: The report now returns deduction records for both active and archived employees. Historical deduction data that was previously excluded will now appear in results.
Person ID column: A Person ID column is now visible in the report output, positioned alongside the employee name. This makes it easier to cross-reference employees using their ID, consistent with the Person ID filter available in the report parameters.
Existing grouping options unchanged: Selecting Office or None in the Group By field produces results identical to the previous report behavior — no changes have been made to those modes.
Deduction codes are managed under ATM > Deduction > Transaction Code.