Microsoft Great Plains Customization Tools ? Overview

Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions Great Plains was initially designed in the earlier 1990th as the extendable and modular application with its proprietary tool: Great Plains Dexterity, written in C programming language as a shell. This was popular tendency those days ?compare with SAP ABAP or Navision C/Side. Great Plains has additional ideas ? database platform independence and graphical platform independent interface (initially targeted to both Apple Macintosh and Microsoft Windows with good chance that one of them will take market over ? and it did happen, including the acquisition of Great Plains Software by Microsoft). In this small article we'll give you revised overview ? you can find previous publication in the last year posts.

? Great Plains Dexterity. Dexterity is the architecture of Great Plains and it is very difficult to take it out of the picture. So we'll say that if you plan on creation GP module or custom piece for reselling it on the market ? you should first consider Dexterity as a tool. Dexterity requires deep training and some experience ? you can not begin programming in Dexterity over night. So-called fat client of Great Plains is pure dexterity application, however database itself since version 8.0 is MS SQL Server with some Dexterity specifics (DEW_ROW_ID column, for example).

? Old Tools. These tools were popular in 1990th and relate to such now legacy technologies as OLE, VBA scripting, etc. Please note that even if C was considered as universal language ? custom scripts were targeted for light customizations and both C and VBA were targeted to modify fat client ? thin client and web interface were not known those good old days.

1. VBA/Modifier. Microsoft introduced VBA as scripting for light customization of Microsoft Office products ? Excel, Word, etc. Great Plains adopted it for its own needs. It tried to produce Dexterity/VBA hybrid and allowed Dexterity forms to be modified via Modifier (Dexterity application) and enabled modified screens to adopt VBA for its fields.

2. Continuum for VB/Dephi. Borland was strong on the customization market ? this is why it also includes Delphi. In Continuum you can program Great Plains workstation as OLE server. For example ? you can have Great Plains Integration Manager integrate several companies data one-by-one with automatic logging in and off without operator intervention ? over night for example. Also ? you can deploy Continuum to switch Dexterity modules (such as Intellisol APOP or Project Accounting) and include Dexterity Sanscript code into VBA scripts.

3. ReportWriter. We placed RW in this section because it is Dexterity application and is now actively replaced with new tools, such as Crystal Reports, SQL Reporting, XML & HTML web publishing

? New Tools. In XXI century development world begins to bias toward thin and web clients and SQL scripting. eCommerce is a must for retail and wholesale nationwide businesses and Microsoft Business Solutions come with these tools:

1. eConnect. As good instrument for eCommerce developer ? it allows to create, modify and delete Great Plains objects ? customers, invoices, purchase orders, payments, inventory items. It has certain restrictions ? it can address core Great Plains objects (not something in former third party modules ? Collection Management, Customer/Vendor Consolidation, etc.). Also eConnect can not post SOP, AR, AP, POP documents ? posting should be done by operator in Great Plains. However you can deploy posting stored procedures, available on the market (through Alba Spectrum for example)

2. Extender. Let's see it in action in the following year. The idea is really nice and it allows non-developer to modify Great Plains screens and place custom logic

You can always appeal to our expertise. Give us a call: 1-630-961-5918, 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.

---

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

7 Things to Consider Before Buying Small Business Accounting Software

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

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

EDI: Electronic Document Interchange for Microsoft Great Plains ? Overview for Software Developer/Pr

Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More

Five Reasons for Using an O/R Mapping Tool

So, why should you use any O/R mapping tool? I... 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

10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now

Is Photoshop CS2 worth the upgrade? You bet it is!... Read More

Microsoft Great Plains RW: Report Writer

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

Brand Your Websites URL With a Favicon

Have you ever noticed that when you look at your... Read More

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

ERP Consulting: Microsoft Great Plains Partner Future Directions

In the Clinton era the status quo was simple: you... Read More

Why Stick With Email Clients Like Outlook?

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

Free Software: How Not To Get More Than You Bargained For!

I completed an experiment recently. I wanted to find out... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

Understanding XML Server

XML Server can be a Web Server that stores the... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Great Plains Dexterity: Customizations & Source Code Programming

Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

Software Upgrades Arent Always the Best Move

When my daughter was getting into AOL instant messaging (AIM)... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... 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 Great Plains Integration Manager ? Working With Text File

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

Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

Great Plains Fixed Assets Management module is a robust tool... Read More

My Experience - Making a Vision into Reality

Disclaimer: All the thoughts expressed are my views only! Your... Read More

Microsoft Great Plains Customization Tools ? Overview

Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More

5 Time-Saving Tips in Microsoft Word

Whether you have used Microsoft Word for years, have just... Read More

OS 101: Suggestions for Choosing an Operating System

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

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

Increase Office Efficiency With One Simple Tool

When you need a phone number, you do a quick... Read More

Microsoft Great Plains eCommerce ? Stored Procedures Approach

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

Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

This is a short article, written in question/answer/FAQ style to... Read More

Microsoft Great Plains Integrations ? Retail Management Sample

Microsoft Business Solutions is emerging as very attractive vendor for... Read More