Microsoft Dynamics GP 9.0: Ecommerce Web Development – Overview For Programmer

 Microsoft “Project Green” phase one is reflected in Microsoft Great Plains/Dynamics GP 9.0 realization. It is exposed to .Net developer currently through eConnect and as time goes – more and more eConnect object will have XML web service interfaces. In this small article we will be touching the set of object, deployed in eCommerce application, using Microsoft Dynamics GP as a backend.

• Sales Order Processing (SOP). In the light eCommerce case – you push data into SOP10100 – SOP
Header table and SOP10200 – SOP Line table. If you do create Sales Orders Only, do not accept deposits against sales order – then you do not care about SOP Distribution table: SOP10102. All these tasks could be realized through eConnect.

• Inventory Tables. If you sell from your inventory (not just services), then you use Inventory module tables: IV00101 – Item master, IV00102 – Item QTY master, the last one shows you quantity at the specific location and in general

• Receivable Management Tables. RM00101 – Customer master – in case if you create and register new customer or update existing customer info in Great Plains.

• eConnect extensions. Obviously eConnect will be repeating the logic of former Great Plains Dexterity objects. In Great Plains you typically create work documents: Quotes, Orders, Invoices and then you post them individually or in the batch – posting process is functionally assigned to the operator, this is why you will have hard time to program it via eConnect (which allows you to create work documents). You will need eConnect extensions or simply stored procedures, which post work records in Sales Order Processing and potentially Receivable Management modules – it is not recommended to create ones from scratch – posting and order transferring logic is very complicated.

• Stored Procedures approach. We see more and more cases when eCommerce is built around Microsoft Small Business Financials, former Microsoft Small Business Manager – in such a situation eConnect might be too expensive and too complex – you may need just several SOP oriented stored procedures to create SOP orders and invoices at the back end in SOP SQL tables. The advice to the developer in the case of Small Business Financials – ask SBF user to create sample transaction – Sales Order and watch how did it distribute across SOP tables – you will get the idea and replication pattern for your SQL coding

• Development Tools. Microsoft Visual Studio.Net is becoming the tool of choice (over now legacy Microsoft Dexterity or Great Plains Software Dexterity). However if you are eCommerce developer – you will have to use SQL scripting. Usually the first question is – where do I get Great Plains table structure description: Tools->Resource Description->Tables. Sometimes developers ask about Great Plains Integration Manager. This tool is in process of being rewritten with eConnect panidea. Integration Manager up to version 8.0 was relatively slow in its technical ability to integrate bulk number of records – it used legacy OLE Server technology – Great Plains was OLE Server and IM used GP screens to validate integration records. New integration manager should be more powerful and it is in the process of the creation as we write these lines.

• Microsoft Dynamics CRM web front. In some cases we see this scenario. Microsoft Great Plains – MS CRM integration is in process of being rewritten on eConnect – currently it uses BizTalk server (and does a nice job, however sometimes you have to programmatically tune the BizTalk integration). In CRM you can create Account or Contact that will be integrated to Great Plains Customer, then Order when submitted can be integrated to Great Plains if needed. Sometimes developers complain, that they have to force credit limit for the CRM Account to be non-zero – in order for the invoice to come through.

 Andrew Karasev

More Articles 

Create Your Own Web Site for Information Purposes or Ecommerce - Jay Peterson
Creating your own web site can be extremely quick, easy, and affordable. Today you can find plenty of tools that can help you create the perfect web site whether it is for pleasure or for commerce. If you are interested in creating your own web...

eCommerce, Communications and the Global Internet Community. - Michael Bloch
In our increasingly online world, cyberspace is still experiencing "gold fever", but there have been and will be many casualties. Only the innovative, responsive, financially sound and flexible will survive. Many new markets are joining the world...

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 Merchant Account - Jack Chevalier
From: hotlib.com Every small business owners and home based entrepreneurs consider the advantages of an ecommerce Internet merchant account. Those who accept merely cash or check payments may decide to increase the ways in which a customer...

eCommerce - A Plan - Richard D S Hill
Planning an ecommerce website is like building a house - architecture and budget need to be agreed before the decoration. AN AGREED REQUIREMENTS SPECIFICATION MUST BE DRAWN UP AS THE FIRST STAGE BEFORE ANYTHING ELSE IS DONE - ANY OTHER...

Ecommerce for small business and sole traders - is it fairtrade - Rod Gardner CEO White Star Communications
Ecommerce for small business and sole traders - solid internet marketing solutions for small businesses! "My website development is costing me an arm and a leg, being only a small business I cant afford it! how can I make better profits...

Simple Ways To Increase Your Ecommerce Website Sales - Robert Michael
One of the best business marketing opportunities ever available, the internet is the gateway to a strong financial future. With the ecommerce website leading the way in the web of cash ventures, it is no surprise that many individuals have become...

For Your ECommerce Success - Michel Richer
Have you always dream of owning your own Business and working in the comfort of your own home ? As human we all want to succeed. We all want the best from life. We all want to be wealthy, to have a great house, to travel around the globe. A great...

The No. 1 Ecommerce Solution Tip For You - Robert Roy
The number one ecommerce solution you need to be a success on the Web is learning to write for the internet. You will be able to capture your visitors attention and hold it, otherwise it's click and off to another site. You need to be able to put...

Microsoft Ecommerce Web-development: Great Plains Econnect .net Approach – Highlights For Programmer - Andrew Karasev
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...

Reverse Logistics and eCommerce - Craig Smith MBA Founder Managing Director Trinity Insight LLC
It’s no secret that a positive experience delivered to a customer determines whether that customer will come back.  Retailers must enhance the user experience prior to pressing the “buy” button but also focus on the post-purchase site...

What's Toll Free Numbers Got To Do With Ecommerce? - Jacob Richards
What's Toll Free Numbers Got To Do With Ecommerce? Sometimes skimping on things can save you good money. But skimping is not always the wisest business strategy. For example, I could've written this article in the windows program notepad as...