Open Forum

Expand all | Collapse all

Employee Card Change Audit Trail

  • 1.  Employee Card Change Audit Trail

    SILVER CONTRIBUTOR
    Posted Aug 27, 2019 02:03 PM
    GP 2016:

    Is there a way to see the audit trail for employee card changes in GP.
    Say you changed their benefits, address or W4, does GP have to history on this that you can generate a report for per pay period or ??

    Thanks
    Tammy

    ------------------------------
    Tammy Bies
    Surgical Management Professionals
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Employee Card Change Audit Trail

    TOP CONTRIBUTOR
    Posted Aug 28, 2019 01:29 AM

    Tammy,

    I just did a webinar on this very topic. https://www.bkd.com/webinar/2019/08/tracking-controlling-data-changes-dynamics-gp  

    There is a downloadable tool from Microsoft called DetailPayrollActivityTracking. It is a series of triggers that are installed on payroll tables, the Direct Deposit tables, and the HR Benefit Enrollment tables.

    If you send me an e-mail at callen@bkd.com I'll send the tool. You'll need a SQL Server admin to implement it for you. there's no default report but a SmartList can be created to view the data.

    Charles

     

     

    Charles Allen

    Senior Consulting Manager | BKD

    2700 Post Oak Blvd. Suite 1500

    Houston, TX 77056

    713.499.4629 Direct

    713.494.2104 Mobile

     

    Solver badge-7829

     

    ****** BKD, LLP Internet Email Confidentiality Footer ******

    Privileged/Confidential Information may be contained
    in this message. If you are not the addressee indicated in
    this message (or responsible for delivery of the message
    to such person), you may not copy or deliver this message to
    anyone. In such case, you should destroy this message, and
    notify us immediately. If you or your employer do not consent
    to Internet email messages of this kind, please advise us
    immediately. Opinions, conclusions and other information
    expressed in this message are not given or endorsed by my
    firm or employer unless otherwise indicated by an authorized
    representative independent of this message.

    Any tax advice contained in the body of this email was not
    intended or written to be used, and cannot be used, by the
    recipient for the purpose of avoiding penalties that may be
    imposed under the Internal Revenue Code or applicable state
    or local tax law provisions.

    These discussions and conclusions are based on the facts
    as stated and existing authorities as of the date of this
    email. Our advice could change as a result of changes in the
    applicable laws and regulations. We are under no obligation
    to update this information if such changes occur. Our advice
    is based on your unique facts and circumstances as you
    communicated them to us and should not be used or relied
    on by anyone else.



    Conference-GPUG_200x200


  • 3.  RE: Employee Card Change Audit Trail

    TOP CONTRIBUTOR
    Posted Aug 28, 2019 02:27 PM
    Hi Tammy,

    I have used that tool successfully for several clients. I usually expose the audit data it creates in a custom SmartList, using SmartList Designer or SmartList Builder.

    ------------------------------
    Mark Wiley
    Dynamics Credentialed Professional
    Senior Solutions Architect
    GraVoc
    Ohio Office
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Employee Card Change Audit Trail

    SILVER CONTRIBUTOR
    Posted Aug 28, 2019 03:07 PM

    Hi Mark;

     

    Which tool are you referring to the DetailPayrollActivityTracking that Mr. Allen was referring to or is there a smartlist already in GP for me to utilize?

     

     

    Tammy Bies

    Corporate Staff Accountant

     




    Conference-GPUG_200x200


  • 5.  RE: Employee Card Change Audit Trail

    TOP CONTRIBUTOR
    Posted Aug 28, 2019 03:21 PM
    The DetailPayrollActivityTracking tool creates a SQL table to store the records created by the triggers. For example, it will store the date and time of the change, the user ID, the before and after values, and the table and fields affected.



    ------------------------------
    Mark Wiley
    Dynamics Credentialed Professional
    Senior Solutions Architect
    GraVoc
    Ohio Office
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role