zoycesar的部落格

This short nonfiction is written, supported on new features of the product, as in good health as considering Microsoft Dynamics GP customization tools combining: Dex, eConnect, SQL Stored Procs, Extender. Currently we accept that you are exploitation Microsoft Dynamics GP publication 9.0, in two shakes of a lamb's tail 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 origin symbols programming. MBS VAR, who has accession to well written communication (DYNAMICS.DIC dictionary with dex sanscript scripts bequest). Dexterity has no confines in accessing and modifying GP resources, such as tables, forms, reports, scrolling windows, information types, etc. Obviously, when you get such a coercive tool, you should wait for that it will have as pluses as good as minuses. Dexterity is not legitimately point bound discourse - you will demand to system old-good-days procedures, functions and dex cursors.

o Dexterity improvements. Beginning with variation 7.0 - you may operate COM objects. Historically when SQL Server 6.5 was introduced Dex enabled job hold on procedures, more envy improvements allowed developers bid SQL scripts from dex.

o Dexterity and eConnect. Contrary to Dexterity, eConnect allows you to work GP objects: Customer, Vendor, Sales Order, Purchase Order, Employee, etc. - and so has weather condition of object-oriented programming. We advise you to brand scenario, when Dexterity is utilized for new word form contemporaries and then from these new forms you nickname eConnect via eConnect XML Web Services surface. This line allows you to start off seamless GP punter/workstation incorporated tradition logic

o Extender. eOne Extender is extremely negotiable module, allowing you to \\"send back\\" dex involvedness and mould GP forms, tables, whatsoever placard logic, positive add Dex sunscript written language to these new constructions. We would urge Microsoft Visual Studio stirring approach present - when you are done near tables prototyping in Extender, satisfy muse Visual Studio DLL labor to sweat near just now created tables and phone call eConnect methods to fix GP objects

o SQL Scripting. In new Microsoft ERP products, such as as Axapta or Microsoft CRM - indicate SQL scripting is typically not subsidized. GP was traditionally investment SQL coding, so you are warmth to invent SQL integrations, notwithstanding you should have whatsoever information beside Microsoft Great Plains Dexterity architecture: DEX_ROW_ID, for sampling. Dexterity has questionable substance scripts - keep procs, allowing Dex shell, shorthand in C programing prose to read SQL tables by dex indexes, these hold on procs have affix zdp_*