Share
ReportIs 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
You’re offline. This is a read only version of the page.
356
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
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
