Microsoft Dynamics GP customization tools combining: Dex, eConnect, SQL Stored Procs, Extender. Currently we assume that you are using Microsoft Dynamics GP version 9.0, soon we should expect Microsoft Dynamics GP 10.0 to be released
o Microsoft Dexterity. It is also often associated with so-called Dynamics GP source code programming. MBS VAR, who has access to source code (DYNAMICS.DIC dictionary with dex sanscript scripts present). Dexterity has no limits in accessing and modifying GP resources , such as tables, forms, reports, scrolling windows, data types, etc. Obviously, when you expect such a powerful tool, you should expect it that you will have pluses as well as asus minuses. will need to program old-good-days procedures, functions and dex cursors.
o Dexterity improvements. Beginning with version 7.0 - you may operate COM objects. Historically when SQL Server 6.5 was introduced Dex enabled calling stored procedures, more resent improvements allowed developers call SQL scripts from dex.
o Dexterity and eConnect. Contrary to Dexterity, eConnect allows you to manipulate GP objects: Customer, Vendor, Sales Order, Purchase Order, Employee, etc. - and so has elements of object-oriented programming. We recommend you to consider scenario, when Econnection via eConnect XML Web Services interface. This approach allows you to create seamless GP client / workstation integrated custom logic
o Extender. eOne Extender is very flexible module, you can "send back" dex complexity and prototype GP forms, tables, some posting logic, plus add Dex sunscript code to these new constructions. when you are done with tables prototyping in Extender, please consider Visual Studio DLL project to work with newly created tables and call eConnect methods to manipulate GP objects
___ ___ 0 ___ ___ 0 ___ ___ 0 Plains Dexterity architecture: DEX_ROW_ID, for example. Dexterity has so - called atomic scripts - stored procs, accept Dex shell, written in C programming language to read SQL tables by dex indexes, these stored procs have prefix zdp _ *
