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
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.
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (