Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the earlier 1990th as first graphical ERP/accounting system for mid-size businesses. The architects of Great Plains Dexterity – this is the internal mid-shell, all Great Plains was written on, designed it to be easily transferable between graphical operating systems (MAC, Windows, Solaris – potentially) and database platforms – initially Great Plains was available on Ctree (both Mac and PC) and Btrieve, a bit later high end version Dynamics C/S+ was available on Microsoft SQL Server 6.5. But the idea was to catch or switch winning/losing database platform – nobody could predict if MS SQL Server, Oracle or DB 2 become a dominant DB platform, like Windows among OS. All these trade-ins for being potentially cross-platform application make the life of nowadays eCommerce developer difficult.

• eCommerce developers were using Microsoft IIS and ASP-based Great Plains eCommerce around 4 years ago. Today, with the move to .Net and ASPX platform, server based scripts are replaced with .Net code behind approach and Great Plains eCommerce should be rewritten.

• Microsoft Great Plains subdivision released SDK – eConnect which was targeted to eCommerce developers to manipulate Great Plains objects, such as Customer, SOP Order, Invoice, Quote, etc. What is a bit unpleasant – eConnect requires license key and is quite expensive for small internet eCommerce sites.

• Custom Stored Procedures. Companies, like Alba Spectrum Technologies have implemented multiple diversified eCommerce projects with Great Plains at the back end. So, these custom stored procedures are available on the market, but they are not packaged as eConnect and could be purchased on the individual agreement base with Microsoft Great Plains partner.

• Some Great Plains tables structure logic is required. You usually need consultant help, however you could try to make maximum work done at home. Tool->Resource Desciption->Tables, re-sort by Table Group technical name, then make test transactions in Great Plains (SOP module) and see where records go. This is how you design and test your queries

help@albaspectrum.com

 Andrew Karasev

More Articles 

Ecommerce: Shopping For A Shopping Solution - Scott Lindsay
The specifics of ecommerce can require a learning curve that many are reluctant to tackle. Perhaps that's why many brick and mortar stores have not entered the world of online marketing. It is possible to look at ecommerce and consider the things...

Ecommerce Merchant Account - Jack Chevalier
From: hotlib.com Every small business owners and home based entrepreneurs consider the advantages of an ecommerce Internet merchant account. Those who accept merely cash or check payments may decide to increase the ways in which a customer...

The No. 1 Ecommerce Solution Tip For You - Robert Roy
The number one ecommerce solution you need to be a success on the Web is learning to write for the internet. You will be able to capture your visitors attention and hold it, otherwise it's click and off to another site. You need to be able to put...

Ask Mr. D - ECommerce Sales - Bill Daugherty
Dear Mr. D, After spending about a year as an affiliate for other companies, I have come up with my own product. My product is similar to one that I was selling as an affiliate. I made real good money selling this product as an affiliate, but my...

Ecommerce Web Sites: If You Build It They Will Come - Or Will They? - Lewis Poteet
"If you build it they will come" is one of the memorable lines from the movie "Field of Dreams", one of my favorite movies, by-the-way. An ordinary guy had a dream about building a baseball field in the middle of a cornfield. He carried...

eCommerce, How much does it cost? - Dennis Dadey
Making profits with your existing website design or creating a new online store can be exciting, affordable and most of all; rewarding. Mmmm . . . that's what the last sales guy told me. What is eCommerce (or selling via the Internet)? It is...

How to Create a Money Magnet Ecommerce Web Site - Izzy Camacho
If you've been online for more than a day you've probably heard some "guru" somewhere recommend that you create a Money Magnet Web Site - a site that is highly automated and helps you make money 24 hours a day. While that might *sound* great, what...

Ecommerce Stores - Mark Lawson
The Internet opens up so many opportunities for a company to exist and to expand their operations worldwide. It opens up a global marketplace in which people from all over the world can buy and sell goods and services from the comforts of their own...

Leading eCommerce Consultant Admits You Should Only Listen to One Real Expert! (And it’s not him..!) - Eric Graham
Let me share with you a secret that most marketing experts and consultants don’t want you to know… (many of them don’t even understand this secret themselves.) The secret is… There is only one true expert who can show you how to drastically...

Eyes on your eCommerce Website - Richard Keir
Copyright 2005 Richard Keir In a recent article I talked about Google AdSense placement based on eye-tracking research. However, research by The Poynter Institute, Eyetools and the Estlow Center for Journalism and New Media has a lot to say about...

eCommerce and other strange animals - Michael Bloch
eCommerce, Ecommerce, e-commerce; however you spell it, the term is now firmly lodged in our language. So just what is it? At it's most simplistic level; eCommerce is simply the buying and selling of goods, services or information via the World...

Ecommerce: Have Cart - Will Shop - Scott Lindsay
In order for you to sell products or services online you will need a shopping cart application to facilitate ecommerce. While your customers simply want a way to make a purchase if they are interested in your product you will have already...