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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Exclude certain pay an...
Microsoft Dynamics GP (Archived)

Exclude certain pay and deduction codes from pay stub.

(0) ShareShare
ReportReport
Posted on by Community Member

I'm fairly experienced with report writer, but I'm having trouble finding information on how to exclude certain pay and deduction codes from showing on the pay stub.  We had to do a little work around for a HSA employer contribution we just started.  The work around involves creating a $25 pay code and $25 deduction so that we could record the HSA contribution on the employee's W2.  We don't want to show it on their pay stub because they will get a separate HSA account statement that will show it, and we figured people would be confused seeing an additional $25 pay and deduction.  So what I'm trying to do is modify the pay stub so that it doesn't show that pay code or deduction.  Any help on how that might be accomplished would be greatly appreciated.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Have you tried using a Restriction on the report to exclude the pay code and deduction?

    Leslie

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Thanks for the response Leslie.  I forgot this was still open, I can close it now.  That was the initial suggestion I got from doing research online.  It doesn't work in this instance though.  The way Dynamics creates the "pay stub" report is by pulling information from a temp UPR table that stores all the information for that given check in a single record.  Because of that if you restrict the record that has that deduction code you restrict all the information about that check and get a blank report.

    What I ended up doing to solve the issue was to create a calculated field that did a logic check and only returned information if the deduction or pay code didn't match the one I was trying to exclude.  Then replaced the "deduction code array" fields with the new calculated field.  It was a little tedious because I had to create a calculated field for each different array index(there's 12 by default) in the deduction and pay code array fields.  As well as create a calculated field to address the deduction description, amount, and year to date amount for all 12 array indexes.  It works well though. Only downside I don't like as much is that it results in blank lines on the pay stub where the HSA deduction would have been, but we can live with that.

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
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans