|
eCommerce programming for Great Plains Dynamics GP Alba Spectrum
If your organization deploys Microsoft Dynamics GP Great Plains ERP and you are thinking on connecting it to your eCommerce site, we would like to give you initial introduction - where to start digging GP, tools, integration options, limitations, pluses and minuses and others typical FAQ. Current version of Great Plains is 10.0, we assume that it is reasonable to be at list on version 9.0, prior to begin ecommerce connection project otherwise you will be reprogramming your integration with version upgrade. If you are on older versions, especially on Pervasive SQL 2000/Btrieve or Ctree/Faircom (this might be the case if you are on GP 7.5, 7.0, 6.0 or earlier), we recommend you first upgrade to MS SQL Server based version (you should contact you MBS VAR and they will provide you with the migration tool and it is recommended that professional Great Plains consultant does the conversion)
1. Sales Order Processing module or SOP. This module is typically integrated with your e-commerce application. In eCommerce you create either SOP Order or SOP Invoice. The easiest scenario is to create order or invoice without inventory items allocation, this is especially recommended if you are trying to program integration in SQL stored procedures
2. Great Plains tables structure. This is one of the first questions, which we hear from developers. You should login GP, depending on version, we will give you the path for version 10.0: Microsoft Dynamics GP->Tools->Resource Description->Tables. Tables are grouped by GP series: Financial, Sales, Purchasing, Inventory, etc.
3. Microsoft Dexterity technology. You should be aware that if you populate GP table records, you should treat GP business logic accordingly. The most important is treating GP Dexterity business logic, which is validated when Great Plains client application tries to read records, populated by you if business logic is violated and could not be validated, Dexterity interface will error out and you will make GP ERP inoperable
4. eConnect. Yes, this is what you should consider to use whenever possible in e-commerce. eConnect core is set of SQL stored procedures, which allow you to create, modify, delete GP master records (customer, vendor, inventory item) and work transactions (such as SOP invoice, or SOP order), plus eConnect allocates invoice or order lines, so the limitation of topic one is not a problem here. What eConnect can not do is post individual transaction or SOP batch this routine is left to GP operator by GP architecture
5. Posting Server. Alba Spectrum Posting Server allows you combine eConnect with autoposting directly from eCommerce application. Posting server is GP Dexterity application and should be installed on separate GP workstation (or your GP server, where you keep GP workstation with Posting server running). When deploying posting server you will need to place approved batches to custom tables and posting server will take care of posting process
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego
Company: Alba Spectrum Group
|
| Related press releases |
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...
|
|
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 ...
|
|
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...
|
|
eConnect eCommerce Posting Server for Dynamics GP Alba Spectrum [2007-09-22 02:52:59]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce .Net c#, VB or SQL developer, you need to know eConnect Microsoft Dynami...
|
|
Microsoft Great Plains eCommerce Web Design & Autoposting Alba Spectrum [2007-08-24 06:18:59]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP Great Plains is MS SQL Server 2005 application, current version in 10.0. ...
|
|
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...
|
|
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...
|
|
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...
|
|
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 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...
|
|
|
|
| Wondershare QuizCreator X'mas Offer |
 Wondershare QuizCreator is a robust solution designed for making highly customized flash quizzes without programming. Users can publish their quizzes to LMS (AICC/SCORM), and pass test results to Web database for learning evaluation. |
|
| TOWeb |
 TOWeb is an easy-to-use software for persons and organizations wishing to quickly create a Blog or a Web Site without any web designing skills, without dealing with web programming stuff and without using a retouching software for their pictures. |
|
| Amazon Price Watch |
 Amazon Price Watch help you to keep track of the price, get notice when hot item is available or price drops for your wishlist, and find great deals or filler items when you need a bit more for free shipping. |
|
| SnapaShot |
 Smallest free screen capture tool, SnapaShot is great for taking screenshots of different size. Just open Snapa, resize its window to fit the area you want to save, and press "save it" button. |
|
| 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. |
|
| MySharpSQL |
 Learn from ebook and well commented example source codes, the easy way to use MySQL with C#. In addition to an ebook, this package contains a real world .NET program that allows you to manage a collection of MySQL and C# programming notes. |
|
| Asoftech Automation |
 Asoftech Automation records all operation of mouse and keystrokes and saves them as macros. It can play back the recorded macros to automate recorded tasks any number of times.It is very easy to use and doesn't require any programming experience. |
|
|
Latest press releases
