Notifications
Announcements
No record found.
Is there a field updated with the GP User ID when that user makes any change (including a new entry), to an employee's e-mail address?
*This post is locked for comments
Michael,
There are a few ways you can tackle this.
1. If you are looking for a Dexterity based solution to do this, you can check Audit Trails from Merit Solutions. This product was formerly OEM'd by Microsoft for quite some time before they returned it to Merit.
www.meritsolutions.com/.../microsoft-dynamics-gp-risk-management-suite
2. You can write a simple SQL Server trigger on the SY01200 table and write any changes or additions to the INET1, EmailToAddress, EmailCcAddress, or EmailBccAddress columns. Your trigger would then write the values prior to the change to a table with the user who changed them. You can also make it write the new values so you can have both sets of changes.
3. You can enable SQL Server Track Changes on that table. More information here docs.microsoft.com/.../about-change-tracking-sql-server
Thank you for such a comprehensive response.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
