Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

When Great Plains Software introduced the first graphical accounting application for Mac and Windows in the beginning of 1990th it had Great Plains Dexterity customization tool, IDE and programming language. Dexterity design was based on several longevity principles: Graphical platform independence and database platform independence and easy switch from one DB to the other among the most important ones. Dexterity was written as a shell in C programming language, which was "platform independent" and at the same time very efficient in compilation (close to assembler). Since then we saw new tools and options:

? Modifier with VBA. This tool allows you place custom buttons and editable fields on the forms and attach VBA scripts to these buttons and fields. Theoretically you can deploy ADO and make a call to the database, but typically this would be given to Dexterity programmer. Also Modifier can deal with ReportWriter report ? which is rarely used option, but you should be aware of it. Another usufull feature - calling Crystal Reports engine from VBA, so you can print custom Crystal Report - Invoice from SOP Entry screen, instead of regular Report Writer SOP Invoice Form.

? Continuum for VB and Delphi. We do not touch obvious features of Continuum, but would like to mention its advanced use. First ? in Dexterity you can not easily target multiple modules (coming from different software vendors ? those days Intellisol Advanced Purchase Order Processing, Project Accounting and ForeStar Fixed Assets). This feature could be addressed through Continuum generated VBA code with inclusion of Dexterity Scripts (Sanscript). The second nice feature of Continuum could be Great Plains Integration Manager custom apps, which allows you to switch Great Plains companies automatically and integrate the whole corporation during the night

? Dexterity SQL Support. When Great Plains C/S+ was introduced on MS SQL Server 6.5 platform ? instead of using Dexterity cursors ? you could use the way more efficient stored procedures and simply call them from Dexterity code. The negative side of this was ? you can not have your custom piece running on Btrieve or Ctree platforms, where Dexterity cursors were the only way to work with the database

? Dexterity COM object support. This was new feature of Microsoft Great Plains Dexterity version 7.0. This feature allows you to call something nice, like web service from your COM object and in this case replace, say Great Plains tax engine with the one working from your web server, located in one place and serving numerous subscribers.

? eConnect. This tool was initially designed for eCommerce developer, who deploys Microsoft Great Plains as the back end/ERP. eConnect is SDK with SQL Stored Procedures and parameters descriptions.

? Extender. We'll wait the next version ? but even now it is very promising and it doesn't require you to be programmer to customize Great Plains.

We encourage you to analyze your alternatives. You can always appeal to our help, give us a call: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ), serving Microsoft Great Plains, CRM, Navision to mid-size and large clients in California, Illinois, New York, Georgia, Florida, Texas, Arizona, Washington, Minnesota, Ohio, Michigan

In The News:


pen paper and inkwell


cat break through


Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

Preventive Maintenance Software Companies

Several software companies design programs for preventive maintenance. Most of... Read More

Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

In this small article we will show you the possible... Read More

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

ERP for Large Corporation ? New Selling Strategy

Our opinion is based on our Microsoft Business Solutions Great... Read More

The Top 5 Wrong Reasons For Not Hiring Testers

Considering whether or not your software company should hire a... Read More

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

String in Java

Handling character strings in Java is supported through two final... Read More

Microsoft CRM Modification ? Overview for IT Specialist

Microsoft CRM is now on the scene and it is... Read More

Rapid Application Development - Is it Really a Need of Today?

Rapid Application Development (RAD) is a software development methodology. In... Read More

Microsoft Small Business Manager eCommerce ? Overview

Microsoft Business Solutions Small Business Manager is scaled down Great... Read More

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

International Support - Microsoft Great Plains VAR/Partner Selection ? Overview for V.P. IT

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

What is a Document Manager without Version History?

Document Manager and Version HistoryIn previous articles I have discussed... Read More

Computer Based Language Development and Spell-checking

Language development computer: Computer-based method for aiding language development seems... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Backing Up And Restoring Your MySQL Database

If you've been using MySQL database to store your important... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Microsoft CRM or Siebel

Siebel is traditional CRM market leader, however and mostly due... Read More

ERP Software Financing: the Future? ? Overview for Company Owner

In our case ? we serve Microsoft Business Solutions ERP... Read More

Reduce TCO: The Java Database Way

TCO (Total Cost Ownership) is the buzzword in... Read More

Great Plains Dexterity History and Programming Overview

As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

Hubris - Definition: Microsofts Passport

Before September of 1995, Microsoft ignored the Internet because their... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

Microsoft Great Plains Integration Manager ? Working With Text File

Microsoft Business Solutions main middle market ERP application - Microsoft... Read More