Announcements
No record found.
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
In SSMS, SELECT * FROM DYNAMICS..SY01500 and there will a list user plus login date per company.
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.
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 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
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
Perfect, just what I needed.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
