Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Bradd Notestine]

Attempting to print checks, we are suddenly receiving the following error when we hit the print button for the payroll checks. 

Found the following article which seems to be spot on but I’m having an issue identifying how many PayCodes our employees have YTD to verify this is the issue:

https://community.dynamics.com/gp/f/32/t/159923

I did find an SSRS report that I think shows me YTD paycodes by employee and I think I’ve got 8 Employees with 12 or more paycodes in 2016 YTD but I do not appear to have anyone with more than 25 paycodes YTD. 

The fix discussed in the link says to shut off YTD amounts for pay codes in Payroll Setup but this is obviously not ideal. 

Anyone got any ideas on verifying how many paycodes YTD each employee has and/or a way to fix this? 

Thanks.

——————————
Bradd Notestine
IT Manager
MPS Group, Inc.
Farmington Hills MI
——————————

[Ken Hubbard]

Hello Bradd,

No ideas on how to fix this other than the suggestion in the post. Below is a SQL script you could use to identify employees with these amounts though:

select COUNT(*) as [COUNT], EMPLOYID from UPR30301 where MTDWAGES_1 + MTDWAGES_2 + MTDWAGES_3 + MTDWAGES_4 + MTDWAGES_5 + MTDWAGES_6 + MTDWAGES_7 + MTDWAGES_8 + MTDWAGES_9 + MTDWAGES_10 + MTDWAGES_11 + MTDWAGES_12 > 0

and YEAR1 = 2016 group by EMPLOYID having COUNT(*) > 25

You will have to replace the YEAR = 2016 with the year you are working with.

——————————
Thank you,
Ken Hubbard
Microsoft Dynamics Support
————————————————————————-