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.
shuttle from O'Hare Brocton .. Lockport Chicago limo O’HareIBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
Usually, the easiest way to tell you have spyware is... Read More
Mike Dunville* had a decision to make. As the new... Read More
When you need a phone number, you do a quick... Read More
Words we choose to describe things and phenomena often show... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Three highly respected names in Human Resources have joined forces... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
If you've been using MySQL database to store your important... Read More
Usually workflow & messaging is realized in CRM and then... Read More
Microsoft CRM is new player on the CRM software... Read More
It's no secret that software companies operate in a very... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
I provide, here clear explanations and a count of function... Read More
You turn on your computer, and it doesn't look quite... Read More
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
Considering whether or not your software company should hire a... Read More
Chicago charter limousine service Hickory Hills ..Microsoft bought Navision, Denmark based software development company, along with... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
XML Server can be a Web Server that stores the... Read More
If you copy something from a Web site or elsewhere...... Read More
Today's business world is fast-paced. No matter what it is... Read More
Fleet Maintenance Management is a critical position in any company... Read More
The US House of Representatives has recently passed the "Spy... Read More
There is many things more frustrating than surfing a website... Read More
The purpose of one of our projects was MS Exchange... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
Once upon a time not so long ago, there was... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
In the new era of internet marketing the problem of... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
In the previous ISDN article, we looked at how and... Read More
Java has come along a long way. Many would agree... Read More
Now that spyware is the single most dangerous threat to... Read More
Accounts payable is just one area of office management where... Read More
I have always had a tendency to focus on the... Read More
I've been active in the Cisco Certification track for four... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Software |