Microsoft Great Plains eCommerce - know your options and alternatives

Microsoft Great Plains eCommerce - know your options and alternatives

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

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

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

ABOUT THE AUTHOR
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

Andrew Karasev

More Articles

Ecommerce Web Hosting: All you need to know - Rodel Garcia
Gone are the days when the Internet was only for the geek labs and university libraries. With the emergence of accessible connectivity and affordable technology, ecommerce and online business are not futuristic concepts. Websites like Amazon and...

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino – overview for developer - Andrew Karasev
Microsoft Business Solutions Great Plains has substantial market share among horizontal and vertical clientele in the USA, Canada (including French version for Quebec/Montreal), UK, Australia, New Zealand, Spanish speaking Latin and Central...

eCatalog - a Key Component of Your eCommerce Initiative - Nowshade Kabir
In recent years, Internet virtually has become major driving force of economic and technological growth in many industries. It is fundamentally changing the way companies operate, do their trade and interact with each other and it is giving birth...

eCommerce development for Microsoft Great Plains: tools and highlights for programmer - Andrew Karasev
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise was designed in earlier 1990th as ERP, which can be easily transferable to the winning Database and OS platform and it was originally available on...

How to set up the ecommerce shopping cart software tools to handle your transactions and how to do in smart, efficient and cost effective way. - Sandro Salsi
Utilizing a ecommerce shopping cart software solution frees you of the burden of setting up and managing your shopping car, credit card processing and sales management functions so you can concentrate on what you do best, providing products and...

ECOMMERCE SOLUTIONS…THE CALL OF THE TIME - Jinky C Mesias
There really is no doubting the impact of Information Technology on our lives. And a significant example of this is the application of ecommerce in business. Conducting business transactions has been changed to a great extent. Just what are...

Ecommerce - Boost Your Business ROI - Rick Caraballo
Did you know that over 90% of all online orders are processed by credit cards and that web sites that offer customers the ability to pay with credit cards can achieve up to 300% more sales than those that do not? It's a fact. Not only do...

Blocking and Tackling | A quick look at some eCommerce fundamentals - Craig Smith MBA Founder Managing Director Trinity Insight LLC
eCommerce can be VERY complex. To offer a world class customer experience, retailers must incorporate technologies and functionality that exceeds rising customer expectations. eCommerce can be VERY complex. To offer a...

Online shopping cart - ecommerce solution - ecommerce web site design - T S Anand
Bring flexibility in checkout pages by Techwave.com Techwave, the leader in ecommerce web solutions for both big and small ecommerce sites has introduced SINGLE PAGE CHECKOUT. This latest generation of Techwave's successful eStore solutions adds...

Increasing Your Conversion Rates: 50 Tips For Ecommerce Sites - Gail Bellaiche
You can convert More of Your Traffic into sales without having to spend a lot of money. There are hundreds of ways to improve your conversion rate and the persuasiveness/stickiness of your website, many of which can be done very quickly and most...

Ecommerce Turnkey Sites - Kim Valentine
Turnkey host sites normally offer the complete package, which normally includes hosting as well as products. Turnkey means an already stocked business, depending on the store it might be stocked with from 10 products to thousands. These...

The Plastic Web of Ecommerce Website Design - Mark Nenadic
Copyright 2006 Mark Nenadic Ecommerce website design embraces the idea of the Internet storefront. When it comes to operating a store on the Internet, taking money from customers should be as easy as it is when dealing out of a street front...