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
![]() |
|
![]() |
|
![]() |
|
![]() |
The term "document management" and "paperless office" is the subject... Read More
Now is the time to look at an alternative to... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Let's first look at your ERP system selection (without Retail... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
The Windows Indexing Service provides you with the ability to... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
Considering whether or not your software company should hire a... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
Microsoft Word is one of the most popular office applications... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
I have always regretted how Microsoft price gouges and rips... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Many Webmasters have never bothered to view their website's server... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
Finding the best spyware removers to detect and remove spyware... Read More
Not all of us have the luxury of working both... Read More
There are many commands that are used in linux on... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
When reading an article where some term is used often,... Read More
We all already got used to computer monitoring both at... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
In the Clinton era the status quo was simple: you... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Imagine something that follows you home and sets itself up... Read More
How do you run a program on a remote server... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
New post-recession era has new features, which didn't exist in... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
If you are in the market for new staffing software,... Read More
Bill of Lading is required report for Logistics and Freight... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Now there are Three Steps To Heaven Just listen and... Read More
As seeing large number of implementations ? in our case... Read More
Microsoft Retail Management System serves retail single store as well... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
We'll give you non formal view, based on our consulting... Read More
What is installation in the language of technology? Installation... Read More
Handling character strings in Java is supported through two final... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Fleet Maintenance Management is a critical position in any company... Read More
There are several kinds of software piracy. The bottom line... Read More
It is now common thing when large corporation selects mid-market... Read More
Many Webmasters have never bothered to view their website's server... Read More
Words we choose to describe things and phenomena often show... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
In this small article we will be looking at the... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
I completed an experiment recently. I wanted to find out... Read More
The title of "software engineer" has got to be among... Read More
Crystal Reports is the most flexible tool on the market... Read More
The fact that a software tester is a most infamous... Read More
While Adobe is the most known maker of PDF tools,... Read More
Microsoft Business Solutions Great Plains has I'd say end user... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
Domino server is a buffer between the operation system and... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
During the years of our consulting practice, which comes back... Read More
Software |