Dynamics GP Improvement: Dexterity, eConnect, SQL Scripting notes

Programming for Microsoft Dynamics GP, formerly regarded as Terrific Plains Dynamics, eEnteprise (please note that its predecessor Terrific Plains Accounting for DOS and Windows is distinctive software and its modification options are distinctive and in truth incredibly constrained) – if this is you research subject matter, we offer you this smaller publication, based mostly on our Terrific Plains Customization experience, which include massive projects in eCommerce, Warehouse Administration and Barcoding, EDI, Random Body weight or Capture Body weight, Barcode Labels algorithms, based mostly on Merchandise Range and Serial/Good deal selection extension, Consignment, Health care, Placement, Finding and Packing, Shipping and Obtaining, Beverage mixing mills, Freight Forwarding industries.  Great Plains Dynamics GP is good suit for mid-dimension enterprises in Usa and English talking international locations, as well as it is moderately localized in Mexico, Caribbean and Spanish Talking Latin The us, it is common in South East Asia and Oceania (and French talking Quebec in Canada).  If you are trying to put into practice (and partially localize Terrific Plains) for these types of international locations and locations as Brazil, China, Russia, East Europe, Japan, Korea, we feel that we type of have to discourage you, as Dynamics GP Dexterity would not support UNICODE (Chinese, Japanese, Korean and other hieroglyph based mostly languages), as well as in Russia, Kazakhstan, Central Asia Microsoft Organization Solutions has Dynamics AX Axapta (and Navision Dynamics NAV) assuming that your overseas subsidiary is mid-dimension organization, and AX and NAV are much too massive in their implementation scope and spending budget intelligent, we propose SAP Organization One, which is localize and certified in most international locations with neighborhood Govt Audit and Tax Authorities.  But let’s appear back again to the subject: Terrific Plains Customization instruments:

one. Terrific Plains Dexterity.  Even if you feel that you do not want to critique this first resource and in essence initial architecture of Terrific Plains Program Dynamics, we feel that it is so essential, as it is nonetheless a core of the Microsoft Dynamics GP ERP, MRP and Accounting apps.  If you have small expertise about ERP shells, that were common in 1990th, we would like you to remind SAP ABAP story.  ABAP was and nonetheless is the shell and its mission is to summary SAP technique from Running Program and Database System.  This abstraction was regarded as essential in the time of Mainframe desktops and Mini (Solar) and Micro (IBM Computer system) desktops competitiveness.  Windows, Macintosh, Unix, Solaris, as well as databases platform parade: Ctree, Btrieve, IBM DBII, Oracle, DBASE, Ingress, Development, as well as take into account computer Graphical Running Programs: Microsoft Windows, MAC and Solaris fight.  GP Dexterity was the way to go those people days and it was coded in C programming language (however Unicode was not regarded those people days, normally Terrific Plains internationalization could be distinctive now).  Dex permitted Terrific Plains Dynamics to coexist on picked (but technically it could be transferrable to other C programming language compliant computer platforms devoid of problem) platforms: Microsoft Windows, Apple Macintosh, as well as on DB platforms: Ctree/Faircom, Btrieve and Microsoft SQL Server.  Dexterity is limitless in Terrific Plains modification capability.  If you are experienced Dexterity programmer, you can modify any chosen GP sort, Report, increase new Types and Studies, Tables, Scrolling Windows, String Sources.  Great Plains was penned in Dexterity and you theoretically can rewrite it at your discretion.  However, currently being fair, Dex requires devotion, and if you have to have to put into practice Terrific Plains Modification task with constrained spending budget, then likely you can not find the money for your IT department programmer studying curve (it has semi proprietary scripting language Sanscript to give you good commencing position for extra research).  Dexterity is the resource, that we propose to outsource to your picked Microsoft Dynamics GP Technology Spouse.  For those people of you who would like to do extra research on Terrific Plains compatibility with UNUCODE, please critique NJ Star products and solutions and increase-ons.  They need to make it possible for you to enter Chinese figures into GP person interface

2. eConnect.  If you are geared towards Dynamics GP ecommerce software custom programming and you previously have ecommerce website produced in C#, VB.Internet or yet another programming languages (which include Linux, PHP, MySQL), which is ODBC compliant and has the options to get in touch with .Internet DLL libraries (eConnect SDK could be exposed via these technologies), please critique this SDK, which was originally in 2003 dedicated to Terrific Plains eCommerce programming and real time integration.  eConnect is in essence replication of Terrific Plains Dexterity DYNAMICS.DIC dictionary learn data, and function transaction development, modification and deletion organization logic.  If you research eConnect deeper, you will come across that it is based mostly on Microsoft SQL Server Encrypted Stored Treatments, replicating Dexterity logic in a lot more Item Oriented Way, comparing to mother Dexterity.  With eConnect we typically hear GP Batch Posting restrictions concerns.  Please, note that Batch acceptance and putting up in Terrific Plains architecture is the functionality of Terrific Plains person.  If you have to have to write-up GP batches immediately from your ecommerce website, please take into account Alba Spectrum Posting Server.  Please note that eConnect is strictly integration resource and SDK, you can not change Terrific Plains interfaces or increase new interfaces with eConnect, in its place you need to rescue to Dexterity, or take into account website based mostly screens, which could be programmed with Microsoft Dynamics GP SDK (this resource is in its turn get in touch with Dex procedures to communicate with Dynamics GP interface and DB)

3. SQL Scripting.  Dynamics GP SQL Stored Treatments and views are incredibly common in Terrific Plains customization environments.  However, just before you go there, we would like to great down your optimism.  First of all, if you are trying to insert new learn data, these types of as Consumers, Sellers, Workforce, Addresses, GL accounts – be aware that eConnect procedures are coded by initial Dynamics GP programmers, who are acquainted with GP Supply code and the issue is  – why you would have to have to replicate the same procedures in custom GP programming.  If you system to log data into Historic or Open up transaction tables: SOP30200, SOP30300, etc, Terrific Plains batches and transaction putting up is incredibly complicated and there is the chance that you may possibly violate GP putting up logic in your details feeding immediately to Terrific Plains Record tables.  It is substantially safer to deliver transaction into Dynamics GP Integration Manager integration and then write-up them from there or system real time transaction integration in eConnect.  If you feel that previously mentioned remarks are Okay to carries on, please set up Dynamics GP SDK from CD #2, the place you can come across full tables framework and fields description

4. Custom made Dynamics GP Reporting.  We propose you to take into account GP ReportWriter (SOP Invoice Blank for is the most typical candidate), SSRS, and of program Crystal Studies.  CR studies as good follow need to be based mostly on SQL Perspective or Stored Technique, as Studies structure resource is good in report presentation, and Data Established is up to you – Terrific Plains Programmer

5. Terrific Plains EDI.  There are a number of Dynamics GP ISV increase-ons readily available on Digital Doc Shipping and delivery.  If your EDI requirement s are actually primary, and you do not have or do not want to devote revenue to obtain EDI mapping Dynamics GP Include-on, you need to discuss to your IT department is they could make formatted EDI compliant choose statement or Stored Technique to do the position.  If they are not aware, feel absolutely free to get in touch with our office

six. Supplemental Dynamics GP customization and programming topics.  We would like to hear from you, Terrific Plains end users and IT programmers what else you would like to know about Terrific Plains Modifications, Reporting, EDI, Barcode Scanning, Customization, Integration. Dynamics GP is Corporate ERP platform and we would like to assistance you to help it.  Back in 2004 Microsoft introduced so-referred to as Venture Inexperienced, meant to merge Terrific Plains, Solomon, Navision, Axapta into appropriate constructing blocks to be completely ready to pick out for upcoming enterprises.  The intension was actually innovative, but in our view the mission need to acquire a lot more time to be recognized.  We are participant in Microsoft Dynamics intercontinental implementation task and this is why your comments are specifically welcomed

7. eCommerce Commitment.  Please, browse our article content printed on Dynamics GP ecommerce topics.  You need to take into account ecommerce B2B and B2C Shopping Cart requirements.  eCommerce is incredibly sophisticated subject, we would like to announce that it is exterior of the scope for this smaller post, but feel absolutely free to give us as a get in touch with or electronic mail us

8. How to get assistance?  Please get in touch with us: one-866-528-0577, if you are exterior of Usa: one-630-961-5918 or electronic mail us assistance@albaspectrum.com.  We talk English, Spanish, Chinese, Portuguese, Russian.  This post is meant to Usa, Australia, South Africa, New Zealand, United Kingdom, Ireland, Canada, Ethiopia Dynamics GP prospective clients and current customers.  If you are positioned in distinctive zone (which include India, Pakistan, Saudi Arabia, Yemen, Oman and other Arabic talking international locations), please look at with us