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..
-
Brandon,
Thanks again for the details you’ve shared. This is ludicrous!
I changed the Ohio tables manually in the UI before the 7/29/2026 Round 6 appeared. I later installed Round 6 to get Georgia also. Round 6 has now overwritten my Ohio corrections with bad info. And the Georgia tables are suspect also.
I’ll re-enter Ohio changes again in the UI. We’ve had Georgia employees in the past but none currently. I wonder if Microsoft is listening.
Regards,
Don McCready
-
Thanks, Brandon. That’s disappointing.
I already made the update manually. In order to verify it, I checked the Ohio withholding on the payroll after that. The challenge for me was calculating the correct Ohio taxable gross since some deductions are pre-tax and others post-tax.
Certainly not an expected professional outcome from MS.
