W4 contains special characters '???' in fields in Microsoft Business Portal HRM Self Service Suite using Microsoft Dynamics GP

Symptoms

The W4 is corrupt and displays question marks (???) in the fields on the W-4 form in Microsoft Business Portal Human Resource Self Service Suite using Microsoft Dynamics GP.

Cause

This is most commonly seen when using Microsoft SQL Server 2000, but has occasionally been exhibited in more recent SQL versions.  The issue can be resolved using the steps below.

Resolution

Run the below scripts to resolve this issue with the current damaged W4 template: 
(NOTE:  If you are just manually updating the W4 form template for a new year and are not experiencing the issue described above, you can skip to step 4.)

1. Make a current backup.

 
2. Open SQL Server Management Studio. Click on the New Query button at the top and select the company database in the drop-down list.


3. In a SQL query window, execute the script below against the COMPANY database to remove the form template for the current damaged W4:

Delete Hrm_W4Template 

(NOTE: If you delete it, you may need to open a Support case to ask for the data.hrm_w4template.sql script to run against the company database to rebuild it. This script will look at all GP databases in the Dynamics database and rebuild the W4 information that was previously removed from the company. This script is provided by request only.)


4.  Sign into either Customer Source or Partnersource using the page links below and download the W4TemplateAddCurrent.sql script:

CustomerSource:
https://mbs.microsoft.com/customersource/northamerica/GP/downloads/tax-regulatory-updates/w4hrmssbp

PartnerSource:
https://mbs.microsoft.com/partnersource/northamerica/deployment/downloads/tax-regulatory-updates/w4hrmssbp



5. Execute the W4TemplateAddCurrent.sql script against the DYNAMICS database.

6. Then check in BP to see if the proper year shows on the W4 now. 

NOTE: If you download the W4 template for the next calendar year, you will not see it in business portal until your user date reaches that same year.
Properties

Article ID: 2395350 - Last Review: Jan 9, 2017 - Revision: 1

Business Portal for Microsoft Dynamics GP 2013, Business Portal for Microsoft Dynamics GP 2010, Business Portal for Microsoft Dynamics GP 10.0, HRM Self Service Suite Employee Pay, HRM Self Service Suite for Microsoft Business Portal, HRM Self Service Suite for Business Portal, Business Portal 5.0, Business Portal 5.1, Business Portal 3.0

Feedback