210
So I was checking my files to prepare to print and send W2's and when I print them the SSWages and SS tax fields are blank. This is also effecting 941 reporting when I print the quarterly. In payroll my deductions occurred but they are not showing on w2 or 941 reports. Any thoughts?
*This post is locked for comments
at this point in time I am thinking that I know my withholdings are all correct, it is just the 941's and w2 that are printing incorrectly for 2016. My 2017 941 and w2s are printing correctly. Instead of wasting more time on this issue I am going to edit the w2 information to be correct for my employees and keep my notes with the w2's and 941's for future reference. on another note my Inquiry screen Deduction History 0229100 will not load. I get that Deduction History has stopped working and windows will close the program.
Nathan, sorry about the typo in my SQL command. I am starting to feel at a loss as to what your issue might be since I have clients using SL 2015 who do not have your stated issue. This is a bit of a stretch but did you uncheck the protect edited fields when you calculated W2s (just in case the system thought those fields were edited). I am not thinking this will help since the 941s did not show correctly either. The other odd fact is that I believe you stated that the earlier 941s for 2016 were correct and now, if you run them again, they are not correct. That means something in the data has changed.
I am afraid that, at this point, you will need someone to look at your data tables. Do you have a Dynamics SL partner that you work with that can do this. If not, let me know and, perhaps, I can do a remote with you to take a look.
I did that and it did not change anything on the 941 reports or to the recalculated W2. I also changed the above sql query to read FED2 as that is my deduction Id.
Run the following command:
begin transaction
update deduction set dedtype = 'I' where dedid = 'DFED2' and calyr = 2016
if it comes back with 1 record then run the following:
commit transaction
if it comes back with more than 1 record, run the following (as there must have been a typo in the fist pair of commands)
rollback transaction
Once the update is done, recalculate W2s and I suspect your issue will be resolved.
I can go into SQL
Nathan, FED2 should have a type of FICA and not Federal. The challenge now is getting it changed back to FICA assuming payroll is now in 2017 as the deduction maintenance screen only displays the current (2017) deduction values. Do you or someone there have access to SQL Management Studio? If so, we can fix this with a query.
I ran the deduction report and it listed the following for 2016
FED1 - Federal,
FED2 - Federal,
FED3 - FICA,
FED4 - FUTA,
FED5 - Federal,
FED6 - FICA,
FED7 - FICA .
Also I have found now when I create my Fed 941 reports for 2016 that the Employee Social Security Percent is defaulting to 0.0000 now when it should be 6.2000.
There is always an answer. Finding it is the challenge. Did not run the deduction type report like I suggested? If so, is it showing those deduction types as FICA? We need to start there.
I do not understand how everything could be working correctly, and then change this last month after I updated the Payroll table? If I could attach my Q1 Q2 and Q3 reports that are all correct from when I printed them earlier in the year, but suddenly now when I print them they are no longer correct? If it has to do with how deduction values are currently or were at the end of 2016 could you explain the fact that all the reports were correct, and now they are not?
Nathan, the deductions will calculate correctly for the individual payrolls and the check stub display even if they do not have the correct type as long as the other setup is correct. It is the W2 and 941 processes (the calculate that is done for those two reports) that is sensitive to the deduction type.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
