Detailed activity tracking tool for Payroll and Human Resource in Microsoft Dynamics GP

This article describes a tool that gives you detailed activity tracking for select payroll and human resources tables. This is a free tool available for download by Partners only. If you are a customer, you must contact your Partner to obtain this tool. 


Microsoft Business Solutions has created a tool to track detailed activity.  The tool tracks changes to some of the fields in the following tables:

  • BE010130 - Human Resource Benefit and Deductions

  • UPR00300 - Payroll Tax Master

  • UPR00900 - Payroll Employee Summary

  • UPR00100 - Payroll Employee Master

  • UPR00400 - Payroll Pay Code Master

  • UPR00500 - Payroll Employee Deduction Master

  • UPR00501 - Payroll Deductions Based on Master

  • UPR00600 - Payroll Benefit Master

  • UPR00601 - Payroll Benefit Based on Master

  • UPR00700 - Employee State Taxes

  • UPR00800 - Employee Local Taxes

  • DD00100 - Direct Deposit Employee Master

  • DD00200 - Direct Deposit Employee Account Master

Note You must run the script against the company database in SQL Server Management Studio every time that you want to view the activity.

select * from trackPayrollChanges

More Information

If you are a Partner, you can access the site below and scroll to the bottom to find the 'Additional Microsoft Dynamics GP Tools' section. The file is available for download for each version. Be sure to refer to the Word Document included in the zip file with installation, setup and more information on using this tool.

This article was TechKnowledge Document ID:34975


Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.