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
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
And kill the best layout software in the process of... Read More
It won't matter how effective your WinRunner Team is if... Read More
To all web designers out there, this article is for... Read More
We don't think about mainframe software pricing anymore, we just... Read More
How many steps does it take you to locate and... Read More
The software giants don't do everything and don't always produce... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
When it comes to screenplay software each screenwriter needs to... Read More
For a windows user like me, just can watch with... Read More
A wiki is an editable text-based website. But you don't... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
All your software is stored on a hard-drive. But how... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Just when you thought you were Web savvy, one more... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Spyware is like the new technological nuclear weapon on the... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
When Windows fails to boot it is normally caused by... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
The most important things you can do for your computer... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
It is really interesting that a bug can create problem... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
While I was preparing some personal background information for a... Read More
Linux essentials:It's free for download but you have to pay... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
The most important benefit of XML is its simplicity. Though... Read More
The objective for Zandi Digital is to make available clever... Read More
Mike Dunville* had a decision to make. As the new... Read More
There are several kinds of software piracy. The bottom line... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
In linux, one of great commands for finding out information... Read More
There are plenty of articles out there about how to... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
The title of "software engineer" has got to be among... Read More
And kill the best layout software in the process of... Read More
The US House of Representatives has recently passed the "Spy... Read More
This article illustrates the best practices to improve the performance... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
This article is the third of a series of articles... Read More
Imagine something that follows you home and sets itself up... Read More
The term "document management" and "paperless office" is the subject... Read More
I like my software simple. If it's too complex or... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
It won't matter how effective your WinRunner Team is if... Read More
Three highly respected names in Human Resources have joined forces... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
I love new technology. I am still ready to wait... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
The Windows Indexing Service provides you with the ability to... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Software |