Skip to Content
avatar image
Former Member

County taxable Wages and Income tax withheld missing on W2 Mag file for some local authorities of IN

Hello All,

When we execute the Tax Reporter (PU19) transaction for Form W-2, the local wages and tax withholding are being reported in PDF forms of Form W-2, but these amounts are not included in the Magnetic media file form under position 309-County Taxable and position 320-County Income Tax Withheld of the RS record. This is happening only for some authorities and not all.

Please refer the below screen shots for the detailed explanation of the issue:

The second page of the W2 Employee Copy form, Box 18 shows the local wages, and box 19 shows the local income withheld correctly, but the corresponding media file for the same EE is not showing the local tax withheld.

We tried to find out from where the W2 PDF form is getting these tax values. This was verified through PU19--> Display form fields-->Enter tax reporter form number-->Execute

Looking at the above screen shot, it’s clear that the County taxable wages are getting pulled out from V002/T125 tax form field and the county income tax withheld from V003/T126 tax form field.

We also checked the configuration of the magnetic media form (HR_F_MMREF_1_IN) to ensure that correct fields are mapped against 309 & 320 position.

Here the tax form fields are mapped correctly. We also tried replacing V002 by T125 and V003 by T126 however the results look same.

Below is the W2 MAG file for Indiana (executed for all employees)-

We can see that the tax amounts are missing only for some authorities and for others it’s getting generated correctly.

Please let me know if we are missing on something or ways to remediate this issue.

Regards,

Pooja J

b0wbs.png (29.3 kB)
ksnml.png (110.4 kB)
osooq.png (89.1 kB)
fgauh.png (103.5 kB)
39moi.png (41.1 kB)
khyxc.png (41.1 kB)
oiagf.png (29.6 kB)
f6chn.png (129.0 kB)
3aqap.png (308.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 15, 2016 at 09:34 AM

    The issue was resolved by maintaining the table T5UX5. Authorities for which the county taxable wages and income tax withheld were not seen were added in T5UX5 with proper customization.

    Add comment
    10|10000 characters needed characters exceeded