Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transaction is being edited by another user AND Item Quantities aren't completely fulfilled

    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'

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transaction is being edited by another user AND Item Quantities aren't completely fulfilled

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Transaction is being edited by another user AND Item Quantities aren't completely fulfilled

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans