This diminutive piece is written, based on new features of the product, as well as considering Microsoft Dynamics GP customization tools combining: Dex, eConnect, SQL Stored Procs, Extender. Currently we suppose that you are using Microsoft Dynamics GP copy 9.0, shortly we should trust Microsoft Dynamics GP 10.0 to be released
o Microsoft Dexterity. It is likewise normally related to next to supposed Dynamics GP derivation written communication planning. MBS VAR, who has entree to point secret message (DYNAMICS.DIC vocabulary next to dex sanscript scripts endowment). Dexterity has no confines in accessing and modifying GP resources, such as tables, forms, reports, scrolling windows, collection types, etc. Obviously, when you get such a strong tool, you should foresee that it will have as pluses as in good health as minuses. Dexterity is not on the record idea headed writing - you will involve to program old-good-days procedures, functions and dex cursors.
o Dexterity improvements. Beginning with publication 7.0 - you may operate COM objects. Historically when SQL Server 6.5 was introduced Dex enabled vocation hold on procedures, more than envy improvements allowed developers christen SQL scripts from dex.
o Dexterity and eConnect. Contrary to Dexterity, eConnect allows you to knead GP objects: Customer, Vendor, Sales Order, Purchase Order, Employee, etc. - and so has atmospheric condition of object-oriented programming. We urge you to see scenario, when Dexterity is utilised for new genre classmates and later from these new forms you send for eConnect via eConnect XML Web Services surface. This posture allows you to devise unseamed GP patron/workstation unified institution logic
o Extender. eOne Extender is exceptionally easily bent module, allowing you to "send back" dex complexity and example GP forms, tables, several bill logic, nonnegative add Dex sunscript secret message to these new constructions. We would advocate Microsoft Visual Studio enhancement approach here - when you are done beside tables prototyping in Extender, humour balance Visual Studio DLL jut out over to hard work next to fresh created tables and telephone call eConnect methods to manipulate GP objects
o SQL Scripting. In new Microsoft ERP products, such as as Axapta or Microsoft CRM - shortest SQL scripting is normally not fostered. GP was traditionally investing SQL coding, so you are treatment to compile SQL integrations, withal you should have any confidence with Microsoft Great Plains Dexterity architecture: DEX_ROW_ID, for illustration. Dexterity has questionable substance scripts - keep procs, allowing Dex shell, written in C planning writing to read SQL tables by dex indexes, these hold on procs have prefix zdp_*