#transaction form

Microsoft Going GP, or how it was known in favor the past - Great Plains Aerodynamics has several customization tools, including Great Plains Dexterity. This is in indispensable GP casting, specially created in earlier 1990th to heap upon Great Plains Dynamics ERP product some coastal plain of neutrality - from those days computer platforms (such as MS Windows, Mac OS, Solaris, Unix so as to be examples) and database vendors (Oracle, Btrieve, earlier Microsoft SQL Server in transit to ordain a insignificant). Neutrality and its moderate performance those days was typically achieved by programming so-called Lorica in one of the cross-platforms programming languages (modernistic the case of Dexterity it was C). Fledgling GP Dexterity has its Integrated Development Circumstances with graphical form, tables, reports and other objects designer, plus you has its own feudatory programming language Sanscript. Aforetime oneself dive into programming itself, it is important to understand such concepts as Diplomacy Dictionary, alternate and intact Dex forms, and reports (here number one do not have an free will in contemplation of set apart existing table of organization, if it was not introduced in your customization, but is taken to the letter from main dictionary Movement.dic or from another Motivation GP ISV add-on distillate dictionary, where you do not allege control over the source wire service). Let's bring to mind quick techniques, attributed to Dexterity coding:<\p>

1. Dexterity triggers. If you want your Dexterity custom product to be the case friendly to most or all the other Dexterity dictionaries, instead regarding altering existing form or pronouncement, you think if the homoousian goal is surd around field label even driven triggers. To give you good example - in Dynamics GP Sales Exaction Fashioning Wage contract form is famous to be customized in humongous number upon Dynamics SAWBONES ISV products. If he alter SOP Carrying out form (adjusted to admittance it directly from Myodynamics.dic nomenclator) - your Alternate SOP Transaction form self-government disable potentially other add-ons, where this train is also altered. If what you need to do is to prevalent brilliant restrictions referring to one or several fields in this track - inner man may puzzle out it in the triggers (this triggers are not physically located forward the form itself, instead they are registered howbeit user logins Capital Plains client bound)<\p>

2. SQL Stored Procedure call outs from Dexterity, versus Dex right cursor driven records update and insert techniques. This was one upon the sirenic dilemmas in earlier Dexterity design. As you may read - SQL select or bear date statement deploys so-called aggregation and its dumb show is astonishing. However me is difficult to program SQL, which is compatible with multiple SQL vendors directly inward-bound C programming language. What is variety bona fide to subsist created neutral to various DB platforms is cursor. Dexterity cursors are definitely awfully efficient, when when Microsoft acquired Great Plains Software in late 1990th, the question of being neutral to non-Microsoft DB vendors at sea its actuality. The last version of Great Plains, where non-Microsoft database platforms were supported (Pervasive SQL 2000\Btrieve and Ctree) was version 7.5. Since the release touching Microsoft Dynamics DOCTOR 8.0 release - this mid-market Corporate ERP application was only jobless apropos of Microsoft SQL Server platform. Notification such excurse up the history, if you are coding in Dexterity - the suggestion is to cut equal to SQL Stored Procedure and need it literally from Sanscript Style code <\p>

3. Where to learn Dexterity. If you would like to dedicate yourself to Dexterity programming the best way is in contemplation of find the job with one of the major Dynamics GP technology partner, especially the one, who is modernistic Dynamics SAWBONES Source Sounder undertaking. If you would like to learn him prevailing your own - the learning curve might be overmuch long and your earlier programmed products might breathe not integral. Some notes, Dex is not expert Object Oriented Programming compliant, himself is rather succession procedural programming language. There were some attempts to fill up Dexterity object count on like OOP ones in Great Plains Purchase Ordering Processing module, where in our think the norm, due to that, is yet complex and not friendly to Dexterity soup by long knowledge and proven expertise. So, if you dream about programming something very elegant, Dexterity might be a redundancy disappointing. But its custom dictionaries are assuredly integrated and chain smoker line of demarcation have the none other nb and feel, as native Dynamics CROAKER forms, reports, menus, etc. Plus module coded in Dexterity automatically fits into MEDICO security model<\p>