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

Article ID: 2395350 - View products that this article applies to.
Expand all | Collapse all

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:

CustomerSource:
https://mbs2.microsoft.com/CustomerSourceApp/search.aspx?qu=w4

PartnerSource:
https://mbs2.microsoft.com/PartnerSourceApp/search.aspx?qu=hrm+w4


b. Search on 'W4' and it should return a link to a page for the current year W4 needed. 

c. Click to open the page that contains the current year W4 for Microsoft Business Portal Self Service Suite. 

d. 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. For 2012, 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.)

Note: For 2011 and prior, there is only one sql script to run.

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. 

MORE INFORMATION

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.
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: June 8, 2012 - Revision: 6.1
APPLIES TO
  • Business Portal for Microsoft Dynamics GP 2010
  • Business Portal for Microsoft Dynamics GP 10.0
  • Business Portal 3.0
  • HRM Self Service Suite Employee Pay
  • HRM Self Service Suite for Microsoft Business Portal
  • HRM Self Service Suite for Business Portal
Keywords: 
kbmbsmigrate kbsurveynew KB2395350

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com