You’re offline. This is a read only version of the page.
1,930
We are using 2018.3 and have a rather strange issue.
We were printing W2's for employees that have been terminated in 2020 by selecting the "Pre-Year-End Inactive Employees. For a inactive employees it was working fine.
All of sudden - not sure what happened - we are getting the message "There are no inactive Employees in the Range you selected"
The strange thing is we just printed earlier the w2 for a terminated employee and we try use the same employee the above message displays.
As a matter of fact we tried with no filters for employee id so it will print W2 for all inactive employees - again the same error message?
Even if we try to print the "Validation Report" same message. We know we have many inactive employees and we print some earlier this morning.
Not sure why it stopped working all of sudden..
Please advise.
Thanks
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
Thanks Andrea - but we checked all of this. The W2's were printing one minute and then all of sudden - start getting this error message.
Hello nfpacct,
I’ve not seen that message crop up unless there really are no employees within the range you’ve selected that are inactive.
If you navigate to the Employee Maintenance window for one of these employees (Cards >> Payroll >> Employee), is the ‘Inactive’ box marked? If not, mark it and try printing the W2 again.
If the Inactive box is marked, did this employee receive any paychecks during the 2020 year?
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 (