10
I'm wondering if there is a report that will show all changes made for each day or selected time period in Payroll? I know the report prints up after you makes changes in a batch, but I need one for any change in the Employee section, such as W-4, Direct Deposit, addresses, taxes , etc.
*This post is locked for comments
You might take a look at the Detail Payroll Activity Tracking Tool from Microsoft. I put the URL below and the information I have on how it works. This tool is free. You can always purchase an audit trails tool and track anything you want.
mbs.microsoft.com/.../NOAM_PSTL
Employee changes will be tracked once UPRTrigger.sql has been executed against each desired company database.
Installing and setting up the Detail Payroll Activity tool
1. Extract UPRTrigger2013SP2.sql from DetailPayrollActivityTracking_2013.zip.
2. Point to Start, point to Programs, point to Microsoft SQL Server, and select Query Analyzer to open the SQL Query Analyzer program.
3. Enter appropriate login information to log into SQL Query Analyzer.
4. In SQL Query Analyzer, go to File and click Open…
5. Open the UPRTrigger.sql file that was extracted in step 1.
6. In SQL Query Analyzer, go to Query and click Change Database… to verify the appropriate company database is selected. Click OK to close the window.
7. Go to Query and click Execute to run UPRTrigger.sql.
8. Execute UPRTrigger.sql against each desired company database. Repeat step 6 to change the company database.
Using the Detail Payroll Activity Tool
1. To view employee changes, execute the following select statement against the desired company database
select * from trackPayrollChanges
2. The results can be printed, or saved and opened in another preferred program.
Within Query Analyzer the user will be able to see the following information:
-USERID
-Table Name affected
-Column name that was changed within the table
-Date and Time changed
-Old value of column affected
-New value of column affected
-Comments will show more detail on the change. For example, if a rate was changed on the SALY pay code for
-Employee ID ACKE0001, the comments would state the following: Payrate was updated for ACKE0001 for paycode SALY
The tool will track changes and additions to the tables below:
UPR00300 - Payroll Tax Information Master
UPR00900 - Payroll Employee Summary
UPR00100 - Employee Master
UPR00400 - Pay Code Master
UPR00500 - Employee Deductions
UPR00501 - Based On Pay Codes (deductions)
UPR00600 - Employee Benefits
UPR00601 - Based on Pay Codes (benefits)
UPR00700 - Employee State Taxes
UPR00800 - Employee Local Taxes
UPR00900 - Employee Summary
BE010130 - Benefits and Deductions
DD00100 - Direct Deposit Setup
DD00200 - Direct Deposit Account Setup
Kind regards,
Leslie
Share
Report
All responses (
Answers (
