web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Exclude certain pay and deduction codes from pay stub.

    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.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Exclude certain pay and deduction codes from pay stub.

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

    Leslie

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans