 |
Ecommerce Programming for Great Plains Dynamics Gp – Introduction
Author: Andrew Karasev  | Posted: 09-09-2007 | Comments: 0 | Views: 36 | Rating: (52)  (?) 
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
Rate this Article:
Current: 0 / 5 stars - 0 vote(s).
Article Source: http://www.articlesbase.com/programming-articles/ecommerce-programming-for-great-plains-dynamics-gp-introduction-211551.html
 About the Author: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
|
Submitting articles has become one of the most popular means to drive traffic to your website and promote yourself and your business. Join us today - It's Free! |
|
Related Articles
E-inbusiness Expands Senior Team With New Head of Projects
By: JDALeeds | 17/07/2008 | ECommerce
Leading multi-channel full service eCommerce & eMarketing agency e-inbusiness has expanded its senior team with the appointment of Tuan Ngo as Head of Projects.
Tuan, who joins e-inbusiness from Fujitsu Services, has been appointed to oversee all eibCommerce technology projects and delivery with an immediate focus on creating a best-of-breed Project Delivery Strategy.
E-inbusiness Expands Business Development Team With Two Key Appointments
By: JDALeeds | 17/07/2008 | ECommerce
Leading multi-channel full service eCommerce and eMarketing agency e-inbusiness has expanded its Business Development Team with the appointment of Andrew Fowler and Nick Pawley as Business Development Managers.
Ecommerce: Naming The Solutions
By: Scott Lindsay | 04/02/2007 | Internet
The world of ecommerce is filled with fascinating technology and significant possibility. The move from a brick and mortar store to online sales may feel like being exported to a foreign country. You may not understand every issue involved in developing a winning website, but you CAN adapt. The end...
Improving The Odds Of Success In Ecommerce
By: Scott Lindsay | 05/02/2007 | Internet
Technological advances have allowed a series of potential revenue streams in the world of ecommerce. Certainly the technological revolution has allowed brick and mortar commerce to open its doors to international clients. And while this is a rather large tip on a rather large iceberg it's not the sum total...
Four Point Consumer Connection
By: Scott Lindsay | 13/02/2007 | Internet
Ecommerce is essentially the art of meaningful connection. When online businesses perceive their role as merely seller they are liable to find themselves in a 'disconnect' with their customers.
Connection # 1 - Know Your Customer
The best step in connecting with your prospects is to learn what they want. This generally...
Ecommerce: How Payment Gets From Here To There
By: Scott Lindsay | 20/02/2007 | Internet
We've all heard the children's song, 'Dem Bones'.
The foot bone's connected to the leg bone,
The leg bone's connected to the knee bone,
The knee bone's connected to the thigh bone,
The thigh bone's connected to the back bone,
The back bone's connected to the neck bone,
The neck bone's connected to the head bone,
Etc.
This...
Ecommerce: Stress Reduction
By: Scott Lindsay | 20/01/2007 | Internet
Certainly it's important to plan and prepare for an online marketplace. It's important to learn what you can about Search Engine Optimization (SEO) techniques, traffic building, ezine publishing, RSS, blogging, PPC and other marketing methods. The point of balance in ecommerce is there doesn't need to be an incredible amount...
Ecommerce: Profit In Data Feeds?
By: Scott Lindsay | 20/01/2007 | Internet
You've been to a shopping engine online. You know the kind, a place where you can do comparison-shopping online before you actually make a buying decision.
If you are a netrepreneur you may wonder if it is even possible to have your product considered for price comparison sites like,...
Got a Question? Ask.
Ask the community a question about this article:
Frequently Asked Questions
Have you seen Store manager for Zen Cart?
By: Martin | 13-10-2008
Hello,
If you have zen cart based store, you may be interested in Store manager for Zen Cart
http://www.zencart-manager.com/
Best regards,Martin
What are the security differences between Great ...
By: Ruth Ann | 01-10-2008
What are the security differences between Great Plains version 9 and version 10?
Websites Design Dallas : Online Marketing : Graphic Web Design
By: dorothy519 | 09-09-2008
Websites Design Dallas. Magic Logix offers digital marketing solutions that include website design, web development, graphic design, flash design, and Online Marketing all over Dallas
Where do Ecommerce Business Owners Help Each Other
By: JohnScottDixon | 29-08-2008
If you are an owner or operator of an ecommerce business, where do you go to learn best practices, exchange information with other ecommerce business owners?
Trying to discover any groups out there that would help us learn from and grow with each other.
What the top 3 contextual ad platforms?
By: Nolan Bayliss | 30-06-2008
What the top 3 contextual ad platforms?
Social Bookmarking Submission Service
By: fantasia236 | 17-05-2008
It is a popular fact that and major search engines like Google, MSN and Yahoo give more weightage to content in a website. Therefore it is likely that the more places you have for your content the greater traffic you are can generate. Hence submitting your site manually into social bookmarking sites like blogthis , Digg, orkut and others will not just generate a greater volume of direct traffic but will also help increase the SERP (Search Engine Results Page) of your website.
Q&A Powered by: 
Latest Programming Articles
Cool Desktop Wallpapers
By: Danny | 18/11/2008
Cool desktop wallpaper is accomplishments arrangement that displayed in the computer operating system. The wallpapers usually be acclimated in JPEG, BMP and GIF book formats. That wallpaper can be acclimated with Microsoft Windows, Linux and Macintosh Mac OS. Each adviser can be altered requirements, alike admitting wallpaper images advised for accepted monitors can be scaled up or bottomward to the fit size. Those are accessible on the internet for free. Some categories of wallpapers are a
Tips for Buying Software Online
By: Daniel Jowssey | 17/11/2008
Buying software online not only helps save the planet, it also has other benefits, including:
* Ease and Simplicity. You can purchase software in your underwear at 4am if you really want to. Shopping online doesn’t have to be done within regular business hours, nor do you need to look your best to do it. It’s also easy to shop around for the best prices and takes less time than driving to the shops.
Mvc Design Pattern
By: TuVinhSoft .,JSC | 14/11/2008
Model-view-controller (MVC) is an architectural pattern used in software engineering. In complex computer applications that present a large amount of data to the user, a developer often wishes to separate data (model) and user interface (View) concerns, so that changes to the user interface will not affect data handling, and that the data can be reorganized without changing the user interface.
Advantages of Low Cost Contract Programmers in Freelance Programming
By: Joanna Gadel | 12/11/2008
It observed that web industry is getting tougher thus the necessity of freelance contract programmer is required for developing more effective website with flexible features. This article states the fruitful advantages of freelance programmers in contract programming.
A Guide to Cnc Kits
By: Martin Applebaum | 09/11/2008
CNC kits are a way in which to construct your CNC machine. This article will provide some information on these machines.
A Guide to Cnc Tube Bending Machines
By: Martin Applebaum | 08/11/2008
Are you familiar with a CNC tube bending machine? This article will shed some light on the main function and components of this machine.
Ways to Hire Dedicated Php Programmers
By: Jucick | 08/11/2008
It’s not at all easy to hire dedicated PHP programmers unless you know where and how to find them. Whether you need to fix, update or enhance your website you naturally want the job done quick and right.
Top 4 Reasons Why Addressing Web Accessibility is Important
By: Matt Cave | 05/11/2008
There are very high chances that web accessibility is more important to the performance of your web site than you realize. Article takes a look at the top 4 reasons why it would be important to address the issue of web accessibility.
More from Andrew Karasev
Dynamics Gp Reseller Newsflash: Gp Customization
By: Andrew Karasev | 17/11/2008 | Software
Dynamics GP ERP is very robust platform for implementing custom business processes as addition to existing ERP and MRP logic. As Great Plains Dynamics is targeting mid-size and even large companies, you should expect that modification flexibility comes with certain level of technology complexity, where you should not expect generic programmer to turn around in couple of days and begin to program such proprietary Great Plains tools, as Microsoft Dexterity.
Great Plains Var Newsflash: Sales Commission Report
By: Andrew Karasev | 16/11/2008 | Software
Microsoft Dynamics GP serves vide spectrum of industries, and likely that very large percentage of Great Plains customers deploy Sales Order Processing module, especially if they also carry Inventory control and need Invoice or Sales Order itemization. In out-of-the-box Dynamics GP you should be able to setup basic commission schema for your sales persons and even sales territories, however real life is often different and requires commissions to be accrued on very complex rules.
Great Plains Dynamics 7.5, 6.0, 5.0 on Pervasive Sql Support Nationwide
By: Andrew Karasev | 15/11/2008 | Software
Current version of Microsoft Dynamics GP is 10.0, it is only available on Microsoft SQL Server platform. If you are still on Pervasive SQL or Ctree, there should be respected reason for you to stick to the old version and do not undertake upgrade to 8.0, 9.0 or 10.0. Additional complication might be something like Intellisol add-ons: Advanced POP or Project Accounting.
Great Plains Partner Newsflash: Dynamics Gp Implementation Recovery
By: Andrew Karasev | 14/11/2008 | Software
Microsoft Dynamics GP ERP implementation is a process, where you should expect high level of cooperation from your accounting, finance, IT, Sales, Purchasing, warehouse management, manufacturing and potentially other groups of employees
Dynamics Gp Var Chicago, San Diego News: Frx Reporting
By: Andrew Karasev | 13/11/2008 | Software
Microsoft Dynamics GP ERP, also known as Great Plains is very popular accounting application and platform for mid-size businesses. It serves large number of industries: wholesale and retail, shipping and logistics, healthcare, light manufacturing and assembly (especially discrete production), multinational companies, services, project organization, trading.
Great Plains 7.5, 6.0, 5.5 Support Overview for Consultant
By: Andrew Karasev | 10/11/2008 | Software
Great Plains Software Dynamics and eEnterprise were very popular in time of these historical versions releases. We know that large number of small and midsize businesses decided to stay with these historical versions and do not undertake upgrade.
Sap Business One Training Overview for Consultant
By: Andrew Karasev | 09/11/2008 | Software
SAP B1 is becoming popular ERP and MRP platform for smaller and mid-size businesses. For larger organizations, SAP BO maybe also good alternative, especially being implemented in subsidiaries and in international branches to be integrated to corporate ERP. In such scenario corporate ERP could be SAP high end version or MRP from different vendor – transactions export from SB1 is simple and typically there are no issues in setting up ongoing GL integration and consolidation.
Great Plains User Training Overview for Consultant
By: Andrew Karasev | 08/11/2008 | Software
Microsoft Dynamics GP ERP is typically deployed in mid-size organizations, or if it is in the smaller firm, then likely that business processes are relatively complex, and this was potentially one of the reasons Great Plains was evaluated and chosen.
|
|
Computers 
