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


Summary


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. 

More Information


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


References


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 DetailPayrollActivityTracking.zip 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.

https://mbs.microsoft.com/partnersource/northamerica/deployment/downloads/service-packs/NOAM_PSTL




This article was TechKnowledge Document ID:34975