Microsoft Great Plains Ecommerce ? Stored Procedures Approach
|
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
|
|
|
Manufacturing Solutions For Microsoft Great Plains ? Overview For Consultant
Microsoft Business Solutions Great Plains has full-featured manufacturing set of modules. In this small article we would like to give you highlights on what kinds of light customization you could deploy, before jumping into Microsoft Great Plains Manufacturing realm. Great Plains Manufacturing is targete...(related: Software)
Lotus Domino: Application Integration ? A Programmer View
There are two approaches for application integration:? Programmer's approach ? for applications integration it is necessary to create some program codes;? Integrator's approach ? in this case special software products are to be used and the integration process set up by those software settings.The following tools may be used for the first approach:? ODBC. In Lotus Domino codes may be used:o Three @-functions (@DbColumn, @DbLookUp and), which work with registrated ODBC-drivers . @DbColumn returns the whole column from external table, @DbLookUp process search by the key, and @DbCommand runs a command of ODBC-driver or external table (for...(related: Software)
The Hidden Power Of Online Manual
Writing software manuals is boring, isn't it? We often think: "My software is easy to use. The user interface is intuitive. Why should I waste so much time for writing the document which nobody reads anyway?" Sometimes it's true ? I've never read the WinZip or Internet Explorer manuals ? everything seems clear without explanati...(related: Software)
What Is Shareware?
Shareware is software that you can try before you buy; shareware is a kind of marketing method for software. Software developers post trial versions of their software on websites. Consumers can then download the trial version to their computer and evaluate it. If the consumer likes the software they can purchase it. Shareware is also called try before you buy.Today almost every big software compan...(related: Software)
Healthcare Preventive Maintenance Software
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can benefit greatly if up to date CMMS software is used. Healthcare CMMS programs will help with the maintenance of the building, alerting workers when items such as automatic doors, light fixtures, and plumbing structures are due for checkups.Another i...(related: Software)
Seven Reasons Why A Hosted Inventory Management Solution Might Be Right For Your Organization
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of headaches related to the implementation and on-going care-and-feedin...(related: Software)
Who Is Minding Your Sensitive Data?
Stealing company information used to be the specialty of spies and conspirators. It was something that only happened to the most powerful of corporations and branches of government.Nowadays, stealing data is commonplace and anyone can be...(related: Software)
C++ Tutorial 1, Introduction To C++
Introduction to C++Why Learn C++?C++ may at first seem like a boring, confusing programming language that you can only program command prompt applications with. Well, that is what it is like in the [b]begining[/b]. And you are going to need to l...(related: Software)
Microsoft Great Plains Security Setup - Overview For Consultant
Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Former product name was Great Plains Dynamics / eEnterprise. Both versions: old and new are Great Plain...(related: Software)
Windows X: Basic Windows ?security? Issues
Language development computer:Computer-based method for aiding language development seems like an interesting idea, the trick with this would be in getting the computer to take on part of the role of the human in the checking process.In all computer aided learning applications aimed at the very young, there is a danger that the computer may be seen as a replacement for a human instructor, however computer are notorious for not volunteering information or inabilit...(related: Software)
Microsoft Crm Integration & Customization: Sharepoint Document Gateway
MS CRM is very close to document workflow automation, including Microsoft Office documents: Words, Excel, etc. The document workflow was perfectly automated about 10 years ago in Lotus Notes Domino. In this small article we describe the solution based on...(related: Software)
Reporting Tools For Microsoft Great Plains ? Overview For Developers
Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. There are several reporting tools available and you definitely need to know which one to use for different types of reports.If you are developer who is asked: how do we create report for Microsoft Grea...(related: Software)
Great Plains Accounting Migration To Microsoft Great Plains - Overview For It Specialist
This is a short article, written in question/answer/FAQ style to give IT Specialist/developer/programmer balanced top level information on Great Plains Accounting migration to Microsoft Business Solutions Great Plains. If you have Great Plains Accounting as main accounting and ERP system you need to know some technical details on the migration to Great Plains and what is going on behind the scenes. As of right now it...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software