 |
Ecommerce Programming for Great Plains Dynamics Gp – Introduction
Author: Andrew Karasev  | Posted: 09-09-2007 | Comments: 0 | Views: 33 | Rating: (62)  (?) 
 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 of generating quality backlinks and targeted traffic to your website. 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.
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...
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.
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
Online shop requirements
By: razk | 10-06-2008
what are the technical requirements of creating an online shop?
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.
What is the website of Ronald A. Katz?
By: DavidAv | 26-04-2008
What is the website of Ronald A. Katz who is described inhttp://en.wikipedia.org/wiki/Ronald_A._Katz
Better than bluehost? Is there any?
By: denen | 21-04-2008
Better than bluehost? Is there any?
How to create or make a callback url?
By: Jahsun | 14-04-2008
How to create or make a callback url?
Invalid Domain Specified. Domain already in use by ...
By: rajabasha | 14-04-2008
Invalid Domain Specified. Domain already in use by another hosting customer. How to solve this problem
Q&A Powered by: 
Latest Programming Articles
Hire Web Developer and Dedicated Web Developer Online
By: Neha Shah | 17/07/2008
Hire-Web-Developer.com offers you to access to one or more dedicated web developers who work for you exclusively on your projects from our facilities here in India. Hire-Web-Developer.com provides dedicated web developer services since six years in the industry.
Why Use Asp.net, and the Basics With Visual Studio 2008 Express Edition
By: D R Haake | 16/07/2008
ASP.Net is a great technology to deploy a new website. There are a couple of drawbacks, but these can be overcome by using Visual Studio 2008 Express Edition. This allows you to create uniform websites quickly and easily and manage your website's content in an easy-to-use manner that many novice web developers can easily get accustomed to.
Offshore Software Development Companies:catalysts of Growth
By: vivek | 16/07/2008
software development companies help corporations in developed markets to experience significant cost savings without compromising on the quality of the output. In today’s globalized economy; companies have adopted a global outlook and find it prudent to get their processes managed from places where it can be done at the lowest cost with a similar degree. Offshore software development companies have gained immensely from this paradigm shift in the global business environment.
Significance of Web Applications in Promoting Online Business
By: vivek | 16/07/2008
Web Applications allow business owners to share their core business applications and data with their globally dispersed stakeholders. In simple words, employees, customers, suppliers, and business partners can collaborate and access the same body of information simultaneously
Off Shore it Out Sourcing Consultancy: Their Roles in it Fields
By: vivek | 16/07/2008
Vendors who provide Off shore IT Outsourcing Consultancy services are referred to as outsourcing consultants. These outsourcing consultants help companies experience significant cost savings by utilizing the cheap labor pool of low cost destinations like India. Since Outsourcing is a recent phenomenon;
On Demand Applications: Enterprise Java Bean Application Development With a Three-tier Architecture
By: vivek | 16/07/2008
A Enterprise java beans is basically a server side component architecture for developing modular enterprise applications based on the java platform. EJB basically encapsulates the business logic and implements back end business logic of an enterprise application.
Asp.net Accordion Control With Sql Server Connectivity
By: Joggee | 15/07/2008
The Accordion is a web control that allows you to provide multiple panes and display them one at a time. It is like having several CollapsiblePanels where only one can be expanded at a time.
How to populate data from the SQL SERVER database and integrate with Accordion Control
I tried from the internet but hardly found something good which is so friendly.
I decided to make a code for this.........
Ecommerce Solutions for Business Needs
By: Synapse India | 11/07/2008
We are living in the age of commerce. The old methods of tackling the commerce may not fade in the real world but they have been molded as per the modern sensibilities to meet the desires of people from all walks of life, and all levels of education
More from Andrew Karasev
Great Plains Consultants and Programmers: Dexterity Customizations
By: Andrew Karasev | 25/07/2008 | Software
If you are looking at Microsoft Dynamics GP ERP implementation, or if you already have it implemented in the past, chances are high that you have to handle Great Plains Dexterity custom programming or upgrade your historical Dex modification
Great Plains Consultants Chicago, San Diego, Houston and Nationwide Support
By: Andrew Karasev | 24/07/2008 | Software
Microsoft Dynamics GP software licenses sale, implementation, data conversion, user training, customization, integration, reporting, version upgrade.
Microsoft Dynamics Gp Great Plains Consultants With Industry Expertise
By: Andrew Karasev | 23/07/2008 | Software
Microsoft Dynamics GP Great Plains certified consultants with average 10 years of experience are available for GP implementation, customization, data conversion, integration, user training and ongoing support. We have experience in such modules as General Ledger, Accounts Payable, Accounts Receivables, Sales Order Processing, Purchase Order Processing, Project Accounting, Fixed Assets, Payroll, ReportWriter, FRx, Crystal Reports for GP, Microsoft Dexterity, eConnect and GP Integration Manager
Great Plains Consultants and Integrators With Emphasis in Technology
By: Andrew Karasev | 22/07/2008 | Software
Microsoft Dynamics GP functional and technical consulting requires strong backing in technology experience, background, training and certification. Modern ERP consultant should be familiar (or be capable to involve fellow consultants) with industries, managerial and financial accounting, be reasonable good in reports design, system modification, have some knowledge and be aware about specific programming techniques and customization tools.
Great Plains Consultant, Specializing in Technically Challenging Projects
By: Andrew Karasev | 22/07/2008 | Software
Microsoft Dynamics GP implementation, data conversion, reports design, user training, integration with legacy system and possible modifications and customizations should be entrusted into the hands of professional certified Dynamics GP consultant
Great Plains Consultant in Chicago, San Diego: Nationwide Support
By: Andrew Karasev | 19/07/2008 | Software
Microsoft Dynamics GP ERP is the member of Dynamics product family. If you decided to implement Great Plains in your organization, you probably came through the process of corporate ERP selection and decided to trust Microsoft Dynamics brand.
Great Plains Dynamics Gp Reseller: Nationwide Support
By: Andrew Karasev | 18/07/2008 | Software
If you are looking for new implementation of Microsoft Great Plains, you need first to locate Dynamics GP (which is new name of this ERP product) VAR, who will become your consulting and implementation partner. VAR selection should be based on your criteria.
Great Plains Customization: Reportwriter Modified and Custom Reports Overview
By: Andrew Karasev | 17/07/2008 | Software
In Microsoft Dynamics GP Report Writer is integrated reports modification tool, where you can modify such reports as Blank SOP Invoice form or Purchase Order to place your company logo there.
|
|
Computers 
