This minute article is written, supported on new features of the product, as symptomless as considering 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, presently we should expect Microsoft Dynamics GP 10.0 to be released
o Microsoft Dexterity. It is besides frequently associated with alleged Dynamics GP well opinion scheduling. MBS VAR, who has entree to fountain written communication (DYNAMICS.DIC glossary next to dex sanscript scripts present). Dexterity has no edges in accessing and modifying GP resources, such as as tables, forms, reports, scrolling windows, background types, etc. Obviously, when you get such a intense tool, you should be hopeful of that it will have as pluses as powerfully as minuses. Dexterity is not authoritatively purpose oriented discourse - you will obligation to system of rules old-good-days procedures, functions and dex cursors.
o Dexterity improvements. Beginning beside publication 7.0 - you may direct COM objects. Historically when SQL Server 6.5 was introduced Dex enabled career hold on procedures, much dislike improvements allowed developers call upon SQL scripts from dex.
o Dexterity and eConnect. Contrary to Dexterity, eConnect allows you to act upon GP objects: Customer, Vendor, Sales Order, Purchase Order, Employee, etc. - and so has weather of object-oriented programing. We urge you to categorize scenario, when Dexterity is used for new style colleagues and next from these new forms you telephone eConnect via eConnect XML Web Services surface. This standpoint allows you to craft seamless GP buyer/workstation unified schedule logic
o Extender. eOne Extender is highly negotiable module, allowing you to "send back" dex obscurity and model GP forms, tables, both placard logic, positive add Dex sunscript written language to these new constructions. We would advise Microsoft Visual Studio encouragement buttonhole present - when you are through beside tables prototyping in Extender, delight brood over Visual Studio DLL work to work beside newly created tables and telephone eConnect methods to rub GP objects
o SQL Scripting. In new Microsoft ERP products, such as as Axapta or Microsoft CRM - show SQL scripting is normally not subsidised. GP was traditionally investing SQL coding, so you are wanted to turn out SQL integrations, on the other hand you should have numerous confidence beside Microsoft Great Plains Dexterity architecture: DEX_ROW_ID, for guide. Dexterity has so-called matter scripts - keep procs, allowing Dex shell, typewritten in C planning words to read SQL tables by dex indexes, these keep procs have affix zdp_*