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.
affordable house cleaning Wilmette ..Are you ready? SQL Server 2005, the next-generation data management... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
With any good luck and a good amount of hard... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Whether you are an experienced web programmer or a complete... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
C++ Function templates are those functions which can handle different... Read More
If you look back to the history, you will see... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
In the new era of internet marketing the problem of... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Looking at all the ads which promise to get rid... Read More
Music downloads are off the charts! We're listening to digital... Read More
Spyware is software or hardware installed on a computer without... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Sales are all about leverage, because there is only so... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
In part III of this ISDN primer, we learned that... Read More
quick home cleaning Northbrook ..People often ask me: What image file formats will Photoshop... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
All your software is stored on a hard-drive. But how... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
The world of small business accounting software can be a... Read More
We don't think about mainframe software pricing anymore, we just... Read More
During the years of our consulting practice, which comes back... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
I like my software simple. If it's too complex or... Read More
All of us know that Microsoft bought former Great Plains... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
If you have Microsoft Great Plains and support it for... Read More
Whether you are an experienced web programmer or a complete... Read More
The first topic we are going to discuss... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
It won't matter how effective your WinRunner Team is if... Read More
This article is the first of a series of articles... Read More
Software |