Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : NF8AyHFowoB8giCm5Xbk7g
Dynamics 365 Community / Forums / FastTrack for Dynamics 365 forum / Reverse Historical Year
FastTrack for Dynamics 365 forum
Unanswered

Reverse Historical Year

Like (0) ShareShare
ReportReport
Posted on 21 Feb 2025 09:45:17 by CU21020943-1
Cant reverse historical year in microsoft dynamics gp. It shows other users logged in system
Categories:
Other
  • Ramesh Kumar Profile Picture
    Ramesh Kumar 2,003 on 24 Mar 2025 at 18:36:40
    Reverse Historical Year
    You should ask your DBA admin to suppress the user session if it's stuck, and then delete it from SY000801
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • VaHiX Profile Picture
    VaHiX 7,200 Super User 2025 Season 1 on 27 Feb 2025 at 02:14:25
    Reverse Historical Year

    Sometimes, user sessions can get stuck. You can remove these sessions by running the following SQL query against the DYNAMICS database:

    DELETE FROM ACTIVITY
    DELETE FROM SY00800
    DELETE FROM SY00801
     

    This will clear out any stuck user sessions.

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,333 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,311 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans