Custom Programming for Dynamics GP Notes

Microsoft Dynamics GP, or previously this corporate ERP application was regarded as Excellent Plains Dynamics, eEnterprise, and its predecessor Excellent Plains Accounting for DOS, Windows and Macintosh, fashionable GP has vide variety of customization, integration, modification, report design tools: Dexterity, eConnect, GP SDK, Internet Solutions for GP, Modifier with VBA.  Plus you can in some circumstances create SQL Server Look at and Stored method (in EDI textual content file export or as reporting base scenarios).  This little publication is supposed to be an introduction.  We will consider to continue to keep stability of getting fairly technical and at the identical time not much too technical:

1. eConnect programming for Excellent Plains Dynamics GP,  eConnect is technology, which has encrypted SQL Stored Strategies in its foundation, and they are uncovered to Microsoft Visual Studio developer by means of .Internet libraries.  Plus eConnect has SDK helper with C# and VB code samples.  eConnect was introduced to Excellent Plains 7.XX versions as programming tool for eCommerce computer software developer to open Excellent Plains objects for ecommerce integrations: SOP Bill (ecommerce procuring cart), Consumer Deposit (credit score card payment), Inventory Merchandise (bill traces), client record and tackle.  It was from the beginning masking B2B and B2C ecommerce versions (the place Business enterprise to Consumer ecommerce typically has predefined GP Wander-In client ID).  Later on eConnect was expanded to most of Dynamics GP modules: Payroll, Task Accounting, Payroll and other modules.  Some of the modules are not protected in eConnect, for case in point Invoicing.  In the scenario of invoicing we recommend you to use Sales Purchase Processing, which does the identical position additionally extra.  One previous be aware on eConnect.  It does not have Batch posting functionality, if you need batch posting, think about Alba Spectrum Posting Server

two. Dexterity Programming for Dynamics GP.  Dex is the architecture, Dynamics.dic meta dictionary is designed in Dexterity.  If you are professional Dexterity programmer, who have entry to Dynamics GP Source Code, you are fairly significantly limitless in your Excellent Plains customization qualities.  However Dex has downsides – if you are generic programmer with solid Item Oriented Programming or even Procedural Programming expertise, Dexterity is not a little something extremely pleasant and you should not expect to come to be Dexterity expert overnight or over week or even over year.  We recommend you to subcontract Dexterity programming to Excellent Plains Dexterity programmers or to Dynamics GP Lover, who runs Dynamics GP Dexterity Software Growth Manufacturing unit

3. Modifier with VBA.  This tool is Dexterity based mostly.  It is not compatible with Windows.Internet, this is why you will need to use VBA scripting and these Database Accessibility technologies as Microsoft ADO (and not ADO.Internet).  Modifier lets you to get rid of fields from existing screens, reposition them or incorporate new fields (which are issue to animation by means of VBA scripts)

4. Crystal Studies for Dynamics GP.  If you are simply just hoping to export existing information from Excellent Plains, you are Okay with CR Wizard, on the other hand if you are creating innovative report, we stimulate you to review Dynamics GP Table Framework in GP SDK (install it from CD #two) or in Dynamics GP Consumer Interface: Resources -> Resource Description -> Tables

5. EDI Programming for Dynamics GP.  Electronic Doc Interchange normally does not involve incorporate-ons or tailor made tools.  You can software EDI code in formatted SQL Pick assertion.  This system should conserve you a ton of revenue and make you neutral to Dynamics GP ISV associates tailor made modules (and their enhance methods and annual enhancement fees)

six. Report Author reviews in Dynamics GP.  Such well known reviews as SOP Blank Bill Kind, the place you spot your company logo as a bare minimum, are handled in Dynamics GP ReportWriter

7. FRx reporting for Dynamics GP.  FRx is solely for Economic Reporting: Balance Sheet, Earnings and Loss, Statement of Cash Flow additionally consolidated versions of these reviews.  FRx is typically pleasant to Accountants and does not involve Dynamics GP Programmer intervention

8. SQL Insert Statement directly to Dynamics GP.  This is a little something we are discouraging you to use, as you might violate GP business enterprise logic and information integrity.  Consider alternatively deploying eConnect approaches

nine. How to get enable? Make sure you, truly feel free of charge to contact us: 1-866-528-0577, outside of United states: 1-630-961-5918 or electronic mail us [email protected] We are extremely technical and true Dynamics GP Dexterity, SAP Business enterprise One particular SDK programming gurus. We have Excellent Plains Software Growth Manufacturing unit and could support limitless Dynamics GP Customization and Programming requirements. Additionally we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native talking income individuals, but as true technical consultants. If you favor skype: albaspectrum