Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Having Issues Posting a Payroll Batch

(0) ShareShare
ReportReport
Posted on by 15

My accountant was trying to post a payroll batch and got the following error:

The batch cannot be posted.  Close the Manual Checks window to print posting journals.

The Manual Checks window was not open and her assistant can post the batch successfully.

Categories:
  • Hokuminaria Profile Picture
    2,950 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,850 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans