Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Tammy Bies]

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
——————————

[Charles Allen]

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

 

 

****** 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.

——Original Message——

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
——————————

[Mark Wiley]

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
——————————
——————————————-

[Tammy Bies]

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

 

——Original Message——

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
——————————

[Mark Wiley]

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
——————————
——————————————-