Dynamics GP Growth: Dexterity, eConnect, SQL Scripting notes

Programming for Microsoft Dynamics GP, previously known as Excellent Plains Dynamics, eEnteprise (remember to be aware that its predecessor Excellent Plains Accounting for DOS and Home windows is diverse application and its modification alternatives are diverse and in truth extremely limited) – if this is you exploration matter, we give you this modest publication, dependent on our Excellent Plains Customization experience, which includes big initiatives in eCommerce, Warehouse Management and Barcoding, EDI, Random Excess weight or Catch Excess weight, Barcode Labels algorithms, dependent on Merchandise Number and Serial/Whole lot amount extension, Consignment, Healthcare, Placement, Buying and Packing, Shipping and Obtaining, Beverage mixing mills, Freight Forwarding industries.  Great Plains Dynamics GP is fantastic in good shape for mid-sizing corporations in United states of america and English talking nations around the world, plus it is fairly localized in Mexico, Caribbean and Spanish Speaking Latin America, 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 partially localize Excellent Plains) for these types of nations around the world and areas as Brazil, China, Russia, East Europe, Japan, Korea, we sense that we type of have to discourage you, as Dynamics GP Dexterity does not support UNICODE (Chinese, Japanese, Korean and other hieroglyph dependent languages), plus in Russia, Kazakhstan, Central Asia Microsoft Small business Solutions has Dynamics AX Axapta (and Navision Dynamics NAV) assuming that your abroad subsidiary is mid-sizing business enterprise, and AX and NAV are too big in their implementation scope and spending budget smart, we propose SAP Small business 1, which is localize and certified in most nations around the world with nearby Authorities Audit and Tax Authorities.  But let’s appear back to the subject: Excellent Plains Customization tools:

one. Excellent Plains Dexterity.  Even if you sense that you do not want to critique this initial software and in essence initial architecture of Excellent Plains Application Dynamics, we sense that it is so essential, as it is continue to a core of the Microsoft Dynamics GP ERP, MRP and Accounting purposes.  If you have very little understanding about ERP shells, that had been well-liked in 1990th, we would like you to remind SAP ABAP tale.  ABAP was and continue to is the shell and its mission is to summary SAP system from Functioning Technique and Databases System.  This abstraction was regarded as as essential in the time of Mainframe computer systems and Mini (Solar) and Micro (IBM Computer) computer systems levels of competition.  Windows, Macintosh, Unix, Solaris, plus database platform parade: Ctree, Btrieve, IBM DBII, Oracle, DBASE, Ingress, Development, plus take into account computer Graphical Functioning Techniques: Microsoft Home windows, MAC and Solaris battle.  GP Dexterity was the way to go those times and it was coded in C programming language (unfortunately Unicode was not known those times, if not Excellent Plains internationalization may possibly be diverse now).  Dex allowed Excellent Plains Dynamics to coexist on picked out (but technically it could be transferrable to other C programming language compliant computer platforms without having trouble) platforms: Microsoft Home windows, Apple Macintosh, plus on DB platforms: Ctree/Faircom, Btrieve and Microsoft SQL Server.  Dexterity is limitless in Excellent Plains modification capacity.  If you are expert Dexterity programmer, you can modify any selected GP sort, Report, incorporate new Kinds and Experiences, Tables, Scrolling Home windows, String Assets.  Great Plains was published in Dexterity and you theoretically can rewrite it at your discretion.  However, being realistic, Dex demands determination, and if you need to put into action Excellent Plains Modification task with limited spending budget, then probable you can not pay for your IT office programmer understanding curve (it has semi proprietary scripting language Sanscript to give you fantastic starting off level for supplemental exploration).  Dexterity is the software, that we propose to outsource to your picked out Microsoft Dynamics GP Technology Associate.  For those of you who would like to do supplemental exploration on Excellent Plains compatibility with UNUCODE, remember to critique NJ Star items and incorporate-ons.  They really should make it possible for you to enter Chinese figures into GP person interface

2. eConnect.  If you are geared toward Dynamics GP ecommerce application tailor made programming and you now have ecommerce website produced in C#, VB.Net or an additional programming languages (which includes Linux, PHP, MySQL), which is ODBC compliant and has the alternatives to call .Net DLL libraries (eConnect SDK could be exposed by these technologies), remember to critique this SDK, which was originally in 2003 focused to Excellent Plains eCommerce programming and serious time integration.  eConnect is in essence replication of Excellent Plains Dexterity DYNAMICS.DIC dictionary master documents, and operate transaction generation, modification and deletion business enterprise logic.  If you exploration eConnect further, you will discover that it is dependent on Microsoft SQL Server Encrypted Stored Treatments, replicating Dexterity logic in additional Item Oriented Fashion, comparing to mother Dexterity.  With eConnect we usually listen to GP Batch Putting up limitations inquiries.  Please, be aware that Batch acceptance and putting up in Excellent Plains architecture is the perform of Excellent Plains person.  If you need to publish GP batches instantly from your ecommerce website, remember to take into account Alba Spectrum Putting up Server.  Please be aware that eConnect is strictly integration software and SDK, you can not alter Excellent Plains interfaces or incorporate new interfaces with eConnect, as an alternative you really should rescue to Dexterity, or take into account website dependent screens, which could be programmed with Microsoft Dynamics GP SDK (this software is in its switch call Dex procedures to connect with Dynamics GP interface and DB)

three. SQL Scripting.  Dynamics GP SQL Stored Treatments and views are extremely well-liked in Excellent Plains customization environments.  However, ahead of you go there, we would like to amazing down your optimism.  First of all, if you are trying to insert new master documents, these types of as Buyers, Distributors, Staff members, Addresses, GL accounts – be knowledgeable that eConnect procedures are coded by initial Dynamics GP programmers, who are familiar with GP Resource code and the query is  – why you would need to replicate the identical procedures in tailor made GP programming.  If you prepare to log documents into Historic or Open transaction tables: SOP30200, SOP30300, etcetera, Excellent Plains batches and transaction putting up is extremely advanced and there is the possibility that you might violate GP putting up logic in your details feeding instantly to Excellent Plains Background tables.  It is considerably safer to carry transaction into Dynamics GP Integration Manager integration and then publish them from there or application serious time transaction integration in eConnect.  If you assume that over remarks are Ok to carries on, remember to put in Dynamics GP SDK from CD #2, the place you can discover complete tables composition and fields description

4. Personalized Dynamics GP Reporting.  We propose you to take into account GP ReportWriter (SOP Bill Blank for is the most regular prospect), SSRS, and of study course Crystal Experiences.  CR experiences as fantastic follow really should be dependent on SQL Look at or Stored Treatment, as Experiences design software is fantastic in report presentation, and Knowledge Set is up to you – Excellent Plains Programmer

five. Excellent Plains EDI.  There are a number of Dynamics GP ISV incorporate-ons out there on Electronic Document Supply.  If your EDI necessity s are seriously standard, and you do not have or do not want to commit cash to order EDI mapping Dynamics GP Insert-on, you really should discuss to your IT office is they could make formatted EDI compliant pick assertion or Stored Treatment to do the work.  If they are not knowledgeable, sense free to call our workplace

6. Added Dynamics GP customization and programming matters.  We would like to listen to from you, Excellent Plains people and IT programmers what else you would like to know about Excellent Plains Modifications, Reporting, EDI, Barcode Scanning, Customization, Integration. Dynamics GP is Company ERP platform and we would like to aid you to enable it.  Back in 2004 Microsoft introduced so-identified as Undertaking Environmentally friendly, intended to merge Excellent Plains, Solomon, Navision, Axapta into suitable setting up blocks to be all set to decide on for long run corporations.  The intension was seriously innovative, but in our viewpoint the mission really should acquire additional time to be realized.  We are participant in Microsoft Dynamics global implementation task and this is why your reviews are particularly welcomed

seven. eCommerce Determination.  Please, browse our articles printed on Dynamics GP ecommerce matters.  You really should take into account ecommerce B2B and B2C Procuring Cart specifications.  eCommerce is extremely advanced subject, we would like to announce that it is outside the house of the scope for this modest article, but sense free to give us as a call or electronic mail us

eight. How to get aid?  Please call us: one-866-528-0577, if you are outside the house of United states of america: one-630-961-5918 or electronic mail us [email protected]  We speak English, Spanish, Chinese, Portuguese, Russian.  This article is intended to United states of america, Australia, South Africa, New Zealand, United Kingdom, Ireland, Canada, Ethiopia Dynamics GP prospective clients and current clients.  If you are located in diverse zone (which includes India, Pakistan, Saudi Arabia, Yemen, Oman and other Arabic talking nations around the world), remember to check with us