Error in MS Dynamics GP Transaction Entry

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