Donald McCready
Forum Replies Created
-
Since I wanted to remove W-2 Box 14 data, I searched UPR0400, UPR00500, and UPR00600 for ’14’ in the 4 box number fields. An example for UPR00400:
SELECT * from UPR00400 where W2BXNMBR = ’14’
SELECT * from UPR00400 where W2BXNMBR2 = ’14’
SELECT * from UPR00400 where W2BXNMBR3 = ’14’
SELECT * from UPR00400 where W2BXNMBR4 = ’14’
Where I found ’14’ data in any of the 3 tables, here’s a sample of how I removed the data:
UPDATE UPR00400
SET W2BXNMBR = ‘ ‘,
W2BXLABL = ‘ ‘
WHERE W2BXNMBR = ’14’
As Hardik suggested, try this in a practice company first. Backing up the database is always suggested, especially in a live company..
