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

---

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

Professional Software Icons For Your Standalone Application

User interfaces and accessibility are some of the most important... Read More

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

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

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and... Read More

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ

Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

How To Make Good Use of Spreadsheets

Most computer users use spreadsheets software such as Microsoft Excel... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

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

CROOK: A Methodology for the Refinement of Forward-Error Correction

Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More

Tripwire for Linux File Integrity

What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

Oracle Development: JDeveloper 10G ? Java, J2EE, EJB, MVC, XML - Overview For Programmer

In 2004 Oracle, Inc. made its new step toward J2EE... Read More

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

During the years of our consulting practice, which comes back... Read More

What You Should Know About Installing Screensavers

Do you remember that frustrating feeling when you find an... Read More

Tools for Customizing Great Plains

Microsoft Business Solutions ? Great Plains has captured the US... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More

When is a Software Engineer Not a Software Engineer?

The title of "software engineer" has got to be among... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

Enterprise Resource Planning Overview

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

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... Read More

Microsoft Great Plains BR: Bank Reconciliation

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Free Software for Newbies and Web Developers

Here is some free software tools to help you build... Read More

Reduce TCO: The Java Database Way

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

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Groupware as a Document Manager: Collaboration Series #3

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

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More