Payroll Check not in checkbook

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Brenda Willey 2,520 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Brenda Willey 2,520 on at

Like (0)

Report

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.

Was this reply helpful? Yes No