Search
Related Links

 

 

Informative Articles

An Arm & A Leg for eCommerce?
As a site designer myself, I realize how much time and effort goes into registering, setting up, and designing a site; not to mention the creation of content and seamless navigation. But it is unbelievable how complicated and expensive this process...

Canada and eCommerce
Canadian eCommerce growth was recently flat but still has an attractive upside... Recent studies found that Canadian retail e-commerce growth was flat year over year (2003-2004). After further examination however, approximately 60% of the...

Canada's eCommerce Opportunity
This brief takes an updated view of the Canadian e-commerce landscape and provides insight for online retailers to help craft future Canadian customer strategies. Canadian eCommerce growth was recently flat but still has an...

The No. 1 Ecommerce Solution Tip For You
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...

VictoryVisions >> Your one stop to build a successfull ecommerce website
Are you looking for a online presence for your shop? Are you looking for improving your present ecommerce site? Are you bored with your existing site design and layout? Victoryvisions is your one stop place where you can find professionals...

 
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

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

help@albaspectrum.com

 

E-Commerce Times: Because E-Business Means Business
Everything you need to know about doing business on the Internet. Information for C-Level executives and small-to-mid-sized business managers.
www.ecommercetimes.com
 
ECommerce-Guide to News, Reviews and Technology Solutions
ECommerce-Guide provides ecommerce business owners with e-commerce news, hardware and software reviews and tutorials, technology solutions and information ...
www.ecommerce-guide.com
 
Electronic commerce - Wikipedia, the free encyclopedia
Electronic commerce (also referred to as EC, e-commerce or ecommerce) ... Even in product categories suitable for e-commerce, electronic shopping has ...
en.wikipedia.org
 
E-Commerce News for IT Managers
Daily e-commerce news for managers of business covering marketing, transaction processing, security, retailing and service delivered over the Web.
www.internetnews.com
 
New Zealand Government E-Commerce
Resource containing information on electronic commerce, including law, trade, tax, privacy, consumer protection, and help for businesses.
www.ecommerce.govt.nz
 
eCommerce Guidebook for web hosting
The eCommerce Guidebook provides many resources, including a directory of online transaction providers, a tutorial, and many other resources.
www.online-commerce.com
 
ClickZ Internet Marketing Solutions for Marketers
Includes columns with commentary and analysis on a wide variety of internet marketing subjects ranging from B2B marketing to search engine marketing.
www.clickz.com
 
Shopping cart software for Dreamweaver, Frontpage, CSS ecommerce ...
Shopping cart software integrated into Frontpage, Dreamweaver, CSS and Golive ecommerce software templates.
www.ecommercetemplates.com
 
E-Commerce & the Internet
Information from the FTC on E-commerce and the Internet. Includes anti-fraud tips.
www.ftc.gov
 
Economy & Work: eBusiness | Europa - Information Society
The e-business concept goes well beyond e-commerce (buying and selling ... A pilot study on E-commerce and the Internet in European businesses (2002) was ...
ec.europa.eu
 
Online Business
If your e-commerce site currently accepts online payments, and is really, really, ... They are looking for entries from ugly e-commerce sites to win a new ...
onlinebusiness.about.com
 
eCommerce Info Center- ONE-STOP for eCommerce info, services ...
eCommerce Info Center, created and maintained by Slim Baltagi, will make it easier and faster for you to find out relevant eCommerce information, ...
www.ecominfocenter.com
 
eCommerce Innovation Centre
Practical resources for small business involved in or considering eCommerce implemetations. Expert Advice and Assistance.
www.ecommerce.ac.uk
 
Web Marketing Today -- E-Commerce, E-Mail, Internet Marketing, and ...
Articles, tips and advice on e-commerce and effective Internet marketing strategies.
www.wilsonweb.com
 
Web Marketing Today Research Room for E-Commerce
The largest collection of annotated links to web marketing and ecommerce articles and resources to be found at any single place on the planet.
www.wilsonweb.com
 
The 2005 E-commerce Awards - Welcome
The UK national E-commerce awards organised by the DTI and Interforum.
www.ecommerce-awards.co.uk
 
Mal's e-commerce
Mal's e-commerce ... Customize the look and feel of your store; No scripts or applications to install; Build as large an e-commerce site as you want ...
www.mals-e.com
 
Howstuffworks "How E-commerce Works"
E-commerce has exploded in the last 10 years. Find out how e-commerce works and how you can harness the potential of e-commerce, from affiliate programs to ...
www.howstuffworks.com
 
Ecommerce Guide - Terms You Need to Know to Do Business on the ...
An online computer dictionary and internet search engine for internet terms and techincal support.
e-comm.webopedia.com
 
Shopping Cart Software Ecommerce Solutions
Ecommerce solutions by Volusion will take your business to new heights. Volusion offers the best prices in the industry for a complete ecommerce web ...
www.volusion.com
 
 

 

Content Menu
  • 7 tips to increase sales with your ecommerce web site

  • accepting payments online an ecommerce web site overview

  • advertising your ecommerce web site

  • an arm a leg for ecommerce

  • an ecommerce internet merchant account

  • ask mr d ecommerce sales

  • a successful ecommerce website part 1

  • a successful ecommerce website part 2

  • blocking and tackling a quick look at some ecommerce fundamentals

  • blogs podcasting and rss ecommerce impact

  • blogs podcasting and rss how will these technologies affect ecommerce

  • building ecommerce websites that work part 1

  • building ecommerce websites that work part 2

  • building ecommerce websites that work part 3

  • building ecommerce web sites where do i start

  • canadas ecommerce opportunity

  • canada and ecommerce

  • choosing an ecommerce shopping cart

  • comparing ecommerce software programs 5 tips

  • cost effective ecommerce solutions

  • developing a winning ecommerce marketing strategy

  • developing a winning ecommerce strategy

  • divesify with ecommerce

  • drop shipping is ecommerce snake oil

  • ecatalog a key component of your ecommerce initiative

  • ecommerce 101 online credit card processing

  • ecommerce and other strange animals

  • ecommerce a new artform

  • ecommerce a plan

  • ecommerce boost your business roi

  • ecommerce communications and the global internet community

  • ecommerce development for microsoft great plains tools and highlights for programmer

  • ecommerce fundamentals

  • ecommerce hosting considerations

  • ecommerce hosting for your online business

  • ecommerce hosting how to choose a merchant account

  • ecommerce how much does it cost

  • ecommerce installing and configuring your shopping cart

  • ecommerce making your bank account grow

  • ecommerce marketing plan

  • ecommerce seo

  • ecommerce solutions

  • ecommerce solutionsthe call of the time

  • ecommerce solutions compared

  • ecommerce solutions for small business owners

  • ecommerce solution for the big and small business

  • ecommerce store owners want visitors heres how

  • ecommerce that makes sense

  • ecommerce turnkey sites

  • ecommerce website development brings more people to your business

  • ecommerce website overview accepting payments online

  • ecommerce web design solutions

  • ecommerce web hosting all you need to know

  • ecommerce web sites if you build it they will come or will they

  • ecommerce web site building where do i start

  • ecommerce your opportunities are unlimited

  • econnect ecommerce development for microsoft great plains

  • evaluating vendors of ecommerce fulfillment services

  • ever wondered what an ecommerce merchant account is

  • eyes on your ecommerce website

  • for your ecommerce success

  • getting started in ecommerce part one

  • getting started in ecommerce part two

  • hosting options for an ecommerce web site

  • how exactly does ecommerce work

  • how to achieve ecommerce success you gotta plan

  • how to create a money magnet ecommerce web site

  • 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

  • increasing your conversion rates 50 tips for ecommerce sites

  • index

  • integrating microsoft great plains accounting erp rms crm ecommerce lotus domino overview

  • integrating microsoft great plains accounting erp rms crm ecommerce lotus domino overview for developer

  • internet basics ecommerce is like playing house

  • introduction to ecommerce

  • is ecommerce right for our business

  • leading ecommerce consultant admits you should only listen to one real expert and its not him

  • meeting the uk ecommerce regulations

  • merchant services add ecommerce functionality to any business

  • microsoft dynamics gp 9 0 ecommerce web development overview for programmer

  • microsoft ecommerce web development great plains econnect net approach highlights for programmer

  • microsoft great plains ecommerce know your options and alternatives

  • microsoft great plains ecommerce overview for developer

  • microsoft great plains ecommerce stored procedures approach

  • microsoft small business manager ecommerce overview

  • my top 7 favorite ecommerce tools

  • network monitoring for serious ecommerce

  • oscommerce a viable ecommerce solution

  • outsourcing your ecommerce order fulfillment

  • quick ecommerce tutorial

  • reverse logistics and ecommerce

  • rotator

  • search engine optimization in an ecommerce world

  • select a niche market for ecommerce

  • seo for ecommerce

  • small business ecommerce web design

  • surviving the ecommerce competition

  • the ecommerce business plan

  • the ecommerce myth

  • the lowdown on ecommerce making all the pieces fit together

  • the no 1 ecommerce solution tip for you

  • the rumors of ecommerce death

  • the seven pillars of ecommerce defined

  • using ebay to market your ecommerce website

  • victoryvisions your one stop to build a successfull ecommerce website

  • web design for ecommerce

  • web ecommerce where to begin

  • whats toll free numbers got to do with ecommerce

  • what ecommerce software has to offer

  • why ecommerce is not ready for my daughter or me

  • why vps is perfect for ecommerce hosting

  • why you should use turnkey websites to jumpstart your ecommerce activity