| If you still have GPA for DOS or Windows versions | | | | Files (DDFs) for Great Plains Accounting. Great Plains |
| 9.5, 9.2, 9.1 and earlier as your Corporate ERP, MRP | | | | has produced DDF files for Versions 9.1 and later that |
| Sales Order Processing, Inventory Control, Purchase | | | | are ODBC-compliant and differ from prior versions of |
| Order Processing and Accounting application, we are | | | | the DDF’s. Because these files differ from earlier |
| offering you this small publication where we compile | | | | versions, we are NOT claiming compatibility with |
| our experience on Exporting data from GPA. If you | | | | ODBC on versions of Great Plains Accounting prior to |
| are on archaic platforms, such as Windows NT, Novell, | | | | Version 9.1. To install these DDFs, go to a DOS prompt |
| Windows 95 (as GPA user workstation), please know | | | | and switch to the directory of a company whose data |
| that there is technology which allows you to redeploy | | | | you wish to access. Insert the diskette labeled |
| Great Plains Accounting on Pervasive SQL 2000 and | | | | “ODBC Disk 1 of 2.” Type A:INSTALL A:. This |
| new Windows 2003 Server, and have DOS user | | | | will load the FIELD.DDF, FILE.DDF and INDEX.DDF files |
| interface redeployed on Windows XP - however this | | | | into that company directory. These must be installed |
| subject is outside of the scope for this publication, | | | | directly in the company’s data folder (ex. |
| please call us if you need this service. Let's begin | | | | GPDATA) that you wish to set up the data source |
| GPA data export opus: | | | | for, otherwise you will not be able to see your data. |
| 1. Accounts Receivable export. Open GPA, Open | | | | 4. GPA Migration Path to Great Plains 7.5. If your |
| AR, Reports->Customer List, fill in selection criteria or | | | | business is flourishing and you would like to walk away |
| simply enter through each field to select All customers, | | | | from archaic Corporate ERP, such as GPA for DOS |
| click Print->Screen or Export File, mark Titles, | | | | or Windows (support was terminated by Great Plains |
| Legends, Headers, Footers and print all your | | | | Software in 2001, Microsoft Business Solutions, current |
| customers. If you printed to the file, you should be | | | | owner of Great Plains Dynamics offers discount for |
| able to import it to Excel and do necessary data | | | | migration, typically 40% of the GPA modules owned |
| massage for using it as source file for new Corporate | | | | by your organization), please call us for upgrade path |
| ERP data conversion (if you are migrating to Microsoft | | | | info and reenrollment into Microsoft Dynamics GP |
| Dynamics GP 10.0, 9.0, 8.0, 7.5, you do not have to do it, | | | | annual enhancement program |
| as Great Plains Dynamics has GPA migration tool, | | | | 5. New Company License Key in GPA. If you would |
| simply call your Great Plains Partner for details) to | | | | like to open new company in Great Plains Accounting, |
| Oracle Financials/Applications/eBusiness Suite, Accpac, | | | | please give us a call, we will send you Dynamics GP |
| QuickBooks, Lawson, Epicor, Navision, Axapta, SAP | | | | Partner Change Form, when we see your records in |
| Business One, etc. Now, for Historical AR records, | | | | Microsoft Business Solutions Customer database, we |
| simply select Transaction History report | | | | can generate new reg key, associated with your new |
| 2. Accounts Payable, Purchase Order and (Sales) | | | | company name |
| Order Entry, use the same report: Transaction History | | | | 6. GPA knowledge base level support. Virtually every |
| in each section. For GL Transaction history we | | | | error was documented and resolved during the GPA |
| recommend you to use Trial Balance report - this is | | | | support era in late 1980th through early 2000th. All |
| GL traditional naming convention for Posted | | | | we need from you is exact error message and |
| Transactions analysis report, and it should give you | | | | description of your actions to reproduce this error, the |
| enough supporting info for GL history records. Chart | | | | rest is our job - we should recommend you matching |
| Of accounts is exportable via Account Lists report. In | | | | solution or the next step to further identify the error |
| our opinion, you do not even have to come to direct | | | | nature. Please, note that there is no way to purchase |
| data reading consideration, as GPA reporting is | | | | new modules or add new users to your GPA licensing, |
| reasonably robust and versatile, and you can use | | | | as Microsoft shut GPA licensing DB down in earlier |
| reporting even if you are on such exotic versions as | | | | 2000th |
| Great Plains Accounting for Mac (Macintosh OS: | | | | 7. How to get GPA help? How to get help? Please, |
| PowerPC etc.). If you still would like to read your | | | | feel free to call us: 1-866-528-0577, outside of USA: |
| GPA Btrieve files in Microsoft Access, let's move to | | | | 1-630-961-5918 or email us We are very technical |
| the next paragraph | | | | and real Dynamics GP Dexterity, SAP Business One |
| 3. Setting up GPA ODBC driver. Here you need to | | | | SDK programming gurus. We have Great Plains |
| create DDF files, as they are required by Pervasive | | | | Software Development Factory and could support |
| SQL and its predecessor Btrieve. Please, insert your | | | | unlimited Dynamics GP Customization and |
| GPA CD, and go to Docs section Btrieve. Below is | | | | Programming needs. Plus we speak English, Chinese, |
| the quote from ODBC2000NT Manual: Install the | | | | Spanish, Portuguese, Russian, and not only as native |
| Data Definition Files (DDFs) Install the Data Definition | | | | speaking sales folks, but as real technical consultants. |