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.

www.albaspectrum.com

1-866-528-0577! www.albaspectrum.com

Benton shuttle to Midway .. Lockport Chicago limo O’Hare
In The News:

Just two months into 2025 there have been numerous Mac malware threats targeting Apple laptops, ranging from infostealers to malicious software.
A self-driving electric bus powered by artificial intelligence has an electric powertrain for zero-emission operation and an automated drive system.
SpaceX is slated to launch its Starship for the eighth time from Boca Chica, Texas, Friday, though plans could be thwarted if the FAA fails to give the green light.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Kurt the CyberGuy offers tips on how you can protect your devices against infostealer malware, which was used to infect 4.3 million machines last year.
Motional is developing autonomous vehicles capable of handling a wide range of real-world scenarios. Its high-speed robotaxi testing reached speeds of 75 mph.
Kurt "CyberGuy" Knutsson explores whether there is artificial intelligence bias involved with the iPhone's voice-to-text conversion in the message app.
Apple's iPhone voice-to-text periodically flashes "Trump" when a user speaks the word "racist." Fox News Digital reached out to Apple about the flaw but did not hear back.
Tech expert Kurt “CyberGuy" Knutsson presents five secret shortcuts: Adjust sound/vibration, share YouTube moments, fix tabs and tweak brightness.
VR transforms senior care: Kurt “CyberGuy" Knutsson says immersive tech helps older adults explore and connect via virtual experiences.
Tech expert Kurt “CyberGuy" Knutsson says DNA tests pose privacy risks like shared genetic information, inaccuracies and hard data deletion.
Tech expert Kurt “CyberGuy" Knutsson says this enormous airship revolutionizes cargo transport by flying to remote areas.
Understanding the language of the internet can help you protect your personal information from bad actors. Kurt "CyberGuy" Knutsson explains.
Woven City is Toyota's experimental city that is a fully functional environment for people to live, work and play while doing research.
The line between spam and scams is thin. Kurt "CyberGuy" Knutsson details his tips for identifying and avoiding phone scams, robocalls and unwanted solicitations.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents
Kurt the CyberGuy takes you through the steps to easily set your preferred web browser whether you're using a Mac, Windows PC, iPhone or Android.
Google, Instagram, Facebook and weather apps can track your location and use that data to serve you ads; here's what you can do to protect your privacy.
A new debate has emerged about whether airlines should charge passengers based on their weight to help reduce fuel consumption and lower emissions.
Tech expert Kurt “CyberGuy" Knutsson says Hipshipper, which is used by eBay, Shopify and Amazon sellers, exposed millions of shipping labels.
Boxabl’s Baby Box is a 120-square-foot foldable home that can be set up in 60 minutes and has off-grid features. Kurt “CyberGuy" Knutsson says it's designed to maximize functionality.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Major IoT data breach: Mars Hydro database with 2.7 billion records exposed. Kurt “CyberGuy" Knutsson says the breach is a reminder of the risks that come with using IoT devices.
Unitree H1 robots dance at gala, blending AI and tradition. Tech expert Kurt “CyberGuy" Knutsson examines the convergence of cutting-edge technology and traditional culture.
For the first time ever, SpaceX launched a rocket into space from Florida and landed the booster the Bahamas, allowing for future polar-orbit spaceflight missions.

Microsoft CRM Integration & Customization: SharePoint Document Gateway

MS CRM is very close to document workflow automation, including... Read More

History of Java

The java programming language is becoming more and more popular... Read More

The Hidden Power of Online Manual

Writing software manuals is boring, isn't it? We often think:... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... Read More

QuarkXpress Tips: How to Move Content Between Print and Web Layouts

Since its release in 1987, QuarkXpress had made an immediate... Read More

Constructionalist Parsing - Deciphering Natural Language

The research in the field of Natural Language Processing usually... Read More

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... Read More

Microsoft Great Plains Accounting/ERP Implementation ? Finance Industry Customization Example

Microsoft Business Solutions Great Plains is very generic accounting application... Read More

Free Software: How Not To Get More Than You Bargained For!

I completed an experiment recently. I wanted to find out... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Microsoft Great Plains BR: Bank Reconciliation

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Getting Technical Support Help Online

Sometimes your PC will start acting strange for no apparent... Read More

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

limousine Chicago airport Arthur ..