Microsoft Business Solutions Great Plains has several options to enable web ordering. Traditionally Great Plains Dynamics/eEnterprise had eOrder ? this is ASP pages based ordering application, enabling you to place or retrieve your Sales Order Processing (SOP) Sales Orders over the web. There were several drawbacks however with eOrder. You should be the customer in Great Plains company database to be able placing the orders. Also if you were planning to customize eOrder ? you could only do cosmetic style changes only ? if you wanted to alter scripts on the ASP pages ? then you would have very serious eOrder upgrade issues. Upgrade simply wipes out your custom scripts and you had to reapply your customization to new version enriched ASP pages. Instead of following the way to move eOrder to ASPX or .Net platform ? MBS introduced eConnect, enabling web designer to "connect" eCommerce site to Great Plains backend. This is very elegant module and solution, however we are hearing a lot of complaints from developers on eConnect restrictions.
? SOP Invoice posting. It is not enabled in eConnect. However you should probably first understand the architecture of Microsoft Great Plains. Order takers supposed to enter Sales Order and submit it (place in the batch and save) to the manager for approval (taking off transfer/print/post holds). eConnect enables you to create or update Great Plains objects, but it doesn't allow you to process them (post) ? this would open a gap in the security/approval cycle.
? Order Transfer. Again ? this is similar problem to the invoice posting. Both Order and Invoice could be subject to holds and approvals. eCommerce logic might need partial or full order transfer to invoice or even backorder, based on the item availability status. Why would you then need to purchase eConnect? Maybe just go ahead and program the connection in SQL stored procedures? The answer is ? eConnect allows you to allocate items in Great Plains Inventory Control module. It would take you a lot of time (if you are new to Great Plains tables structure and never coded in Great Plains Dexterity). Plus eConnect allows you to create and update customer record in Great Plains ? this is however relatively simple to imitate in the stored procedure.
Then what is the solution?
? Do not allow order transfer and posting through eCommerce. This is probably the best advise we could give you ? just create orders, or invoices, leave them to the Great Plains user to approve and post. However in some cases it is absolutely critical and required
? Look for Invoice posting stored proc on the market. You are not the first and not the last one to face this dilemma ? somebody already has it implemented (SOP10200, SOP10100, SOP30200, SOP30300 tables)
? Microsoft Small Business Financials or former Microsoft Small Business Manager. In your case ? you need the whole set of stored procedures to enable eCommerce
Great Plains version: more likely you are using eConnect for Great Plains Standard or Great Plains Professional 7.5, 8.0 and in the future 8.5 or 9.0
Good luck in e-Commerce developing and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 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 clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com
![]() |
|
![]() |
|
![]() |
|
![]() |
Just imagine: you are walking, say, towards your car, and... Read More
It is possible that if one avoided all sources of... Read More
This short paper will expand on two key reasons to... Read More
Did you ever want to erase everything on your computer?... Read More
Mike Dunville* had a decision to make. As the new... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
Should one use Windows Update?This topic has good and valid... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
Microsoft Business Solutions Great Plains has I'd say end user... Read More
For a windows user like me, just can watch with... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
The java programming language is becoming more and more popular... Read More
Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
Are you a whiz at calculating financial information? Not the... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
Finding the best spyware removers to detect and remove spyware... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
In the early days of the personal computer, we're talking... Read More
Need software to record your voice, streaming audio or musical... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
When you think... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
C++ Function templates are those functions which can handle different... Read More
This is the tutorial where we really get into programming.... Read More
Think of this, first we had the HAM Radio, then... Read More
Homeland security, airport security, Internet security â?" these days weâ??re... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
The major reason I recommend getting your hands on real... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Are you a database professional? Do you work with a... Read More
It's not very often I get excited about a software... Read More
TikiWiki is open source software - it is written in... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Having from five to ten and more favorite screensavers is... Read More
Fundraising software lets you connect with donors in a way... Read More
Now is the time to look at an alternative to... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
Research bears that less than 70 percent of development projects... Read More
After almost two decades of existence, Quark has become the... Read More
First we had the original Google search that evolved into... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Viruses and spyware usually show up on your computer one... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
The stakes are high when considering security, privacy, and savings,... Read More
We were recently faced with a decision: either to let... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
It's all about turn times in the eMedia industry! The... Read More
Which Type of Shop Can Rely On A Home Built... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
Software |