You’re offline. This is a read only version of the page.
75,730
Does anyone have any SQL scripts that look for missing records in the payroll transaction tables as well as the payroll summary tables? I have a situation where the quarter end reports for 2020 Q1 do not agree with the period end report for the same period.
Hi Richard, we are not a date effective system. There is no way to see this unless they had table tracking of changes from the detailed activity tracking tool which is free to download, but they probably don't have. You could always take an OLDER back up and restore to test company and see how it looks at that time. Thanks
Terry Heley
Microsoft
I am pleading to get that case open. Can you help with this clue? I have found 13 employees who had a deduction that was incorrectly not checked as being tax sheltered. The client claims they were set correctly at one time. Is there anyway I can determine when this incorrect change was made? Can I use the UPR30100 or UPR30300 tables or some other tables?
Hi Richard,
Thank you for your update.
I would recommend creating a support case so we can look further into the specifics of this issue.
Please let me know if you have questions/concerns.
Wishing you and yours healthy and happy days ahead.
Nicole Fiskum
Support Engineer
Microsoft Dynamics GP
Any updates on this? If not, I will open a support case with Microsoft.
Nicole, I am a bit confused by this KB. How do I use these notes to find the transactions that are incorrect? Is there a script to run?
FICA/SS Tax W/H' of $0.00 <> calculated of $133.54
FICA/SS Tax W/H' of $0.00 <> calculated of $31.23
Is this saying create a script and compute what the value should be and compare it to what is on the record?
Also, on the
quarter-end report for Q1 2020 the total wages, tips and other compensation is $1,181,331.86
on the period-end report for Jan - Mar 2020 the federal wages is listed as $1,182,917.76
How do I find what is causing this difference of $1,5189.90?
This client has written only one manual check all year which they voided immediately.
Hello Richard,
Thank you for your update.
Is the numerical error you are referring to FICA/SS Tax W/H' of $[SS Tax W/H] <> calculated of $[recalculated SS Tax W/H] and FICA/MC Tax W/H' of $[MC Tax W/H] <> calculated of $[recalculated MC Tax W/H]?
If so, please see:
FICA/SS Tax W/H' of $[SS Tax W/H] <> calculated of $[recalculated SS Tax W/H]
Note Replace the placeholder [SS Tax W/H] with the social security tax withholding, and replace the placeholder [recalculated SS Tax W/H] with the calculated social security tax withholding.
This is a validation error message that prompts you to verify the accuracy for any employee who has a FICA/SS tax withheld amount that is more than the employee FICA/SS wages multiplied by the FICA/SS rate.
FICA/MC Tax W/H' of $[MC Tax W/H] <> calculated of $[recalculated MC Tax W/H]
Note Replace the placeholder [MC Tax W/H] with the FICA/Medicare tax withheld, and replace the placeholder [recalculated MC Tax W/H] with the calculated FICA/Medicare tax withholding amount.
This is a validation error message that prompts you to verify the accuracy for any employee who has a FICA/Medicare tax withheld amount that is more than the employee FICA/Medicare Wages multiplied by the FICA/Medicare rate.
These were found in Description of the errors or warnings that may appear on the Payroll Validation report in Payroll in Microsoft Dynamics GP
I hope this helps. Please let me know if it does not or if you have any other questions/concerns.
Wishing you and yours healthy and happy days ahead!
Nicole Fiskum
Support Engineer
Microsoft Dynamics GP
Nicole, the W2-Validation report yields these errors. What should I do about the numerical errors?
Terry shared this note with me this morning. I am now beginning the arduous task of finding what is causing the differences. I will keep you posted on my progress.
Hi Richard,
Thank you for your post.
I believe that Terry's blog My 941 does not match my payroll summary, tell me WHY? may be of help here. Could you check it out and let us know if you still have questions/concerns?
I look forward to your feedback when available.
Wishing you and yours healthy and happy days ahead.
Nicole Fiskum
Support Engineer
Microsoft Dynamics GP
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (