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 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, Germany, 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 developer
Your Article Search Directory : Find in Articles
Recent articles in this category:
- Web Development Projects - Developers Tools Tips
Open source usually refers to software that is released with source code under a license that ensur - A Guide to Cnc Kits
Building a CNC machine means that you would require a lot of tools, parts or different components. - Xlphoto Printing, the Best Choice for Banner Printing and Poster Printing
Suppose, you have visited a tourist spot or a hill station; over there, you have witnessed some of - Reliable Software Programming
Software reliability is an important facet of software quality. It is defined as "the probability - Designing an Ecommerce Site
In a recent article I talked about Google AdSense placement based on eye-tracking research. Howeve - Asp.net Development Benefits
Rightway solution has been keenly looking out for. Microsoft ASP.NET is a free technology that allo - Choosing Offshore Software Development Company
To turn into successful and gain the full benefits of software outsourcing, you require preferring - E-commerce and Web Portal Development in Vietnam
VIETNAM, owing to its superior intellectual capital has emerged as the ultimate destination for - Types of Softwares
Computer software is a general term used to describe a collection of computer programs, procedur - Offshore it Out Sourcing Consultancy in Vietnam
Vendors who provide Off shore IT Outsourcing Consultancy services are referred to as outsourcing
Most viewed articles in this category:
- Oracle Applications (Oracle E-Business Suite) Customizations: What is it?
Oracle recommends every company that installs Oracle Applications to avoid any customization, but I - Offshore Outsourcing: An All Win Premise
The awareness that outsourcing can boost productivity sans forfeit of class has impelled MNC’s - Oracle E-Business Suite vs. Microsoft Dynamics AX - Axapta: LATAM and Brazil
In this small article we will only concentrate on Microsoft Dynamics Axapta (and will not consider M - SAP Business One vs. Microsoft Dynamics GP - highlights for consultant
In this small article we will not make side-by-side technical specs comparison. We would rathe - Microsoft Great Plains - licensing and product versions
Current Microsoft Business Solutions Great Plains has more that 10 years of history. Former Gr - OCR Software - Optical Character Recognition or Optical Crud Recognition?
Optical Character Recognition (OCR) refers to a software technology and processes that involve the t - Microsoft Dynamics AX - Axapta - technical notes plus customization
Axapta or current name Microsoft Dynamics AX has one of the newest ERP design and architecture among - Microsoft Dynamics AX-GP-NAV-CRM: trends and international recommendations
Microsoft Great Plains/Microsoft Dynamics GP, Microsoft Navision (former Attain) Microsoft Dynamics - Microsoft Moves to Small Business Accounting/Retail Market - stakes and thoughts
In this small article we will be looking at the new opportunities for Microsoft Small Business Serve - Microsoft Axapta - Dynamics AX: Brazilian Portuguese version - consultant highlights
Axapta/Microsoft Dynamics AX short overview. Navision Axapta was designed by Navision Software