Index 0 of array ‘Pay YTD Array’ is out of range in script

  • Index 0 of array ‘Pay YTD Array’ is out of range in script

    Posted by Bradd Notestine on December 21, 2016 at 2:10 pm
    • Bradd Notestine

      Member

      December 21, 2016 at 2:10 PM

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

      j6G96HlJQR6hkzS2FFcK_pr-error.png

      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

      Member

      December 29, 2016 at 9:36 AM

      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
      ————————————————————————-

    Bradd Notestine replied 7 years, 7 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Index 0 of array ‘Pay YTD Array’ is out of range in script’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!