You’re offline. This is a read only version of the page.
170
I just discovered a very strange occurrence after voiding a payroll check. GP10 (latest SP)...
We had a check with no wages but two business expenses, we were reimbursing someone for. In the same check, we were also deducting, some type of advance we had given him. (for less than the total of the two reimbursements). So no tax implications anywhere. For whatever reason, we needed to void this check. At first glance it looked like all was fine and it everything reversed properly. However, if we run the Reprint Check Post Report. There is an additonal line... an additional debit amount ($60.00), same as the deduction being reversed, and it's being thrown to Account index 0. The real problem is, that every payroll we've run since, shows this amount on the reprint check post report and there is a new line being created in the UPR30401 table (PR Hist Dist Detail), each time we run payroll. This started in December, and it's gone on since then, across the year end, etc. When I recently looked in the table, there was about 15 lines with an acct index of 0, and the same amount of 60.00. I have been able to reproduce the error, and have tried removing history for these transactions (in a test database), but everytime I run a new payroll, I'm still getting a new line in the table going to actindex 0, and it shows on the reprint report.
Sorry for the length, but this was too long and complicated to get in CS, although I've been researching endlessly.
Thanks for any help,
Jim R
*This post is locked for comments
These are the payroll work tables that should be empty after every payrun. Perhaps something has gotten stuck in one of them.
Delete DYNAMICS..UPR10300
Delete DYNAMICS..UPR10304
Delete UPR10200
Delete UPR10201
Delete UPR10202
Delete UPR10203
Delete UPR10204
Delete UPR10205
Delete UPR10206
Delete UPR10207
Delete UPR10208
Delete UPR10209
Delete UPR10213
Delete UPR10301
Delete UPR19900
Delete UPR19901
Direct Deposit
Delete DD10100 --(Direct Deposit Employee Deposit Work)
Delete DD10200 --(Direct Deposit ACH Copy)
Delete DD10300 --(Direct Deposit ACH Cross Reference)
Delete DD10400 --(Direct Deposit ACH Header) - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file.)
Delete DD10500 --(Direct Deposit ACH Items) - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file.)
Delete DD10600 --(Direct Deposit Prenotes Completed)
Delete DD10700 --(Direct Deposit Exceptions)
Hi Leslie: Thanks for getting back. I had checked a lot of these tables, but you got me thinking again, there had to be a record stuck somewhere. So I started going through them. It turned out the table UPR10209 - "Payroll Work Post" which I hadn't looked at, but seemed to be part of the saved "builds" - was holding one record with an actindx of 0. Once I deleted, I had to recreate the builds, but all is now fine!... Thanks so much for your help! Jim Robinson
PS: 2 tables on the list, that I didn't think were a good idea to delete was UPR00100 and UPR41200. The first is the employee master, and the second is the employee classes. Every record in these tables had an actindx of 0, but I think this is normal!
Hi,
I've tried to post this multiple times so I apologize if they all show up at once. My answer keeps getting shorter :)
Back everything up and try this in test. Delete every record from any of your UPR tables that contain the column ACTINDX with a value of zero. in my database, the following UPR tables contain a column named ACTINDX
UPR00100
UPR10202
UPR10209
UPR10310
UPR10400
UPR19900
UPR19901
UPR30401
UPR40500
UPR41200
UPRA0100
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,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (