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 ? this 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!
About The Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Texas, California, Florida, 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.
Culver prom limo ..The purpose of Project Management Software is to provide an... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Imagine something that follows you home and sets itself up... Read More
I love new technology. I am still ready to wait... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Mike Dunville* had a decision to make. As the new... Read More
This article illustrates the best practices to improve the performance... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
In the early days of the personal computer, we're talking... Read More
An integral part of any quality CRM system is lead... Read More
If you are in a business that passes documents around... Read More
When you need a phone number, you do a quick... Read More
Three highly respected names in Human Resources have joined forces... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
Learning how to program software seems like a daunting task... Read More
Scrapbooks are very popular these days. I think that almost... Read More
It's not very often I get excited about a software... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
Since technology changes so quickly, it is hard to begin... Read More
If you have Microsoft Great Plains and support it... Read More
Wood Dale limo ..MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
People often ask me: What image file formats will Photoshop... Read More
C++ Function templates are those functions which can handle different... Read More
Linux essentials:It's free for download but you have to pay... Read More
Looking at all the ads which promise to get rid... Read More
Best Software Act! is very popular CRM for small and... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
The purpose of one of our projects was MS Exchange... Read More
I love new technology. I am still ready to wait... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Homeland security, airport security, Internet security ??" these days we???re... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
After almost two decades of existence, Quark has become the... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Since technology changes so quickly, it is hard to begin... Read More
New post-recession era has new features, which didn't exist in... Read More
Have you ever noticed that when you look at your... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
I have yet to see a business that, sometimes in... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Software |