This query will list funding used for all payroll earnings as well as taxes and deductions which make up the gross-to-net calculations. Please note that the users will have to calculate the summary of Gross/Ded/Net when the output has been downloaded to Excel. To that end, all lines will be formatted the same in the output.
- PY Batch Processor
- PY Payroll Operations
- PY Payroll Processing
To perform this procedure, please follow these steps:
- Navigation: Reporting Tools > Query > Query Viewer
- Type "UW_PY_VOUCHER_DEPTID" in the search box. Click Search
- From the search results find the Payroll Voucher Report by Dept and select Excel in the Run to Excel column.
- A new window will open. Enter the desired search terms and click View Results.
- Both fields are required in order to return results, but entering a % will return all possible values for that field.
- A prompt will appear asking whether you want to open or save the Excel file. Click Open unless you want to save your results to view at a later time.
- An excel file will open containing the query results.