News and Announcements icon

Dynamics 365 CommunityForums FastTrack for Dynamics 365 forum Reverse Historical Year

FastTrack for Dynamics 365 forum

Unanswered

Reverse Historical Year

(0) Share

Report

Report

Posted on by CU21020943-1

Cant reverse historical year in microsoft dynamics gp. It shows other users logged in system

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Ramesh Kumar 2,067 on at

Like (0)

Report

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.
Vahid Ghafarpour 7,515 Super User 2025 Season 1 on at

Like (1)

Report

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.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 232,498 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans