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

---

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

Vlans

In order to implement VLANs in a network environment, you'll... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

The first topic we are going to discuss... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

What Stands Behind The Software Description?

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

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

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

Lotus Notes Domino and Web: Application Development ? Tips for Programmers

Beginning with Domino version R4 it has integration with the... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

The Dreaded Paper Label - Should it be Used?

While paper labeling CDs and DVDs may appear to be... Read More

Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the... Read More

Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

Great Plains Fixed Assets Management module is a robust tool... Read More

Who?s Watching What You Type?

If someone entered your home, uninvited and installed numerous cameras... Read More

Ukraine IT Myths Dispersed

While Ukraine is becoming a new popular IT outsourcing destination,... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now

Is Photoshop CS2 worth the upgrade? You bet it is!... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More

netstat - Linux Command to Display Networking Information

In linux, one of great commands for finding out information... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

Change Your Word Docs in Record Time!

Anyone who has ever used Microsoft Word knows that it... Read More

New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink

Three highly respected names in Human Resources have joined forces... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM

Midsize business or non-profit organization should decide if one-vendor solution... Read More

Software Upgrades Arent Always the Best Move

When my daughter was getting into AOL instant messaging (AIM)... Read More

Troubleshoot Windows with Task Manager

Task Manager is a Windows system utility that displays thetasks... Read More

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant

Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More