web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Payroll Deduction Error - need troubleshooting ideas

(0) ShareShare
ReportReport
Posted on by 225

We have just run payroll on GP 10.0, and we use deduction codes for the amounts employees want deposited to various banks using direct deposit.

One deduction code (for Credit Union) is set up to deduct a fixed amount of $200.00, and for years it has been working fine, then this week GP only deducted $19.91.  

The deduction code (for the Bank) where the remaining net pay is to be deposited is set up as a "percent of net wages" and was increased by the difference of $180.09.  Here's what I have already checked:

  • Gross Pay - There is plenty of gross pay to cover this and all other deductions
  • Deduction setup - Deduction code is indeed set up for $200 (and has not changed since last payroll); deduction is active
  • Per Pay Maximum? -- There is no "maximum deduction" limit that would affect it (the maximum per pay period for this deduction code is in fact $300)
  • Sequencing? -- There does not appear to be a sequencing problem (the default sequence for the company provides the credit union deduction to be taken while there is still plenty of money remaining, and this employee is not set up to have a unique deduction sequence); I believe that the fact that the next deduction in the sequence (the bank) is increased is proof that there is plenty of money.....

Any other ideas?  I can have the employee do a manual transfer to make up the difference this time, but we need to get GP fixed for the next payroll.  All ideas welcome.

Maureen

 

 

*This post is locked for comments

I have the same question (0)
  • Brian Wick Profile Picture
    Microsoft Employee on at

    Hi Maureen,

    Thanks for your post.

    On the deduction code, does it have a Yearly or Lifetime maximum set?  I see you have $300 pay period max set, but you never said anything about a Yearly or Lifetime max.  Also verify these maximums in the Employee Deduction Maintenance window if you have not.  Many users verify the maximums at the setup level, but not at the employee card level.

    I would also encourage you to review KB 865480 as it goes over reasons why deductions are not properly taken out.

    865480 Payroll deductions are not being taken in Microsoft Dynamics GP

    mbs.microsoft.com/.../KBDisplay.aspx

    I hope this is helpful.

    Thank you,

    Brian Wick

    Microsoft Dynamics GP

  • mgmlive Profile Picture
    225 on at

    Brian,

    Good suggestions, looking at all maximums -- (pay period, yearly and lifetime) at both the employee card level and the company wide setup.  Results of that review:

    Employee level:

    • Pay period - deduction is for $200, max is $300, therefore haven't hit max.
    • Yearly - no maximum imposed.  Field is blank.  Therefore, I don't believe this shouldn't create a limitation, Correct?
    • Lifetime - no maximum imposed.  Therefore, I don't believe this shouldn't create a limitation either.

     

    Company Setup:

    • No maximum specified in the fields for pay period, yearly and lifetime maximums.

    Thanks, too, for the reference to KB 865480.  There were a couple of items in there that I hadn't come up with.

    But now, I have looked in detail at all 10 items suggested in KB 865480.  I have double-checked each against our current setup, and none seems to be the issue.

    This is truly puzzling, since this deduction code and sequence has worked for several years for this employee.  And the only recent changes are to add updated amounts for other deductions. 

    This might lead us to believe that there isn't enough net pay, but tat isn't the case:  this deduction is understated by $180 and the next in the sequence (which is based on 100% of remaining net pay) is overstated by the same amount.  That shoots the net pay issue out of the water.

    Further suggestions for fixing GP?  Or suggestions for a workaround if it happens again next payroll?  I need both a temporary and a permanent fix.  All ideas welcome, thanks!

    Maureen

     

     

  • L Vail Profile Picture
    65,271 on at

    Is the deduction still linked to the appropriate income codes? Once I had a deduction that didn't include all of the income codes and the one income code it was linked to did have enough income to satisfy the deduction even though the employee made plenty of income from other codes.

  • mgmlive Profile Picture
    225 on at

    Thanks for the idea, Leslie -- the deduction code is set up based on "All" Pay Codes.  This is true at the company level and on the Employee Deduction card.

  • Brian Wick Profile Picture
    Microsoft Employee on at

    Hi Maureen,

    Do you have a TEST company setup?  If none of the suggestions have helped resolved the issue, restore a backup of your LIVE database into the TEST company and then try a payrun in this company.  See if the issue still occurs.  You might be troubleshooting an isolated incident.  

    871973 How to set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, or SQL Server 2005

    mbs.microsoft.com/.../KBDisplay.aspx

    If the issue continues to occur, then try removing the maximum deduction limits for each pay period.  You already have it set to a fixed amount of $200.  Try another pay run.  If the issue still occurs without any maximums, then I would recommend opening a support incident so we can review the issue further.

    Thanks,

    Brian Wick

    Microsoft Dynamics GP

  • Sunil Chhabra Profile Picture
    1,958 on at

    Hi Mgmlive,

    Were you able to resolve this? I have the "same exact issue" and it started right after applying the year end tax update code.

  • mgmlive Profile Picture
    225 on at

    Hello, Sunil

    I haven't yet resolved it -- I haven't had time to go out and follow the 2/15 suggestion to create a new TEST company.

  • Sunil Chhabra Profile Picture
    1,958 on at

    FYI..  I created a test company – but I got the same “bad results”.

    I have opened a case with support,  and had them login in with me an confirm the "bad results"

    The support person then setup something similar on his "personal" machine and it seems to work correctly there.

    For us it started to occur after the year end update was installed?

    Thanks

  • mgmlive Profile Picture
    225 on at

    To confirm for you, our problems also started to occur with the first payroll after the year end update was installed.  And we have had problems with each payroll since then.

    I will have to start a support case, too.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans