Microsoft Dynamics GP US Payroll module calculates Federal, State and Local taxes and as you can imagine taxes change on the regular basis, likely every year you see tax formula changes – Microsoft Business Solutions, as well as earlier Great Plains Software has tax update download, which you can do either from Partner Source
if you are Dynamics GP Reseller, or from Customer Source, if you are end customer. In this small publication we will try to give your technical highlights on tax updates, especially when you are on older Great Plains versions: 8.0, 7.5, 7.0, 6.0, 5.5, 5.0. Payroll tax update might look like minor issue for somebody, however if you are midsize organization on old Great Plains Dynamics or eEnterprise version, you don’t want to mail incorrect W-2 form to your employees and contractors
1. Payroll Tax Update process. If you download tax update from MBS Source, you will see that it populates UPR41300 and related tables in Dynamics database. These tables have similar structure for older Great Plains versions, and if you are Great Plains consultant, you could simply roll down updates from Great Plains Dynamics GP 10.0 Dynamics tax tables to linked server, where you have older version of Great Plains installed
2. How to update Payroll tables if you are on Ctree or Pervasive SQL. This may seem as grim problem, however to Great Plains Technical consultant and SQL programmer it is not such a big deal. The hint here is this – bring with you your laptop, where you have Dynamics GP 10.0 or 9.0 installed with UPR payroll tax tables populated with newer Payroll tax update. In our legacy Great Plains environment, install Pervasive SQL Server or Client driver (depending on where you are linking from – server or client, plus also review if you have to generate DDF files – or data definition files), or Ctree driver (if you are on Ctree). In Microsoft Access create new database, instead of creating new physical tables, create linked tables and switch to ODBC link. Select all the tables (or just UPR tables if you are interested in Payroll only). If you are comfortable with Microsoft SQL Server Linked Server construction, please connect now your Microsoft SQL Server 2000 or 2005 to Pervasive SQL or Microsoft Access ODBC data source to begin Payroll Tax update roll out to your Pervasive SQL or Ctree tables
3. Great Plains Accounting for DOS and Windows Support. Here we recommend you to migrate from Novell or Windows NT 4.0 Server to Windows 2003 Server and change DB platform to Pervasive SQL 2000, preferably Service Pack 3. If you are on GPA for DOS or Windows, then unlikely that you are using Payroll module, as Payroll is very cheap to outsource nowadays
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
