Missing detail record in payroll transactions

(0) Share

Report

Posted on by JBurgess

When viewing Check history, total deductions are more than the sum of deductions when looking at this check from payroll transaction inquiry window. Specifically one deduction code that is included in the summary is not show at all in the transactions.

Total is $105.43

Sum is 85.43

I've run check links and reconcile on the employee. Neither of those fixed this discrepancy. From what I can tell, there is a missing record in the UPR30300 Table for the deduction code. Without adding in records to that table manually, how could I fix this?

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (0)

Sort by

Suggested answer

Terry R Heley Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is a good find as typically those two would tie out.

If you go to Cards | Payroll | Deduction for this employee and click Summary does the month of May total out for you as you would expect? This is pulling from the UPR30301 which is the summary table to the UPR30300 where you state it is missing. This would have popped up on a reconcile report so I'm guessing it is not there?

If it is missing in both tables, we could do a manual check for the deduction which will then make it right and totals correctly.

Let me know what you find, thanks

Terry

Terry Heley | Sr. Escalation Engineer | Microsoft Dynamics

701-492-6376 (o) | 701-412-5619 (m) | theley@microsoft.com
JBurgess 74 on at

Like (0)

Report
Copy link

Link copied!

Hey Terry, thanks for the response. It appears that it's missing on the Summary as well. As the Month of May should be $40 and it's showing $20:

That being the case, I will suggest that the client does a manual check for the deduction to fix this. Can you think of any reason why this would happen, and more importantly, a way to check for additional situations like this and prevent them?

Jason
Suggested answer

Terry R Heley Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If it is missing from both, it should be fine, thanks!

Terry
JBurgess 74 on at

Like (0)

Report
Copy link

Link copied!

This same issue has happened again for the same client. What could be causing this? Anything to watch out for as far as processing goes? or a way to catch these without them finding them when looking at specific employees?