Microsoft Dynamics GP Integration: Advanced Scenario

May 17

06:27

2006

Andrew Karasev

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

Article "tagged" as: