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

---

Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

As we could imagine, if you are reading this article... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

Microsoft CRM Modification ? Overview for IT Specialist

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

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

5 Mac Security Tips You Can?t Live Without

So, you've bought a new Macintosh, and now you may... Read More

Things You Can Do With Windows XP!

Did you ever give a thought to the number of... Read More

Why Stick With Email Clients Like Outlook?

Trying to figure out a stream in banning one email... Read More

Microsoft Great Plains eCommerce ? Stored Procedures Approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More

Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview

In the case when you represent mid-size or mid-size-to-large business,... Read More

How to Choose the BEST Charting Software

I suggest that you do not spend a lot of... Read More

Fleet Maintenance Software Reviews

Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

The Dreaded Paper Label - Should it be Used?

While paper labeling CDs and DVDs may appear to be... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

Manufacturing in the USA is far away down from mid... Read More

OS 101: Suggestions for Choosing an Operating System

An operating system (abbreviated OS) is essentially the path through... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More

Anti-Spyware Protection ? Holes in the Shining Armor

Looking at all the ads which promise to get rid... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Business Plan Software Review: Ultimate Business Planner?

One of the main reasons business owners and entrepreneurs use... Read More

What is Shareware?

Shareware is software that you can try before you buy;... Read More

Microsoft CRM Customization - Processing In/Out-Going Email Messages

We would like to give you several situations, when you... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

The End of Spyware?

The US House of Representatives has recently passed the "Spy... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

Microsoft CRM: Implementation, Customization, Support ? Consultant Overview

Microsoft Business Solutions CRM is present several years on the... Read More

Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

Microsoft Great Plains is one of the Microsoft Business Solutions... Read More

Preventive Maintenance Software Companies

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

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More