Subject: How to set up a SQL Table Audit on the ACTIVITY table to track the activity of a user logging in or out of Dynamics GP. Resolution: In order to capture a user login to Dynamics GP, you must use a SQL Table audit on the ACTIVITY Table. The...
Subject: Explains how to set Audit Group Access when the SQL Table does not exist in all companies. Information: If you have a SQL Table you want to audit but the table does not exist in all of your companies, you will need to mark access for only...
How do I write an Archive/Purge query to purge audit records older than 90 days? If todays date is 9/21/2012, you will need to use RSA_Date < '6/21/2012' There is no automated way to do this inside of Auditor currently, so someone will need to...
How do we recover our accidentally deleted audit log records and insert them into the current audit log records? The audit log records are stored in tables RSAS015 and RSAS031. Retrieve your back-up copy of those two tables that contains the...
How does Auditor compare to Great Plains' Activity Tracking? The Activity Tracking feature in Great Plains is different in its scope and purpose than Auditor. Here are the major differences. First, Activity Tracking will track failed logins and...
How long does it take to setup Auditor? The setup time is going to depend on how well the user completing the setup is familiar with the Great Plains windows/tables. The actual setup of an Audit only takes minutes. The majority of the time will...
Issue: How can you determine if the audit came from a form, table or SQL audit in Auditor? Resolution: The Audit Type field will display if the audit was a Form (Window), Table or SQL audit. You can add the Audit Type field to your Smartlist...
Issue: How do I audit Auditor's tracking setup? Resolution: Excluding the RSAS015 and RSAS031 tables since those contain actual audit results, you could audit these: RSAS001 RSAS002 RSAS003 RSAS010 RSAS011 RSAS016 - RSAS028 RSAS041 E-Sign: RSAS032...
Issue: How do I fix errors on my Auditor report relating to INSERT, UPDATE and DELETE triggers existing for the wrong database? Resolution: You will need to run the Reconcile process and Remove stranded items. Steps: Go to...
Issue: In Auditor, how do I set up an e-signature on the Void button in the Sales Transaction Entry window in Dynamics GP? Resolution: Please do the following steps: 1. While in the Signature Assignment Wizard, it will ask you to navigate to the...
