Error in MS Dynamics GP Transaction Entry

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #124930

Error in MS Dynamics GP Transaction Entry

qa-featured

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 = (
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
)

[email protected]_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 [email protected]_ID)=0
         DELETEFROMDYNAMICS..ACTIVITY WHERESQLSESID [email protected]_ID
   END

 

Hope this may help you.

Best of luck

Login/Register to Answer

Related Questions