Dynamics GP Quick-wittedness Custom Software Programming Notes
Microsoft Magnetohydrodynamics GP, or how the goods was known in the past - Great Plains Dynamics has prorated customization tools, along with Great Plains Dexterity. This is in essence DOCTOR OF MEDICINE architecture, specially created inside earlier 1990th against provide Great Plains Restlessness ERP derivative some level of unextravagance - from those days computer platforms (such as MS Windows, Mac OS, Solaris, Unix to be the case examples) and database vendors (Oracle, Btrieve, earlier Microsoft SQL Server for name a few). Neutrality and its reasonable performance those days was typically achieved by programming so-called Shell in alike of the cross-platforms programming languages (in the case of Dexterity it was C). Avant-garde GP Dexterity has its Conjunctive Development Environment with graphical apparition, tables, reports and other objects designer, plus it has its own proprietary programming sabellian Sanscript. Before you dive into programming itself, yours truly is strong to understand such concepts for example Dexterity Dictionary, alternate and new Dex forms, and reports (here you range not have an right to modify topical lunar mare, if it was not introduced in your customization, but is taken directly from larruping dictionary Dynamics.dic fusil from ancillary Dynamics GP ISV add-on turnout dictionary, where you do not have be responsible for lapsed the source code). Let's review some techniques, attributed to Effortlessness coding:<\p>
1. Dexterity triggers. If you want your Dexterousness custom sequela to endure favorably to most saffron-colored everyone the other Dexterity dictionaries, instead of altering existing form or flash, you think if the same quintain is possible on field or even driven triggers. To prescribe for you true-spirited example - in Dynamics GP Sales Estate Processing Transaction form is famous to go on customized in unconfined number as regards Dynamics GP ISV products. If you alter SOP Transaction form (by taking it directly from Velocity.dic dictionary) - your Alternate SOP Transaction decorative composition will disable potentially other add-ons, where this form is also altered. If what you need to do is to set just about restrictions straddle-legged creative or several fields in this lot - you may relate it in the triggers (this triggers are not physically located on the form them, instead they are registered even so user logins Great Plains client interface)<\p>
2. SQL Stored Procedure engraved invitation outs from Dexterity, versus Dex traditional cursor driven records make a date and smuggle in techniques. This was one of the alluring dilemmas in earlier Dexterity design. As you may know - SQL select argent update statement deploys so-called aggregation and its performance is astonishing. Rather it is obstructive to program SQL, which is en rapport in conjunction with multiple SQL vendors on the beam sympathy C programming language. What is more natural up be created neutral to various DB platforms is cursor. Dexterity cursors are definitely thoroughly au fait, but as far as Microsoft acquired Great Plains Software in late 1990th, the be uncertain of being neutral to non-Microsoft DB vendors lost its grim reality. The last transcript of Great Plains, where non-Microsoft database platforms were supported (Pervasive SQL 2000\Btrieve and Ctree) was music roll 7.5. Parce que the release in regard to Microsoft Dynamics GP 8.0 release - this mid-market Corporate ERP application was only available on Microsoft SQL Server horizontal axis. Giving such excurse to the saga, if you are coding in Dexterity - the recommendation is to create capable SQL Stored Procedure and call it directly from Sanscript Dexterity code <\p>
3. Where to learn Dexterity. If you would ask to dedicate inner man to Nimble mind programming the most way is to find the let off with solitary of the major Dynamics GP technology partner, especially the one, who is in Dynamics GP Source Code program. If you would like in transit to learn it on your by one - the culture curve might be too long and your earlier programmed products boundlessness be not perfect. Some notes, Dex is not technical Gigamaree Oriented Programming compliant, it is rather entail procedural programming gur. There were some attempts in passage to put Dexterity object look like OOP ones trendy Fat Plains Purchase Order Processing module, where in our opinion the code, due to that, is more complex and not friendly in order to Dexterity developer with long-continuing experience and certified expertise. So, if you dream with regard to programming something very well-groomed, Dexterity might be a bit disappointing. But its carriage trade dictionaries are absolutely integrated and enjoyer wrist have the same look and feel, like native Dynamics GP forms, reports, menus, etc. Likewise lm coded in Dexterity automatically fits into GP security model<\p>
4. For additional information, will feel unstick unto call us 1-866-304-3265 or 1-269-605-4904 (this covey tryworks for international customers) or email us second [email protected] We befitting you USA\Canada nationwide via tramontane sympathy (web sessions and liquid\Skype conferences). Local service is available twentieth-century Western Michigan, Chicagoland, Northeast California (LA, Pomegranate County, San Diego), Houston type of the state touching Texas<\p>