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
Culver prom limo ..Let's first look at your ERP system selection (without Retail... Read More
A few months back I really got sick of my... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
TikiWiki is open source software - it is written in... Read More
During the years of our consulting practice, which comes back... Read More
With any good luck and a good amount of hard... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
The Windows registry is a huge database that ensures normal... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
The software giants don't do everything and don't always produce... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Are you one of those people that keeps track of... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Three highly respected names in Human Resources have joined forces... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
Do you want to get quality software at a reasonable... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
User interfaces and accessibility are some of the most important... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
The research in the field of Natural Language Processing usually... Read More
Wood Dale limo ..Many Webmasters have never bothered to view their website's server... Read More
It won't matter how effective your WinRunner Team is if... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Spyware is software or hardware installed on a computer without... Read More
... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
Are you one of those people that keeps track of... Read More
New post-recession era has new features, which didn't exist in... Read More
Let's say that you have a software project that's under... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
Sales are all about leverage, because there is only so... Read More
We would like to give you pluses and minuses of... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
RSS (Really Simple Syndication) is a way for a site... 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
Do you remember that frustrating feeling when you find an... Read More
Software |