I am using MS Dynamic GP with Citrix. I’ve been out for a while and leave my GP open because I attended a meeting and when I came back I tried to open a voucher with Payables Transaction Entry, but I keep seeing error that states “You cannot display this record while another user is editing it”.
How can I continue working without getting this error?
Microsoft Dynamic GP
You cannot display this record while another user is editing it.
Error in MS Dynamics GP Transaction Entry
Dear Elijah barrett
This problem happens when a user has an open transaction in payables transaction entry and left GP with no touch for a while, such as the meeting you have attended. You should have closed GP down before going away for a period. You didn't log back in and another user tried to open the invoice and so the error message occurs. Now you need to remove the lock from ACTIVITY in the system DB and DEX_LOCK & DEX_SESSION in tempdb. In the following SQL that is supposed to solve the problem, please consider changing the value @VCHRNMBR to your voucher number.
SELECT* FROM tempdb..DEX_LOCK
SELECT * FROM tempdb..DEX_SESSION
SELECT * FROM DYNAMICS..ACTIVITY
DECLARE@Session_ID INT
DECLARE @VCHRNMBR VARCHAR(30)
SET@VCHRNMBR ='00000000000000460'
SET@Session_ID = (
SELECT
session_id FROM tempdb..DEX_LOCK AS DEX_LOCK (*)
INNER JOIN
PM10000 AS ['PM Transaction WORK File'] (*)
ON ['PM Transaction WORK File'].DEX_ROW_ID = DEX_LOCK.row_id
WHERE
['PM Transaction WORK File'].VCHRNMBR = @VCHRNMBR
)
IF@Session_ID IS NOT NULL
BEGIN
DELETE FROM tempdb..DEX_LOCK WHERE session_id = @Session_ID
IF (SELECT COUNT(*) FROM tempdb..DEX_SESSION AS DEX_SESSION (*) WHERE DEX_SESSION.session_id = @Session_ID) > 0
DELETE FROM tempdb..DEX_SESSION WHERE session_id = @Session_ID
IF(SELECTCOUNT(*)FROMdynamics..ACTIVITY ASACTIVITY (*)WHEREACTIVITY.SQLSESID =@Session_ID)=0
DELETEFROMDYNAMICS..ACTIVITY WHERESQLSESID =@Session_ID
END
Hope this may help you.
Best of luck
