web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Please help with payroll Void? -Long-Sorry!

(0) ShareShare
ReportReport
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

  • L Vail Profile Picture
    65,271 on at

    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

  • Verified answer
    Jim Robinson Profile Picture
    170 on at

    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!

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    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)

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans