Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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:
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.
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:
To determine which scenario you are running into, take the following steps:
SELECT CMPNYNAM, INTERID, * FROM DYNAMICS..SY01500
SELECT * FROM DYNAMICS..DB_Upgrade WHERE db_status <> 0
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:
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:
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
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
Business Applications communities