|
Great Plains Integrations: how to design and FAQ Alba Spectrum
When you plan to implement new ERP system, or advance existing one by integrating your legacy applications with your accounting system, implement EDI or Electronic Document Interchange interface, integrate custom business logic and put in into standard ERP routines, you need first to understand your options and the best ways to do whatever you decided to undertake. This article is the introduction and initial know how. We will assume that you are new to Microsoft Dynamics GP and not familiar with this ERP package in your initial MRP selection phase
1. Integration Manager tool. Great Plains client application, besides from GP Business Portal, is written in Microsoft Dexterity programming language and IDE. With version 10.0, which is current now December 2007, IM has two connectors: first one is traditional and it utilizes GP Dexterity workstation to do integration as OLE Server, meaning that GP workstation must be open and running (with all the GP screen closed as OLE Server will open screens in macro playing regime) and the second connector is eConnect one, which works on MS SQL Server Stored Procedures level and doesnt require GP workstation presence and running status. Integration Manager covers majority of GP modules, however not all of them, Invoicing module is not covered in IM, for instance. In IM you can exercise some modification scenarios, where you apply VBA scripting in handling IM events: before the document, for example allows you to weed out blank lines, if integration is using human readable report, where you see empty lines as document formatting.
2. Direct eConnect integrations. If you are comfortable with Microsoft Visual Studio C# or VB programming, you can try to program eConnect objects directly from your MS VS software development project. In this case you should contact your Microsoft Business Solutions VAR and get eConnect SDK or Software Development Kit
3. SQL Stored Procedures. Direct SQL scripting and creation of custom SQL objects: user tables, views, databases is not deprecated in Great Plains (as it is in Microsoft CRM, where you must use MS CRM SDK and do not go down to SQL scripting level), however you should try to stay away from it as long as possible, as it typically requires you to be familiar and comfortable with GP data flow and business processes technical layer, good to recommend you to be comfortable with GP proprietary architecture Great Plains Dexterity. If you think you should jump down to SQL programming, please review GP SDK or look at GP tables structure in Microsoft Dynamics GP Tools Resource Descriptions Tables
4. Microsoft Dexterity integrations. These integrations allow you to go to the most intrinsic parts of Great Plains and manipulate all the GP objects, however Dex is proprietary tool and Sanscript programming language
5. Integration Automation. We often hear questions about how to automate GP integration, especially the one coming from IM. Version 10.0 allows you to create packages and deploy DOS batch files to run these packages with parameters as scheduled jobs, this should give you initial highlight, you can do your homework for further details or call for the details
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918. Serving GP customers in Illinois, Texas, California, Florida, Wisconsin, New York, Michigan and USA and Canada nation wide via remote support. Our service is popular in USA country side, where you do not expect local consultants to be available and we cover the whole country with travel onside with initial user training then we typically save your budget by convenient remote support, as we already are familiar with your key IT and accounting personnel. Local service is available in Chicago, Houston, Naperville, Oakbrook, Wheaton, Joliet, Plainfield, Aurora, Elgin, Springfield, Morris, Ottawa, LaSalle, Channahon, Brookfield, Villa Park, Downers Grove, Lisle, Hinsdale, Lincolnwood, Zion, Kankakee, Braidwood, Niles.
|
Company: Alba Spectrum Group
| Related press releases |
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
Microsoft Dynamics GP 10.0 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Web Design for Microsoft Dynamics GP: custom ecommerce solutions Alba Spectrum [2007-08-18 05:19:13]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
More articles are published about Microsoft Great Plains Dynamics GP 10.0. Very hot topic is e...
|
|
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
Planning upgrade for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-08 04:56:42]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are on the way to upgrade GP versions 7.5, 8.0, 9.0 to GP 10.0, then you should read thi...
|
|
Integration Options for Microsoft Great Plains overview Alba Spectrum [2007-10-05 06:21:02]
ERP is typically considered as the platform, open for custom integrations, software development, reporting, EDI. Implementation and deployment requires interoperability with multiple computer systems...
|
|
Microsoft Dynamics GP 10.0 eCommerce autoposting Alba Spectrum [2007-08-13 05:18:50]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains Alba Spectrum posting server, which is built upon Microsoft Dexterity so...
|
|
Great Plains Integrations: how to design and FAQ Alba Spectrum [2007-12-27 08:28:25]
When you plan to implement new ERP system, or advance existing one by integrating your legacy applications with your accounting system, implement EDI or Electronic Document Interchange interface, inte...
|
|
|
|
| Screen Paver |
 Screen Paver is an easy to use make-your-own slide show screen saver. The program will display an unlimited number of your own jpeg, png, or bitmap images from local and/or network directories. Plays music too. Great for digital camera users. |
|
| BusinessCards MX |
 Use this program to easily and quickly design and print professional business cards. The program interface was designed so that even the beginning user will have no problem operating the program. |
|
| Amara Flash Intro and Banner Builder |
 Amara Flash Intro and Banner Builder is the ultimate Flash text effect tool to help the web designer create and design flash animations. |
|
| SecuKEEPER |
 Are your data safe?SecuKEEPER is an ALL-IN-ONE file encryption software design to secure your files and folders from prying eyes, which designing four protection method(hide/rapidly lock/encrypt/private coffer). Furthermore offer Password Manager. |
|
| Pure SEO CMS |
 Fast, powerful, SEO website builder, optimized CMS, CSS compliant. Fast, client side XML to html engine. Beginners enter content and select design. Experts use their own templates and save time building high quality sites . No online server required. |
|
| QuickUML Windows |
 QuickUML is a software design tool that tightly integrates a core set of UML models with code generation. A project is presented through a tabbed window of use cases, class models, object models, dictionary and code and saved as an XML file. |
|
| Clix-FX Fee Flash Menus |
 Flash XML Menu Templates from Clix-FX We offer you the easiest way imaginable to design and create Flash menus for your website. |
|
|
Latest press releases
