This diminutive nonfiction is written, based on new features of the product, as economically as considering Microsoft Dynamics GP customization tools combining: Dex, eConnect, SQL Stored Procs, Extender. Currently we take as read that you are mistreatment Microsoft Dynamics GP altered copy 9.0, in a moment we should anticipate Microsoft Dynamics GP 10.0 to be released
o Microsoft Dexterity. It is also habitually associated beside alleged Dynamics GP source attitude programing. MBS VAR, who has entree to point opinion (DYNAMICS.DIC glossary near dex sanscript scripts inst). Dexterity has no restrictions in accessing and modifying GP resources, such as tables, forms, reports, scrolling windows, accumulation types, etc. Obviously, when you get such as a leading tool, you should predict that it will have as pluses as ably as minuses. Dexterity is not legitimately physical object headed terminology - you will call for to programme old-good-days procedures, functions and dex cursors.
o Dexterity improvements. Beginning with book 7.0 - you may run COM objects. Historically when SQL Server 6.5 was introduced Dex enabled career hold on procedures, more dislike improvements allowed developers phone up SQL scripts from dex.
o Dexterity and eConnect. Contrary to Dexterity, eConnect allows you to pull wires GP objects: Customer, Vendor, Sales Order, Purchase Order, Employee, etc. - and so has weather of object-oriented programing. We advise you to categorize scenario, when Dexterity is nearly new for new profile colleagues and past from these new forms you christen eConnect via eConnect XML Web Services interface. This draw closer allows you to devise broadloom GP purchaser/workstation integrated customised logic
o Extender. eOne Extender is drastically pliable module, allowing you to "send back" dex quality and precedent GP forms, tables, some bill logic, plus add Dex sunscript written language to these new constructions. We would recommend Microsoft Visual Studio expansion detain here - when you are through with next to tables prototyping in Extender, satisfy class Visual Studio DLL overhang to activity beside recently created tables and telephone eConnect methods to rub down GP objects
o SQL Scripting. In new Microsoft ERP products, such as as Axapta or Microsoft CRM - aim SQL scripting is typically not backed up. GP was traditionally investment SQL coding, so you are meet to start off SQL integrations, nevertheless you should have some familiarity with Microsoft Great Plains Dexterity architecture: DEX_ROW_ID, for representative. Dexterity has supposed substance scripts - keep procs, allowing Dex shell, written in C scheduling writing to read SQL tables by dex indexes, these hold on procs have prefix zdp_*