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: http://www.albaspectrum.com
Let's say that you have a software project that's under... Read More
All of us know that Microsoft bought former Great Plains... Read More
Scrapbooks are very popular these days. I think that almost... Read More
We would like first emphasize the change in the paradigm.... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
The most important things you can do for your computer... Read More
First we had the original Google search that evolved into... Read More
There is many things more frustrating than surfing a website... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
And kill the best layout software in the process of... Read More
Are you lost in the mess of documents that get... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
Usually workflow & messaging is realized in CRM and then... Read More
I provide, here clear explanations and a count of function... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
I like my software simple. If it's too complex or... Read More
Best Software Act! is very popular CRM for small and... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
There are so many different programs that clutter up your... Read More
Once a business idea is selected, it is highly recommended... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
If you look back to the history, you will see... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
Program Flow is what you think it is. How the... Read More
Let us give you - developer some hints in the... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
We all already got used to computer monitoring both at... Read More
Since technology changes so quickly, it is hard to begin... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Spyware is software or hardware installed on a computer without... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Not every software testing project can or should be automated.... Read More
If you have been using the Internet for any amount... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Software |