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
![]() |
|
![]() |
|
![]() |
|
![]() |
Microsoft Great Plains is now targeting large and midsize businesses... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
The vast majority of us will have, at some point,... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
I provide, here clear explanations and a count of function... Read More
Find out why Spyware Removal from computers is important and... Read More
There are several kinds of software piracy. The bottom line... Read More
Some companies that are in need of fleet management may... Read More
Did you ever give a thought to the number of... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
Microsoft CRM is now on the scene and it is... Read More
Now is the time to look at an alternative to... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
In the Clinton era the status quo was simple: you... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
So let's begin crunching down these 300 images using Adobe... Read More
Introduction: The creating of a computer program involves a number... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
Sales are all about leverage, because there is only so... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
Anti-virus software is used to find, remove or fix files... Read More
Most people understand that the "hardware" part of their computer... Read More
If you are in the market for new staffing software,... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Ok... Where to start?Well, I guess I will start at... Read More
TikiWiki is open source software - it is written in... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
Bill of Lading is required report for Logistics and Freight... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
Fleet Maintenance Management is a critical position in any company... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
It is possible that if one avoided all sources of... Read More
Research bears that less than 70 percent of development projects... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Microsoft Word is one of the most popular office applications... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
The Internet is reshaping every form of communications medium, and... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
The major reason I recommend getting your hands on real... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
How many steps does it take you to locate and... Read More
A wiki is an editable text-based website. But you don't... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
Software |