| Microsoft Dynamics GP ERP, current version is | | | | and others. eConnect doesn’t post batches |
| 10.0 has a list of pretty robust modification and | | | | automatically and if you need your Sales Invoices |
| development tools, including Microsoft Dexterity, | | | | to be posted directly from e-commerce, you |
| eConnect, SDK for Visual Studio Programmer, | | | | need Albaspectrum posting server add-on |
| SQL stored procedures and views, VBA with | | | | 2. Great Plains Dexterity. This tool is in essence |
| Modifier. Plus you can deploy integration tools, | | | | GP architecture, it is written in C programming |
| such as GP Integration Manager with the options | | | | language as a shell with its own proprietary |
| of data translation, scripting, advanced ODBC | | | | scripting language Sanscript. Dex is almighty and |
| queries. Based on your programming skills and | | | | there are no barriers in its programming and |
| preferences you can use one tool or another, | | | | modification power. However Dex programmers |
| however it is helpful to know the typical | | | | are not commonly available on the job market |
| recommendations in tools selection: | | | | and you need to make your own subcontractors |
| 1. eConnect. This tool was specially recommended | | | | search in your area or appeal to nationwide |
| and initially dedicated to eCommerce web | | | | support for Dexterity developing |
| developers, who are linking e-commerce site with | | | | 3. SQL scripting. Technically there is a possibility to |
| GP ERP as accounting back office. eConnect was | | | | do direct data pulling and in certain cases data |
| introduced to serious integration around 2004. | | | | insertion to GP tables. The second option requires |
| Since then eConnect scope was extended to | | | | more expertise and accuracy simply to avoid data |
| automate master records and work transaction | | | | damage and inconsistency cause |
| creation in most of the native GP modules: SOP, | | | | 4. Reporting. |
| GL, POP, RM, PM, IV, Payroll, Project Accounting | | | | |