Microsoft eCommerce Web-development: Great Plains eConnect .Net ? 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 is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK

In The News:


pen paper and inkwell


cat break through


How to Get The Best Accounting Software For Your Small Business

Buying accounting software is a major investment. It's an important... Read More

Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

This is intermediate level SQL scripting article for DB Administrator,... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

Hubris - Definition: Microsofts Passport

Before September of 1995, Microsoft ignored the Internet because their... Read More

Great Plains Dexterity Customization Options ? Overview For Developers

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Linux Vs. Windows

This article will not attempt to advocate the use of... Read More

Spyware Protection: A Must for Any Home Computer

Now that spyware is the single most dangerous threat to... Read More

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Microsoft Great Plains Integration Manager ? Working With Text File

Microsoft Business Solutions main middle market ERP application - Microsoft... Read More

Microsoft CRM for Large Corporation ? Security

Microsoft Business Solutions CRM proved to be reliable solution in... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview

In the case when you represent mid-size or mid-size-to-large business,... Read More

Start Developing Your Own Software

Learning how to program software seems like a daunting task... Read More

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Make or Break Factors - When Considering Estimating Software

Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

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

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

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup ? overview

Microsoft Great Plains may be recommended for international freight forwarding... Read More

.Net Charts and Graphs Interact with Businesses and Customers

Bar charts, bar graphs, and any other chart or graph... Read More

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

Destination: Desktop for Google

First we had the original Google search that evolved into... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Microsoft and Webmasters

Does Microsoft care for WebmastersIt's always been a problem with... Read More

What is Fleet Maintenance Software?

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

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

Linux vs Windows Operating Systems

With so many Microsoft Windows related viruses, errors, and other... Read More

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

SyncUp ? A File/Folder Synchronizer For Windows

SyncUp, a file synchronizer is designed to assist the home... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More