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 doesnt 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