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 Preventive Maintenance Software?

Preventive Maintenance (PM) is defined as scheduled work done on... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Running a Program on a Remote Server Using SSH

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

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

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

How To Choose A Fire Wall Software Program

In the real world a "fire wall" is a fireproof... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

Let's first look at your ERP system selection (without Retail... Read More

Document Templates Give You The Perfect Framework For Your Documents

When it comes to running an office, the SOHO entrepreneur... Read More

Know-how in Microsoft Publisher

For those who still don't know, Microsoft Publisher helps computer... Read More

Microsoft Great Plains: Large Scale Implementation

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

An Easy Way to Deal with Email Viruses and Worms

If you feel intimidated when someone tries to teach you... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

The Secret of the Layer Styles Dialogue

When you double-click a layer in the Layer Palette, you... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC)

It is possible that if one avoided all sources of... Read More

The Bluebird Project

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

Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

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

Microsoft Great Plains PM: Payables Management

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

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Accounts Payable: A Powerful Document Management and Workflow Solution

Accounts payable is just one area of office management where... Read More

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More

Microsoft CRM USA Nationwide Remote Support

Remember old good days when your company probably had Great... Read More

Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

Microsoft Great Plains serves majority of US based horizontal and... Read More

Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

Microsoft Business Solutions Great Plains is written in Great Plains... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

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

Configure Windows Indexing Service for Performance

The Windows Indexing Service provides you with the ability to... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

Remember nice and prosperous Clinton era? When you implemented innovative... Read More

How to Tell You Have Spyware, Ad-ware or Viruses

Usually, the easiest way to tell you have spyware is... 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