|
|
|
 |
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
MORE RESOURCES:
Google News |
|
|
|
RELATED ARTICLES
Microsoft Great Plains: Government & Non-Profit Organization - Workflow Implementation Usually workflow & messaging is realized in CRM and then transactions are just logged into Accounting/ERP/MRP. In the case of Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Axapta the natural CRM choice would be Microsoft CRM. Bill of Lading - Custom Reporting for Microsoft Great Plains - Overview for Consultant Bill of Lading is required report for Logistics and Freight Forwarding companies. If you are looking at Freight Forwarding software, targeted to automate transportation business - Bill of Lading with multiple custom forms should be present there. How the Firefox: How to... Manual Helped Me A few months back I really got sick of my computer always being slow and having system errors. So I started doing a bit of research and heard of a new browser called "Firefox". Dreamweaver vs FrontPage There are two major WYSIWYG(What You See Is What You Get) editors available for beginners. These are: Microsoft FrontPage and Macromedia Dreamweaver. Adware and Spyware What is 'adware'?Adware is basically software or scripts that are hidden on your computer, that make advertising show up all over the place. It may be an extra menu in your web browser, icons appearing on your desktop, bookmarks or favourites appearing out of no where, and pop up ads that seem to come from no where!What is 'spyware'?Spyware is similar in nature to adware, however I feel its purpose is slightly more sinister. 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. Microsoft CRM for Corporate Business - Working Offline If your company has regional and worldwide operations, you might already realized that it is very hard to get decent internet connection in your remote locations. In this small article we will try to give you highlights on how to implement Microsoft Business Solutions CRM for worldwide operations with restricted internet connection. Should I Use Windows Update? Should one use Windows Update?This topic has good and valid arguments on both sides. Some would say keeping your windows up to date is essential in keeping it free of the newest, worst viruses and the like. Popular Fleet Maintenance Programs Some companies that are in need of fleet management may choose to utilize the services of a fleet maintenance program. These programs can generally handle all of you fleet management needs. Microsoft CRM in Latin America: Implementation, Customization, Support - Overview for Consultant Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe. We expect substantial number growth of Microsoft CRM implementations across South and Central America and the need for Microsoft CRM implementation, support, tuning, reporting, training services, especially in such countries as Mexico, Columbia, Venezuela, Argentina, Peru, Uruguay, Chili, Costa Rica. Microsoft Great Plains: Dexterity vs. eConnect - FAQ Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise was originally written in IDE and programming language - Great Plains Dexterity. Currently Microsoft is on the way of transforming its ERP applications: Great Plains, Navision, Solomon, Axapta and MS CRM to be better integrated and fit into the future of its . Microsoft CRM Data Import FAQ Microsoft CRM has built-in conversion tool, however you should probably first try third party conversion tool, such as Scribe. It is relatively expensive and has bunch of importing capabilities, that you might never use and need. Microsoft CRM for Large Corporation - Security Microsoft Business Solutions CRM proved to be reliable solution in the whole spectrum of industries and market niches: transportation & logistics, education, recruiting & placement, supply chain management, pharmaceutical, oil & gas, aerospace & defense, manufacturing, wholesale & retail. When corporation is looking into CRM application to choose from - one of the fist questions is security. The Truth about Colossus: Are You Just A Magnetic Image? What is Colossus?Colossus is software licensed to about twenty-five insurance companies to aid in predicting the settlement value of claims. The insurance industry maintains it is a useful tool because it considers a great many factors, and the settlement values are just a range for use in any way the insurer wishes. Lowering The Risks In Developing Do-It-Yourself Software Projects Mike Dunville* had a decision to make. As the new operations manager for Alpha Staffing, he wanted to make a difference at the dynamic staffing firm. Microsoft Navision Customization and Reporting - Tips For Programmer/IT Specialist C/SIDE (Client/Server Integrated Development Environment) - The core of Navision is the C/SIDE. C/SIDE is the foundation for all the business management functionality of Navision. Artificial Intelligence And Intuition The intuitive algorithm.Roger Penrose considered it impossible. Top Questions to Ask Before Buying a Help Desk & Asset Management Software #5 All your hardware components like Printers, PCs etc come under various maintenance contracts with different maintenance vendors. Do you know which batch of PCs are under warranty & for what number of PCs is the warranty about to expire (so that you can plan for an AMC)? Can you split up & tell how much AMC charges do you pay for each hardware component & how much for each vendor? Can you re-calculate the costs if an AMC with a vendor is to be renewed?#4 Typically your company gets hardware parts and accessories from different vendors. Five Steps to Rapid Development with TierDeveloper 4.0 Follow the steps below to quickly design, generate, and deploy a great portion of your real-life N-Tier application.STEP 1: HAVE YOUR DATABASE READY1. Groupware and Online Collaboration: Collaboration Series #4 This article is the fourth of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware.
|
| home | site map | software information | PPC Dictionary |
| © 2006 - 2007 Thagodz.com - A PPC Search Engine |
