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
Internet worms. Is your PC infected?If your computer has become... Read More
Is your PC is slow and wimpy? Then you need... 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
Midsize business or non-profit organization should decide if one-vendor solution... Read More
Having from five to ten and more favorite screensavers is... Read More
A wiki is an editable text-based website. But you don't... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
If your company has regional and worldwide operations, you might... Read More
The most important things you can do for your computer... Read More
The adware and spyware definitions list is very long. But... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
We would like first emphasize the change in the paradigm.... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
In order to implement VLANs in a network environment, you'll... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Are you a database professional? Do you work with a... Read More
Mike Dunville* had a decision to make. As the new... Read More
At the end of XX century, in the late 1990th... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
It is now common thing when large corporation selects mid-market... Read More
Music downloads are off the charts! We're listening to digital... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
With thousands of web pages added to the Net every... Read More
If you are to buy a HelpDesk & Asset Management... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Imagine something that follows you home and sets itself up... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
We were recently faced with a decision: either to let... Read More
There are several kinds of software piracy. The bottom line... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Since technology changes so quickly, it is hard to begin... Read More
Before being able to choose a secure Internet communication system,... Read More
During the years of our consulting practice, which comes back... Read More
Homeland security, airport security, Internet security â?" these days weâ??re... Read More
Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Java has come along a long way. Many would agree... Read More
Anti-virus software is used to find, remove or fix files... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
When reading an article where some term is used often,... Read More
The first thing that you will notice about Linux Red... Read More
Our hosted solution allow you to run your own search... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
Microsoft Business Solutions Great Plains has I'd say end user... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Whether you have used Microsoft Word for years, have just... Read More
The stakes are high when considering security, privacy, and savings,... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
It is really interesting that a bug can create problem... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Well, even if the combination might look very unusual, we... Read More
This short paper will expand on two key reasons to... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Using professional icons in your application or website can bring... Read More
Software |