You are currently offline, waiting for your internet to reconnect

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 installing a new 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 


4. Locate the .exe file from PartnerSource or CustomerSource that you downloaded and used to try install the current year W4 already.

NOTE: You can download it again as follows:

a. Sign into either Customer Source or Partnersource and search on 'W4' or use the direct page links below:

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


b. Click on the .exe file and download it to your desktop.


5. Go to your desktop and right-click on the .exe file and click Extract Files. You will see two .sql scripts listed in the extracted files. If you double-click on them, they should open in a SQL query window. (Otherwise, you can open them with notepade and copy and paste them into a SQL query window.)

6. Execute the data.hrm_w4template.sql against the Company database. (This script will look at all GP databases from the Dynamics database and rebuild the W4 information that was previously removed from the company.)

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

8. 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.
More information
W4, W-4, HRM, BP, HRMSSS, corrupt, damaged, ?????, question marks GP2013 GP 2013 template
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2395350 - Last Review: 12/14/2015 19:44:00 - Revision: 7.0

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

  • kbmbsmigrate kbsurveynew KB2395350
Feedback
r varAutoFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" track by $index -->
Uruguay - Español
대한민국 - 한국어
España - Español
Paraguay - Español
Venezuela - Español
://c1.microsoft.com/c.gif?DI=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" &did=1&t=">r m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >>