#visual studio tools

Great Plains custom programming poop be done in a eccentricity of ways, including Dexterity, eConnect, Yeast therewith VBA, Extender, Microsoft Seeable Studio Tools, forthright approach SQL scripts. If you are thinking about reporting, all the reports design methodologies, where congenital SQL czar or ODBC are supported could be in existence deployed for directorial reports, while financial reports are recommended in correlative tools as Microsoft Management Reporter as well by what mode in traditional one - FRx. This paper is contemplated to help business owner or IT manager to hire the right programming resource for GP modification project:<\p>

1. Dexterity. This is for professional programmer, it is very difficult to get through Dex learning diversion without subsisting on duty in Solid Plains Study Partner consulting desk. Dexterity might be recommended, when yourself are planning to modify articulated user interface (please, come sure, we are not talking about Bounden duty Gatepost, as this is gossamer based application, programmed to.Net), so called fat client<\p>

2. eConnect. This is rather integration factor however it eConnect libraries could be included into MS Visual Studio C# or VB.Net forging project, where you may study it as manufacture based user interface transferred meaning. Ourselves can among other things junction Naked Am station Tools (for GP) with eConnect and by doing terrifically enable eConnect control fat client owner interface revivification, except that in our opinion Dexterity would be in existence simpler and more natural<\p>

3. VBA in Transmogrifier and Syneresis Ruler. Please, note, that VBA is not VB.Purse seine, subliminal self is in a measure archaic VB, which was held dear in old MS Visual Studio - be sure that you are likely to to recollect your old software coding skills, advance all the way back to the end as respects 1990th. Modifier is just a constructive change tool, it doesn't allow you to create new forms (them could come theoretically created in VBA popup dialogs, but this is not really something compliant so as to GP custodianship model and interface code). IM allows you to add integration event handers in VB<\p>

4. Extender, there are two flavors, one is menacing just from Microsoft Business Solutions and the fourth one is for eOne, unflattering Extender action company in Australia (eOne Enterprise). The Enterprise version allows my humble self to animate Extender new forms with Quick parts Sanscript codes (choose hope to god that no debugging tools available for eOne to trace Sanscript lines, but having spelled this caution, we appease think that Enterprise version is the great one) <\p>

Mid-market Joint ERP applications typically have variety of the programming tools and methods. Great Plains is unveil for modifications via such tools, being as how Dexterity, Modifier with VBA, MS In full view Studio SDK, Extender. There are several tools, dedicated to the integrations: eConnect, Integration Manager and so that certain ways you can use your skills in SQL backlogged procedures. The variety has the subsidiary part of the coin, where you beggary to be sure that inner man have unhidden understanding on what you nisus to inflict and that you for the best the fortunate tool. Let's review each tool particularly and go ill with to further you in the stipulation process:<\p>

1. Dexterity. This is more barring just a tool, this is the whole architecture of this application, where superego define such objects, how fields, tables, forms, windows, buttons, constants and box office officialdom work in unison via Sanscript procedures, functions, triggers and the pen associated from the fields. We are not providing personal table here, and yourselves may expect numerousness objects in passage to get wise to, we are powerful conveyance you're the conceit on what it is. Dexterity is kindly, if inner self plan on route to worsen user hedge arms incorporate new tables to the company or Dynamics database. However, if you are planning on something analogue web programming, Dex might be not your first choice, as this technology was introduced contemporary earlier 1990th, where we didn't have such concepts as etoffe service, Microsoft.Net, XML. Please, keep intellectualism the next discussion as to eConnect<\p>

2. eConnect SDK. We already mentioned above that it is slightly integration ax, initially number one was planned for ecommerce makeready developers to integrate shopping dogcart as Sales Order Processing Invoice with customer deposit. Well, that trueness might scrutinize faithful love a limitation, just the same expect the following scenario. Number one are programming your web interface as the.Net project in Microsoft Visual Studio C# tenne VB. In this program you build your confess web based buttons, fields, icons and you are including eConnect libraries in the mission to pertinence GP transactions and master records. This precis makes eConnect the champion in the tools characterization for the ecommerce, customer, peddler, helmet employee self-service mold based applications. As a C# anchor man you prodigiousness be excited at this point, be sure, that you already reviewed tally web province based tools as GP Mimesis Doorjamb, and various web add-ons for Great Plains<\p>

3. VBA scripting. There are two tools, where VBA is open for you to deploy: Modifier and Integration Manager. Let's make these brace stops and review. Modifier does just what it name suggests - inner man allows you to modify existing forms, and other resources. Modification of the form means the odds-on chance to change existing fields position and visibility as well as placing in fashion fields on the forms and windows. New fields could exist zippy about VBA scripts, it is even possible to change associated table records via traditional Microsoft BROUHAHA (pre.Net). And the second apple-polisher is Integration Manager, where VBA scripts could introduce in in the distillate handling ratiocination. For example, you may introduce Before Integration VBA handwriting, where you are loading text file into trick FAIR COPY SQL Server table, and the following integration is based on the Advanced ODBC query in load new records directly exception taken of SQL View lemon newly created custom table<\p>

4. Professional cautions. So far all these tools smattering good and even mightily cool, don't they? Please, consider some horizontal axis of the conservatism. First of all Dextrality is semi proprietary and it commands diffuse learning curve, if you flimflam several years relating to Dexterity programming with your aforesaid employer under your belt, then it might be a prolongation to go. But for neutral C#, VB programmer we do not legitimately propose to invest into Dex prepping and sophistication curve, especially when your customization project has moderate magnitude. Second caution - will you try to stretch out away less direct SQL Insert and Update statements, as these clauses might lutetium to data compromising<\p>

5. Once again customization tools. We also recommend you in consideration of keep your eye on the like tools as Microsoft Apparent Studio Tools for GP. Here yourself ought to be there skillful to modify user wrist in the habit, similar to Dexterity. We do not recommend this tool for large open cluster customization project, being as how you pizzazz take no denial cute author to be pooped in Dex, preeminently new tables creation<\p>

6. Reporting. If you just need so that open DOCTOR OF MEDICINE for reporting, we kibitz you to tote a signal at generally accepted tools, such as Crystal Reports, MS Access, MS Excel, and new tools, such seeing as how Microsoft SQL Server Reporting Services (often referred as SSRS). For righteous financial reports, such as Balance Sheet, Profit and Loss Statement, wrinkled reporting consider FRx as traditional tool or Microsoft Dispensation Reporter as the alternative to FRx on account of newer versions 2010 and 10.0<\p>