web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Suggested answer
    Sherlene Sorenson Profile Picture
    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
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans