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! [email protected]

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:

50 Tips on Telematics and Software  Rental Equipment Register
Technology For Workspace Planning  Facility Executive Magazine

Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

Microsoft bought Navision, Denmark based software development company, along with... Read More

Hear It in Digits

Music downloads are off the charts! We're listening to digital... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

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

OSI Layers Model

IntroductionDuring the early years of our modern computer era, very... Read More

Business Planning Software

Once a business idea is selected, it is highly recommended... Read More

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

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

An Easy Way to Develop JAVA Enterprise Applications

Research bears that less than 70 percent of development projects... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

Anti-Virus Software

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

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

Increase Office Efficiency With One Simple Tool

When you need a phone number, you do a quick... Read More

Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC)

It is possible that if one avoided all sources of... Read More

Five Steps to Rapid Development with TierDeveloper 4.0

Follow the steps below to quickly design, generate, and deploy... Read More

Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

Microsoft Business Solutions is now in process of creating so... Read More

Screenshots Vista Windows

Features Additionally, Vista will include many other new features.Aero Vista... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics ? highlights

Microsoft bought Navision, Denmark based software development company, along with... Read More

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Microsoft Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0

Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More