Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Payroll Printing 2020 W2 before closing the year

Posted on by 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

  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Payroll Printing 2020 W2 before closing the year

    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

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    RE: Payroll Printing 2020 W2 before closing the year

    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.

  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Payroll Printing 2020 W2 before closing the year

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans