| Microsoft Dynamics GP US Payroll module calculates | | | | 2. How to update Payroll tables if you are |
| Federal, State and Local taxes and as you can | | | | on Ctree or Pervasive SQL. This may seem as grim |
| imagine taxes change on the regular basis, likely every | | | | problem, however to Great Plains Technical consultant |
| year you see tax formula changes — Microsoft | | | | and SQL programmer it is not such a big deal. The |
| Business Solutions, as well as earlier Great Plains | | | | hint here is this — bring with you your laptop, |
| Software has tax update download, which you can do | | | | where you have Dynamics GP 10.0 or 9.0 installed with |
| either from Partner Sourceif you are Dynamics GP | | | | UPR payroll tax tables populated with newer Payroll |
| Reseller, or from Customer Source, if you are end | | | | tax update. In our legacy Great Plains environment, |
| customer. In this small publication we will try to give | | | | install Pervasive SQL Server or Client driver |
| your technical highlights on tax updates, especially | | | | (depending on where you are linking from — |
| when you are on older Great Plains versions: 8.0, 7.5, | | | | server or client, plus also review if you have to |
| 7.0, 6.0, 5.5, 5.0. Payroll tax update might look like | | | | generate DDF files — or data definition files), or |
| minor issue for somebody, however if you are midsize | | | | Ctree driver (if you are on Ctree). In Microsoft |
| organization on old Great Plains Dynamics or | | | | Access create new database, instead of creating |
| eEnterprise version, you don’t want to mail | | | | new physical tables, create linked tables and switch to |
| incorrect W-2 form to your employees and | | | | ODBC link. Select all the tables (or just UPR tables if |
| contractors | | | | you are interested in Payroll only). If you are |
| | | | | comfortable with Microsoft SQL Server Linked Server |
| 1. Payroll Tax Update process. If you | | | | construction, please connect now your Microsoft SQL |
| download tax update from MBS Source, you will see | | | | Server 2000 or 2005 to Pervasive SQL or Microsoft |
| that it populates UPR41300 and related tables in | | | | Access ODBC data source to begin Payroll Tax |
| Dynamics database. These tables have similar | | | | update roll out to your Pervasive SQL or Ctree tables |
| structure for older Great Plains versions, and if you are | | | | |
| Great Plains consultant, you could simply roll down | | | | 3. Great Plains Accounting for DOS and |
| updates from Great Plains Dynamics GP 10.0 | | | | Windows Support. Here we recommend you to |
| Dynamics tax tables to linked server, where you have | | | | migrate from Novell or Windows NT 4.0 Server to |
| older version of Great Plains installed | | | | Windows 2003 Server and change DB platform to |
| | | | | Pervasive SQL 2000, preferably Service Pack 3. |