Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

GP Payroll Created Two Checks Per Employee Erroneously

Posted on by 30

Hello,

Has anyone experienced the Dynamics GP Payroll system generating two checks per employee when posting payroll?  Please see screenshot below where you can see the one Audit Trail Code (UPRCC00000035) and two Check Numbers (DD4129 and DD4130) for the exact same amount.  We've seen this occur 2 times recently for 2 different companies.  It's been a pain to clean-up.

pastedimage1678300798843v1.png

If you have run into this problem, what causes it?  I'd sure like to know how to prevent this from happening.

Thanks!

Vivian Dietz

Great Plains Health Alliance

Categories:
  • RE: GP Payroll Created Two Checks Per Employee Erroneously

    Hi Brandon,

    When this occurred, I asked the payroll clerk if she received any errors or messages, and she said no.  You mentioned "it is not recommended to just continue with current batch as you likely have stuck records".  How will the user not continue with current batch?  Do they get a message of some sort?  How will the user know not to continue?

    The only "batches" in GP Payroll are the ones you select in Build Payroll Checks so I am wondering what you are referring to when you say "not to continue with current batch".  Please see screenshot below where the user selects the batches to process.

    pastedimage1678736838025v1.png

    I would like to make the users aware of what they should do/not do if this occurs.

    Thanks!

    Vivian

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: GP Payroll Created Two Checks Per Employee Erroneously

    Hey All,

    These should be cleared after the posting. Likely what happened is there was an interruption during the check run and it was processed a second time. This is the most common thing we see when this happens.

    Anytime there is an issue with a check run, it is not recommended to just continue with the current batch as you likely have stuck records and will have incorrect checks. We recommend you create a support case if you have never been through a Payroll Check Run interruption so the interrupted records can be cleaned up before it is attempted to be processed again.

    Thank you!

    Brandon | Microsoft Support Engineer.

  • RE: GP Payroll Created Two Checks Per Employee Erroneously

    Richard,

    The system did create 2 separate check numbers with the exact same amounts.

    The GL batch was fine, but the Checkbook posting entry doubled.  See screenshot below in the Payments where it is doubled the amount of the Deposit amount.

    pastedimage1678389301243v1.png

    Thanks for the tables that should be empty prior to each payroll run.  The thing is we have 23 hospital databases so to check these before each payroll clerk processes would be somewhat difficult.

    I appreciate your input.

    Vivian

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP Payroll Created Two Checks Per Employee Erroneously

    I have never seen this before but not clearing the work tables can have unexpected results. I would have expected two checks per employee with different check numbers. In the resulting ledger batches were the checks duplicated there as well? Here is a list of the payroll work tables. They should be empty prior to each pay run.

    UPR10300

    UPR10304

    UPR10200

    UPR10201

    UPR10202

    UPR10203

    UPR10204

    UPR10205

    UPR10206

    UPR10207

    UPR10208

    UPR10209

    UPR10213

    UPR10301

    UPR19900

    UPR19901

    DD10100

    DD10200 --(Direct Deposit ACH Copy)

    DD10300 --(Direct Deposit ACH Cross Reference)

    DD10400 --(Direct Deposit ACH Header)

    DD10500 --(Direct Deposit ACH Items)

    DD10600 --(Direct Deposit Prenotes Completed)

    DD10700 --(Direct Deposit Exceptions)

  • RE: GP Payroll Created Two Checks Per Employee Erroneously

    Naomi69,

    Did you find the reason why it happened?

    Thanks,

    Vivian

  • RE: GP Payroll Created Two Checks Per Employee Erroneously

    Richard,

    This occurred on ALL employees.  Have you seen this happen when the payroll work tables weren't cleared?  How can this be prevented?

    One theory is the user somehow clicked on Process twice during the posting step.  I'm not sure how that could happen unless there was disconnection of sort but I think the system would "queue" the job being processed if the user clicked Process once and there was loss of connectivity without allowing the user to be able to click on Process again.

    What are your thoughts?

    Thanks,

    Vivian

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP Payroll Created Two Checks Per Employee Erroneously
    [deleted]
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP Payroll Created Two Checks Per Employee Erroneously

    Did it do this for all employees or just this one? Sounds like the payroll work tables did not get cleared from the previous pay run.

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

Product updates

Dynamics 365 release plans