Integration Manager Error: “RPC Server is unavailable”

This error has been the most troublesome for me in the past.  Typically of you try searching the error you will get pointed to KB article 943948.   What I have found is that this is caused when you run an integration and Microsoft Dynamic GP seems to disappear and Integration Manager freezes or gets closed down integration.  I have also seen this occur after an error and the user tries to re-run the integration.

What is occurring is that Integration manager and Microsoft Dynamic GP still has processes running in the background.  If you go into task manager and look at the running processes you will see multiple for Microsoft Dynamics GP for the user trying to run Integration Manager.  You have two solutions, either go into task manager to stop the processes and test again or have the user reboot.

Sometimes just stopping the services does not resolve the error and a reboot is still required.  If a user is logged into a terminal server it is important to verify that they fully log off the server and simply does not disconnect.

 

Advertisements

1095C Form Show Wrong/Incorrect Information

One of my clients had an interesting issue that prompted me to write this article.  They have been tracking their ACA information religiously throughout the year.  However, when we created the wage file and printed the 1095C to screen, all of the figures were wrong.  The last code that they should have used was in 2015 and according to the documentation for the ACA, it should have rolled forward.

They utilize three benefit codes.  One for their Buy up plan, one for Dental, and one for Vision.  The buy-up plan is updated in August and the Dental and Vision plans are updated in February.  The change on the 1095C was in February and marked as none, none and 0.00.

We checked the codes on the each of the benefits and they were correct.  If you do not want the codes to apply to the ACA you are supposed to mark them as ‘None,’ ‘None,’ and leave the cost blank or 0.00.  The Buy-Up code was assigned the appropriate ACA reporting.

Then the next step would be to look into the SQL tables.  The following tables are the corresponding tables for the ACA:

UPR00904 – uprMstrDependentACA
UPR00905 – uprMstrEmployeeACA

These can also be found under my Table Reference page. The ACA-specific information is held in the UPR00905 (ACA Employee) /UPR00904 (ACA Dependent) tables and these tables can be updated to remove employees that are not eligible for the ACA health benefit prior to creating the year-end wage file, which will remove them from 1095-C reporting also.

ACA reporting is only based on the dates the employee was added to HR and not the hire/active dates on the PR side.  For example, one employee may start on February 2 and their benefits start 60 from their start date (In April).   If you do want to add a health benefit to an HR employee insure the GP system date is set to the date that you want the ACA reporting to start for the employee in the current year.

In this case, when a benefit is changed in August, it applies a record to the UPR00905 table.  You can also backdate the records by changing your user date.  For example, if you are adding a health benefit to an employee today but you want the ACA to list the date that health care was offered to be in February, you would change your user date in GP to ’02/01/2016′ prior to creating the record.

It is important to note how the 1095C pulls data.  From the table UPR00905 it will only select the last date of the month.  Meaning if you made a change on 2/12/2016 and then 3 months later backdate to 2/1/2016 to make a correction, it will pull the information from 2/12/2016.

Additionally, it will only record one benefit per month.  If you have two hospitalization plans, it will take the last record made for the month as the reporting record.  In our case we ran into the issue that the Dental, even though it was marked ‘None,’ ‘None,’ and 0.00, it was recording in February.  We corrected this by running a delete statement for the specific benefit codes that should not have been used in 2016.  Please note that we first tested the script in their test database with a fresh restore. 

“Delete UPR00905 where Year1=’2016’ and BENEFIT=‘benefitcode’”

 We then used a third party tool from Integrity Data that allowed users to manually adjust the UPR00905 table.  Integrity Data is a leader in innovative payroll solutions that greatly reduce the burden of the Affordable Care Act on employers.  Tom Franz, their Client Engagement Manager, has made their free utility available to me.  For more information on the free utility, email Tom at tfranz@integrity-data.com to request your free copy. In addition, their website (www.integrity-data.com/aca) is a great place for ACA-related information and also talks about Integrity Data’s full-featured ACA solution.

 I first extensively tested the tool in our test company to verify that it worked how we needed it to.  If you choose to use this tool, please complete testing within your test environment.  Straightforward Dynamic GP is not liable if you choose not to test and verify that this solution works for your specific need.

I used this 3rd party tool to only make corrections to past records.  It is not designed to update the information moving forward in Microsoft Dynamic GP.  After the correcting entries are made then you will want to utilize the proper method to making changes within Microsoft Dynamic GP to make any new entries.  Here are the steps I took:

  1. We will be using a 3rd party software from Integrity Data to fix the older entries. There is no built-in method through Great Plains.  This solution has been tested.
    1. Navigate to CARDS>>PAYROLL>>EMPLOYEE
    2. Select an employee
    3. Then select additional at the top
    4. Select Edit Employee ACA Information
  1. You will see all the codes from the beginning of HR. You can make changes to the employee and their dependents.post3-1
  1. To delete a row. Select the Year within the row you would like to delete and then the delete row button.post3-2

 

  1. To add a row go to the last item on the record and type the correcting entry. You will able to place an entry for earlier in the year.

post3-3

Note:  I was not paid to promote any item from Integrity Data.

Recommendations:

  1. Only use this window to make corrections to past records and never use it to make new entries moving forward. After these items are made then you will want to change your user date and update the Health Insurance through your normal process.
  2. Before trying this solution, it is HIGHLY recommended to make a backup. Then make a copy of your live database into your test environment and test all changes that you want to make before applying the changes to your live data. After testing in your TEST environment and it does what you want it to do, please make an additional backup before you apply the solution in your live database.
  3. Some companies monitor the 1095-C content throughout the year by creating a TEST company from a current copy of the LIVE database and creating the Year-End Wage file in TEST to review.

 

Resources used for creating this post:

Terry Heley’s Microsoft Dynamics GP Blog – She works for Microsoft and is the most knowledgeable person about Payroll and HR.  Each year she produces a guide for the ACA on her blog and includes troubleshooting steps.  I highly recommend following her blog.

Integrity Data – Integrity Data is a leader in the application of technology to improve business processes around payroll and Affordable Care Act tracking and reporting. Celebrating 20 years in business and serving over 8,000 organizations, Integrity Data strives to ensure that employers maintain IRS compliance around the Affordable Care Act and that their most valuable asset, their employees, are paid accurately and efficiently.

The Scan button grayed, shaded or unavailable is in Microsoft Dynamics GP

5-1

In Microsoft Dynamic GP, there is a direct scanning button that is available.  For the direct scan button to activate you must have a WIA driver installed.  If it does not detect the driver it will appear grayed out (as the screenshot above shows).

I ran into an issue recently where I needed to have the users RDP into a terminal server and be able to utilize an activate scan button.  Microsoft redirect did not work and I tested several third-party scanning redirect software programs, such as TSscan and scanredirect.  Neither of these products worked to activate the scan button because they installed a TWAIN driver on the terminal server.  I had tested about 6 scanning redirection options before I found one product that installed a TWAIN and WIA driver on the server side and pulled the scanner’s default scanning options into the server.  This product is Scanner for Remote Desktop.   Here is their guide to their product with instructions on how to install.

Additional Disclaimer:
I was not paid to represent this product and earn no money placing this on my blog.  I found that this product assisted in resolving a problem that took me over a month to find a solution.  If you have another scanner redirection product that also installs a WIA driver on the server I would be more than happy to edit this post and add it.