Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Payroll Check not in checkbook

(0) ShareShare
ReportReport
Posted on by

When balance my period end payroll I discovered my Gross Wages were off by one payroll run. Upon checking, it appears that my run posted to the GL but the checkbook did not update.  Please advise a fix for this if you have ever had this problem. I was unsuccessful in locating a resolution when I check Customer Source Knowledge Base.  Thanks in advance for your help

*This post is locked for comments

  • Brenda Willey Profile Picture
    2,520 on at
    RE: Payroll Check not in checkbook

    The checks that are not making it to the checkbook are net checks where there is a DD for a savings account and the net in a physical check.

  • Brenda Willey Profile Picture
    2,520 on at
    RE: Payroll Check not in checkbook

    I'm having the same issue only it is for random checks within a checkrun.  No consistency that I can find.   They are in the UPR30300 table but not the UPR30100 or the CM20200 or CM20100.   This is causing an issue with the safe pay file as it did not upload to the bank.

  • Community Member Profile Picture
    on at
    RE: Payroll Check not in checkbook

    I also has the same issue with two of my clients. Actually when we post the payroll, 2 tables need to be populated:

    1. UPR30100 Payroll Check History

    2. UPR30300 Payroll Transaction History

    But in our case only UPR30300 gets updated with transaction but no checks are written to UPR30100. Plus Journal entries are posted but bank did not get updated.

    Even CM20200 and CM20100 did not get updated.

    Any one please advise. This issue is happening second time with my client.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Payroll Check not in checkbook

    I assume it is too late to restore from backup? Do you have SQL knowledge? I would take a look at the CM20200 table to see if you can find these checks in there. Short of that, I would open a case with Microsoft.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans