25
I am in need of a report for the AP Audit trail to give me information as to when and who changed vendor profile information.
Thank you for your prompt response.
*This post is locked for comments
Donna --
Each Solomon standard table has six fields: crtd_user, crtd_datetime, crtd_prog, lupd_user, lupd_datetime, and lupd_prog. The first three tell who, when and how (what screen or process) the record was originally created, the second three tell who, when and how the record was last updated. Other than that, there is no tracking history. This means if two people updated a record on the same day, you would only see the second name. Also, it doesn't tell you what the person actually changed.
But if all you need is when and who changed vendor profile information, the lupd_user and lupd_datetime of the vendor table should give you what you need. The report could be created in Crystal by your system administrator.
Tracy --
Unfortunately, I don't know anything about GP.
Donna, I'm looking for the same type report for GP. Were you ever able to find anything that worked for you?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (