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.
recurring cleaning service Wilmette ..The most important things you can do for your computer... Read More
Usually, the easiest way to tell you have spyware is... Read More
Are you a database professional? Do you work with a... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
It???s easy to understand why you might be drawn to... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
If you would like to pick something from Microsoft, or... Read More
Not every software testing project can or should be automated.... Read More
Now is the time to look at an alternative to... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
When making a decision to buy any piece of software... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
This is the tutorial where we really get into programming.... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
... Read More
Music downloads are off the charts! We're listening to digital... Read More
Google Inc. has launched a new software package that allows... Read More
Stealing company information used to be the specialty of spies... Read More
There are two major WYSIWYG(What You See Is What You... Read More
It is really interesting that a bug can create problem... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
reliable maid service Morton Grove ..Once upon a time not so long ago, there was... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Are you lost in the mess of documents that get... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
How would you like to prevent spyware and adware from... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
After almost two decades of existence, Quark has become the... Read More
The adware and spyware definitions list is very long. But... Read More
Crystal Reports is the most flexible tool on the market... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
When you need a phone number, you do a quick... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
With thousands of web pages added to the Net every... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
This is the tutorial where we really get into programming.... Read More
Software |