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


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

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

Great Plains Dexterity Development: FAQ

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

Lotus Domino: Application Integration ? A Programmer View

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

The Dreaded Paper Label - Should it be Used?

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

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators

How to delete the user? This is the first problem... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

CRM and Customer Life Cycle

Customer Relationship Management or CRM is a combination of enterprise... Read More

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

Understanding XML Server

XML Server can be a Web Server that stores the... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

Pros and Cons of Using FREE Software in Your Business

Itâ??s easy to understand why you might be drawn to... Read More

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

IBM Lotus Domino or Microsoft Exchange?

IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More

Ukraine IT Myths Dispersed

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

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Linux Secrets

The first thing that you will notice about Linux Red... Read More

How to Build a Basic CSS Layout

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

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Microsoft Great Plains & CRM in Transportation & Logistics ? Overview

Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More

Quick Summary of Basic and Common Linux Commands

There are many commands that are used in linux on... Read More

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

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

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

Does your Company have Documentum?

Are you lost in the mess of documents that get... Read More

Microsoft Great Plains Integrations - Tips for Developer

In this short FAQ style article we would like to... Read More

How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software

Fortunately one of the most common reasons cited for the... Read More

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and... Read More