Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Error with Reversing Journal Entry

(0) ShareShare
ReportReport
Posted on by

We start getting the following errors when trying to do reversing journal entry... and for some odd reasons, these errors only happen when we use GP from RDS server.  If we logon the SQL server and run GP from there, everything seems to work just fine.  Please advise.

image005.jpg

image001.jpg

2072.image006.jpg

image011.jpg

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Error with Reversing Journal Entry

    Thank you so much, Richard!!  This resolved the errors.

  • Verified answer
    Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Error with Reversing Journal Entry

    I would start by having everyone exit GP and then clear the DEX_LOCK and DEX_SESSION tables. Run these scripts in SSMS.

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans