Personal Technology Information

Microsoft Great Plains Dexterity Customizations


Microsoft Business Solutions is on the way to popularize it's ERP systems implementation. Right now such products as Microsoft CRM and Small Business Manager (cheap version of Microsoft Great Plains, based on the same Great Plains Dexterity runtime and DYNAMICS.DIC dictionary) are targeted to self-implementation by in-house IT group. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0. Plus you probably should know about programming language of Microsoft Great Plains - Great Plains Dexterity

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.

1. 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

2. 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.

3. 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.

4. 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 1-866-528-0577! help@albaspectrum.com

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Arizona, California, Texas, Florida, Georgia, New York, UK, Canada, Australia 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


MORE RESOURCES:

04/27/2024
Get the Most Out of Your iPad With These Accessories
These are some of our favorite stands, cases, keyboards, and styli, no matter which Apple tablet you have.


more info


04/27/2024
7 Spring Albums That You Don’t Need to Fight About Online
New music from Maggie Rogers, Tyla, Brittany Howard, and SchoolBoy Q showcase distinct artistic evolutions.


more info


04/27/2024
Meta’s Ray-Ban Smart Shades Get a Fresh Blast of AI
Plus: Leaked details tell us more about the new Google Pixel 8A, Freitag’s environmentally conscious bag is entirely recyclable, and it’s time to unpack a whole bunch of tech acronyms.


more info


04/27/2024
1 in 3 Americans Live in Areas With Dangerous Air Pollution
Climate change is increasing the number of days people are exposed to hazardous pollution, affecting already disadvantaged communities the most.


more info


04/27/2024
School Employee Allegedly Framed a Principal With Racist Deepfake Rant
This week in cybersecurity news: Google holds off on killing cookies, Samourai Wallet founders get arrested, GM stops its driver surveillance program, and a school principal's racist rant is revealed to be a deepfake.


more info


04/27/2024
Russia Vetoed a UN Resolution to Ban Space Nukes
A ban on weapons of mass destruction in orbit has stood since 1967. Russia apparently has other ideas.


more info


04/26/2024
Roborock's Robot Vacuums—Including WIRED's Top Pick—Are on Sale Right Now
More like Robot Rock, am I right? (Sorry.) These are some of the best dust-busters around and they're cheaper than usual.


more info


04/26/2024
Tesla Autopilot Was Uniquely Risky—and May Still Be
In an investigative report into crashes and deaths associated with Tesla Autopilot, federal regulators concluded that the system lacked standard protections.


more info


04/26/2024
The 32 Best Shows on Amazon Prime Right Now
From "Mr. and Mrs. Smith" to "Three-Body," these are our picks for what you should be watching on the streamer.


more info


04/26/2024
The 17 Best Movies on Amazon Prime Right Now
From "Road House" to "Bottoms," these are the must-watch films on the streamer.


more info


04/26/2024
Decades of Garry’s Mod Nintendo Uploads Are Disappearing
Nintendo is once again flexing its copyright muscles by filing takedown requests for user-generated content on the popular game platform.


more info


04/26/2024
The Best Lubes for Every Occasion
For the most sensitive parts of the human body, friction is the enemy. Here’s how to keep it at bay.


more info


04/26/2024
Which Govee Smart Lighting Kit Should You Buy?
Govee makes some of the best affordable smart lights, but its enormous range can be overwhelming and confusing. Here’s how to choose the right fit for your home.


more info


04/26/2024
The Best USB-C Cables for Your Phone, Tablet, or Laptop
Unravel the tangled world of cords and find the ones you need to charge your gadgets and transfer data.


more info


04/26/2024
The Best Car Phone Mounts and Chargers
These mobile accessories will make your smartphone a better—and safer—road trip companion.


more info


04/26/2024
Sale or No Sale, TikTok Will Never Be the Same
TikTok but without the algorithm? TikTok by Meta? A new law this week puts the platform on a death watch—and none of the potential outcomes look great.


more info


04/26/2024
The Best Coffee Subscriptions to Keep You Wired
These services deliver freshly roasted, delicious coffee picks right to your door—each with its own twist.


more info


04/26/2024
1994 Was the Last Good Year—and It's Still Going
1994 was the last year before our culture began migrating to the internet. If you were alive then, you may remember how you heard about Kurt Cobain's death, or where you watched "Pulp Fiction." What were your cultural touchstones that year? Tell us in the comments below.


more info


04/26/2024
What’s the Safest Seat on an Airplane?
All of them and none of them, really. Let us explain.


more info


04/26/2024
Can’t Afford a House? Buy a Piece of One Instead
In a chaotic housing market that has shut many buyers out, fractional home ownership and investing trends are taking off.


more info


04/25/2024
Google Thinks It Can Cash In on Generative AI. Microsoft Already Has
While both Alphabet and Microsoft boasted strong quarterly earnings, only one tech giant showed that its generative AI bet is starting to pay off.


more info


04/25/2024
There's a Rare $25 Discount on the Nintendo Switch OLED Right Now
Nintendo's top-of-the-line handheld gaming console hardly ever goes on sale, making this small discount super appealing.


more info


04/25/2024
Net Neutrality Returns to a Very Different Internet
The FCC voted 3-2 to restore net neutrality rules that had disappeared during the Trump administration.


more info


04/25/2024
The 30 Best Movies on Hulu This Week
From "Poor Things" to "Dune: Part One," here's everything you need to watch on Hulu right now.


more info


04/25/2024
Our Favorite Outdoor Security Cams for Your Home or Business
These weatherproof outdoor security cams keep a watchful eye on your property while you get on with life. Our list includes battery-powered and LTE devices and options that need no subscription.


more info



home | site map | contact us