Microsoft Great Plains eCommerce – stored procedures approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great Plains Standard are available on Microsoft SQL Server and MSDE (which is in fact MS SQL with database size limit of 2GB). As eCommerce designer you should be aware of several options and customization tools in your disposition, when you utilize Microsoft Great Plains 8.5 (June 2005), 8.0, 7.5, Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Great Plains Dynamics C/S+. When you have old versions (7.5 and prior) we assume that you are on MS SQL Server 2000/7.0, because if you are on Ctree or Pervasive SQL/Btrieve – you should use ODBC / RDO connection tools, such as MS Access and its queries or use MS SQL Server Linked Server technique with OPENROWSET statements. So, lets assume that you are on MS SQL Server. You have basically two options eConnect (you should pay for the reg key/license and this is SDK) and custom stored procedures. We’ll only consider custom stored procedures way here:

1. Stored Procs. The first question is – are we allowed to create stored proc in Great Plains DYNAMICS and companies databases. The answer is Yes – opposite to such products as Microsoft CRM (where you are banned to create any custom object in MS CRM database, and instead you create your own custom database and place all your procedures and views there) – you are encouraged to create your stored procedures and place them in both DYNAMICS and Company databases. You need to know the anatomy of Great Plains tables structure

2. Tables Structure. If you launch Great Plains workstation and follow this way: Tools->Resource Descriptions->Tables – then you are in tables descriptor, sorting by tables Physical, Logical or Tables Group Technical names. This is all Great Plains Dexterity architecture realm and it is relatively complex and not “developer-friendly” – but if you create sample transactions in Great Plains – you can figure out where data should be populated

3. Sales Order Processing. Or SOP module. This is usually the core of eCommerce development – transactions should go into SOP tables (with SOP prefix): SOP10100, SOP10200 and others. If you are selling to your existing customers, then customers are in Receivables Management module (AR) with AR prefixes: RM00101 – is Customer Master, RM00102 – customer address master, etc.

4. Sales Order/Invoice Allocation dilemma. Great Plains SOP module is working in concert with Inventory control, making allocation of inventoried items in IV. So, this is very challenging to replicate allocation logic. We recommend do not allocate in Orders and Invoices and do allocation by operator, who processes the internet orders batch

5. Sales Order transfer dilemma. If you are using eConnect – this is kind of issue, so you have to appeal to GP internal architecture and do it with the stored procs approach.

help@albaspectrum.com

 Andrew Karasev

More Articles 

Ecommerce: I Second That Emotional Connection - Scott Lindsay
“We are much more emotionally attached to products for which we feel some involvement. So true personalization and customization makes a real difference.” – Donald Norman (author) There is a psychology to the products we use most. In truth, there...

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 Website Solution - Delphine Campes Edouard
Implementing your own e-commerce website solution can be a technical nightmare, especially for those uninformed about technical processes and procedures. But without an e-commerce-enabled website, how can you expect to capture your share of an...

Building eCommerce Websites That Work - Part 1 - Richard Keir
Copyright 2005 Richard Keir You want to succeed at eCommerce? Welcome to a very big family. Right off, let’s be clear - there are lots of ways to do business on the internet. And lots of ways to both make and lose money. Successful eCommerce...

Building Ecommerce Web Sites: Where Do I Start? - Jacob Richards
Building a web site isn't something that is really cut and dry. There's a huge variety of products and services that can either help you get your web site where you want it or simply confuse you. It's also important that you make the right choices...

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...

Accepting Payments Online: An ECommerce Web Site Overview - Bobette Kyle
There are a seemingly infinite number of choices and configurations to accepting payments online. Choices range from almost total "do it yourself" programming to turnkey packages. You can accept online payments from an ECommerce Web site in two...

eCommerce Solutions - Paul Sanford
Copyright 2005 Paul Sanford All of the long, grueling nights and an unknown number of working weekends spent converting your dream into reality finally paid off—in a big way! Affiliates are signing up every single day and the clicks have really...

SEO For Ecommerce - Ray Yee
Ranking well under the free listings in the major search engines basically mean one thing – Lots of free, recurring, and targeted traffic. Major search engines like Google, Yahoo and MSN can be very powerful weapons in your internet marketing, if...

eCommerce - A Plan - Richard D S Hill
Planning an ecommerce website is like building a house - architecture and budget need to be agreed before the decoration. AN AGREED REQUIREMENTS SPECIFICATION MUST BE DRAWN UP AS THE FIRST STAGE BEFORE ANYTHING ELSE IS DONE - ANY OTHER...

The Rumors of Ecommerce Death - Rob Spiegel
As Nasdaq sputters along in dot com shame, a few million few dogged Internet consumers have ignored the crash. They continue to happily buy away. The good-news story is not popular with business writers, but Web retailing continues to grow...

Discount Ecommerce Web Hosting - Max Bellamy
This article provides useful, detailed information about Discount Ecommerce Web Hosting. In the present online climate, many business Web sites are being used as online shops and online service providing resources,...