Microsoft Dynamics GP Integration: Advanced Scenario

Andrew Karasev

Alba Spectrum Group, USA/Canada: 1-866-528-0577, 1-630-961-5918,  help@albaspectrum.com skype: albaspectrum

Microsoft Dynamics GP 9.0 or old Microsoft Great Plains 8.0 has very solid and traditional integration tools, such as eConnect (designed for eCommerce developer), Integration Manager (this is end-user tool, with new trend to be rewritten in eConnect it is improving the performance).  Also bullet proof method is direct SQL coding – SQL Stored procedure does the job in SQL Server 2005, or SQL Server 2000/7.0.  In some cases, however you need advanced integration techniques, when you involve Microsoft Dexterity engine to help you with the functionality, lacking in eConnect or Integration Manager.  This technique is based on some Dexterity custom development, which in turn requires medium or advanced level of dexterity sanscript programming.

• Scenario.  Imagine – you create work transactions and place them into the work batch in SOP module, this could be relatively easy programmed in eConnect or through direct data insertion into SOP10100 and SOP10200 tables (document header and line).  Then, if you have automatic payments from your customers through eCommerce or via EDI, these batches are good to be posted automatically with applied deposits. 
• Dexterity Process Server.  Elegant technical solution is – use dexterity customization to track batch status and when it is ready to be posted (some custom flag).  Dexterity is running on one processing workstation (without operator intervention).  When flag is set – Dexterity calls its posting engine for SOP batch and “posting” in this case is not custom, but “native” and reliable, plus this type of approach doesn’t require reprogramming for version upgrade

Please do not hesitate to call or email us: USA/Canada: 1-866-528-0577, 1-630-961-5918, Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico: 52-55-535-04027 help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.ronix-systems.de  ) - 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, Europe: Germany, France, Belgium, Poland, Russia, Middle East (Egypt, Saudi Arabia, OAE, Bahrain), Asia: China, Australia, New Zealand, Oceania, South & Central America: Mexico, Peru, Brazil, Venezuela, Colombia, Ecuador, Chile, Paraguay, Uruguay, Argentina, Dominican Republic, Puerto Rico