| Microsoft Dynamics GP ERP has US and Canadian | | | | launched by Great Plains User or scheduled (in this |
| Payroll modules, and this accounting application is | | | | case you may need GP IM automatic integration |
| often used by Payroll outsourcing companies to | | | | routine, available for purchase from Microsoft |
| serve their customers as well as by large | | | | Business Solution). |
| corporation to accrue and pay payroll checks, | | | | 2. eConnect US Payroll integration programming. |
| Social Security, Medicare, Federal and State | | | | eConnect is C# and VB .Net programmer friendly |
| Income taxes, plus W-2 printing and mailing to | | | | SDK, allowing Great Plains Developer to automate |
| employees. In order to save on Dynamics GP | | | | US Payroll integration in real time, if desired. If you |
| user licenses, it is common to see simple or | | | | are on Great Plains Dynamics GP versions 9.0 or |
| complex timecard custom made application on the | | | | 10.0 - please know that Integration Manager can |
| front, often web based, where employees are | | | | use eConnect connector as the technology base |
| logging their time on the daily base after each | | | | for the integration. eConnect breaks through |
| shift and then this timesheet logging application | | | | former limitations on the transaction volume, as |
| should be automatically or manually integrated | | | | eConnect is based on encrypted SQL stored |
| with Great Plains Dynamics GP. In this publication | | | | procedures. |
| we will review various options to do the job: | | | | 3. Third party Payroll integration products and |
| 1. Dynamics GP Integration Manager Payroll | | | | add-ons. In this small publication these are out of |
| connector. This is sort of user friendly tool, | | | | scope, here we only stress the fact, that IM or |
| however we recommend IT level involvement, as | | | | eConnect programming are so simple and cheap in |
| it requires you to understand such features as | | | | their installation and implementation, that they |
| Text file parsing, ODBC queries, and Advanced | | | | might be better way to go. |
| ODBC (where you can base your query on | | | | 4. Great Plains Business Portal Employee Self |
| custom SQL View with grouping, filtering and | | | | Service. If your IT department is strong enough |
| other SQL constructions). Great Plains Integration | | | | to the level of hosting your Microsoft Sharepoint |
| Manager allows you to add or update employee, | | | | and .Net website, please review Dynamics GP |
| set up employee taxes and deductions. Regarding | | | | Business Portal HR Employee Self Service |
| Payroll transactions integration - here you can | | | | functionality, where you can save on Payroll |
| integrate Hourly Pay Codes to the core US or | | | | Check stub mailing postage (as you are required |
| Canadian Payroll module logic to make them | | | | to either mail stub or provide gateway for self |
| available for batch processing in Great Plains | | | | service - to read stub out of the web), plus BP |
| Dynamics GP. GP IM integration could be easily | | | | HR has other cool features. |