GP Payroll Created Two Checks Per Employee Erroneously

(0) Share

Report

Posted on by Great Plains Health...

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.

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:

Microsoft Dynamics GP

I have the same question (0)

All responses (8)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GP Payroll Created Two Checks Per Employee Erroneously

[deleted]

Was this reply helpful? Yes No
Great Plains Health... 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Great Plains Health... 30 on at

Like (0)

Report

RE: GP Payroll Created Two Checks Per Employee Erroneously

Naomi69,

Did you find the reason why it happened?

Thanks,

Vivian

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Great Plains Health... 30 on at

Like (0)

Report

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.

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

Was this reply helpful? Yes No
Hokuminaria 2,950 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Great Plains Health... 30 on at

Like (0)

Report

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.

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

Thanks!

Vivian

Was this reply helpful? Yes No