Great,Plains,Accounting,for,DO computer Great Plains Accounting for DOS and Windows Data Export Note

----------------------------------------------------------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 onarchaic platforms, such as Windows NT, Novell, Windows 95 (as GPA userworkstation), please know that there is technology which allows you to redeployGreat Plains Accounting on Pervasive SQL 2000 and new Windows 2003 Server, andhave DOS user interface redeployed on Windows XP - however this subject isoutside of the scope for this publication, please call us if you need thisservice.  Let's begin GPA data exportopus: 1.       AccountsReceivable export.  Open GPA, Open AR,Reports->Customer List, fill in selection criteria or simply enter througheach field to select All customers, click Print->Screen or Export File, markTitles, Legends, Headers, Footers and print all your customers.  If you printed to the file, you should beable to import it to Excel and do necessary data massage for using it as sourcefile for new Corporate ERP data conversion (if you are migrating to MicrosoftDynamics GP 10.0, 9.0, 8.0, 7.5, you do not have to do it, as Great PlainsDynamics has GPA migration tool, simply call your Great Plains Partner fordetails) to Oracle Financials/Applications/eBusiness Suite, Accpac, QuickBooks,Lawson, Epicor, Navision, Axapta, etc. Now, for Historical AR records, simply select Transaction History report 2.       AccountsPayable, Purchase Order and (Sales) Order Entry, use the same report:Transaction History in each section.  ForGL Transaction history we recommend you to use Trial Balance report - this isGL traditional naming convention for Posted Transactions analysis report, andit should give you enough supporting info for GL history records.  Chart Of accounts is exportable via AccountLists report.  In our opinion, you do noteven have to come to direct data reading consideration, as GPA reporting isreasonably robust and versatile, and you can use reporting even if you are onsuch exotic versions as Great Plains Accounting for Mac (Macintosh OS: PowerPCetc.).  If you still would like to readyour GPA Btrieve files in Microsoft Access, let's move to the next paragraph 3.       Settingup GPA ODBC driver.  Here you need tocreate DDF files, as they are required by Pervasive SQL and its predecessorBtrieve.  Please, insert your GPA CD, andgo to Docs section Btrieve.  Below is thequote from ODBC2000NT Manual:  Installthe Data Definition Files (DDFs)  Installthe Data Definition Files (DDFs) for Great Plains Accounting. Great Plains hasproduced DDF files for Versions 9.1 and later that are ODBC-compliant anddiffer from prior versions of the DDF’s. Because these files differ fromearlier versions, we are NOT claiming compatibility with ODBC on versions ofGreat Plains Accounting prior to Version 9.1. To install these DDFs, go to aDOS prompt and switch to the directory of a company whose data you wish toaccess. Insert the diskette labeled “ODBC Disk 1 of 2.” Type A:INSTALL A:. Thiswill load the FIELD.DDF, FILE.DDF and INDEX.DDF files into that company directory.These must be installed directly in the company’s data folder (ex. GPDATA) thatyou wish to set up the data source for, otherwise you will not be able to seeyour data. 4.       GPAMigration Path to Great Plains 7.5.  Ifyour business is flourishing and you would like to walk away from archaicCorporate ERP, such as GPA for DOS or Windows (support was terminated by GreatPlains Software in 2001, Microsoft Business Solutions, current owner of GreatPlains Dynamics offers discount for migration, typically 40% of the GPA modulesowned by your organization), please call us for upgrade path info andreenrollment into Microsoft Dynamics GP annual enhancement program 5.       NewCompany License Key in GPA.  If you wouldlike to open new company in Great Plains Accounting, please give us a call, wewill send you Dynamics GP Partner Change Form, when we see your records inMicrosoft Business Solutions Customer database, we can generate new reg key,associated with your new company name 6.       GPAknowledge base level support.  Virtuallyevery error was documented and resolved during the GPA support era in late1980th through early 2000th.  All we needfrom you is exact error message and description of your actions to reproducethis error, the rest is our job - we should recommend you matching solution orthe next step to further identify the error nature.  Please, note that there is no way to purchasenew modules or add new users to your GPA licensing, as Microsoft shut GPA licensingDB down in earlier 2000th 7.       Howto get GPA help?  How to get help?  Please, feel free to call us: 1-866-528-0577,outside of USA: 1-630-961-5918 or email us [email protected]  We are very technical and real Dynamics GPDexterity, SAP Business One SDK programming gurus.  We have Great Plains Software DevelopmentFactory and could support unlimited Dynamics GP Customization and Programmingneeds.  Plus we speak English, Chinese,Spanish, Portuguese, Russian, and not only as native speaking sales folks, butas real technical consultants.  If youprefer skype: albaspectrum