N/APosted on - 02/09/2012
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
[email protected]_ID INT
DECLARE @VCHRNMBR VARCHAR(30)
[email protected] ='00000000000000460'
[email protected]_ID = (
session_id FROM tempdb..DEX_LOCK AS DEX_LOCK (*)
PM10000 AS ['PM Transaction WORK File'] (*)
ON ['PM Transaction WORK File'].DEX_ROW_ID = DEX_LOCK.row_id
['PM Transaction WORK File'].VCHRNMBR = @VCHRNMBR
[email protected]_ID IS NOT NULL
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 [email protected]_ID)=0
DELETEFROMDYNAMICS..ACTIVITY WHERESQLSESID [email protected]_ID
Hope this may help you.
Best of luck