You’re offline. This is a read only version of the page.
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 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'
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
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.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
