Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Detailed activity tracking tool for Payroll and Human Resource in Microsoft Dynamics GP

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. 

↑ Back to the top

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


↑ Back to the top

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

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 862657
Revision : 1
Created on : 1/7/2017
Published on : 12/22/2016
Exists online : False
Views : 79