I'm trying to fix an employee deduction card. The tax shelter status is not set to true and should be. When you try to change it, you get "Activity exists fro this code. The tax status cannot be changed."
*This post is locked for comments
I know this is an old post but I'm trying to find some help on this same issue. From what I've seen, manual adjustments are required even after making the changes to the table. What manual adjustments did you have to make after making these changes, if you had any?
Perfect!! That is exactly what I needed.
Thanks!!!
Hi Barry,
Three points in response if I may:
So if you are in GP2013 or later, it would be this:
Share
Report
All responses (
Answers (
update UPR00500
set TXSHANTY=1, SFRFEDTX=1,SHFRFICA=1,SHFRFICAMED=1
where EMPLOYID='ACKE0001' and DEDUCTON IN ('MED', 'DEN')
so, lets say that I have two deductions (MED and DEN) that I want exempt from Fed tax, FICA soc sec and FICA med. Is this how my script should look?
update UPR00500 set TXSHANTY=1, SFRFEDTX=1, SHFRFICA=1, SHFRFICAMED=1 where EMPLOYEEID='ACKE0001' and DEDUCTION='MED', 'DEN'
Here's script to take care of that for you...please note that you need to ensure there's a 1 for each field that you want marked as TSA, and 0 if you don't want it marked:
update UPR00500 set TXSHANTY=1, --this is overall marking for TSA if checkmarks should exist for any
--taxes so leave it as 1 SFRFEDTX=1, --Fed tax SHFRFICA=1, -- FICA (soc sec & medicare) SHFRSTTX=1, --State tax SFRLCLTX=1 --Local Tax where EMPLOYID='ACKE0001' --<< Change this to be your desired employee ID and DEDUCTON='MED' --<< Change this to be equal to your desired deduction code
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,307
Most Valuable Professional
#3
nmaenpaa
101,156
