Green Accounting
Posted: Nov 05, 2011 |Comments:
Fast, Powerful, Affordable, Easy Migration Tools. Free Download!
Sesame Software Relational Junction for Data Integration ; Analysis
If you are staying within the same application vendor them chances are high that there is migration tool. Master data, open and historical documents. Which documents to migrate? It is reasonably low for master records and often high for historical transactions. 3. Data migration technology. Each ERP application has its own integration tool. Peach Tree has Excel templates. The challenge is often related to the way of exporting data from legacy accounting database. Exporting records from Great Plains. When customers are talking about Great Plains they might be referring Great Plains Accounting for DOS 9.5 or earlier version or Great Plains Dynamics 5.5, 6.0, 7.5. Since version 8.0 Dynamics GP or in essence rebranded Great Plains Dynamics was available exclusively on MS SQL Server platform. SQL Server data export is not a big challenge. Table structure could be reviewed in GP SDK or in user interface: Tools -> Resource Description -> Tables. ODBC connection could be established in Pervasive SQL Control Center where you need DDF (Data Definition) files. Exporting documents from SAP Business One. Exporting transactions from small business accounting and ERP packages such as MYOB, Peachtree, QuickBooks and Quicken. Excel as data cleansing tool. If you are facing the same problem we recommend you to import exported records into custom SQL table via data import wizard (SSIS in SQL Server 2008 or 2005) and then do cleansing job via SQL Views8. Second Opinion in Migration Projects. Local firms are doing great job by popularizing and selling modern accounting packages.
No comments:
Post a Comment