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
Mercedes Benz s500 rentals Salem ..GroupwareThe internet is full of 1.5 million to 7 million... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
The major reason I recommend getting your hands on real... Read More
Following tips help you to learn a software in lesser... Read More
XML parser is a software module to read documents and... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
In this short FAQ style article we would like to... Read More
Microsoft Word is one of the most popular office applications... Read More
Are you a database professional? Do you work with a... Read More
Finally, you have some time to personalize your desktop with... Read More
The purpose of one of our projects was MS Exchange... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
When you need a phone number, you do a quick... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
I suggest that you do not spend a lot of... Read More
When it comes to screenplay software each screenwriter needs to... Read More
You've finally created databases that you can actually use to... Read More
Using professional icons in your application or website can bring... Read More
Need help making sense of algebra? Have algebra lectures in... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
Think of this, first we had the HAM Radio, then... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Dowagiac cheap limo service ..Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
The world of small business accounting software can be a... Read More
Every day millions of new web documents emerge on the... Read More
I provide, here clear explanations and a count of function... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
2005 ? Back to the Future.What does the future hold?... Read More
The first topic we are going to discuss... Read More
At the end of XX century, in the late 1990th... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
In today's business world it's all but impossible to escape... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
To all web designers out there, this article is for... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
Software |