Link to home
Start Free TrialLog in
Avatar of doctor069
doctor069Flag for Canada

asked on

Dynamics GP - Document Is In Use

Hi -
In Cash Receipting > NSF/Void Entry I am getting the error "Document Is In Use By Other User"

All users are logged out, does anyone know how I unlock the document?

Thanks
Avatar of Victoria Yudin
Victoria Yudin
Flag of United States of America image

Make sure that all users are our of Dynamics GP and then run the following query in SQL:

delete from DYNAMICS..ACTIVITY
delete from DYNAMICS..SY00800
delete from DYNAMICS..SY00801
delete from tempdb..DEX_LOCK
delete from tempdb..DEX_SESSION

Open in new window


That should clear up any locks GP has on documents.
Avatar of doctor069

ASKER

Thanks victoria_y

I tried that but I does not seem the release the document.

select * from DYNAMICS..ACTIVITY
select * from tempdb..DEX_SESSION  
select * from tempdb..DEX_LOCK  
select * from DYNAMICS..SY00800
select * from DYNAMICS..SY00801

Returns no records....
ASKER CERTIFIED SOLUTION
Avatar of Victoria Yudin
Victoria Yudin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks -
You were correct, the issue was caused by a 3 party add on.