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:

06/17/2024
Alex Jones Is Now Trying to Divert Money to His Father's Supplements Business
Conspiracist Alex Jones has responded to his bankruptcy proceedings by urging viewers to spend money with his father's company—which isn't answerable to the Sandy Hook families.


more info


06/17/2024
The 18 Best Portable Chargers for All of Your Devices
Keep your phone, tablet, laptop, and other electronics running with these handheld power banks.


more info


06/17/2024
Orkut’s Founder Is Still Dreaming of a Social Media Utopia
In the mid-2000s, Google engineer Orkut Büyükkökten’s self-titled social network briefly took the world by storm before disappearing. Now he’s back, with a plan for a happier social media.


more info


06/17/2024
The Best Place Online Is a Race in the Middle of Denver’s Airport
You can compete against anyone on Strava, anytime, anywhere—even in an international airport at 2 am. Which is better than doomscrolling.


more info


06/17/2024
OpenAI-Backed Nonprofits Have Gone Back on Their Transparency Pledges
Two organizations that handed out unconditional cash grants told WIRED that they will no longer disclose their financial statements and internal policies. Their stance follows a similar denial by OpenAI.


more info


06/17/2024
Banks Are Finally Realizing What Climate Change Will Do to Housing
Extreme weather threatens the investment value of many properties, but financing for climate mitigation efforts are only just getting going.


more info


06/17/2024
AI Is Coming for Big Tech Jobs—but Not in the Way You Think
Companies aren’t replacing workers with AI yet. But they are sacrificing thousands of jobs in the race to further innovation in the technology.


more info


06/17/2024
Hackers Detail How They Allegedly Stole Ticketmaster Data From Snowflake
A ShinyHunters hacker tells WIRED that they gained access to Ticketmaster’s Snowflake cloud account—and others—by first breaching a third-party contractor.


more info


06/17/2024
Amazon-Powered AI Cameras Used to Detect Emotions of Unwitting UK Train Passengers
CCTV cameras and AI are being combined to monitor crowds, detect bike thefts, and spot trespassers.


more info


06/16/2024
The 16 Best Electric Bikes for Every Kind of Ride
We tested the best electric bikes in every category—commuting, mountain biking, foldable, cruisers, and more.


more info


06/16/2024
Analog Photography: The Beginner’s Guide to Film Cameras
Which film camera should you get? Which films are the best? We demystify the world of analog photography to help you get started.


more info


06/16/2024
Our Favorite Pillows for a Restful Night’s Sleep
We spent months sleeping on various pillows to find the right support for your noggin whether you snooze on your side, back, or in a tangle of blankets.


more info


06/16/2024
Sorry, VR: The Meta Ray-Ban Wayfarers Are the Best Face Computer
Finally! An AI-enabled face computer that's comfortable, useful, attractive, and not completely humiliating to wear.


more info


06/16/2024
How to Spot a Business Email Compromise Scam
In this common email scam, a criminal pretending to be your boss or coworker emails you asking for a favor involving money. Here's what do to when a bad actor lands in your inbox.


more info


06/16/2024
Light-Based Chips Could Help Slake AI’s Ever-Growing Thirst for Energy
Optical neural networks, which use photons instead of electrons, have advantages over traditional systems. They also face major obstacles.


more info


06/16/2024
Let Slip the Robot Dogs of War
The United States and China appear locked in a race to weaponize four-legged robots for military applications.


more info


06/15/2024
The Best Camera Bags, Straps, and Backpacks
Tote your photo and video gear around in style. We tested more than 75 packs and rounded up our favorites.


more info


06/15/2024
Our Favorite Gender-Neutral and Inclusive Clothing Brands
These fashion brands are here to help you break free from the gender binary.


more info


06/15/2024
How to Shop Like a Pro During Amazon Prime Day
We’ve got tips to help you cut through the clutter to find real Amazon Prime Day deals.


more info


06/15/2024
The 34 Best Shows on Amazon Prime Right Now
“The Boys,” “Outer Range,” and “Fallout” are just a few of the things you should be watching on Amazon Prime Video this week.


more info


06/15/2024
A Guide to RCS, Why Apple’s Adopting It, and How It Makes Texting Better
The messaging standard promises better security and cooler features than plain old SMS. Android has had it for years, but now iPhones are getting it too.


more info


06/15/2024
How to Avoid Getting Sick This Summer
A microbiologist explains how to not catch summertime germs at the barbecue, in the pool, or on the trail.


more info


06/15/2024
Autocomplete Interview
Autocomplete Interview - Is Ice Cube a nice guy? Do astronauts really drink their own pee? Does Gerard Butler still surf? The internet searches for answers and WIRED goes right to the source for the answer.


more info


06/15/2024
Apple Intelligence Won’t Work on Hundreds of Millions of iPhones—but Maybe It Could
Older iPhones might well be able to cope with Apple’s AI, so why won’t your $900 year-old model run it? Here’s why.


more info


06/15/2024
Panerai’s Submersible Elux Lab-ID Dive Watch Generates Its Own Light Show
You have to pay $100,000 for a timepiece with a singularly hi-tech route to make 160 micro-LED lights come on without any battery to power them.


more info



home | site map | contact us