Dynamics GP Payroll Social Security Contribution Issues and Possible Solutions

Jan 5
09:17

2012

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

As you know in January of 2011 Employee contribution to Social Security fund was reduced from 6.2 to 4.2 percent while employer contribution was left as it was before at 6.2%.

mediaimage

Originally Great Plains Dynamics Payroll module was built upon the match principle and in UPR41302 Payroll Tax Table Setup FICAS tax had only one filed to address both employer and employee portions.  In order to fix the issues Microsoft initially released tax update round one,Dynamics GP Payroll Social Security Contribution Issues and Possible Solutions Articles where FICAS rate was reduced to 4.2% as it was important to keep W2 calculations accurate.  Old functionality in Payroll module in this scenario accrues employer contribution also at 4.2%.  At the time Microsoft recommended GL correction increasing accrued contribution to 6.2 percent.  Then in January of 2011 MS released tax update with code update with mismatching logic for SS contributions.  GP customers on old Dynamics versions are questioning ‘is it possible to get the logic work for them as well?  Let’s try to answer these questions:

1. First of all we have to think about Dynamics GP versions which were supported by MS tech support in January of 2011: 2010, 10.0 and 9.0.  Please note that 9.0 was scheduled for support phase out.  Only these three versions at the time got logic update.  If you are on older version such as 8.0, 7.5, 7.0, 6.0 or 5.5 then you have to deal with mismatch in GL

2. 2010 and 10.0.  At this time of January of 2012 Microsoft Business Solutions supports these ones and what you need to do is regularly apply tax updates.  We would like to mention that due to delay in Congress on either to abolish employee SS rate reduction or not at the end of December of 2011 Round one was released with the match as it used to be in the past.  However you probably know that privilege was extended and Round One update was rereleased in earlier January of 2012.  So be sure that you had a discussion with your consulting partner and reapplied the update

3. 9.0.  Support expired and new updates are not available.  However you can still run Payroll with correct tax percentages by either manually changing tax settings or having your provider to update them by copying from test server with current version.  In order to get mismatching logic you will need to apply tax update released at the end of January of 2011 which could be found on Customer Source for download or if you do not have current annual maintenance contract you can ask your reseller to download it for you through Partner Source channel

4. Old releases 4.0, 5.0, 5.5 and up to 8.0.  Here you have to assess the role of payroll module in your business.  If you have small number of employees you can consider it outsourcing to payroll processing networks.  On the other hand if it plays important role then we recommend you to talk to your VAR about upgrade options.  Update itself is not a huge deal but in order to get access to new reg key you have to be current with annual enhancement contract.  Reenrollment fee might be too high and show stopper.  At least good news is possible work around in General Ledger and manual tax rate correction or via SQL scripts

5. Great Plains Accounting for DOS, Windows or Mac 9.5, 9.2 and earlier.  Just do what you have to do each January or in other words open tax forms and modify rates manually

6. Great Plains Dynamics on Pervasive SQL 2000 and Btrieve 7.5 and older releases.  Theoretically it is possible to update rates via ODBC connection in Microsoft Access or similar ODBC compliant tool.  However it might be complex to find programmer who is quick in learning curve and ready to update Pervasive SQL tables.  So our recommendation is manual rate change

7. For information feel free to call 1-866-528-0577 or email us help@albaspectrum.com  We are comfortable to provide nationwide and international support via web sessions and phone conferences and willing to travel onsite when required on travel expenses reimbursement agreement