Dynamics GP transaction will not post

Dynamics GP transaction will not post

One of our clients called for assistance with a receivables batch which refused to post. GP did not return any error messages, and the user had sufficient permissions to post this batch. The DYNSA user was able to post this batch in the test company, but not in the live company. When posting was attempted GP briefly displayed the posting status window and returned to the batch entry window without making any changes.

No errors were found in the dex_sql log or a SQL trace…. but there was a lock on the PM10000 table held by another user. Once this user logged out of GP, the DEX_LOCK table cleared and the batch posted successfully.

You can use the following SQL command to view the list of active GP users, and any locks held at the time you run this query:

SELECT
A.USERID
, A.CMPNYNAM
, A.SQLSESID
, L.session_id
, L.row_id
, L.table_path_name
FROM DYNAMICS..ACTIVITY A
LEFT JOIN tempdb..DEX_LOCK L
ON A.SQLSESID = L.session_id
ORDER BY SQLSESID;

Try having any users with a lock close all windows, and if the lock persists, have them log out of GP.