Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How do I handle the er...
Microsoft Dynamics GP (Archived)

How do I handle the error user reconciling item????

(0) ShareShare
ReportReport
Posted on by CatSam 90

Please help, recently running the INVENTORY- UTILITIES-RECONCILE, that computer was powered off and now everybody is unable to work in GP. A pop-up appears "You cannot enter transactions: another user is reconciling item quantities". What should I do??????

*This post is locked for comments

  • CatSam Profile Picture
    CatSam 90 on at
    Re: How do I handle the error user reconciling item????

    We are fine now! The user initiating the process just simply had to signback on.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    Re: How do I handle the error user reconciling item????

    It is in the DYNAMICS database. It is the Batch Activity table. It sounds like you have a bogus reconcile batch.

  • CatSam Profile Picture
    CatSam 90 on at
    Re: How do I handle the error user reconciling item????

    I have checked the Application database but cannot find that table- where should this be???

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: How do I handle the error user reconciling item????

    Check if table sy00800 has record for Reconcile process.

    Select * from SY00800 where TRXSOURC='Reconcile'

    Run this query against Dynamics database.

    If record exists, delete it

    delete from SY00800 where TRXSOURC='Reconcile'

    Rubal,

    http://dynamicsgphelp.com/

  • Verified answer
    CatSam Profile Picture
    CatSam 90 on at
    Re: How do I handle the error user reconciling item????

    I have emptied all tables DEX_LOCK, DEX_SESSIONS and ACTIVITY however the error mesage is still popping up when trying to do any transaction. What's next, please?

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    Re: How do I handle the error user reconciling item????

    Try going into the SQL tempdb database and with no one in gp delete all records out of the DEX_LOCK and DEX_SESSIONS table and then go into the DYNAMCIS database and delete all records in the ACTIVITY table.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

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... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans