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
shuttle from O'Hare Bingham .. Lockport Chicago limo O’HareSo, why should you use any O/R mapping tool? I... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
We don't think about mainframe software pricing anymore, we just... Read More
The first thing that you will notice about Linux Red... Read More
It is a well known fact that Java as a... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Usually workflow & messaging is realized in CRM and then... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Just when you thought you were Web savvy, one more... Read More
The vast majority of us will have, at some point,... Read More
With many manufacturing shops heading over seas in favor of... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
Considering whether or not your software company should hire a... Read More
The purpose of one of our projects was MS Exchange... Read More
When Windows fails to boot it is normally caused by... Read More
Not every software testing project can or should be automated.... Read More
Icons are used everywhere; right from software applications, to internet... Read More
While I was in college, if you would have asked... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Mishawaka limo O'Hare ..One day, you suddenly realize that your computer started to... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
XML parser is a software module to read documents and... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
Enabling Chinese input is quick and easy, there are only... Read More
When you need a phone number, you do a quick... Read More
In linux, one of great commands for finding out information... Read More
Microsoft Business Solutions Great Plains has I'd say end user... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
Intro This concise article will tell you in plain English... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Stealing company information used to be the specialty of spies... Read More
If you have been running Windows XP for a couple... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
The Windows registry is a huge database that ensures normal... Read More
Some companies that are in need of fleet management may... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Beginning with Domino version R4 it has integration with the... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
NOTE: Please take time to read on - it may... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
With any good luck and a good amount of hard... Read More
Software |