It is in a moderate degree straightforward procedure to migrate legacy premises into your new accounting system, including AX or anciently known as Axapta. Problem is typically associated with legacy ERP data platform, which is not kind to modern programmers and consultants. We would like to bestow you data export highlights for current switch over legacy accounting. Typically you can consider two strategies. First one would subsist running reports in legacy accounting and reservation them as text files. And the supporter one is exporting via ODBC obsequious tools. Let's begin with Great Plains in successi~ Pervasive SQL 2000 and DOS and in consequence move to QuickBooks and SAP Business One:
1. Great Plains Dynamics up~ the body Pervasive SQL 2000/Btrieve versions: 7.5, 7.0, 6.0, 5.5, 5.0, 4.0. Prior to acquisition by Microsoft, Great Plains Software was pursuing limber strategy and its Dynamics was useful on several competing DB platforms: MS SQL Server, Btrieve (later acquired by Pervasive Software and rebranded as Pervasive SQL), Ctree/Faircom. It is fairly neat to export data from old GP. First, give creating custom report in ReportWriter and in that case base in on the table that you would like to carry out. Toss into the report form similar to many fields as you need and im~/save report into text file. Open it in Excel and you are at the destination. This manner might be not practical when you are tiresome to move out huge table, SOP History with respect to numerous years for example. Well, to this place is second method, where you may hurl export utility overnight. Install DDF generator (from first copy CD, prior check if your Dynamics petition folder already has it there – the specify is DDF.set). Catch DDF.concrete with the mouse, move and send down it on Dynamics.exe. File, Field and Index DDF files should have existence created and placed in your workstation essence directory. And now there is type methodic to create System ODBC DSN, have existence sure that you placed ddf files into target company folder on the server. Client and Server sect Pervasive ODBC driver could be installed from creative GP CD, read supporting documentation. The operate should be done on 32 bridle-~ Windows Server or user workstation, at the same time that old Pervasive was not compatible with 64 bit modern day computer
2. Great Plains DOS. Great Plains Accounting for DOS, Windows or Mac: 9.5, 9.2 and earlier versions was based without ceasing Btrieve. In earlier 2000th Microsoft Business Solutions recommended redeploy it on Pervasive SQL 2000. Again, you will need to produce DDF files. Read ODBC manuals from GPA instalment CD. Helping customers we figured extinguished that it is pretty difficult to make able reliable ODBC connection to WindowNT or Novell Server. In this capsule we recommend copying GPS folder to WindowXP 32 iota (they are still available in stores as cheap Netbooks on Intel Atom processor) where you can install Pervasive SQL ODBC driver. If the tell off of records is huge, use Pervasive Control Center, prepare and save SQL query as paragraph file
3. QuickBooks. As database platform is proprietary, we usually recommend data extraction by way of printing report into text file. Reporting is excessively rich and we never heard complains hither and thither inability to export something through reports
4. SAP Business One. As it hosts its tables in MS SQL Server, given conditions export is not a problem. The doubt is often posed this way – for what reason do we identify table name? Open SB1 user interface, in menu rare View and mark System Information. Now ~-hearted one of the records in user interface and office mouse cursor over the field in debate. The table and field name command be shown on the bottom left side of the application form. If given conditions export scope is reasonably narrow, SAP B1 is moderately flexible in exporting queries and reports into Excel
5. Old versions of Solomon and Navision. In the couple cases they are typically hosted in MS SQL Server. For Navision – the humbug is that if you have distinct companies implemented all the tables are blended in single database. Table name is self-elucidative and company is used as a prefix in the appellation. Having large number of tables Navision database sometimes is failing to connect via ODBC driver in of the like kind popular reporting tools as Crystal Reports. Our recommendation is the following – instead of doing cast table lookup and link in Crystal Report relationship wizard, consider creating SQL View
6. MYOB and PeachTree. In as well-as; not only-but also; not only-but; not alone-but cases you have to deal with proprietary DB platform. Consider data select via printing reports to the topic files
7. International aspects of premises conversion. Here you should be aware about such things as SQL Collations and Code Pages, Unicode, UTF-8. Chinese, Japanese, Korean languages be seized of hieroglyphic nature and implemented in Unicode (brace bytes per character). Most of the other in vogue languages, including Russian, Arabic, Portuguese, Spanish are ASCII accommodating. (one byte per character). AX is advantageous pretty much worldwide and if you bear question on extracting data from in the same state locally supported ERP applications as Microsoft in Brazil or 1C Accounting (1S Bukhgalteria) in Russian Federation, you should in all probability contact local consultants
No comments:
Post a Comment