Great Plains Dexterity Programming - Overview For Developer

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.

If you are developer who is asked: how do we customize Great Plains with its native programming language - Great Plains Dexterity - read this and you will have the clues on where to look further.

The history of the Dexterity. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface.

Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases - you use Dexterity ranges and loops to manipulate the records

Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects - you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet.

Dexterity Forms - if you like VBA and are comfortable to do all the business logic in VBA - you can use Dexterity as new forms creator/editor. This is OK - but you have to purchase VBA/Modifier and Customization Site Enabler from MBS.

Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary - DYNAMICS.DIC. If you need cross dictionaries customization - consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary..

Happy customizing! if you want us to do the job - give us a call.

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, Georgia, New York and having locations in multiple states and internationally www.albaspectrum.com, he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

akarasev@albaspectrum.com

1-866-528-0577! help@albaspectrum.com

MORE RESOURCES:

Callidus Software Presents at 11th Annual Needham Growth Stock ... - MarketWatch (press release)

Perceptive Software lays off 53 Kansas City Business Journal - Bizjournals.com

PerkinElmer and IDBS Announce Software Collaboration to Improve ... - Reuters

Rainmaker Signs Three-Year Renewal with TIBCO Software for ... - Reuters

Insider Software to Unveil TypeTrax at Macworld Expo: Represents ... - Reuters

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/4-0fd=Rurl=http://www.reuters.com/article/pressRelease/idUS82934%2B05-Jan-2009%2BBW20090105cid=1287205999ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNFtmnT8RWeqksJPNMDcrWp1kRBgogInsider bSoftware/b to Unveil TypeTrax at Macworld Expo: Represents b.../b/abrfont size=-1font color=#6f6f6fReutersnbsp;-/font nobr16 hours ago/nobr/fontbrfont size=-1New Digital Asset bSoftware/b Tracks Projects, Font Usage and Automatically Preflights InDesign and Illustrator Jobs LOS GATOS, California--(Business Wire)-- b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-1fd=Rurl=http://stuff.techwhack.com/5956-typetraxcid=1287205999ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNErHrduZQiE8764LuworxlGaLGs7AInsider bSoftware/b launches TypeTrax/a font size=-1 color=#6f6f6fnobrTechWhack/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-2fd=Rurl=http://www.macworld.com/article/137910/2009/01/typetrax.htmlcid=1287205999ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNGb1i3ZBmMpltcaZS_GOhBItzkRjQExpo: TypeTrax manages Creative Suite projects/a font size=-1 color=#6f6f6fnobrMacworld/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-3fd=Rurl=http://www.macnn.com/articles/09/01/05/insider.releases.typetrax/cid=1287205999ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNH_vASGZaxPySV8yGRsoEMf-OEjAgTypeTrax manages Adobe CS documents, fonts, more/a font size=-1 color=#6f6f6fnobrMacNN/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1287205999hl=ennobrall 21 news articles/nobr/a/font/div/font/td/tr/table

ZyLAB Receives Highest Rating in Research Firm`s E-Discovery ... - Reuters

Expo: ModelBaker rapid app development software debuts - Macworld

TX Announces AutoSave(TM) CD/DVD Recordable Media Lineup With ... - Reuters

Smith Micro Mobile WiMAX Management Software for Clearwire - TMCnet

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/8-0fd=Rurl=http://wimax.tmcnet.com/topics/wimax/articles/48021-smith-micro-mobile-wimax-management-software-clearwire.htmcid=1286850288ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNFUtynd956K5hpvkwpU-WbT0a_qDgSmith Micro Mobile WiMAX Management bSoftware/b for Clearwire/abrfont size=-1font color=#6f6f6fTMCnetnbsp;-/font nobr14 hours ago/nobr/fontbrfont size=-1And now, Smith Micro bSoftware/b, Inc., a developer and marketer of mobility solutions and services for the wireless market, has announced it has been selected b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/8-1fd=Rurl=http://newsticker.welt.de/%3Fmodule%3Dsmarthouse%26id%3D828433cid=1286850288ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNF7MIYMqrZOFyFa3m_0nIBw1jtXggSmith Micro’s Connection Management bSoftware/b Tapped for Clear b.../b/a font size=-1 color=#6f6f6fnobrWELT ONLINE/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/8-2fd=Rurl=http://www.xchangemag.com/hotnews/clearwire-mobile-broadband-usability.htmlcid=1286850288ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNGXDohc1EB8Rn4cfUu7Dt3ZREP7IQClearwire Simplifies Mobile Broadband Usability/a font size=-1 color=#6f6f6fnobrxchange Magazine/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/8-3fd=Rurl=http://www.reuters.com/article/pressRelease/idUS82928%2B05-Jan-2009%2BBW20090105cid=1286850288ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNHqwYp1LXNalQbkBT08D37gyO0wMwSmith Micro`s Connection Management bSoftware/b Tapped for Clear b.../b/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/8-4fd=Rurl=http://www.pcworld.com/businesscenter/article/156392/clearwire_set_to_launch_its_first_wimax_city.htmlcid=1286850288ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNFknYCH5E8gY7BDElL17QOZ_tHlAgnobrPC World/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/8-5fd=Rurl=http://www.forbes.com/wireless/2009/01/05/wimax-clearwire-portland-tech-wire-cz_rb_0105clearwire.htmlcid=1286850288ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNGPiC38bYoAYua4JCfgBanRq5avmgnobrForbes/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1286850288hl=ennobrall 38 news articles/nobr/a/font/div/font/td/tr/table

MasterCard acquires software provider Orbiscom - Reuters

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/9i-0fd=Rurl=http://www.dividend.com/blog/%3Fp%3D4595cid=1287219423ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNFyGggTwerqtvtx0X5fVk-yP9ARlAimg src=http://nt0.ggpht.com/news?imgefp=oEjN6kenIpUJimgurl=www.dividend.com/blog/wp-content/uploads/storypics/mastercard.jpg width=80 height=64 alt= border=1brfont size=-2Dividend.com/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/9-0fd=Rurl=http://www.reuters.com/article/euMergersNews/idUSN0536893220090105cid=1287219423ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNHQ7jVYo2X0yLQkZ8hWHHWQakiLMwMasterCard acquires bsoftware/b provider Orbiscom/abrfont size=-1font color=#6f6f6fReutersnbsp;-/font nobr12 hours ago/nobr/fontbrfont size=-1N) said on Monday it has acquired bsoftware/b provider Orbiscom Ltd for $100 million to enhance its payments processing system. Part of the purchase price for b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/9-1fd=Rurl=http://www.marketwatch.com/news/story/MasterCard-buys-payment-software-firm/story.aspx%3Fguid%3D%257BF9433138-E6FB-4DF7-877D-0DCD92EAB8E3%257Dcid=1287219423ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNGEOfHFBDFzGcdfTQCLYBGE6HBrRwMasterCard buys payment bsoftware/b firm Orbiscom/a font size=-1 color=#6f6f6fnobrMarketWatch/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/9-2fd=Rurl=http://www.irishtimes.com/newspaper/breaking/2009/0105/breaking53.htmcid=1287219423ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNE6u2TNFfWx8Lk1pMqohDdNxfQ44wIrish bsoftware/b firm sold to Mastercard for $100m/a font size=-1 color=#6f6f6fnobrIrish Times/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/9-3fd=Rurl=http://www.bizjournals.com/stlouis/stories/2009/01/05/daily1.htmlcid=1287219423ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNGVVD8920WkLY7R9Y2hAh-GQ4lo8gMasterCard buys Orbiscom for $100M/a font size=-1 color=#6f6f6fnobrBizjournals.com/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/9-4fd=Rurl=http://www.siliconrepublic.com/news/article/12025/comms/pbx-goes-virtualcid=1287219423ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNFW-J3mqVWqkV1r4-8X5KL8UXguBQnobrSiliconrepublic.com/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/9-5fd=Rurl=http://www.businessweek.com/ap/financialnews/D95H1ETO0.htmcid=1287219423ei=ZN9iSdSMMYzK8ATmmdiZBAusg=AFQjCNGNYXMy7Un3ssXAVC_C2rwY3HnmhAnobrBusinessWeek/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1287219423hl=ennobrall 56 news articles/nobr/a/font/div/font/td/tr/table

Software - Google News

RELATED ARTICLES

Benefits of Integrating Online Chat Software with CRM
Customer Relationship Management (CRM) is a strategy and processes used to learn more about customers' needs and behaviors in order to develop stronger relationships with them. CRM applications are traditionally developed as client-server software.

Microsoft CRM: Implementation, Customization, Support - Consultant Overview
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 USA.

Off The Record - Tips For Picking Recording Software
Need software to record your voice, streaming audio or musical instruments? There are dozens of great products on the market. Some cost up to five hundred dollars, but here are some of the low cost alternatives you might want to consider.

Causes of ERP Failures
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP software integrates business activities across various functional departments, from product planning, parts purchasing, inventory control, product distribution, to order tracking.

Microsoft Navision and Crystal Reports - An Overview
Microsoft Business Solutions - Navision is an integrated solution for small and midsize companies looking to expand their business operations without much interruption to its existing processes. Microsoft Navision enables businesses to alter as much or as little of its existing system, integrate add-ons and vertical segments of its development.

Microsoft Great Plains & CRM in Transportation & Logistics - Overview
Microsoft Business Solutions Great Plains and MS CRM (client relation management system) are very popular in various industries and market niches. In previous article we described Microsoft Great Plains implementation for transportation & logistics company.

.NET :Solving the Multiple Inheritance Issue Under .NET Platform
.NET platform does not support multiple inheritance.

How to Build a Basic CSS Layout
Designing without tables by using CSS layouts is fastbecoming the new standard on the Web because of thebenefits mentioned in my previous article. Web browsersused these days are now able to render web pagesproficiently.

HelpDesk & Asset Management Software - Choosing The Right One
If you are to buy a HelpDesk & Asset Management software, see the following checklist before you decide on one.Comprehensive Help Desk FunctionalityA good Help Desk product can dramatically rise the productivity of the Help Desk Personnel (which in turn will rise the organisation's productivity as a whole).

New SQL Delta Version 3.1
COMMAND LINE FUNCTIONA powerful command line script processor has been introduced to SQL Delta 3.1.

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content
It's no secret that software companies operate in a very competitive space where rivalry is increasingly fierce and where profit margins can be razor thin. New, smaller software companies are sprouting up each month and the leading software companies continually make strong advancements forward leveraging massive cash flow reserves.

Tools for Customizing Great Plains
Microsoft Business Solutions - Great Plains has captured the US market with its integrated business applications for small and mid-size organizations. Its comprehensive accounting and business management capabilities provide businesses with tools to customize various modules of the Great Plains software.

Mapping Software: Putting Data Visualization on the Map
Mapping Software Improves Data VisualizationFrom the outset, it is important to clarify exactly what mapping software is and what it has to do with data visualization. If you are looking for driving directions for your next road trip, this is not the article for you.

An Introduction to .NET Framework
.Net Framework is a platform or development environment to seamlessly create web-applications that are accessible through client machines from across the globe.

Accessing XML Using Java Technologies
The most important benefit of XML is its simplicity. Though it is simple it is powerful enough to express complex data structures.

Great Plains Dexterity Development: FAQ
Microsoft Business Solutions Great Plains is Dexterity-written application and currently we see increased interest for Great Plains customers to do in-house Dexterity development and customization. Dexterity itself is written on C programming language and its initial architecture was based on the Graphical and Database platform independence, which C programming language was believed to provide.

Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision, Solomon and its own CRM solution - Microsoft CRM. Targeting to automate all business operations, Microsoft CRM is now integrated with Microsoft Great Plains and in the close future it should have integration with Microsoft Navision.

Configure Windows Indexing Service for Performance
The Windows Indexing Service provides you with the ability to perform advanced searches on directories located on your computer and on shared directories on the network. The Indexing Service was introduced with IIS (Internet Information Services) and is now installed with Windows 2000 and Windows XP.

How To Choose A Fire Wall Software Program
In the real world a "fire wall" is a fireproof wall that is built to stop thespread of fire from one part of a building to others. In the Internet world afirewall has a similar purpose in that it stops the spread of harmful virusesand attacks from entering your home or office network.

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.