Dynamics,Consultant,Newsflash, computer Dynamics GP Consultant Newsflash: Importing into Great Plain
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 ----------------------------------------------------------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
Dynamics GP has multiple data import and export options andin this small publication we would like to give you initial GP integrationhighlights: 1. Dynamics GP Integration Manager. This tool is really great and you can setupthe integration simply by reading IM user manual. It integrates text files: CSV, Tab andspecial character delimited. Also, youcan get advantage of more flexible ODBC data sources integration, where you candeploy such ODBC compliant constructions as SQL Views, includingcross-platform: Oracle, Lotus Notes, Pervasive SQL, Ctree, Microsoft Access,Excel, PHP mySQL (including bridges to Linux or Unix) to give you the idea. Plus, IM allows you to alter integrationlogic in VBA scripts: before integration, before document commit, and otherexecution points. You may say, that itis all great, the only problem for you is ERP implementation and support budget(especially now in 2009, when we are supposed to be in deep recession) Integration Manager doesnt come free with GP purchase (however Dynamics GPBusiness Ready license gives you, at least now the IM conversion license thisis temporary license, assuming that you need few month to conversion legacyaccounting and MRP data to Dynamics GP Great Plains) 2. Dynamics GP Macros. This technique is a bit creative and notnecessary known to every Dynamics GP programmer or consultant. Macros work even if you have add-ons, orthird party Dynamics GP ISV partners customizations. The idea of macro deployment is simple andstraightforward: open the window of the object to be integrated (customermaintenance for instance) and start recording macro inTools->Macro->Record. Entermanually two new customers and then stop playing macro. Look at the macro file, open Excel file withyour customers (coming from legacy system: PeachTree, MYOB, QuickBooks, LotusNotes Domino) and add macro commands as Excel columns (in between your customerrelated fields). Then save your Excelfile in text format and give the new text file macro extension. Now you are ready to play macro. Macro playing requires computer sessiondedication do not try to switch to another application while macro is inprogress simply take lunch or cup of coffee 3. eConnect programming. If you are on Dynamics GP 10.0 or 9.0, and ifyou classify yourself as Microsoft Visual Studio C# or VB.Net programmer withgood skills in SQL and XML, then you can program integration on your own. eConnect is especially great tool forecommerce programmer, who needs to expose Dynamics GP as back end ERP forecommerce application
Dynamics,Consultant,Newsflash,