You’re offline. This is a read only version of the page.
175
I need to setup 3 payroll deductions that collectively cannot exceed 50% of net wages for an employee. The deduction amount needs to be reduced evenly if the net wages are not sufficient. All 3 have the same Maximum Deduction for the deductions on the employee deduction screen. I have made the 3 deductions the same sequence number for that employee. The full amount for each deduction is being withheld taking the total deduction above the maximum. I would appreciate any help to make this work. Thanks in advance
The following is the help documentation.
In the Employee Deduction Sequence window, assign the garnishments the same sequence number. In the Garnishment Maximum Setup window, define a maximum code that applies to the total of all the garnishments that have the same sequence number, and leave the Include Previously Sequenced Garnishment Deductions option unmarked. If the total of all the garnishments that have the same sequence number exceeds the maximum, the garnishments will be reduced by an even or proportional value specified in the Split Method window.
*This post is locked for comments
| deductions | amnt | pro rated | 50% of pro rated |
| GAR1 | 400 | 0.444444 | 0.222222 |
| GAR2 | 300 | 0.333333 | 0.166667 |
| GAR3 | 200 | 0.222222 | 0.111111 |
| total | 900 | 1 | 0.5 |
| deductions | max amnt | Deduction % of NDI | net wages | deduct calc | deduction taken |
| GAR1 | 400 | 0.222222 | $2,000 | $444.44 | $400.00 |
| GAR2 | 300 | 0.166667 | $2,000 | $333.33 | $300.00 |
| GAR3 | 200 | 0.111111 | $2,000 | $222.22 | $200.00 |
| deductions | max amnt | DEDUCTION % of NDI |
net wages | deduct calc | deduction taken |
| GAR1 | 400 | 0.222222 | $1,200 | $266.67 | $266.67 |
| GAR2 | 300 | 0.166667 | $1,200 | $200.00 | $200.00 |
| GAR3 | 200 | 0.111111 | $1,200 | $133.33 | $133.33 |
I have been trying this using Dynamics GP 2016 and have also had no luck. Terry Healy (Microsoft Payroll Expert) had suggested calculating the actual percentages of each deduction (instead of just 55% of net earnings, do the calculation of my deduction against the 55%) but that didn't work either. Plus, each person could have a different deduction and the customer would have many maximum IDs. Has anyone re-tested this in GP2018? I am happy to do it, but I don't have a lot of faith that it is going to work.
We couldn't get the deductions to reduce proportionally. We opened a case with Microsoft and they suggested we create Max Deduction Codes for each employee/deduction combination that has the 50% restriction. The Max Withholding Percent was calculated by dividing the individual deduction by the total of all restricted deductions and dividing that by 2. They sent a worksheet to help with that. If an employee has
Deduction 1 = $100
Deduction 2 = $70
Deduction 3 = $30
TOTAL = $200
The max deductions would be:
Deduction 1 = 100/200/2 = 25%
Deduction 2 = 70/200/2 = 17.5%
Deduction 3 = 30/200/2 = 7.5%
Unfortunately my client adds about 200 deductions a week so that would have taken quite a bit of time. I added a stored procedure to do the calculation and create the garnishment max deduction. The stored procedure is called from the employee deduction maintenance screen when the deduction is saved. They have been using it for several years. We will be testing the functionality in GP2018. Hopefully the mod will no longer be needed. Hopefully that helps!
Hi Leslie - Do you know if there has been a resolution to the multiple garnishment issue that results in deductions that exceed the maximum. We are having the same problem here. Thanks!
Hi,
If I'm understanding correctly, the sticking point is probably the 'deduction amount needs to be reduced evenly'. The Pro-rata reduction works flawlessly. Here's my example:
Our friend Pilar Ackerman has three fixed garnishments as follows
$1,000
$1,500
$2,000
Each of the garnishments is limited to 50% of earnings. Earnings is defined as gross wages minus taxes and insurance (remember, I'm making this up as I go along).
For Pilar the calculation works out thusly:
$432.69 - Salary
$-47.89 - taxes on wages
$-72.95 - insurance deduction
$311.85 - Net earnings
$155.93 - 50% of Net earnings available to satisfy garnishments.
Reducing each garnishment proportionaly would result in the following allocation:
Garn 1 $34.65
Garn 2 $51.98
Garn 3 $69.30
You do not want it split that way. What you want is to divide the available $155.93 by 3 and allocate it out that way. Each of the garnishments would get $51.98.
To accomplish this split, you would ordinarily need to choose the Even split option on the sequence window. However, when you select this option, the result is incorrect (way incorrect!).
What I've been doing is a crude work around. I let the system calculate the total amount that is available, the $155.93 in my example, and then manually do the split. I have a set of deductions I use to pop in the correct amount, and then I rebuild the checks using the new deduction codes and call it a day.
If Microsoft has provided a nice workaround, it would be great if you would share it on the forum so that others can benefit from your answer. This is a widespread problem and you could help many people by sharing your workaround with the GP community.
Kind regards,
Leslie
Hello, I have the same issue. Tested extensively and could seem to get it to work.
What did you find out?
Jim, I opened an incident with Microsoft. They provided a work around because the sequencing doesn't work or at least not for this. If you provide your email address I will email the work around.
Am having the same exact issue.
Buffy, did you get this to work yet? And if so, how?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (