Dynamics GP Improvement: Dexterity, eConnect, SQL Scripting notes

Programming for Microsoft Dynamics GP, formerly known as Good Plains Dynamics, eEnteprise (remember to note that its predecessor Good Plains Accounting for DOS and Home windows is various application and its modification choices are various and in reality really minimal) – if this is you investigate subject matter, we offer you this little publication, dependent on our Good Plains Customization encounter, together with substantial projects in eCommerce, Warehouse Management and Barcoding, EDI, Random Bodyweight or Capture Bodyweight, Barcode Labels algorithms, dependent on Item Amount and Serial/Good deal number extension, Consignment, Healthcare, Placement, Buying and Packing, Shipping and delivery and Acquiring, Beverage mixing mills, Freight Forwarding industries.  Great Plains Dynamics GP is fantastic fit for mid-size companies in Usa and English talking international locations, additionally it is fairly localized in Mexico, Caribbean and Spanish Talking Latin The usa, it is well-liked in South East Asia and Oceania (and French talking Quebec in Canada).  If you are trying to put into action (and partly localize Good Plains) for this kind of international locations and areas as Brazil, China, Russia, East Europe, Japan, Korea, we experience that we form of have to discourage you, as Dynamics GP Dexterity will not support UNICODE (Chinese, Japanese, Korean and other hieroglyph dependent languages), additionally in Russia, Kazakhstan, Central Asia Microsoft Small business Methods has Dynamics AX Axapta (and Navision Dynamics NAV) assuming that your abroad subsidiary is mid-size small business, and AX and NAV are also substantial in their implementation scope and spending plan clever, we recommend SAP Small business 1, which is localize and licensed in most international locations with regional Federal government Audit and Tax Authorities.  But let us occur again to the topic: Good Plains Customization applications:

1. Good Plains Dexterity.  Even if you experience that you do not want to evaluation this initial device and in essence initial architecture of Good Plains Software Dynamics, we experience that it is so critical, as it is continue to a main of the Microsoft Dynamics GP ERP, MRP and Accounting apps.  If you have minor expertise about ERP shells, that were well-liked in 1990th, we would like you to remind SAP ABAP story.  ABAP was and continue to is the shell and its mission is to summary SAP method from Operating Procedure and Databases Platform.  This abstraction was deemed as vital in the time of Mainframe personal computers and Mini (Solar) and Micro (IBM Computer) personal computers level of competition.  Windows, Macintosh, Unix, Solaris, additionally database platform parade: Ctree, Btrieve, IBM DBII, Oracle, DBASE, Ingress, Development, additionally think about computer Graphical Operating Techniques: Microsoft Home windows, MAC and Solaris battle.  GP Dexterity was the way to go all those times and it was coded in C programming language (however Unicode was not known all those times, in any other case Good Plains internationalization might be various these days).  Dex permitted Good Plains Dynamics to coexist on chosen (but technically it could be transferrable to other C programming language compliant computer platforms without having problem) platforms: Microsoft Home windows, Apple Macintosh, additionally on DB platforms: Ctree/Faircom, Btrieve and Microsoft SQL Server.  Dexterity is limitless in Good Plains modification means.  If you are expert Dexterity programmer, you can modify any selected GP sort, Report, include new Sorts and Stories, Tables, Scrolling Home windows, String Resources.  Great Plains was prepared in Dexterity and you theoretically can rewrite it at your discretion.  However, staying realistic, Dex needs devotion, and if you require to put into action Good Plains Modification job with minimal spending plan, then most likely you can’t afford your IT division programmer studying curve (it has semi proprietary scripting language Sanscript to give you fantastic starting up stage for added investigate).  Dexterity is the device, that we recommend to outsource to your chosen Microsoft Dynamics GP Technology Spouse.  For all those of you who would like to do added investigate on Good Plains compatibility with UNUCODE, remember to evaluation NJ Star goods and include-ons.  They really should make it possible for you to enter Chinese people into GP person interface

two. eConnect.  If you are geared toward Dynamics GP ecommerce application customized programming and you by now have ecommerce website formulated in C#, VB.Internet or another programming languages (together with Linux, PHP, MySQL), which is ODBC compliant and has the choices to get in touch with .Internet DLL libraries (eConnect SDK could be exposed by way of these systems), remember to evaluation this SDK, which was originally in 2003 committed to Good Plains eCommerce programming and actual time integration.  eConnect is in essence replication of Good Plains Dexterity DYNAMICS.DIC dictionary grasp data, and perform transaction development, modification and deletion small business logic.  If you investigate eConnect deeper, you will obtain that it is dependent on Microsoft SQL Server Encrypted Saved Treatments, replicating Dexterity logic in a lot more Item Oriented Method, comparing to mom Dexterity.  With eConnect we often hear GP Batch Publishing limitations inquiries.  Please, note that Batch acceptance and submitting in Good Plains architecture is the functionality of Good Plains person.  If you require to put up GP batches immediately from your ecommerce website, remember to think about Alba Spectrum Publishing Server.  Please note that eConnect is strictly integration device and SDK, you can’t alter Good Plains interfaces or include new interfaces with eConnect, in its place you really should rescue to Dexterity, or think about website dependent screens, which could be programmed with Microsoft Dynamics GP SDK (this device is in its flip get in touch with Dex techniques to talk with Dynamics GP interface and DB)

three. SQL Scripting.  Dynamics GP SQL Saved Treatments and views are really well-liked in Good Plains customization environments.  However, in advance of you go there, we would like to neat down your optimism.  First of all, if you are trying to insert new grasp data, this kind of as Prospects, Suppliers, Workers, Addresses, GL accounts – be knowledgeable that eConnect techniques are coded by initial Dynamics GP programmers, who are familiar with GP Resource code and the query is  – why you would require to replicate the exact same techniques in customized GP programming.  If you plan to log data into Historical or Open transaction tables: SOP30200, SOP30300, and so forth, Good Plains batches and transaction submitting is really intricate and there is the probability that you may well violate GP submitting logic in your facts feeding immediately to Good Plains Historical past tables.  It is significantly safer to carry transaction into Dynamics GP Integration Supervisor integration and then put up them from there or program actual time transaction integration in eConnect.  If you assume that previously mentioned remarks are Ok to continues, remember to put in Dynamics GP SDK from CD #two, the place you can obtain complete tables structure and fields description

4. Tailor made Dynamics GP Reporting.  We recommend you to think about GP ReportWriter (SOP Bill Blank for is the most common applicant), SSRS, and of training course Crystal Stories.  CR experiences as fantastic apply really should be dependent on SQL Watch or Saved Course of action, as Stories design device is fantastic in report presentation, and Knowledge Established is up to you – Good Plains Programmer

five. Good Plains EDI.  There are several Dynamics GP ISV include-ons available on Electronic Doc Supply.  If your EDI requirement s are really essential, and you do not have or do not want to commit dollars to order EDI mapping Dynamics GP Include-on, you really should speak to your IT division is they could create formatted EDI compliant decide on statement or Saved Course of action to do the career.  If they are not knowledgeable, experience free to get in touch with our workplace

six. Extra Dynamics GP customization and programming topics.  We would like to hear from you, Good Plains customers and IT programmers what else you would like to know about Good Plains Modifications, Reporting, EDI, Barcode Scanning, Customization, Integration. Dynamics GP is Corporate ERP platform and we would like to enable you to allow it.  Back in 2004 Microsoft introduced so-identified as Undertaking Green, meant to merge Good Plains, Solomon, Navision, Axapta into compatible creating blocks to be ready to opt for for long run companies.  The intension was really innovative, but in our belief the mission really should get a lot more time to be realized.  We are participant in Microsoft Dynamics worldwide implementation job and this is why your feedback are primarily welcomed

7. eCommerce Devotion.  Please, examine our content released on Dynamics GP ecommerce topics.  You really should think about ecommerce B2B and B2C Shopping Cart prerequisites.  eCommerce is really sophisticated topic, we would like to announce that it is outside of the scope for this little report, but experience free to give us as a get in touch with or e mail us

8. How to get enable?  Please get in touch with us: 1-866-528-0577, if you are outside of Usa: 1-630-961-5918 or e mail us enable@albaspectrum.com.  We speak English, Spanish, Chinese, Portuguese, Russian.  This report is meant to Usa, Australia, South Africa, New Zealand, United Kingdom, Ireland, Canada, Ethiopia Dynamics GP potential clients and existing clients.  If you are positioned in various zone (together with India, Pakistan, Saudi Arabia, Yemen, Oman and other Arabic talking international locations), remember to check with us