180
When we go to print 1095-C forms for employees, only about 40 of our 400 employees print out. Is there something that can prevent these from printing? We've checked the insurance codes and they are identical between the employees, they just won't print.
We're currently on version 18.3.1290.
Yes, the '1095C' tab in the 'Edit W-2 ' window for payroll updates the codes directly in UPR10111 table for the employee only. (Dependents are in the UPR10108/UPR10109 tables, Employees are in the UPR10110/UPR10111 tables.) You are editing the 1095C form only for that year when you use the Edit-W2 window.
As mentioned before, when you enroll employees in the Health insurance code, the UPR00905/UPR00904 tables are updated with the GP user date and ACA code. This is the information used when you generate the year-end wage file, and puts the data into the URP10110/UPR10111/UPR10108/UPR10109 tables. So if the dates and codes were correct in the UPR00905/UPR00904 tables, then the 1095C form would be correct in the 4 year-end wage file tables above. So you will want to get the codes corrected in the UPR00905/UPR00904 tables so this doesn't happen again next year. You can find a link on this blog article, at the end for how to create a free smartlist designer report to look at the ACA data prior to generating the year-end wage file. Be sure to read #5 on this blog:
ON this DOCS link Dynamics GP U.S. Payroll - Dynamics GP | Microsoft Docs it tells you how these tables are updated:
UPR10110 – Payroll Master Dependent ACA History and UPR10111 - Payroll Master Employee ACA History tables
• The UPR10110 will be updated during the year-end close is process in Payroll using data from the UPR00904 (Payroll Master Dependent ACA) table.
• The UPR10111 will be updated during the year-end close is process in Payroll using data from the UPR00905 (Payroll Master Employee ACA) table.
The supported method would be to make sure that the dates and ACA codes are correct in the UPR00904/UPR00905 tables before you generate the year-end wage file. If you are unable to undo the year-end wage file and generate it again (which most cannot), then we give you the option to edit the codes in the EDIT W2 window for the 1095C form. This is completely manually. If you could get 4-5 people to edit the codes on the front-end, it doesn't seem like it would take that long for 350 employees. But if you choose to edit in these 4 year-end wage file yourself, that is up to you. You would be on your own. I just recommend to change one employee in the front-end first, and verify which fields it changes in the tables, so you can be sure to update the rest of the employees the same way. Update one employee and print it and verify it prints the way you want it to.
Hope that helps,
Cheryl
Hi Cheryl,
I appreciate your insight on this. doing a little bit more testing, I was able to get the form to print without changing the effective date in the table, it's still set to 12/13/2021 and only editing the 1095c in the edit w-2 window and changing 2A to 2C for all months. Manually editing these for about 350 employees would get tedious.
I've also found the UPR10111 table that has the codes for each month in them. Looking at a few of the employees who were fulltime and had health coverage for all of 2021, the safe harbor code is set to 1 (2A) instead of 3 (2C) for all months in the record for 2021. Double checking that this is the record that gets edited on the Edit W-2/1095-C screen? If I look at the records for the previous year, they are correctly set to 3. Does the Year end closing process or generating the year end wage file add the record for the year? If so, why would it set it to 1 instead of 3? I've checked with the folks in the accounting department and they don't think that they did anything that would reset these all back to 1 and they are still set correctly in the Health Insurance Enrollment card. Is there some way within Dynamics GP to batch edit all these and set them back to 3?
If I update the UPR10111 table and set the safe harbor code to 3 for all 12 months for all the fulltime employees who had coverage for the whole year would this fix the printing issue?
It sounds like you found that the employee was updated with a 2021-12-31 date, instead of 2021-01-01, so you had to update both the effective date and the ACA codes in order to get the form to print out for all employees.
I would suspect that the user may have added the Health insurance code to all employees with a GP user date of 12/31/2021, as the Effective dates in the UPR00905/UPR00904 tables are updated with the GP user date as the Effective date. The 'start date' in the health insurance enrollment window is not used for ACA, so that is most often the reason for incorrect Effective dates as the user was not aware that the GP user date is used in the table. We do recommend to set up smart lists on the UPR00904/UPR00905 tables and review this data throughout the year. You can make a change directly in these SQL Tables at any time before the Payroll Year-end wage file is generated. Here are the links to how ACA works, and there are many more links and information available from there. It should keep generating forward so if the employee has a record of 2021-01-01 and it remains in the table, then that should also be used for going forward for years 2022 and 2023, etc. To get it to stop, you'd have to set your GP user date to a date in the month that it should stop and put their codes to NONE/NONE and save.
You can find quick illustrations to common Q&A questions in this KB article:
http://support.microsoft.com/help/3106180
There are examples and more links on how it works in the links below:
Dynamics GP U.S. Payroll - Dynamics GP | Microsoft Docs
I hope that helps.
Cheryl
Microsoft Support.
I checked with the accounting department and we did some testing. For one employee who wasn't printing, I set the effective date in UPR00905 to 2021-01-01 instead of 2021-12-31 and tried printing the 1095C forms. This didn't fix it so the form would print.
We did some more testing and think we found the reason they aren't printing. When we look at the employees card for Health Insurance Enrollment, line 14 and 16 show the correct codes, 1A and 2C. But when we go to edit the W2 and look at the 1095-C codes for the employee, they show 1A (14 Offer of Coverage) and 2A (Section 4980H) for all months. If we correct this code from 2A to 2C the form will print for the employee.
The question we have now is how do these get out of sync and is there a way to batch update these to match what is in the Health Insurance Enrollment Card? Looks like this mostly affects employees who's health coverage didn't change for the year, ie, they were covered for the whole year and didn't have any changes in health coverage.
One note, we're still running 18.3.1290 and cannot upgrade to the latest year end update due to the integration to the ERP system we're using not being certified with any higher versions. We also upgraded from 2016 to 2018 in December 2021.
Hi Cheryl,
Looking at the table upr00905, I see records for all the employees with YEAR1=2021. I noticed that the effective date on most of them is "2021-12-31 00:00:00.000". I think this may be the reason they don't print. Is that correct? The change date on those records is also "2021-12-31 00:00:00.000". Would there have been some process in Dynamics GP that would have updated all these records to the same date?
If I look up one employee in the UPR00905 table, I see the following entries
| YEAR1 | EMPLOYID | BENEFIT | Effective_Date | OfferOfCoverageCode | SafeHarborCode | CHANGEBY_I | CHANGEDATE_I | LowestCostPremium | DEX_ROW_ID |
| 2015 | 546 | H/INS1 | 2015-01-01 00:00:00 | 1 | 3 | USER | 2015-01-01 00:00:00 | 0 | 574 |
| 2015 | 546 | H/INS1 | 2015-11-01 00:00:00 | 1 | 3 | USER | 2015-11-01 00:00:00 | 50 | 896 |
| 2020 | 546 | H/INS1 | 2020-12-31 00:00:00 | 1 | 1 | USER | 2020-12-31 00:00:00 | 50 | 1912 |
| 2021 | 546 | H/INS1 | 2021-12-31 00:00:00 | 1 | 3 | USER | 2021-12-31 00:00:00 | 50 | 2681 |
This is one of the many employee that isn't printing the 1095-C form. Shouldn't the effective date be 2021-01-01 instead of 2021-12-31?
From what we can tell, only new employees are printing the form, while older employees aren't.
I appreciate your help!
When you enroll the employee in the HR code, a record gets written to the UPR00905 table with an effective date (which is the GP user Date). So review this table, as I would expect you only have about 40 employees with a record in this table then.
You need to have a record in the UPR00905 table for each employee enrolled in the code and an effective date whenever they were enrolled. The same codes will then get used for all months after that effective date, so you don't need to do anything from year to year if the record does not change or expire. Dependents get enrolled in the UPR00904 table. So you should review the UPR00905/UPR00904 table prior to running the Year-end wage file. The 1095C prints from the UPR10111 year-end wage file table. Here are links for useful documentation on ACA for you as well.
Here is the ACA blog for this year of highlights and changes and useful links:
https://community.dynamics.com/gp/b/dynamicsgp/posts/microsoft-dynamics-gp---2021-year-end-blog-series-schedule
Here is the ACA documentation for setup and how it works:
Dynamics GP U.S. Payroll - Dynamics GP | Microsoft Docs
Q&A on KB article:
http://support.microsoft.com/help/3106180
If any specific questions, please let me know.
Cheryl W
Microsoft Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (