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.

Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com

Andrew is Great Plains specialist in Alba Spectrum Technologies (http://www.albaspectrum.com) ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, New Orleans, Toronto, Montreal and having locations in multiple states and internationally

---

Imagine if Everyone Working In Your Office Was In Synch?

Microsoft-Outlook is a pretty amazing program. So much more than... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Microsoft Small Business Manager eCommerce ? Overview

Microsoft Business Solutions Small Business Manager is scaled down Great... Read More

Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

Traditionally we were considering functionally rich systems, such as SAP,... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

Theres Gold in Your Websites Server Log

Many Webmasters have never bothered to view their website's server... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Microsoft Great Plains Customization: Project Organization ? International Business Example

Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

Microsoft CRM USA Nationwide Remote Support

Remember old good days when your company probably had Great... Read More

Databases ? How We Love to Hate Them!

You've finally created databases that you can actually use to... Read More

Tripwire for Linux File Integrity

What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

Know-how in Microsoft Publisher

For those who still don't know, Microsoft Publisher helps computer... Read More

Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview

In the case when you represent mid-size or mid-size-to-large business,... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

5 Mac Security Tips You Can?t Live Without

So, you've bought a new Macintosh, and now you may... Read More

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

The True Meaning of Freeware

The vast majority of us will have, at some point,... Read More

Adware and Spyware Blockers

The most important things you can do for your computer... Read More

Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant

Bill of Lading is required report for Logistics and Freight... Read More

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

Microsoft Great Plains fits to majority of horizontals and retail... Read More

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More