Image source: http://c.s-microsoft.com/en-us/CMSImages/SDL_timeline_infographic_large2.jpg?version=53abd9da-8a6b-f164-dcbb-9dabbc075fd6
1.Dynamics GP Dexterity, also referred as Microsoft Dexterity and Great Plains Dexterity. Dex is architectural fundament of Great Plains or Microsoft Dynamics GP. There is philosophical segment in Dexterity, if you'd like to recognize it - Dexterity mission to guard Computer Operating System (a bit Graphical Operating System, akin to Microsoft Windows, Mac, or Solaris) and Database Platform immunity (before the full factor Great Plains was introduced on Btrieve and Ctree and competently was expanded to hide Microsoft SQL Server DB platform). Dexterity has its own proprietary scripting and programming language Sanscript. If you attempt to provide a contribution for your traffic Corporate ERP creating and programming, trust taking Microsoft Dexterity identical or personalized instruction. If you are hunting for Great Plains Dexterity luxurious or official programming (this tool requires a couple of years of Great Plains Customization programming dedication), we recommend you to make Dynamics GP programming accomplice estimation and lookup. Our firm is committed to Microsoft Dynamics GP modifications, plus we guiding concept all versions (new and antique) of Microsoft Dynamics GP, Great Plains Dynamics, GP Select, eEnterprise, Great Plains Accounting for DOS, Windows and Macintosh. If this article is classed as press release by any person in your institution IT department, please review our technical articles on Great Plains Dexterity customizations, we published them in early 2000th. Microsoft Dexterity Source Code Programming - if your customization requires entry to the resource of usual Dynamics GP business logic and scripts - you ought to recognize so-called Microsoft Dynamics GP Source Code Partner
Microsoft Dynamics Corporate ERP and CRM family of goods contains Dynamics GP (earlier to now known as Great Plains Dynamics, eEnterprise, Great Plains Select on Pervasive SQL and Ctree), AX (earlier to now known as Axapta), NAV (known as Navision), SL (Solomon), Microsoft Dynamics CRM (here's CRM utility, it'd be a segment of Corporate ERP, nonetheless technically it's miles basically CRM). In this publication we are able to be targeting Microsoft Dynamics GP Programming, Integration and Software Development tools: Dexterity, eConnect, Integration Manager, direct SQL Scripting and SQL Stored Procedures coding in such routines as ecommerce, EDI, Barcoding, generic integration and reporting:
6.Is your customization for GP internationalization or localization for explicit usa or zone? If the reply is certain and you attempt to provide a expand to GP for worldwide subsidiary for your traffic, where you ought to have Great Plains in US or Canadian headquarters, please know that localization is complex, as it contains two components: within sight language guiding concept and compliance to shut by tax, government, state and municipal reporting. You could a bit smoothly translate Dynamics GP screens to the language, supporting ASCII abnormal (eight bits or as much as 256 characters interior the alphabet which includes digits and distinguished characters - maximum of Europe, which includes such countries as Russia, Poland, Finland, Baltic States, Greece, Armenia, Georgia, Kazakhstan, Uzbekistan, Turkmenistan). GP is localized for much of the individuals will of English talking countries, plus French Canadian, maximum of Spanish Speaking Latin America and Caribbean. If GP is now now not very localized (interior the sense of Tax and Government reporting compliance), we recommend you to trust different Corporate ERP utility. SAP Business One is localized for much of the individuals will of nations (historically apart from Arabic characters based alphabets). We recommend SB1 in such countries as Brazil, Russia, China, Germany, France - as it's miles localized and broadly Certified with Government specialists interior the respected countries. SAP BO is distinct bendy in its info and reports export to Excel or in direct SQL Select scripts. You can consolidate your SB1 based subsidiary via FRx report in Dynamics GP or do scheduled GL transactions consolidation from SB1 to GP traffic. We are a bit optimistic about SB1 with the release of variation 88, where A and B streams are merged and you can now deploy all the databases/organizations on an analogous MS SQL Server. Unicode based alphabets and Dynamics GP - sincerely the recommendation is simple - GP doesn't guiding concept Unicode (Chinese, Japanese, Korean hieroglyph based alphabets). With basically numerous efforts and with such tools as NJStar you can make GP settle for Chinese characters and with Crystal Reports you can mix GP info with tradition tables, containing hieroglyph to resemble Chinese Invoice, as an instance, nonetheless suppose basically numerous price and budget
5.Before you take direct SQL Scripting route. If you are experienced MS SQL DBA or SQL developer - it's miles pure to aim direct SQL scripting in info feeding to your Corporate ERP utility (akin to Microsoft Dynamics GP). In this paragraph we could like to provide you basically numerous purposes to trust earlier to making SQL insert or update commentary (in fact, Select commentary is friendly as it's miles basically for info pulling from SQL Server Database). First of all - Dynamics GP info flow and table shape is complex and info feeding frequently requires the complete cluster of tables to be involved and it's miles broadly now now not simple to mimic business logic in SQL Stored Procedure, written from scratches. Secondly, eConnect is already created for you in encrypted SQL Stored techniques and it covers the logic you will have and if you plan to code SQL tradition stored techniques, maximum likely that you plan to replicate the logic already automated in eConnect
three.Dynamics GP Customization Upgrade review. Great Plains variation improve is small surgical procedure, which requires preparation and dedication. an analogous deserve to be true about GP Modifications variation update. You deserve to ask your usual or newly selected Dexterity or eConnect programmer to review customization code and make integral changes to make it compatible with centred variation of Microsoft Dynamics GP (existing variation is 10.0, Dynamics GP 11.0 is predicted to be released in May 2010)
2.eConnect for Microsoft Dynamics GP. This Software Development Kit was introduced before the full factor as a tool for Great Plains eCommerce programmers to open GP gadgets through ecommerce web utility: Customer, Sales Invoice, Inventory Item, Credit Card deposit money, Ship To Address, etc. Later on eConnect was expanded to hide maximum of the modules in GP: General Ledger, Purchase Order Processing, US Payroll, Project Accounting, Sales Order Processing (please, notice that older Invoicing module is now now not very covered). If you are Microsoft Visual Studio developer, who is programming in C#, VB.Net with fairly-priced publicity to XML and SQL Stored techniques, we recommend you to aim eConnect self discovery or take a coaching. Sometimes ecommerce builders recognize eConnect limitations. One of them maybe found through this case - let's suppose that you can like ecommerce utility to do all the work, which includes automatic transaction posting in Dynamics GP. eConnect doesn't publish GP batch or individual transaction, as those routines are assigned to Dynamics GP User (study the numbers and QTY, take off holds if any, print Batch Edit report and publish the batch). If you can like to publish the batch from ecommerce utility at once - you will definitely wish Dynamics GP Posting Server add-on, readily available from Alba Spectrum
