This invoice is being edited by another user
Run this script first, xxx is inv number
select PSTGSTUS, BCHSOURC, VOIDSTTS, TRXSORCE, SOPNUMBE, DEX_ROW_ID FROM SOP10100 WHERE SOPNUMBE = 'xxx'
Make note of DEX_ROW_ID
Run this script next
SELECT * FROM TEMPDB..DEX_LOCK
Find the row_id that matches the DEX_ROW_ID in the first script
Next, delete the record
DELETE TEMPDB..DEX_LOCK where session_id= 'xxx' and row_id='xxx'
Row_id is only used if there are more than one session with the same number (I use both just in case)
Should be able to get into the transaction after deleting it