Microsoft Dynamics Gp Great Plains Integrations

Writen by Andrew Karasev

Microsoft Great Plains or former Great Plains Software Dynamics/eEnterprise was designed in 1990th with specially created Great Plains Software Dexterity programming language and development environment. Currently Microsoft Business Solutions (renamed into Microsoft Dynamics) is applying new Microsoft .net, eConnect, XML web services and MS Office stack integration to Microsoft Dynamics GP, however Dexterity core is still strong and end-user integration – Microsoft Dynamics GP Integration Manager

• Dexterity Fat Client as OLE Server. When you are launching Integration Manager- you need to close all Microsoft Great Plains forms, including menu pallets – the reason is simple – IM uses GP workstation as OLE server to validate IM manager integrations business logic enforcement directly through GP forms

• VBA Scripting. You can do some SQL manipulations in advanced ODBC query, such methods as sorting, grouping, aggregation, however the real power of integration manager lays in the manipulation of VBA scripting – you can replace portions of IM logics with your custom VBA scripts. The same technique was popular for Microsoft Excel several years ago, prior to introduction of Microsoft .Net strategy

• eConnect. As Microsoft plans – GP IM will be totally rewritten in eConnect – eConnect will allow to resolve IM performance issue and will so allow you huge real time integration (when you need to integrate thousand orders per hour for example).

• C#, VB and MS Visual Studio. Contrary to Great Plains Dexterity, which is proprietary platform and requires company licensing and training to do programming, Visual Studio requires individual licensing and could be available to broad masses of programmers. Visual Studio developers should concentrate on eConnect direction of Microsoft Dynamics GP customization and integration

• Axapta, Navision, Solomon directions. Microsoft Dynamics project as a successor of Microsoft Project Green is aiming to synchronize all Microsot ERp applications, however it is probably difficult to predict if it will be licensing/scaling/upgrade path or real modules cross-integration. Possible scenario is – when you are small business you use Microsoft Small Business Accounting, then you upgrade to Microsoft Dynamics GP and when you go public you upgrade to Microsoft Dynamics AX Axapta

Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally. We are serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM, MN, Chicago, New York, Los Angeles, Phoenix, San Francisco, Denver, Seattle, Boston, Atlanta, Miami, Houston, Dallas, San Diego, Toronto, Montreal, Vancouver, Minneapolis, Washington, Baltimore, New Orleans, Austin, Kansas City.