Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Determine last date of use for a Company

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Determine last date of use for a Company

    Perfect, just what I needed.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Determine last date of use for a Company

    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

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Determine last date of use for a Company

    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:

    1. Login/Logout Tracking:
    2. Access Tracking
    3. Process Tracking
    4. File Tracking
    5. Posting Tracking

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Determine last date of use for a 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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Determine last date of use for a 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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Determine last date of use for a Company

    In SSMS, SELECT * FROM DYNAMICS..SY01500 and  there will a list user plus login date per company.

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.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans