SOP locked by other user

[susantor]

Can somebody tell me which table and field tells us the SOP doc and item transaction document is being edited by other user?

How GP knows which SOP doc and item transaction document is being opened by other user?

Any help will be greatly appreciated.

Thank you.

 

[klewis10367]

Take a look in the SY00800 table in the company database.

 

[GPGuy]

We have GP8 and sometimes a user account will not log out properly and release any locks. Try running the following Query from your company database:

-- RUN THIS QUERY TO VIEW ANY SALES TRANSACTION LOCKS
SELECT     tempdb.dbo.DEX_LOCK.table_path_name, master.dbo.sysprocesses.loginame, dbo.SOP10100.SOPNUMBE, dbo.SOP10100.CUSTNMBR
FROM         tempdb.dbo.DEX_LOCK LEFT OUTER JOIN
                      dbo.SOP10100 ON tempdb.dbo.DEX_LOCK.row_id = dbo.SOP10100.DEX_ROW_ID LEFT OUTER JOIN
                      tempdb.dbo.DEX_SESSION ON tempdb.dbo.DEX_LOCK.session_id = tempdb.dbo.DEX_SESSION.session_id LEFT OUTER JOIN
                      master.dbo.sysprocesses ON master.dbo.sysprocesses.spid = tempdb.dbo.DEX_SESSION.sqlsvr_spid