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 Mac and PC ? Mac OS and Microsoft Windows respectively. Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure:
? Naming Convention. Great Plains was designed to be ready to move to the winning database platform and probably this is why we see this a bit complicated naming convention in place: SOP10100, RM00101, IV00101 ? these are samples: SOP header, Customer master, Inventory master. First ? we see module prefix: SOP ? Sales Order Processing, RM ? Receivables management, IV ? Inventory control, etc., then 0 stays for the master files, 1 ? so-called work files (before transaction being posted), 2 ? open files (after transaction is posted) and 3 ? historical files (when you close the year in General Ledger ? transactions are moved from open to history files). So as you see ? logic is present and structured, but it is not friendly to the developer, who never seen and worked with Great Plains Dynamics.
? Tables Groups. Great plains was designed to first serve mid-size businesses and then with the availability of third party modules ? the intention was to compete on corporate ERP market with Oracle, PeopleSoft, SAP and others big players. This is why we see the whole cluster of tables to store, say Sales Invoice: SOP Header, SOP Lines, SOP Distribution, RM Key file, etc.
From the Forms side (or screens) you can see more human-readable names: SOP Entry, RM_Customer_Maintenance, POP_Entry or the like. But these legacy Great Plains Dexterity names do not help eCommerce developer ? only probably as the reference on which table works with specific screen.
Let's take a look at the tools available:
? eCommerce ? together with eOrder, and other eXXX products it should be considered as legacy and phase out product, based on Microsoft eCommerce server and ASP technology, today Microsoft has new paradigm - .Net and ASPX World
? eConnect ? was specially created for eCommerce developers, who integrate Microsoft Great Plains with eCommerce web interface. This tool covers a lot of Great Plains objects creation and retrieving functionality, however it does have restrictions, because it was not intended as replacement to Great Plains Dexterity shell. For example ? if you create Orders in SOP via Web interface/eConnect ? it is difficult manipulate these orders (transfers to Invoices, backorders, reallocations, etc.). Another issue with eConnect ? developers are kind of used to the fact that Microsoft provides free SDK to its products, Microsoft CRM for example has freely downloadable Microsoft CRM SDK. For eConnect you have to pay license and be on Microsoft Business Solutions annual support to get version upgrades. Also if you are ISV and develop your GP integration to your customers ? you have licensing issue with Microsoft.
? Custom SOP/AR stored procedures. Microsoft Business Solutions partners in their practice usually have several Great Plains integration projects implemented where integration is realized on the stored procedures level and transactions are created and manipulated in Great Plains SOP. So ? you may end up seeking this type of help
Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com
Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in San Francisco, San Diego, Chicago, New York, Atlanta, Houston, Dallas, Miami, Orlando, New Orleans, Phoenix, Seattle, Minneapolis, Detroit, Los Angeles
Bradley bmw rental chicago .. Lockport Chicago limo O’HareMicrosoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
If there still are few unprotected computers left, I haven't... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
Enabling Chinese input is quick and easy, there are only... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
This article illustrates the best practices to improve the performance... Read More
OEComplete is a utility for managing the personal information of... Read More
We were recently faced with a decision: either to let... Read More
I have recently created my first Php program. I wanted... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
During the years of our consulting practice, which comes back... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
In this short FAQ style article we would like to... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Icons are used everywhere; right from software applications, to internet... Read More
prom limo McHenry ..It is now common thing when large corporation selects mid-market... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
As we could imagine, if you are reading this article... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
Think of this, first we had the HAM Radio, then... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Each Industry and market niche has business specific and unique... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
When it comes to screenplay software each screenwriter needs to... Read More
Fundraising software lets you connect with donors in a way... Read More
With any good luck and a good amount of hard... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
The adware and spyware definitions list is very long. But... Read More
Need software to record your voice, streaming audio or musical... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
We would like to give you several situations, when you... Read More
First we had the original Google search that evolved into... Read More
When Great Plains Software was designing and developing Great Plains... Read More
Three highly respected names in Human Resources have joined forces... Read More
It's not very often I get excited about a software... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
Software |