Search
Recommended Products
Related Links


 

 

Informative Articles

eCommerce development for Microsoft Great Plains: tools and highlights for programmer
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise was designed in earlier 1990th as ERP, which can be easily transferable to the winning Database and OS platform and it was originally available on...

eCommerce, How much does it cost?
Making profits with your existing website design or creating a new online store can be exciting, affordable and most of all; rewarding. Mmmm . . . that's what the last sales guy told me. What is eCommerce (or selling via the Internet)? It is...

Getting Started in ECommerce - Part One
In 2004, Enquiro.com conducted a study of the search behaviors of men vs. women. They found that women spend more time in their searches and at specific sites. The study also revealed that women tend to be more deliberate in reading search results,...

My Top 7 Favorite Ecommerce Tools
Copyright 2005 Jim Edwards When you make your living on the Internet, you sometimes forget that the resources you use every day (and take for granted) might rate an incredible discovery to anyone who doesn't already know they exist. Whether...

The Ecommerce Business Plan
Simply put, business plans can make or break your business. Starting a Drop Ship business online is no different from starting a traditional non-online business. With the strong emphasis individuals place on writing business plans for starting up...

 
from our sponsors
Internet Home Business Training Course
Your privacy is safe.


Mike%20SaundersQuantcast
eConnect: eCommerce development for Microsoft Great Plains

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




Didn't Find What You Were Looking For?
Try a Specialized Search HERE




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