 |
Great Plains Sql Technology Background – Tables Structure, Dexterity
Author: Andrew Karasev  | Posted: 07-03-2008 | Comments: 0 | Views: 12 | Rating: (53)  (?) 
 Microsoft Dynamics GP, or as this ERP is currently known and popular among the IT community – Great Plains Dynamics is at this time Microsoft SQL Server based application. SQL means tables, their names, fields, data flow as it reflects business processes, such as Sales invoices entering, posting, customer payments against these invoices, voiding, etc. As you can imagine, Great Plains MRP is not just the collection of tables, it has software logic, which is realized in Microsoft Dexterity (or as it was formerly known Great Plains Dexterity). If you have intentions to customize Great Plains, you can do it either on SQL level or in Dexterity, plus new tools are now available, such as eConnect, which is in essence the replication of Dex logic in encrypted SQL stored procedures with rich interfaces stack: COM+, BizTalk, Web Services. Dexterity has also such extensions as Extender (or full version of eOne extender, available from eOne). Let’s come to technical highlights:
1. GP tables structure. The best and the most appropriate way of getting the essence of GP tables and their relations, is to install and review GP SDK, available from CD 2. However, more practical is quick access of the tables structure in GP workstation interface, simple go to Microsoft Dynamics GP->Tools->Resource Descriptions->Tables, then select series: financials, manufacturing, project, system, financials, receivables, payables, payroll, HR
2. Data entering and posting workflow. GP is mid-market ERP, and its business processes are not trivial. In order to get them imitated via SQL stored procedures, you will need to enter imitating transactions in the test company environment. Good example – if you plan to imitate Sales Order Processing cycle: enter Sales Invoice, then post it and apply customer payment – monitor each step in SQL to verify which table got the record and on which step
3. Dexterity. Great Plains Dex is the Source of current GP version, 10.0 as of March 2008. Dex business logic is in Dynamics.dic and associated third party dictionaries. Dexterity in-house programming is not recommended, due to complexity and long learning curve for Dexterity software developer
4. eConnect. This SDK is more new GP welcomed tool, than Dex. We recommend it if you try to do GP modifications, integrations, DB conversion internally
5. GP eCommerce Shopping Carts and Catalogs. The best approach is first to explore Microsoft Great plains Dynamics GP Business Portal Order Management module, which is seamlessly integrated with GP SOP and Inventory Control modules natively
Rate this Article:
Current: 0 / 5 stars - 0 vote(s).
Article Source: http://www.articlesbase.com/software-articles/great-plains-sql-technology-background-tables-structure-dexterity-353681.html
About the Author:Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego
|
Submitting articles has become one of the most popular means of generating quality backlinks and targeted traffic to your website. Join us today - It's Free! |
|
Related Articles
Deciding on a New ERP Solution? Choosing Working With the Right Microsoft Partner Could Make the Difference in your Systems Success
By: Monique Tatum | 05/09/2007 | Software
The right Microsoft Certified Partner will prove invaluable as your new ERP solution is implemented, but having your solution set up correctly in the first place is only half the battle. Your chosen consulting firm for implementation should do much more than integrate and optimize your solution.
Great Plains Version Upgrade – Microsoft Dynamics Gp Installation Notes
By: Andrew Karasev | 07/10/2007 | Software
Microsoft Business Solutions Great Plains Dynamics GP version update technology seems to be straight forward – you insert new version CD and upgrade will be launched automatically with wizard. Proven Great Plains Dexterity technology will determine your current version and it will replace first GP workstation side files
Microsoft Great Plains Version Update to 10.0 Latest Notes
By: Andrew Karasev | 16/11/2007 | Software
According to Microsoft Dynamics GP technical support, today on November 16, 2007 MBS release Service Pack 1 for GP 10.0, and by doing this ended long lasting GP upgrade path problem: if you were on GP 9.0 higher than SP2, then you had to wait with upgrading to GP version 10.0.
Workflow in Microsoft Dynamics Gp 10.0
By: Monique Tatum | 21/12/2007 | Software
Microsoft Dynamics GP 10.0 is an ERP system that leverages several advanced features of SharePoint to enable internal workflow.
Great Plains Support: How to Recover “suspicious” Company Database
By: Andrew Karasev | 13/02/2008 | Software
Microsoft Great Plains from time to time falls to the situation, when the problem really sits at the MS SQL Server level and you need to do SQL scripting in SQL Query Analyzer.
Great Plains Automatic Batch Posting Overview
By: Andrew Karasev | 17/05/2008 | Software
If you know Microsoft Dynamics GP architecture, Dexterity business logic, you probably realized that standard Great Plains Integration tools, such as Integration Manager, eConnect, which are typically deployed in eCommerce integration scenarios, allow you create only so-called work transactions: SOP Invoice is the most popular transaction type
Great Plains Setup: Installation, Data Conversion, User Training
By: Andrew Karasev | 15/06/2008 | Software
Microsoft Dynamics GP ERP system is targeted to mid-size businesses, and Small Business Financials is for smaller companies. It is common norm on the MRP market, when mid-size accounting software requires professional installing, support, data migration and reports design
Great Plains Consulting in San Diego Overview
By: Andrew Karasev | 01/07/2008 | Software
Microsoft Dynamics GP is popular ERP in USA and we would like to recommend you our company Alba Spectrum as GP reseller, integration, consulting partner and ISV with local office in San Diego, California. Considering San Diego business diversity, our lead consultants are fluent in both – English and Spanish and we have experience in implementing Great Plains for US companies with manufacturing facilities in Maquiladora area of Mexico as well as n Baja California
Got a Question? Ask.
Ask the community a question about this article:
Frequently Asked Questions
Do we have adapter for Project Accounting in GP ...
By: GPIM | 16-10-2007
Do we have adapter for Project Accounting in GP Integration Manager Ver 10.0 ?
Q&A Powered by: 
Latest Software Articles
Great Plains Consultants Chicago, San Diego, Houston and Nationwide Support
By: Andrew Karasev | 24/07/2008
Microsoft Dynamics GP software licenses sale, implementation, data conversion, user training, customization, integration, reporting, version upgrade.
Statistical Process Control by Hertzler Systems Impacts Leading Flavor Manufacturer
By: Thomas Cutler | 24/07/2008
Statistical Process Control by Hertzler Systems Impacts Leading Flavor Manufacturer
How to Convert Nsf Archives to Outlook Pst File ?
By: Evan Swans | 24/07/2008
How to fix corrupt views of Lotus Notes NSF Archives? How to convert Lotus Notes NSF Archives to MS Outlook PST file? Export Notes is powerful software to migrate Lotus Notes to MS Outlook. Convert Lotus Notes emails, calendar, contacts, and journals, to do list to Ms Outlook with SysTools Export Notes. If you face any problem converting Lotus Notes NSF archive to MS Outlook PST file due to corrupt views of NSF file, try using IBM Data Fixup Utility.
Seo and Keyword Analysis
By: Kanwaljit Kaur | 24/07/2008
Targeted keywords are hard to ignore in search engine optimization. Keywords play vital roles in optimizing a website, ranking on the search engines and reaching target market. Keywords have loads of benefits if you know how to find them.
Building a Flexitime Management System - Challenges Faced
By: Mike R Turner | 24/07/2008
When asked to adapt our time-recording software so it can be configured to account for flexitime, there were number of questions that needed to be resolved. We explain the issues we considered.
Customized User Interfaces for Multi Function Printers
By: Mike Nicholson | 24/07/2008
By their nature, MFPs are complex devices. Many MFPs now include high resolution screens and other user interface aids. Generally, most office MFPs contain advanced LCD panels resembling a custom computer-like user interface.
Get Free Registry Repair Solution From Internet
By: Arvind | 24/07/2008
Registry is an integral part of the Windows based computer. Windows creates and uses the registry file to store all the vital data about the hardware and software configuration, system settings, network settings and user account details of the computer.
Quickbooks Means Accounting Simplified
By: markoriks | 23/07/2008
Managing a small business is tough. It needs knowledge, money, dedication and time. The successful small businesses are those that are financially on top position. Keeping a track of from where money comes and to where it's going is absolutely necessary. One way to effectively keep this track is to use QuickBooks accounting software.
More from Andrew Karasev
Great Plains Consultants Chicago, San Diego, Houston and Nationwide Support
By: Andrew Karasev | 24/07/2008 | Software
Microsoft Dynamics GP software licenses sale, implementation, data conversion, user training, customization, integration, reporting, version upgrade.
Microsoft Dynamics Gp Great Plains Consultants With Industry Expertise
By: Andrew Karasev | 23/07/2008 | Software
Microsoft Dynamics GP Great Plains certified consultants with average 10 years of experience are available for GP implementation, customization, data conversion, integration, user training and ongoing support. We have experience in such modules as General Ledger, Accounts Payable, Accounts Receivables, Sales Order Processing, Purchase Order Processing, Project Accounting, Fixed Assets, Payroll, ReportWriter, FRx, Crystal Reports for GP, Microsoft Dexterity, eConnect and GP Integration Manager
Great Plains Consultants and Integrators With Emphasis in Technology
By: Andrew Karasev | 22/07/2008 | Software
Microsoft Dynamics GP functional and technical consulting requires strong backing in technology experience, background, training and certification. Modern ERP consultant should be familiar (or be capable to involve fellow consultants) with industries, managerial and financial accounting, be reasonable good in reports design, system modification, have some knowledge and be aware about specific programming techniques and customization tools.
Great Plains Consultant, Specializing in Technically Challenging Projects
By: Andrew Karasev | 22/07/2008 | Software
Microsoft Dynamics GP implementation, data conversion, reports design, user training, integration with legacy system and possible modifications and customizations should be entrusted into the hands of professional certified Dynamics GP consultant
Great Plains Consultant in Chicago, San Diego: Nationwide Support
By: Andrew Karasev | 19/07/2008 | Software
Microsoft Dynamics GP ERP is the member of Dynamics product family. If you decided to implement Great Plains in your organization, you probably came through the process of corporate ERP selection and decided to trust Microsoft Dynamics brand.
Great Plains Dynamics Gp Reseller: Nationwide Support
By: Andrew Karasev | 18/07/2008 | Software
If you are looking for new implementation of Microsoft Great Plains, you need first to locate Dynamics GP (which is new name of this ERP product) VAR, who will become your consulting and implementation partner. VAR selection should be based on your criteria.
Great Plains Customization: Reportwriter Modified and Custom Reports Overview
By: Andrew Karasev | 17/07/2008 | Software
In Microsoft Dynamics GP Report Writer is integrated reports modification tool, where you can modify such reports as Blank SOP Invoice form or Purchase Order to place your company logo there.
Great Plains Consultants and Developers Provide Nationwide Support
By: Andrew Karasev | 16/07/2008 | Software
If you have Microsoft Dynamics GP installed and implemented in your organization, and you are looking to get second opinion on your current system setup, customization, integration projects
|
|
Computers 
