eConnect: eCommerce development for Microsoft Great Plains

Microsoft Business Solutions Great Plains has several options to enable web ordering. Traditionally Great Plains Dynamics/eEnterprise had eOrder – this is ASP pages based ordering application, enabling you to place or retrieve your Sales Order Processing (SOP) Sales Orders over the web. There were several drawbacks however with eOrder. You should be the customer in Great Plains company database to be able placing the orders. Also if you were planning to customize eOrder – you could only do cosmetic style changes only – if you wanted to alter scripts on the ASP pages – then you would have very serious eOrder upgrade issues. Upgrade simply wipes out your custom scripts and you had to reapply your customization to new version enriched ASP pages. Instead of following the way to move eOrder to ASPX or .Net platform – MBS introduced eConnect, enabling web designer to “connect” eCommerce site to Great Plains backend. This is very elegant module and solution, however we are hearing a lot of complaints from developers on eConnect restrictions.
• SOP Invoice posting. It is not enabled in eConnect. However you should probably first understand the architecture of Microsoft Great Plains. Order takers supposed to enter Sales Order and submit it (place in the batch and save) to the manager for approval (taking off transfer/print/post holds). eConnect enables you to create or update Great Plains objects, but it doesn’t allow you to process them (post) – this would open a gap in the security/approval cycle.
• Order Transfer. Again – this is similar problem to the invoice posting. Both Order and Invoice could be subject to holds and approvals. eCommerce logic might need partial or full order transfer to invoice or even backorder, based on the item availability status.
Why would you then need to purchase eConnect? Maybe just go ahead and program the connection in SQL stored procedures? The answer is – eConnect allows you to allocate items in Great Plains Inventory Control module. It would take you a lot of time (if you are new to Great Plains tables structure and never coded in Great Plains Dexterity). Plus eConnect allows you to create and update customer record in Great Plains – this is however relatively simple to imitate in the stored procedure.
Then what is the solution?
• Do not allow order transfer and posting through eCommerce. This is probably the best advise we could give you – just create orders, or invoices, leave them to the Great Plains user to approve and post. However in some cases it is absolutely critical and required
• Look for Invoice posting stored proc on the market. You are not the first and not the last one to face this dilemma – somebody already has it implemented (SOP10200, SOP10100, SOP30200, SOP30300 tables)
• Microsoft Small Business Financials or former Microsoft Small Business Manager. In your case – you need the whole set of stored procedures to enable eCommerce
Great Plains version: more likely you are using eConnect for Great Plains Standard or Great Plains Professional 7.5, 8.0 and in the future 8.5 or 9.0
Good luck in e-Commerce developing 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-866-528-0577! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

 Andrew Karasev

More Articles 

Ecommerce Keywords Used Buy Our Site For Nursery Sales - Bill Hirst
Did you ever wonder what keywords are used for a google site other than you own? Well here is my list for keywords on an add I ran for Arborvitae that we sell. aaborvitae ** 0.05 ** http://www.seedlingsrus.com/Arborvitae.html aarborvitae **...

A Successful eCommerce Website - Part 1 - Richard G Keir
So you want to succeed at eCommerce? Welcome to a very large group. First off, let’s be clear that there are a lot of ways to do business on the internet - and a lot of ways to both make and lose money. No way can I cover all of them in a few...

Ecommerce solutions for small business owners - Uthkusa Gamanayake
You are running a small business. Or You may have a web site but has not been generating a good income. Or You may have a web site, which is generating a good income, but you want to increase your income. Or You do not have a web site, but thinking...

Free Viral Marketing Campain that Will Help Increase eCommerce Conversion Rate Leads to Sales - Brian Hawkins
This article shows you how to use free viral markeitng campain tools that will help increase ecommerce conversion rate leads to sales. Learn five ways to improve online conversion rates and increase online sales today. Learn a tip to increase sales...

Oscommerce A Viable Ecommerce Solution ! - ravi chamria
Ecommerce has become the buzz of the day !! The Internet success stories revolving around Ecommerce, Online selling or shopping has been increasing day by day and the late thinkers are losing a huge market. The advent of online payment...

Network Monitoring for Serious eCommerce - David Leonhardt
In the real world, businesses come in every size, from self-employed entrepreneurs like me to mega malls like Wal-Mart. On the Internet, companies come in every size, too, from a stand-alone ebook sales page with webmaster and owner all in...

The Lowdown on ECommerce: Making All The Pieces Fit Together - Max Glantzman
The Lowdown on Ecommerce Ecommerce is truly the most confusing aspect of purchasing web design services. This is unfortunate since most (if not all) businesses online would like to provide their customers and potential customers with easy...

Blogs, Podcasting and RSS | eCommerce Impact - Craig Smith MBA
Blogs, Podcasting, and RSS Overview You probably have heard all these terms an awful lot lately. You wonder about what these technologies do? What value to they provide? If you aren't up to speed on these new applications and how they are...

Ecommerce 101 – Online Credit Card Processing - Nick Temple
Back in 1998 (through 2000 or so), I worked for a small company (called PaymentNet / then Signio) that handled online transactions. Verisign later purchased this company, and the product team I led integrated the "client" - the portion that took...

Ecommerce Store Owners : Want Visitors? Here’s How. . . - Robin Porter
Have you recently opened an online store, and waiting for those customers to drop by and start shopping? In cyberworld - unlike the real world - you just can’t pick a good location and rely on passing trade. You’ve got to work hard to get visitors...

Ecommerce: What Do Consumers Need? - Scott Lindsay
"My first rule of consumerism is never to buy anything you can't make your children carry." – Bill Bryson If you are involved in ecommerce it is important to accept the truth that we live in a consumer-driven society. What this means in practical...

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