Excellent Plains Programming Resources: Dex, Econnect, Sql, .internet

New name for Excellent Plains is Microsoft Dynamics GP, present edition ten. as of summer season 2008.  In get to be organized to personalize Dynamics GP you must familiarize oneself as application programmer with growth instruments and their functions.  In this small post we would like to give you highlights on Dexterity, eConnect, SQL stored methods and .Net programming

1.       Excellent Plains Dexterity, now it is referred as Microsoft Dexterity.  This software is in essence the foundation of Excellent Plains as GP Dynamics was originally created as computer and databases system impartial ERP software.  In Dex you have to choose a training course in Sanscript programming as perfectly as get acceptable knowledge customizing in Dexterity so-known as alternate GP varieties and windows.  Typical state of affairs in Dex when you choose clean up Dynamics.dic file and increase scripts, varieties, windows, methods, triggers and other means there.  You should assessment this sort of documents as Dex.ini, Dynamics.set

two.       eConnect.  If you are integrating eCommerce website or organizing to boost GP via Microsoft Visible Studio programming, then you must commit your time in eConnect investigate.  This software has set of encrypted SQL stored methods at the conclusion of the way, which imitate GP Dexterity logic and allow for you to build, modify or delete GP learn information, this sort of as buyer, vendor, staff, GL account, contract, undertaking, additionally so-known as get the job done transactions: SOP bill, POP purchase get, GL transaction, stock transfer or adjustment to give you numerous examples

three.       SQL scripting.  If you are looking at oneself as SQL guru or very expert DBA, then you can experiment with SQL views (which do not do any hurt as they only pick information) and stored methods.  We would like to discourage you from overestimating this sort of an choice.  You should, know that eConnect in point presently has most of the methods you would most likely strategy to reprogram and 2nd – eConnect was established by Microsoft Small business Methods programmers group, where they incurred many countless numbers of growth hours.

4.       GP Reviews.  At times reporting is also categorised as programming and modification.  You should assessment the following instruments: Excellent Plains Report Author, Crystal Reviews, Microsoft SQL Server Reporting Products and services or SRS. MS Excel and MS Access.  If you require customized reviews to be known as from GP security realm, then you might require to attempt Dexterity customized reviews