Microsoft Ecommerce Web-development: Great Plains Econnect .net Approach – Highlights For Programmer

 In our small article we’ll consider Microsoft Business Solutions Great Plains Sales Order Processing module as eCommerce backend. Plus we’ll cover what is possible and impossible in eConnect and why.
Microsoft Great Plains is one of the most popular ERP in the US, Canada, Australia, New Zealand, Middle East, Latin America, UK and South Africa. Due to the MBS strategy – Great Plains Dynamics was pulled from other markets, such as continental Europe (Germany, France, Russia) – where Navision and Axapta are the promoted and recommended solutions. If you have Navision or Axapta – please read our publications on these products on Alba Spectrum Technologies publication site.

• Great Plains Platform – Great Plains Software Dynamics is written on GPS proprietary platform in Dexterity program language. Dexterity is based on very shrewd application development philosophy – ERP application will stay decades if it is independent from the graphical computer environment and database platform. Back in 1992 C programming language was believed to be the rescuer and be cross-platform.

• Great Plains Architecture. Here we need to give you highlights on Great Plains Dynamics initial design. General Ledger (GL) was intended as core module, then you see modules, posting directly to GL: Receivables Management (RM), Payables Management (PM), Payroll, Inventory Control. The next level – modules, posting to GL through other modules: Sales Order Processing (through Accounts Receivable), Purchase Order Processing (through Accounts Payables), etc. The second principle – Great Plains would never allow you to post the batch of transactions behind the scene – only via the user interface – checked and approved by the user.

• eOrder – this IIS ASP application was initially available for all the platforms: MS SQL Server, Ctree and Btrieve (later on Pervasive SQL 2000), in 1998 Great Plains Software made it available for MS SQL server only. eOrder was predecessor of modern eCommerce sites and all the attempts to customize eOrder were dubious in the version upgrade.

• .Net paradigm. Instead of inventing and making you use standard eCommerce solution - .Net gives you the choice to select from variety of products available on the market. This means that no more eOrders – you just need the connector which will allow you to address Great Plains objects from your eCommerce application. As usual you are free to use your language of choice: VB or C#

• eConnect. Yes – exactly – it was initially developed for eCommerce programmers. Later on eConnect was extended on the majority of Great Plains modules, including distributions

• Restrictions. As you see above – Great Plains allows you to address work tables only – this means that you can not post transactions using eConnect. Other reported issues were related to Sales Order transfer to Invoice/Backorder

• Custom Stored Procedures. Right – you have to use these custom SQL scripts to post transactions, created with eConnect.

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 Karasev

More Articles 

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 Website Owners: Are You Leaving Money On The Counter? - Robin Porter
Own an ecommerce website? Do you have a mailing list? If not, you’re potentially leaving a lot of money on the counter. Keeping in touch with your past customers and visitors, is one of the easiest and cost effective methods of increasing your...

Ecommerce: Shopping For A Shopping Solution - Scott Lindsay
The specifics of ecommerce can require a learning curve that many are reluctant to tackle. Perhaps that's why many brick and mortar stores have not entered the world of online marketing. It is possible to look at ecommerce and consider the things...

eCommerce Solutions - Paul Sanford
Copyright 2005 Paul Sanford All of the long, grueling nights and an unknown number of working weekends spent converting your dream into reality finally paid off—in a big way! Affiliates are signing up every single day and the clicks have really...

Search Engine Optimization in an eCommerce World - Mike Barton
Before one can fully understand the importance and necessity of implementing a search engine optimization program into their marketing mix, it is important to look first at the phenomenal statistics regarding Internet use. For example: There...

Small Business Ecommerce Web Design - Joel Walsh
If your small business is venturing into ecommerce, you may be daunted by the technical wizardry you think is involved. But fear not: complete web store software packages will keep all the technical wizardry safely behind the screen, so you don't...

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

Hosting Options for an Ecommerce Web Site - Bobette Kyle
Deciding how to host your ecommerce Web site and what approach to take can be daunting. There are several approaches available, each with different advantages and disadvantages. Storefronts If you have a small business, you may want to...

Ecommerce Hosting Considerations - Eric Lester
Website hosting can be a complex undertaking. Determining how much space you need, how much transfer, finding a reliable host, and getting everything online is no simple task. Add ecommerce to the mix and things become even more complex. This...

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

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

eCommerce Website Design - Warren Baker
eCommerce websites have their own unique character that is designed to lead the visitor to one simple task - make an online purchase. A web designer needs to consider a variety of online selling principles while designing an eCommerce website....