Ok, thanks for letting me know!
I can tell you that we don’t have any known quality issues around this. This leads me to believe you’ve either got a 3rd party coming into play, or some records that are not marked as inactive for the problem employee(s) on the backend.
Here are some scripts you can use to find any records not marked as inactive for a specific employee. Replace XXX with the employee id:
SELECT * FROM UPR00100 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 --EMLOYEE MAINTENANCE
SELECT * FROM UPR00400 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 -- EMP PAY CODES
SELECT * FROM UPR00500 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 -- EMP DEDUCTIONS
SELECT * FROM UPR00600 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 -- EMP BENEFITS
SELECT * FROM DD00100 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 --EMP DD SETUP
SELECT * FROM DD00200 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 --EMP DD ACCOUNT
SELECT * FROM UPR00700 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 --EMP STATE TAX
SELECT * FROM UPR00800 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 --EMP LOCAL TAX
SELECT * FROM UPR00200 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 --EMP TIMECARD
SELECT * FROM UPR00210 WHERE EMPLOYID = 'XXX' AND INACTIVE <> 1 --EMP TIMECARD
If these scripts return results, then not all records are actually inactive for the employee. You could test updating the records to be inactive to see if that resolves the problem.
If these scripts don’t return any results for the problem employee(s), then I recommend you start disabling 3rd parties in the Customization Status window (Microsoft Dynamics GP >> Tools >> Customize >> Customization Status). Go ahead and disable everything that is ‘not’ core GP to begin with, and test printing the W2 again. Are you getting the same error?
If the error goes away, start ‘enabling’ one 3rd party at a time to see which is causing the problem.
If the error persists when all employee records are inactive, 3rd parties are ruled out, and the employee has activity in the ‘current year’ – then I recommend you open a support case so we can assist you with digging into this further.
Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP
