Microsoft Dynamics GP Year-End Update 2019: Electronic W-2 (EFW2) for a successful filing!!!

It's that time of year again, and EFW2’s (aka: Magnetic Media for those of you that have been around for a while) are due on 01/31/2020!! In order to ensure you’re able to get your these out the door on time I’d like to provide you with some basic information about EFW2's in Microsoft Dynamics GP, along with the questions we see most often in support.

What has changed for EFW2s in Microsoft Dynamics GP THIS YEAR:

There are NO EWF2 changes included in the 2019 Year-End Update!!!!!

Reminder: Accuwage is now entirely online (no longer downloadable).

What You Should Know About EFW2s in Microsoft Dynamics GP every year:

1. EFW2 (aka. Magnetic Media) is FREE in Microsoft Dynamics GP 2010 and up!!! YEAH!
2. You can utilize the W-2 Electronic Filing window (Microsoft Dynamics GP >> Tools >>  Routines >> Payroll >> W-2 Electronic Filing) to create an electronic file (aka: EFW2 or Magnetic Media) to submit W-2 information to the Social Security Administration.
3. The W-2 Electronic Filing window displays ALL company databases. You can select one or more companies to be included in your electronic file.
4. The EFW2 file is generated using data from the EFW2 work tables which are stored in the Dynamics database. The EFW2 work tables are populated with data based on the Year End Wage tables from each company database:

5. As always, we recommend you utilize ACCUWAGE to test your electronic file prior to submitting to the SSA. **This is Important**

EFW2 FREQUENTLY ASKED QUESTIONS:

QUESTION 1: I am receiving the following error when I attempt to generate my EFW2, "Not all required fields have been entered. Required fields appear in bold red type" even though all required fields in the W-2 Electronic Filing window have been entered. How do I fix this?

ANSWER 1: This error generally crops up when one of the required fields (most commonly the 'email field) in the Electronic File Submitter window is not populated. Simply click on the 'Submitter' button in the  W-2 Electronic Filing window, populate all required fields, save your changes, and verify the error no longer occurs.

QUESTION 2:

I am receiving a "Message #3970 missing" when I go to Routines >> Payroll >> W-2 Electronic Filing. When I press OK on the error, I am able to get to the window without a problem. What does this error mean?

ANSWER 2: The error message, "Message #3970 missing", is typically caused by a damaged reports or forms dictionary. You can utilize KB 850465 for steps on how to recreate the Reports.dic and KB 951767 for steps on how to recreate the Forms.dic file.

QUESTION 3: We are generating the EFW2 electronic file and we do not know what the WFID number should be, what is this?

ANSWER 3: The WFID field in the W-2 Electronic Filing window should only be available if the resubmitting checkbox is checked. If you receive your original electronic file back from the Social Security Administration (SSA), you would check the resubmitting checkbox and the WFID (Wage File Identifier) will be displayed on the notice sent to you by the SSA. This is the number you would enter.

QUESTION 4: My W3 and total EFW2 ‘Wages, Tips, and Other Compensation’ amounts don't match! Why, and how can I fix this?

ANSWER 4: This is valid data condition if you have employees who reside in Puerto Rico, Virgin Islands, American Samoa, Guam, or the Northern Mariana Islands. Employers who have employees who live in Puerto Rico, Virgin Islands, American Samoa, Guam, or Northern Mariana Islands are required to file an additional magnetic media file called the called W2PR including only these employees.

The Social Security Administration states to omit employees in Puerto Rico, Virgin Islands, American Samoa, Guam, or the Northern Mariana Islands from the EFW2. For more detail on this, please see page 40 of the 2019 EFW2 instructions, from the SSA.

The W2PR form is not currently available in Microsoft Dynamics GP. Greenshades does offer the W2PR form. 

IF you do not have an employee who resides in any of the areas mentioned above, and your ‘Wages, Tips, and Other Compensation’ field is understated on the EFW2: You may have accidentally associated one or more of your employees with Puerto Rico, Virgin Islands, American Samoa, Guam, or the Northern Mariana Islands incorrectly. You can double check this by running the following script against the company database:

SELECT * FROM UPR10101 WHERE STATE IN ('AS','GU', 'MP','PR','VI') AND RPTNGYR = '2019'

To fix a state that was assigned to an employee by mistake: Simply update the ‘state’ associated with the problem employee in the Edit W-2 Information window (Microsoft Dynamics GP >> Tools >> Routines >> Payroll >> Edit W-2), and save your change. Finally, recreate the EFW2 file and verify the ‘Wages, Tips, and Other Compensation’ are updated as expected.

QUESTION 5: I am receiving the following error, "The Federal W-2 electronic file couldn't be created" when I click on Create File in the W-2 Electronic Filing window. How can I fix this?

ANSWER 5: This error crops up when the file name at the bottom of the W-2 Electronic Filing window is blank, OR the user does not have access to the file location specified. Change/update the file location appropriately, and try to generate the file again.

QUESTION 6: I am receiving the following error, "There is not enough space on the drive you selected. Insert a blank disk, or save the file to another location." when I click on Create File in the W-2 Electronic Filing window. How can I fix this?

ANSWER 6: This seems to happen when there is a damaged year end file that was created.  In the window, the employment code field is blank and it should state Regular in most cases.  To fix this problem, you can run the below script against the Dynamics/System database.  The column is probably zero or blank and it should be a 5, update the column, then go back into Microsoft Dynamics GP and choose that line item to create the file with.  Next year, it should create fine.

select Employment_Code, * from W200006 where RPTNGYR='2019'

QUESTION 7: I am receiving the following error message, “A GET/CHANGE OPERATION ON 'UPR_YEAR_END_WORK_HDR'FAILED ACCESSING SQL DATA” when I open the W-2 Electronic Filing window. How can I fix this?

ANSWER 7: As discussed above, when you open the W-2 Electronic Filing window, Microsoft Dynamics GP looks at ALL companies. Most commonly, this error crops up when there is company being pulled into the window where one of the following scenarios is true:

• Scenario 1 (Most Common): The problem (erring) company was deleted, but not all references were removed from the Dynamics database. These references needs to be cleaned up to resolve the error.
• Scenario 2: The problem (erring) company’s database was not updated in Utilities to correspond to the latest version of GP (likely the Year-End Update) and that will cause a problem when the design of the table has changed (columns added, data types changed, etc.).

To determine which scenario you are running into, take the following steps:

• Find out which company GP is erring on by gathering a Dex.sql log.
• Now that you have your log, do a search for UPR10300, it will start with a call like {CALL DYNAMICS.dbo.zDP_UPR10300F_2(-1,'',-1,'ÿÿÿÿÿÿÿ')} Right below it you will see your first company, example { CALL TWO.dbo.zDP_UPR10100SS_1 ( 2019 ) } This error message below is fine to see and means no issues Invalid column name 'desSPRkmhBBCreh'.*/ After the company call if you see no Invalid column name error or Could not find stored procedure Then search for your next UPR10300 / company and keep going down your log till you see an error like above, that is your problem company.
• Once you know which company is erring, run the following select statement against the DYNAMICS database to see if the Company ID is present in the SY01500 (Company Master) table:

SELECT CMPNYNAM, INTERID, * FROM DYNAMICS..SY01500

• If the erring Company ID is not/should not be in the SY01500 table (because it was deleted at some point), and you want to remove remaining references from the DYNAMICS database: You are running into Scenario 1. You can test the following steps to resolve the problem: 
  • First, get all users out of the system. 
    1. Make backups of the Dynamics and company databases.
    2. Run the ClearCompanies.sql script against the DYNAMICS database to ‘clean up’ any straggling company references in the DYNAMICS database associated with companies that were not deleted correctly.
    3. Make another backup of the databases after running the script.
    4. Verify the error no longer occurs when you open the W-2 Electronic Filing window.

• If the erring Company ID is associated with a valid Company Id in your environment you are running into Scenario 2. Please run the following select statement against the DYNAMICS database:

SELECT * FROM DYNAMICS..DB_Upgrade WHERE db_status <> 0

• If records are returned in association with the erring company database, this indicates the database did not upgrade successfully. As such, we recommend you utilize the AWESOME Microsoft Dynamics GP Upgrage Blog series resources to troubleshoot your failed upgrade. If you’d like assistance with troubleshooting a failed upgrade we are happy to help you via a new support case!! *See below for guidance on appropriate support topics for failed upgrades.

• If records are not returned in association with the erring company database, and you are not running into Scenario 1: We'd like you to open a new support case for further troubleshooting (be sure to note the error message, GP version, and results from your testing above in the case) so our AWESOME Payroll Engineers can assist you with determining how to best resolve the error message. *See below for guidance on appropriate support topics for EFW2 assistance.

QUESTION 8: I am receiving the following error message, “A GET/CHANGE OPERATION ON 'UPR_YEAR_END_WORK_STATE' FAILED ACCESSING SQL DATA” when I print the Federal W-2 Electronic Filing Summary report in the W-2 Electronic Filing window. How can I fix this?

ANSWER 8: As discussed above, when you open the W-2 Electronic Filing window, Microsoft Dynamics GP looks at ALL companies. This error will occur when a non-power user does not have access to one of the companies listed in the W-2 Electronic Filing window.

The Federal W-2 Electronic Filing Summary report is populated with ‘state’ summary data. This state summary data is pulled from each appropriate company database. If the user does not have access to the company database, the state summary data cannot be pulled, and the error will occur.

To successfully print the Federal W-2 Electronic Filing Summary report, you have the following options:

1. Log in as SA or a POWERUSER to print the Federal W-2 Electronic Filing Summary report.
2. Grant the problem user access to ALL company databases that are displayed in the W-2 Electronic Filing window prior to when the user attempts to print the report. This can be done in the User Access window (Microsoft Dynamics GP >> Tools >> Setup >> System >> User Access). Then, after the report is printed, take away access to any company database you don’t want that user to have access to.

QUESTION 9: Can I use Microsoft Dynamics GP to generate and submit my STATE electronic W-2 file?

ANSWER 9: Microsoft Dynamics GP generates the Federal electronic W-2 file format. Some states will accept this format. However, some states will not. As such, you will need to check to verify whether or not your state will accept the Federal format. If they do, then yes you use Microsoft Dynamics GP to generate your state electronic W-2 file. Greenshades does offer state electronic W-2 filing functionality.

Assistance for EFW2's:

• Microsoft Dynamics GP Blog
• Microsoft Dynamics Community
• Microsoft Dynamics Support

If you are creating a case with the Technical Support Team for assistance with a failed upgrade, please refer to the category selections below to ensure you are routed to the correct Support team for assistance:

 --Support Topic Selection:    System and Security Setup, Installation, Upgrade, and Migration

--Sub-topic Selection:    System Upgrade

If you are creating a case with the Technical Support Team for assistance with EFW2's in association with Year End close for Payroll, please refer to the category selections below to ensure you are routed to the correct Support team for assistance:

--Support Topic Selection:    Payroll

--Sub-topic Selection:      Year End Procedures 

EFW2 Resources:

• IRS Forms and Publications 
• EFW2 Instructions 
• Accuwage

Year-End Close Resources:

Be sure to refer to the 2019 Year-End Blog Schedule to review current and upcoming blog posts and other helpful resource links related to Year-End Closing for Dynamics GP.

Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP