web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Employee Benefit and Deduction Code History

(0) ShareShare
ReportReport
Posted on by

I've been tasked with generating a SSRS report for audit purposes that will display change history of employee pay, benefit, and deduction codes.  The report needs to show who made the change, when, reason, current value, previous value, etc.

I was able to locate the information I need for paycodes in the HRP_Salary_History table (HRPSLH01).  However, I can't seem to locate a similar table for the benefit or deduction codes.  Does GP keep track of such changes and if so what tables should I be looking at?

We're on GP2010 SP3.  Thanks.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    The two tables that might help you are HR2BEN08 and HR2BEN10.

  • Community Member Profile Picture
    on at

    Thanks but those tables are empty for us.

  • Community Member Profile Picture
    on at

    Microsoft has a free set of SQL triggers that you can get either through CustomerSource or your Partner.

    Detail Payroll Activity Tracking Tool - it tracks changes to the following tables:

    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

    As you make changes to employee data, either in Dynamics GP or through a tool like SQL Server Management Studio, a record will be created in a custom table created when running a SQL script. The table, called TrackPayrollChanges, is in the company database.

    I know this doesn't help you for your current history, but this would help moving forward.

    You can look at the UPR30300 to see the history of the benefits and deductions as they were paid, but not why they were changed.

  • Community Member Profile Picture
    on at

    Thanks for the info.  I'll try to download and take a look at the tracking tool.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans