Microsoft Dynamics GP Year End Release 2015 Affordable Care Act

December 08 | By Tracey Brinkman

Tags: | | |

Microsoft Dynamics GP Year End Release 2015 Affordable Care Act

Content based on Blog by Terry Heley_ Microsoft in Fargo

Microsoft Dynamics GP 2015 and Microsoft Dynamics GP 2013 U.S. Year-End Updates have all shipped. Follow this link HERE, to the Microsoft Dynamics GP Community Blog.

There were MANY changes in the year end update for ACA, so if you are going to track ACA in Dynamics GP, it is MANDATORY that you install the year end update to co-inside with all the changes.

A few items that Microsoft is getting questions on:

  1. After the update GP is now tracking lowest cost premium and the date change of the premium.  Just like the ACA codes.  This is important – It is highly recommend that you to install the update, put your Microsoft Dynamics GP user date back to 1/1/2015 and from the setup, roll down the monthly lost cost premium on your plans to the employees.  This should then report correctly in box 15.
  2. You DO NOT need to order/purchase the 1095-C and 1094-C forms, we will be printing the forms with the lines and the instruction page that goes with the 1095-C.  You will still however need to order your W-2 forms and Payables 1099 forms.
  3. Check out the table changes that were made in the year end update, some related to ACA. Click HERE
  4. Changes made to printing of dependents when you are not a self-insured plan.
  5. Microsoft will not create the electronic file if you are over 250 employees.  There are ISV products available that will, please review the detailed document below if you need this functionality.
  6. Employees that do not have wages may still get a 1095-C. This feature is available so customers that did not use Dynamics GP Payroll product but do have Human Resources could still create ACA forms.

 

This will create a SmartList Designer report from a view so you can review your ACA information.

There are two tables used to store ACA information as you save changes UPR00905 – employee                                          UPR00904 – dependent

In Microsoft SQL Server Management Studio run each view below where I have TWO change to your company name.

USE [TWO]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[ACAEMPLOYEE]

AS

SELECT            dbo.UPR00905.YEAR1,

dbo.UPR00905.EMPLOYID,

dbo.UPR00905.BENEFIT,

dbo.UPR00905.Effective_Date,

dbo.UPR00905.OfferOfCoverageCode,

dbo.UPR00905.SafeHarborCode,

dbo.UPR00905.CHANGEBY_I,

dbo.UPR00905.CHANGEDATE_I

FROM        dbo.UPR00905

 

USE [TWO]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[ACADEPENDENT]

AS

SELECT            dbo.UPR00904.EMPLOYID,

dbo.UPR00904.SEQNUMBR,

dbo.UPR00904.Effective_Date,

dbo.UPR00904.HealthInsDependentCov,

dbo.UPR00904.CHANGEBY_I,

dbo.UPR00904.CHANGEDATE_I

FROM        dbo.UPR00904

 

Log into Microsoft Dynamics GP

Go to SmartList, click the New Button

SmartList_New_Company

Give it a name that you want, in the example below it is named ACAEMPLOYEE. Under the Database View go all the way down till you see Views, expand it Choose Company, expand it

You will see the two views the script created.

Choose the ACAEMPLOYEE and click OK

Click New again and do the same steps for the dependent list name it something different.

In the example it is ACADEPENDENT

SmartList Designer_ACA_Employee

Now go to SmartList and run your ACA information.

SmartList_ACA_DEPENDENT_EMPLOYEE

Click HERE : This will open a Word document with links to several previous Blogs regarding ACA documentation for the 2015 year and all changes in the update in detail.

Click HERE for a copy of the 2014 year end document that covers reconcile Payroll information to Human Resource to start to set up Benefits in Human Resource as ACA required Human Resource. Click HERE to view the 1095-C form with sample data of multiple dependents and instructional page. Click HERE for the IRS instructions.

You can view the original Microsoft Blog by Terry Heley at: https://community.dynamics.com/gp/b/dynamicsgp/archive/2015/11/25/gpye2015aca

If you are an iSolutions Partners customer and have questions regarding Microsoft Dynamics GP Year End Release 2015 Affordable Care Act, please contact us at: support@iSolutionsPartners.com

You can view our previous blogs at: http://www.isolutionspartners.com/resources/dynamics-gp-blog-for-indiana-and-wisconsin/