Enhancement for Microsoft Dynamics GP, previously recognised as Terrific Plains: Dexterity, eConnect, eCommerce programming

Microsoft Dynamics Company ERP and CRM household of products and solutions includes Dynamics GP (previously recognised as Terrific Plains Dynamics, eEnterprise, Terrific Plains Choose on Pervasive SQL and Ctree), AX (previously recognised as Axapta), NAV (recognised as Navision), SL (Solomon), Microsoft Dynamics CRM (this is CRM application, it might be portion of Company ERP, but technically it is just CRM).  In this publication we will be concentrating on Microsoft Dynamics GP Programming, Integration and Program Enhancement instruments: Dexterity, eConnect, Integration Manager, direct SQL Scripting and SQL Stored Processes coding in such routines as ecommerce, EDI, Barcoding, generic integration and reporting:

one. Dynamics GP Dexterity, also referred as Microsoft Dexterity and Terrific Plains Dexterity.  Dex is architectural fundament of Terrific Plains or Microsoft Dynamics GP.  There is philosophical portion in Dexterity, if you would like to know it – Dexterity mission to secure Computer Operating Technique (especially Graphical Operating Technique, such as Microsoft Home windows, Mac, or Solaris) and Database System immunity (in the beginning Terrific Plains was released on Btrieve and Ctree and quickly was expanded to protect Microsoft SQL Server DB platform).  Dexterity has its have proprietary scripting and programming language Sanscript.  If you are making an attempt to contribute for your organization Company ERP creating and programming, consider taking Microsoft Dexterity exact or custom-made teaching.  If you are hunting for Terrific Plains Dexterity luxurious or responsible programming (this software needs numerous several years of Terrific Plains Customization programming perseverance), we propose you to make Dynamics GP programming companion estimation and investigation.  Our firm is committed to Microsoft Dynamics GP modifications, in addition we support all variations (new and old) of Microsoft Dynamics GP, Terrific Plains Dynamics, GP Choose, eEnterprise, Terrific Plains Accounting for DOS, Home windows and Macintosh.  If this report is categorized as push release by anyone in your business IT department, make sure you evaluation our technological posts on Terrific Plains Dexterity customizations, we posted them in early 2000th.  Microsoft Dexterity Supply Code Programming – if your customization needs accessibility to the supply of unique Dynamics GP business logic and scripts – you have to come across so-known as Microsoft Dynamics GP Supply Code Lover

2. eConnect for Microsoft Dynamics GP.  This Program Enhancement Package was released in the beginning as a software for Terrific Plains eCommerce programmers to open GP objects as a result of ecommerce internet application: Buyer, Profits Invoice, Stock Merchandise, Credit Card deposit payment, Ship To Handle, etcetera.  Later on eConnect was expanded to protect most of the modules in GP: Basic Ledger, Buy Purchase Processing, US Payroll, Venture Accounting, Profits Purchase Processing (make sure you, take note that more mature Invoicing module is not protected).  If you are Microsoft Visible Studio developer, who is programming in C#, VB.Web with acceptable exposure to XML and SQL Stored methods, we propose you to check out eConnect self discovery or choose a teaching.  Sometimes ecommerce developers come across eConnect constraints.  One of them perhaps uncovered as a result of this scenario – let’s think that you would like ecommerce application to do all the do the job, together with automatic transaction publishing in Dynamics GP.  eConnect isn’t going to publish GP batch or person transaction, as these routines are assigned to Dynamics GP User (check out the figures and QTY, choose off retains if any, print Batch Edit report and publish the batch).  If you would like to publish the batch from ecommerce application immediately – you will require Dynamics GP Publishing Server insert-on, available from Alba Spectrum

3. Dynamics GP Customization Upgrade evaluation.  Great Plains edition upgrade is small surgical procedure, which needs preparing and perseverance.  the identical should really be real about GP Modifications edition update.  You should really check with your unique or recently chosen Dexterity or eConnect programmer to evaluation customization code and make needed alterations to make it appropriate with specific edition of Microsoft Dynamics GP (current edition is ten., Dynamics GP 11. is envisioned to be launched in May well 2010)

four. More ecommerce programming for Dynamics GP things to consider.  If you do not require serious time ecommerce transaction integration and you would be Alright with quasi serious time (every single hour or every single twenty minutes, for case in point) or batch integration (every single night) – consider Microsoft Dynamics GP Integration Manager.  IM isn’t going to require programming (but it is open for uncomplicated or advanced modifications) and friendly for Dynamics GP close consumer

5. Right before you choose direct SQL Scripting route.  If you are professional MS SQL DBA or SQL developer – it is organic to check out direct SQL scripting in details feeding to your Company ERP application (such as Microsoft Dynamics GP).  In this paragraph we would like to give you some causes to consider prior to earning SQL insert or update statement (of program, Choose statement is friendly as it is only for details pulling from SQL Server Database).  First of all – Dynamics GP details flow and desk structure is advanced and details feeding usually needs the complete cluster of tables to be concerned and it is usually tricky to imitate business logic in SQL Stored Course of action, published from scratches.  Secondly, eConnect is previously produced for you in encrypted SQL Stored methods and it covers the logic you require and if you program to code SQL custom stored methods, likely that you program to replicate the logic previously automated in eConnect

six. Is your customization for GP internationalization or localization for particular region or region?  If the answer is beneficial and you are making an attempt to broaden GP for global subsidiary for your organization, the place you have Terrific Plains in US or Canadian headquarters, make sure you know that localization is advanced, as it includes two areas: nearby language support and compliance to nearby tax, governing administration, condition and municipal reporting.  You may well somewhat efficiently translate Dynamics GP screens to the language, supporting ASCII conventional (8 bits or up to 256 characters in the alphabet together with digits and distinctive characters – most of Europe, together with such international locations as Russia, Poland, Finland, Baltic States, Greece, Armenia, Georgia, Kazakhstan, Uzbekistan, Turkmenistan).  GP is localized for the bulk of English talking international locations, in addition French Canadian, most of Spanish Speaking Latin The us and Caribbean.  If GP is not localized (in the perception of Tax and Governing administration reporting compliance), we propose you to consider diverse Company ERP application.  SAP Small business One is localized for the bulk of international locations (traditionally besides Arabic characters centered alphabets).  We propose SB1 in such international locations as Brazil, Russia, China, Germany, France – as it is localized and in most cases Qualified with Governing administration authorities in the highly regarded international locations.  SAP BO is very versatile in its details and reports export to Excel or in direct SQL Choose scripts.  You can consolidate your SB1 centered subsidiary by means of FRx report in Dynamics GP or do scheduled GL transactions consolidation from SB1 to GP organization.  We are especially optimistic about SB1 with the release of edition 88, the place A and B streams are merged and you can now deploy all the databases/providers on the identical MS SQL Server.  Unicode centered alphabets and Dynamics GP – in standard the recommendation is uncomplicated – GP isn’t going to support Unicode (Chinese, Japanese, Korean hieroglyph centered alphabets).  With some endeavours and with such instruments as NJStar you can make GP settle for Chinese characters and with Crystal Reviews you can combine GP details with custom tables, made up of hieroglyph to resemble Chinese Invoice, for case in point, but count on some price and spending plan