Dynamics GP
Dynamics GP
Organizer:
- JOSE Organized by
-
-
W-2 Box 14 Labels and Amounts
-
W-2 Box 14 Labels and Amounts
Can someone recommend an easy way to delete all W-2 Box 14 references, labels and amounts in the SQL database? I see some in UPR00400 and UPR00600, but there must be others.
We changed the Box 14 label for No Tax on Overtime and now both the old name and new name are calculating and showing up on reports. We will have to manually input the amount at YE for Box 14 anyway, so we just want to remove all Box-14-related data now. Then we’ll re-enter the correct Box 14 label and correct the amounts manually for the W-2s at YE.
Thanks in advance for any assistance!
-
4 Replies
-
Hi @donald-mccreadytheschaefergroup-com
Box 14 data lives in three places: UPR00400 (Pay Codes), UPR00500 (Deductions), and UPR00600 (Benefits). Also check UPR10101 if you’ve already done year-end.
Quick approach:
1. First, back up your database
2. Identify which codes have Box 14:
SELECT EMPLOYID, PAYRCORD, W2BXLABL FROM UPR00400 WHERE W2BXNMBR = '14'3. Remove Box 14 assignment:
UPDATE UPR00400 SET W2BXNMBR = NULL, W2BXLABL = NULL WHERE W2BXNMBR = '14'(do same for UPR00500 and UPR00600)4. Re-enter the correct Box 14 label manually in Payroll Setup
5. If year-end is closed, you’ll need to reverse and recreate the year-end wage file
Key thing: Always test in non-production first.
If you hit issues with this or need help reversing year-end, let me know. We work with GP cleanup like this regularly and can help guide you through it. Finding solid GP support is getting harder these days, so I’m happy to assist.
Good luck!
-
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..
Log in to reply.
