Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Please help with payroll Void? -Long-Sorry!

Posted on by 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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Please help with payroll Void? -Long-Sorry!

    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)

  • Verified answer
    Jim Robinson Profile Picture
    Jim Robinson 170 on at
    Re: Please help with payroll Void? -Long-Sorry!

    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!

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Please help with payroll Void? -Long-Sorry!

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans