RE: Having Issues Posting a Payroll Batch
Hey Jason3k,
It sounds like the user who is having a problem has stuck records. I would recommend the KB article below to clear out any stuck work records for Payroll.
learn.microsoft.com/.../errors-when-selecting-a-batch
If that does not work, clear out the Activity tables. All users should be logged out for these and should return no results when everyone is logged out.
Selects to verify if records are stuck when all users are logged out. If any returned, use the delete statements to clear out the stuck records.
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
I hope this helps!
Brandon | Microsoft support engineer.