Issue: Auditor is not tracking changes in SmartList. Causes: Cause 1: The registration keys are invalid. (See Resolution 1) Cause 2: Auditor is not installed on each client workstation (including Terminal Server workstation or Citrix workstation)...
Knowledge Base

Auditor is not tracking user login activity
Issue: Auditor is not tracking User Login even though an audit has been set up on the User Activity table. Cause: Auditor will not track User logins using a Table Audit. In order to use a Table audit, GP must be running so that Auditor may track....
Audit Non-GP Users
Subject: Explains how to track users even if they do not have a GP User ID. More Information: In order to track a user without a GP User ID, a SQL Table Audit would need to be created. A GP User would need to create the SQL Table Audit within...
Auditing views or Modified Tables Using a SQL Table Audit
Subject: Explains if you may audit Views or Modified Tables and if so, how to audit them. More Information: Views may not be used in audits, however, modified tables may be audited. In order, to audit a Modified Table, you may need to run...
Performance issues with Auditor
Subject: You are using Auditor and are wanting to know if it will affect the performance of Dynamics GP. Information: In general, performance degradation will not be an issue for most users of Auditor. Auditor has the ability to track a ton of...
An error occurred with the pass-through SQL connection. Action: TableExists(RSES_Approval_Log_MSTR, DYNAMICS) of form Rockton_Helpers
Error: When a user tries to access a window the following error message is being thrown. An error occurred with the pass-through SQL connection. Action:TableExists(RSES_Approval_Log_MSTR, DYNAMICS) of form Rockton_Helpers Resolution: Be sure that...
Information on Reference Fields in Auditor
Subject: Explain what Reference Fields are used for within Auditor and if they are audited. More Information: Reference Fields are additional pieces of information that you could see for each audit to help identify, or provide more information...
Using an E-Sign Signature to a Button on a Window
Subject: Provides information on how to assign an E-Sign signature to a button on a window. Recommendation: Certain button fields have a property called “hyperspace” enabled on them. The “hyperspace” property disables some functionality that the...
An Error Occurred Executing SQL statements. GPS Error: 10 SQL Error: 10 ODBC Error: 10 Try Reviewing the SQL Script for Validity
Error: You receive the following error message when closing the Auditor Maintenance window. An error occurred executing SQL statements. GPS Error: 10 SQL Error: 10 ODBC Error: 10 Try reviewing the SQL Script for validity. Cause: Cause 1: Product...
An error occurred with the pass-through SQL connection. Action: Initialize_SQL_Tables_MSTR
Error: During the Install/Upgrade process you receive the following message: An error occurred with the pass-through SQL connection. Action: Initialize_SQL_Tables_MSTR’ This message is followed by: ‘ODBC support codes: 54 2627 [Microsoft][SQL...