This mini nonfiction is written, supported on new features of the product, as well as considering Microsoft Dynamics GP customization tools combining: Dex, eConnect, SQL Stored Procs, Extender. Currently we expect that you are exploitation Microsoft Dynamics GP version 9.0, presently we should wait for Microsoft Dynamics GP 10.0 to be released
o Microsoft Dexterity. It is likewise regularly associated near questionable Dynamics GP origin symbols scheduling. MBS VAR, who has right to fountainhead symbols (DYNAMICS.DIC dictionary near dex sanscript scripts souvenir). Dexterity has no precincts in accessing and modifying GP resources, specified as tables, forms, reports, scrolling windows, information types, etc. Obviously, when you get specified a ruling tool, you should expect that it will have as pluses as in good health as minuses. Dexterity is not on the record goal oriented lexis - you will inevitability to program old-good-days procedures, functions and dex cursors.
o Dexterity improvements. Beginning near journal 7.0 - you may run COM objects. Historically when SQL Server 6.5 was introduced Dex enabled line hold on procedures, much envy improvements allowed developers ring SQL scripts from dex.
Other sampleso 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 planning. We advise you to believe scenario, when Dexterity is utilized for new word generation and later from these new forms you telephone eConnect via eConnect XML Web Services surface. This attack allows you to invent broadloom GP purchaser/workstation unified tradition logic
o Extender. eOne Extender is incredibly bendy module, allowing you to "send back" dex sophistication and precedent GP forms, tables, quite a few posting logic, plus add Dex sunscript code to these new constructions. We would recommend Microsoft Visual Studio enhancement conceptualisation present - when you are through with next to tables prototyping in Extender, fulfil believe Visual Studio DLL hang over to labour with fresh created tables and name eConnect methods to fix GP objects
o SQL Scripting. In new Microsoft ERP products, such as as Axapta or Microsoft CRM - forward SQL scripting is as usual not verified. GP was traditionally leverage SQL coding, so you are treatment to manufacture SQL integrations, on the other hand you should have quite a few confidence next to Microsoft Great Plains Dexterity architecture: DEX_ROW_ID, for occasion. Dexterity has alleged matter scripts - keep procs, allowing Dex shell, written in C programing style to read SQL tables by dex indexes, these keep procs have affix zdp_*