Great,Plains,Partner,Los,Angel computer Great Plains Partner Los Angeles, Chicago Newsflash: GP Payr
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
if you are Dynamics GP Reseller, or from Customer Source, ifyou are end customer. In this smallpublication we will try to give your technical highlights on tax updates, especiallywhen 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 issuefor somebody, however if you are midsize organization on old Great PlainsDynamics or eEnterprise version, you dont want to mail incorrect W-2 form toyour 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 Dynamicsdatabase. These tables have similarstructure for older Great Plains versions, and if you are Great Plainsconsultant, you could simply roll down updates from Great Plains Dynamics GP10.0 Dynamics tax tables to linked server, where you have older version ofGreat Plains installed 2. How to update Payroll tables if you are on Ctreeor Pervasive SQL. This may seem as grimproblem, however to Great Plains Technical consultant and SQL programmer it isnot such a big deal. The hint here isthis bring with you your laptop, where you have Dynamics GP 10.0 or 9.0installed with UPR payroll tax tables populated with newer Payroll taxupdate. In our legacy Great Plains environment,install Pervasive SQL Server or Client driver (depending on where you arelinking from server or client, plus also review if you have to generate DDFfiles 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 toODBC link. Select all the tables (orjust UPR tables if you are interested in Payroll only). If you are comfortable with Microsoft SQLServer Linked Server construction, please connect now your Microsoft SQL Server2000 or 2005 to Pervasive SQL or Microsoft Access ODBC data source to beginPayroll Tax update roll out to your Pervasive SQL or Ctree tables 3. Great Plains Accounting for DOS and WindowsSupport. Here we recommend you tomigrate from Novell or Windows NT 4.0 Server to Windows 2003 Server and changeDB platform to Pervasive SQL 2000, preferably Service Pack 3. If you are on GPA for DOS or Windows, thenunlikely that you are using Payroll module, as Payroll is very cheap tooutsource nowadays
Great,Plains,Partner,Los,Angel