TGP REMEMBER
TGP REMEMBER
It is a light weight auditing tool that provides: Who modified what and when in the DYNAMICS or companies’ databases.
It is very simple to install and gives the flexibility to indicate which tables should be included, TitaniumGP even suggests where to start, and this includes the configuration tables, exchange rates, security, master data, etc.
In a single table per database, it records each INSERT, UPDATE and DELETE instructions sent to that table where this feature is activated.
How does it work:
When a table is being activated in TGP-Remember, the process first analyzes the column structure of the table and dynamically generates a trigger that will identify and record only the values of the columns that were changed, with this, the impact in the audit table is small and very manageable, each trigger is different per table and is encrypted.
Additional Tables
To prevent to unmanaged growth, there is a feature to create and schedule a SQL Job to erase old data, where the user can indicate the limits: by the number of days or by data table size.
This feature is not limited to the default GP tables, you can include any table from a third party as long as it is in the company database.
In order to add a specific table not included in the suggestion box, you will need to know the physical name of the table, for GP Tables, please use the look up field to identify tables registered in the dictionaries.
How to review the audit information?
There are at least 3 ways to review the audit results as follows:
First
If the installation has Elastic Windows activated, the user will be able to see the changes on that particular record, for example, once a customer is presented in the Customer Maintenance window, the user can see the changes to that card in the elastic window, who modified what and when.
Second
The Audit table, can easily be added to SmartList using Smart Designer (Instructions available) where you can use the Search button to locate the desired information.
Third
Some sample SSRS reports are available to download (requires install, instructions available)
See How it Works. Learn HOW TO COPY AND PASTE Now!
What we do
We are TitaniumGP and we bring happiness to Microsoft Dynamics GP users.
With an innovative suite of productivity tools for Microsoft Dynamics GP, TitaniumGP helps companies get more done in less time by reducing manual tasks, eliminating errors, and enhancing the flexibility of Dynamics GP.
Contact Info
1041 Market St., Suite #174
San Diego, CA 92101
Phone:+1 855.238.8739
Fax:+1 860.736.8739
Email: info@titaniumgp.com
Web: https://titaniumgp.com
Recent Tweet
Reminder that #ASPIRE21 kicks off tomorrow🤩at 11am EST Don't miss out! We will be participating in the sessions and showing you what #TitaniumGP can do, as well as giving all attendees a coupon code for some exciting free features😍Get ready! We look forward to seeing you there! pic.twitter.com/LVWk63hvPa— TitaniumGP (@TitaniumGP) October 20, 2021