Since Version 8.0 Microsoft Business Solutions Great Plains & Great Plains Standard are available on Microsoft SQL Server and MSDE (which is in fact MS SQL with database size limit of 2GB). As eCommerce designer you should be aware of several options and customization tools in your disposition, when you utilize Microsoft Great Plains 8.5 (June 2005), 8.0, 7.5, Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Great Plains Dynamics C/S+. When you have old versions (7.5 and prior) we assume that you are on MS SQL Server 2000/7.0, because if you are on Ctree or Pervasive SQL/Btrieve ? you should use ODBC / RDO connection tools, such as MS Access and its queries or use MS SQL Server Linked Server technique with OPENROWSET statements. So, lets assume that you are on MS SQL Server. You have basically two options eConnect (you should pay for the reg key/license and this is SDK) and custom stored procedures. We'll only consider custom stored procedures way here:
1. Stored Procs. The first question is ? are we allowed to create stored proc in Great Plains DYNAMICS and companies databases. The answer is Yes ? opposite to such products as Microsoft CRM (where you are banned to create any custom object in MS CRM database, and instead you create your own custom database and place all your procedures and views there) ? you are encouraged to create your stored procedures and place them in both DYNAMICS and Company databases. You need to know the anatomy of Great Plains tables structure.
2. Tables Structure. If you launch Great Plains workstation and follow this way: Tools->Resource Descriptions->Tables ? then you are in tables descriptor, sorting by tables Physical, Logical or Tables Group Technical names. This is all Great Plains Dexterity architecture realm and it is relatively complex and not "developer-friendly" ? but if you create sample transactions in Great Plains ? you can figure out where data should be populated.
3. Sales Order Processing. Or SOP module. This is usually the core of eCommerce development ? transactions should go into SOP tables (with SOP prefix): SOP10100, SOP10200 and others. If you are selling to your existing customers, then customers are in Receivables Management module (AR) with AR prefixes: RM00101 ? is Customer Master, RM00102 ? customer address master, etc.
4. Sales Order/Invoice Allocation dilemma. Great Plains SOP module is working in concert with Inventory control, making allocation of inventoried items in IV. So, this is very challenging to replicate allocation logic. We recommend do not allocate in Orders and Invoices and do allocation by operator, who processes the internet orders batch.
5. Sales Order transfer dilemma. If you are using eConnect ? this is kind of issue, so you have to appeal to GP internal architecture and do it with the stored procs approach.
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 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com
Andrew is Great Plains specialist in Alba Spectrum Technologies (http://www.albaspectrum.com) ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, New Orleans, Toronto, Montreal and having locations in multiple states and internationally
![]() |
|
![]() |
|
![]() |
|
![]() |
When you buy a computer, it most likely comes with... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
Not all of us have the luxury of working both... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
If you have Microsoft Great Plains and support it... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Microsoft CRM is now on the scene and it is... Read More
The software giants don't do everything and don't always produce... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
First we had the original Google search that evolved into... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
Looking at all the ads which promise to get rid... Read More
Are you lost in the mess of documents that get... Read More
When Windows fails to boot it is normally caused by... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
The stakes are high when considering security, privacy, and savings,... Read More
While I was in college, if you would have asked... Read More
Microsoft Outlook is one of the most widely used software... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
Some companies that are in need of fleet management may... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
If you have been running Windows XP for a couple... Read More
All your software is stored on a hard-drive. But how... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
ERP Consulting industry is on the way to serve clients... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
Anti-virus software is used to find, remove or fix files... Read More
The first thing that you will notice about Linux Red... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
This article is the fourth of a series of articles... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
Just imagine: you are walking, say, towards your car, and... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Some companies that are in need of fleet management may... Read More
The fact that a software tester is a most infamous... Read More
In the previous ISDN article, we looked at how and... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
In this small article we will show you the possible... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
It is really interesting that a bug can create problem... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
The adware and spyware definitions list is very long. But... Read More
Microsoft Outlook is one of the most widely used software... Read More
One day, you suddenly realize that your computer started to... Read More
... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
You've finally created databases that you can actually use to... Read More
Software |