web
You’re offline. This is a read only version of the page.
close
Skip to main content

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) / Transaction is being e...
Microsoft Dynamics GP (Archived)

Transaction is being edited by another user AND Item Quantities aren't completely fulfilled

(0) ShareShare
ReportReport
Posted on by Alicia Berglund 1,144

I have two invoices that are in 2 separate SOP batches.  When attempting to select these transactions I receive the error 'This transaction is being edited by another user'.  When I look at the batch edit list the transactions have line errors 'Item Quantities aren't completely fulfilled'.  I looked in the SY00800 and SY00801.  Found one of the transactions in question but not the other.  Not sure article ID 866440 is the fix for this. http://support.microsoft.com/kb/866440

Any guidance would be appreciated.

Thanks!

Alicia

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    You have two issues here. First, if you get everyone out of GP you can clear these tables:

    DELETE DYNAMICS..ACTIVITY

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB_DEX_SESSION

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    You should them be able to access this sales order and then you will need to allocate and fulfill the lines on this order.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Richard is correct, once the records get unlocked you can update the sales order.  David Musgrave has a script that can release the transactions without having to get everyone out of the system:

    blogs.msdn.com/.../releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx

    Please read the entire blog before executing the script.

    Terry

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I know this is an old post, but I found a very easy method.

    Find the Dexterity number by running:

    SELECT * from SOP10100 where SOPNUMBE = 'ORDxxxxxxx'

    Then run:

    SELECT * FROM TEMPDB..DEX_LOCK

    Goto the results and find the dexterity number in the “row_id” column.

    Get the “session_id” number from the row you find it in.

    Run:

    DELETE TEMPDB..DEX_LOCK where session_id= 'xxxxx'

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans