Home
>
Personal Technology
>
Microsoft Great Plains Dexterity Customizations

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 (help@albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer; help@albaspectrum.com

Brookfield car service from Midway ..

In The News:

The Great Pacific Garbage Patch, a vast marine debris vortex, is being tackled by The Ocean Cleanup’s innovative technologies. Kurt “CyberGuy" Knutsson explains.

Discover easy solutions to tame autocorrect frustration on iOS and Android devices. Turn off, customize and add personal touches to your typing experience.

Kurt “CyberGuy" Knutsson reveals the six top things to do right now before it’s too late: Tech and life choices that can keep your safer on and offline.

Kurt “CyberGuy" Knutsson shows you some simple steps to discreetly hide apps or an entire app page on your iPhone for decluttering or confidentiality.

The ambient light sensors on smartphones may be turned into cameras, according to researches at MIT. This could pose a threat to people's privacy.

The Autonomous Road Repair System from tech firm Robotiz3d uses artificial intelligence technology to locate potholes and promptly seal them.

Scammers have stooped to using artificial intelligence to scan obituary websites to create fake obituary websites to target the grieving.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

A Mercedes-Benz Manufacturing factory in Hungary is using humanoid robots to help with human staffing shortages on the factory floor.

Some video games act like unregulated banks, according to CFPB, which has begun monitoring the situation. The agency says children may be most at risk.

Ascender the robot is capable of climbing stairs with heights up to 8.7 inches, and it can give every corner of your home a deep cleaning.

Tax-return scams are on the rise, and one tax expert from a cybersecurity firm says filing your taxes on time is one way to avoid tax scams.

The innovative XPENG Robot Unicorn is inspired by the mythical unicorn, and you may forget the robot is not actually a living creature.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

The Federal Trade Commission, the federal agency to report scams to, is being impersonated as part of a new sophisticated phone scam.

Eatrenalin is a restaurant in Germany with a Floating Chair innovation that makes the 17,000-square-foot venue feel like an amusement park.

U.S. Air Force Secretary Frank Kendall met with the Senate Appropriations Committee on Tuesday and said he plans to ride in an autonomously-operated aircraft this Spring.

Kurt “CyberGuy" Knutsson reveals advice from a reader who files debit card fraud claims all day. Here are eight do's and don'ts to prevent debit card fraud.

Kurt “CyberGuy" Knutsson shows you how to update your password, PIN or pattern on your Android to keep your device safe and secure from hackers.

Tech expert Kim Komando explains how to use Google Maps tricks like looking at your childhood home, planning trip times, and virtually visiting buildings and shipwrecks

Kurt “CyberGuy" Knutsson reveals how hackers have unleased a new, more powerful version of the Vultur banking Trojan that's capable of taking full control of your Android device.

Take your online tasks offline: Kurt “CyberGuy" Knutsson shows you how to print your Reminders app lists on your iPhone to take wherever you go.

Two types of malware are designed to trick Mac users and steal data. So, it's important to make sure your private data is locked down.

Eve is a new artificial intelligence-powered humanoid robot from 1X that can help with household chores, including folding the laundry.

What happens when your landline rings and the caller ID lists your number? Strange, right? This happened to one of our subscribers, who reached out to ask us about it.

Microsoft Great Plains Dexterity Customizations

Personal Technology