Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / 1095-C all employees s...
Microsoft Dynamics GP (Archived)

1095-C all employees showing Line 14 1A and Line 16 2C

(0) ShareShare
ReportReport
Posted on by Community Member

I've just loaded GP into test environment, ran the year end update, created the wage file, and printed the 1095-C's. Every employee is getting 1A in Line 14, nothing in Line 15, and 2C in Line 16, regardless if they had coverage or not. I've checked the Health Insurance Enrollment in the HR module, and I the correct information in the Affordable Care Act Info box. I also see the correct Benefit Begins date.

Why is the 1095-C not pulling this information? How can I fix this before year end?


Thanks

*This post is locked for comments

  • Suggested answer
    Sherlene Sorenson Profile Picture
    Sherlene Sorenson 967 on at
    RE: 1095-C all employees showing Line 14 1A and Line 16 2C

    Hi George,

    You would definitely have some clean up to do directly in the SQL tables that Tom mentioned. The GP ACA reporting does not recognize anything about the "Benefit Begins" or "Benefit Ends" dates, and not even anything about whether the code is marked as Active or not.  All that it looks at is what the values are in the ACA boxes, and the GP User Date when you save a change to those fields.

    I would recommend working with your GP Partner for assistance getting you started with this table cleanup.  Once you have the initial clean up done and are using recommended methods for saving changes going forward, it is not so hard to maintain, but doing some cleanup directly in the SQL tables on this one will get you a good start on getting better data on the reports.  I do suggest biting the bullet and doing this rather than just editing directly in the Edit W2 window, so you will have better looking data to start out the new year with for next years' reports.

  • Suggested answer
    Thomas Franz Profile Picture
    Thomas Franz 1,105 on at
    RE: 1095-C all employees showing Line 14 1A and Line 16 2C

    Line 14/15/16 information comes from the UPR00905 table and is populated when HR Health Insurance Benefit codes are assigned to/updated for employees. There is no way within core Dynamics GP to "see" and edit this information prior to closing the year. The effective date of this information defaults from the User Date at the time the edit was made, which can make it difficult to correct.

    I created a free utility to make editing this information easier (see below). This will let you view and edit the information in the UPR00904/5 tables prior to closing your payroll year to ensure your ACA information is correct.

    If you would like a copy of this tool, please email me (tfranz@integrity-data.com) and I will forward it to you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans