I have an old company in GP that hasn't been used in years; is there a way to check and see when the last activity in there was?
*This post is locked for comments
Perfect, just what I needed.
By "last activity", do you mean the last transaction posted? If so, perhaps you can just check the GL table(s) for the latest journal entry?
select max(TRXDATE) Last_Open_Trx from GL20000
select max(TRXDATE) Last_Historical_Trx from GL30000 --historical years
I am hoping since it's an old company, there are no unposted transactions, but if you think there may be, you can also check the unposted table:
select max(TRXDATE) Last_Unposted_Trx from GL10000
I believe Dynamics GP Activity Tracking is what you may be looking for, when this feature is "activated", you will get a detailed report for all the processes that are being performed on the company including the following:
Check this out for further illustration on how to set it up, Dynamics GP Activity Tracking
Data for activity tracking is stored in SY05000, as well, there is a system inquiry if you want to check the data on the application level, rather than the db. To go to the inquiry, go to Inquiry > System > Activity Tracking
There is an auditing module for that for GP. This is also an add-on from Merit and Rockton but these would be separate purchases. Have you asked your reseller for pricing on the auditing module?
I'm not sure that's what I want...that only gives me a list of who changed something in the company information, not who would have changed any data inside the company.
In SSMS, SELECT * FROM DYNAMICS..SY01500 and there will a list user plus login date per company.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156