Dynamics GP Development: Dexterity, eConnect, SQL Scripting notes

Programming for Microsoft Dynamics GP, previously recognised as Great Plains Dynamics, eEnteprise (remember to note that its predecessor Great Plains Accounting for DOS and Home windows is different application and its modification choices are different and in actuality very limited) – if this is you research topic, we offer you you this small publication, based mostly on our Great Plains Customization experience, which includes significant jobs in eCommerce, Warehouse Management and Barcoding, EDI, Random Weight or Capture Weight, Barcode Labels algorithms, based mostly on Merchandise Number and Serial/Lot amount extension, Consignment, Health care, Placement, Buying and Packing, Shipping and delivery and Receiving, Beverage mixing mills, Freight Forwarding industries.  Great Plains Dynamics GP is good fit for mid-dimensions companies in United states and English speaking nations, furthermore it is moderately localized in Mexico, Caribbean and Spanish Talking Latin The us, it is well-known in South East Asia and Oceania (and French speaking Quebec in Canada).  If you are making an attempt to apply (and partially localize Great Plains) for this sort of nations and locations as Brazil, China, Russia, East Europe, Japan, Korea, we experience that we sort of have to discourage you, as Dynamics GP Dexterity does not assist UNICODE (Chinese, Japanese, Korean and other hieroglyph based mostly languages), furthermore in Russia, Kazakhstan, Central Asia Microsoft Organization Solutions has Dynamics AX Axapta (and Navision Dynamics NAV) assuming that your abroad subsidiary is mid-dimensions organization, and AX and NAV are far too significant in their implementation scope and budget wise, we recommend SAP Organization One, which is localize and accredited in most nations with community Govt Audit and Tax Authorities.  But let us arrive back to the matter: Great Plains Customization resources:

1. Great Plains Dexterity.  Even if you experience that you do not want to evaluate this original device and in essence authentic architecture of Great Plains Software Dynamics, we experience that it is so critical, as it is nevertheless a main of the Microsoft Dynamics GP ERP, MRP and Accounting apps.  If you have minimal understanding about ERP shells, that ended up well-known in 1990th, we would like you to remind SAP ABAP story.  ABAP was and nevertheless is the shell and its mission is to abstract SAP process from Running Method and Database System.  This abstraction was regarded as as very important in the time of Mainframe computers and Mini (Sunlight) and Micro (IBM Pc) computers competition.  Windows, Macintosh, Unix, Solaris, furthermore databases platform parade: Ctree, Btrieve, IBM DBII, Oracle, DBASE, Ingress, Development, furthermore take into account computer Graphical Running Techniques: Microsoft Home windows, MAC and Solaris battle.  GP Dexterity was the way to go people times and it was coded in C programming language (however Unicode was not recognised people times, normally Great Plains internationalization could be different currently).  Dex authorized Great Plains Dynamics to coexist on picked (but technically it could be transferrable to other C programming language compliant computer platforms devoid of challenge) platforms: Microsoft Home windows, Apple Macintosh, furthermore on DB platforms: Ctree/Faircom, Btrieve and Microsoft SQL Server.  Dexterity is limitless in Great Plains modification ability.  If you are professional Dexterity programmer, you can modify any selected GP type, Report, include new Kinds and Reports, Tables, Scrolling Home windows, String Methods.  Great Plains was composed in Dexterity and you theoretically can rewrite it at your discretion.  However, staying realistic, Dex involves determination, and if you want to apply Great Plains Modification venture with limited budget, then possible you can not afford to pay for your IT section programmer studying curve (it has semi proprietary scripting language Sanscript to give you good setting up position for further research).  Dexterity is the device, that we recommend to outsource to your picked Microsoft Dynamics GP Technology Lover.  For people of you who would like to do further research on Great Plains compatibility with UNUCODE, remember to evaluate NJ Star products and include-ons.  They should let you to enter Chinese people into GP user interface

2. eConnect.  If you are geared toward Dynamics GP ecommerce application customized programming and you now have ecommerce website produced in C#, VB.Net or a further programming languages (which includes Linux, PHP, MySQL), which is ODBC compliant and has the choices to contact .Net DLL libraries (eConnect SDK could be uncovered as a result of these systems), remember to evaluate this SDK, which was at first in 2003 committed to Great Plains eCommerce programming and actual time integration.  eConnect is in essence replication of Great Plains Dexterity DYNAMICS.DIC dictionary learn data, and perform transaction generation, modification and deletion organization logic.  If you research eConnect deeper, you will find that it is based mostly on Microsoft SQL Server Encrypted Stored Techniques, replicating Dexterity logic in more Item Oriented Fashion, comparing to mom Dexterity.  With eConnect we typically listen to GP Batch Putting up restrictions inquiries.  Please, note that Batch approval and publishing in Great Plains architecture is the function of Great Plains user.  If you want to publish GP batches immediately from your ecommerce website, remember to take into account Alba Spectrum Putting up Server.  Please note that eConnect is strictly integration device and SDK, you can not alter Great Plains interfaces or include new interfaces with eConnect, instead you should rescue to Dexterity, or take into account net based mostly screens, which could be programmed with Microsoft Dynamics GP SDK (this device is in its transform contact Dex approaches to connect with Dynamics GP interface and DB)

3. SQL Scripting.  Dynamics GP SQL Stored Techniques and views are very well-known in Great Plains customization environments.  However, prior to you go there, we would like to amazing down your optimism.  First of all, if you are making an attempt to insert new learn data, this sort of as Prospects, Suppliers, Workers, Addresses, GL accounts – be knowledgeable that eConnect approaches are coded by authentic Dynamics GP programmers, who are common with GP Source code and the dilemma is  – why you would want to replicate the same approaches in customized GP programming.  If you strategy to log data into Historical or Open up transaction tables: SOP30200, SOP30300, and many others, Great Plains batches and transaction publishing is very elaborate and there is the probability that you may well violate GP publishing logic in your information feeding immediately to Great Plains History tables.  It is a great deal safer to carry transaction into Dynamics GP Integration Supervisor integration and then publish them from there or program actual time transaction integration in eConnect.  If you imagine that earlier mentioned remarks are Ok to carries on, remember to install Dynamics GP SDK from CD #2, wherever you can find comprehensive tables construction and fields description

4. Custom Dynamics GP Reporting.  We recommend you to take into account GP ReportWriter (SOP Invoice Blank for is the most regular candidate), SSRS, and of course Crystal Reports.  CR reviews as good follow should be based mostly on SQL View or Stored Treatment, as Reports style and design device is good in report presentation, and Data Established is up to you – Great Plains Programmer

five. Great Plains EDI.  There are quite a few Dynamics GP ISV include-ons obtainable on Electronic Document Delivery.  If your EDI prerequisite s are truly standard, and you do not have or do not want to shell out funds to invest in EDI mapping Dynamics GP Insert-on, you should converse to your IT section is they could develop formatted EDI compliant pick assertion or Stored Treatment to do the occupation.  If they are not knowledgeable, experience totally free to contact our office environment

6. More Dynamics GP customization and programming subjects.  We would like to listen to from you, Great Plains customers and IT programmers what else you would like to know about Great Plains Modifications, Reporting, EDI, Barcode Scanning, Customization, Integration. Dynamics GP is Corporate ERP platform and we would like to aid you to permit it.  Back in 2004 Microsoft introduced so-known as Task Inexperienced, intended to merge Great Plains, Solomon, Navision, Axapta into appropriate creating blocks to be ready to pick for foreseeable future companies.  The intension was truly modern, but in our belief the mission should just take more time to be realized.  We are participant in Microsoft Dynamics worldwide implementation venture and this is why your remarks are specifically welcomed

7. eCommerce Dedication.  Please, examine our articles or blog posts published on Dynamics GP ecommerce subjects.  You should take into account ecommerce B2B and B2C Purchasing Cart needs.  eCommerce is very highly developed matter, we would like to announce that it is outside the house of the scope for this small write-up, but experience totally free to give us as a contact or email us

8. How to get aid?  Please contact us: 1-866-528-0577, if you are outside the house of United states: 1-630-961-5918 or email us [email protected]  We talk English, Spanish, Chinese, Portuguese, Russian.  This write-up is intended to United states, Australia, South Africa, New Zealand, United Kingdom, Eire, Canada, Ethiopia Dynamics GP prospects and present clients.  If you are found in different zone (which includes India, Pakistan, Saudi Arabia, Yemen, Oman and other Arabic speaking nations), remember to check with us