Menu Close

Locked Sales Transaction Entry ticket

A common error in Sales Transaction Entry is when another user has a ticket open and you get the prompt that it is locked. But who has it open. I wish GP would just tell you the user that left that order, invoice or return open but it doesn’t it. So, what to do? 

The easiest thing is to just open up enterprise manager and search out what user it is. Run these quick queries and get the user to save the ticket:

use TWO
select dex_row_id from sop10100 where sopnumbe = 'enter sopnumbe'

use tempdb
select session_id from dex_session where session_id = (select session_id from dex_lock where row_id = 'dex row id from above')

use dynamics
select userid from activity where sqlsesid = 'session_id from above'