Tools for Customizing Great Plains

Microsoft Business Solutions ? Great Plains has captured the US market with its integrated business applications for small and mid-size organizations. Its comprehensive accounting and business management capabilities provide businesses with tools to customize various modules of the Great Plains software. These tools have been proven to have contributed to business growth and tighter control over its processes.

There are several ways in which customization and integration can be applied to Great Plains applications because of its open architecture characteristic. Integrity of data and performance of processes can also be validated using one of the many tools as listed in this article. So how do we answer the question of Customizing Great Plains?

Dexterity

Although Dexterity requires the user an extensive knowledge in software development (primarily in C/C++ or Pascal) and experience in scripting languages (VBScript, or Dexterity's own script - SanScript), this proprietary programming language that Great Plains was developed in allows access to all of Great Plains resources such as tables, reports and scripts. With this access, you can manipulate and define triggers such as opening a form or leaving a field. Moreover, it can be used to call up procedures and functions and create new applications without interfering with other customizations already in place and integrate them into Great Plains user interface easily.

Dexterity can be installed using CD #2 that comes with the Great Plains 7.5 package.

Modifier with VBA

Modifier with VBA is one of the simplest tools to have for end-users and developers alike. It uses common graphic drawing techniques which can be used to alter the appearance of a Great Plains application. It can be used to move, alter or delete menus within a window so that you can manipulate the importance of each field. It also allows for addition of new windows or controls or simply rearranging those that exists. This customization tool is safe to use since the original information is stored separately from the modified one. Modifications can also be shared with other users. However, unlike Dexterity, it is not recommended to create new applications with Modifier VBA.

Continuum for VBA/Delphi

This tool uses Great Plains as an OLE Server. It captures the VB or Delphi code as queried by the user for macro recording. However, we do not recommend it since it is an old technology.

Crystal Reports

Great Plains comes with its own Report Writer. However, its functionality is limited. Introducing Crystal Reports to Great Plains opens up a whole new world of creating reports. With the use of the Crystal Report Designer Interface, you can easily create complex reports with formatting and grouping just the way you want it ? professionally done. Grouped data can be summarized and subtotaled and with its drill-down capabilities, the user can view report data in detail.

Crystal Reports also came up with a version for Visual Studio .NET. With all the features of Crystal Reports 8.0, the Visual Studio .NET version gives .NET users the flexibility to share information and reports over the internet. Through the use of Database drivers, Crystal Reports connects to the Great Plains database and accesses the specific data as queried by the user and selects the tables or views according to the user's proposition.

In Great Plains, the Tables structure can be found in: Tools > Resource Description > Tables

Direct Web Publishing

If you're looking to publish your Great Plains information over the Internet, then using Visual Studio .NET is the right tool to use. It allows the deployment of Web-based applications and XML Web Services and can be leveraged by the use of programming languages like Visual Basic .NET, Visual C# and Visual J#.

eConnect

Integrating data from outside sources, such as your point-of-sale applications, customer relationship management applications and Web services, to your Great Plains application is what eConnect is all about. eConnect can filter data or add script to the business object according to the specified diagram. It enables for limiting the number of values entered in a field or setting a default value for the field. Although eConnect promises integration, it asks for advanced programming skills. It uses a number of different programs including Microsoft SQL Server, Visual Basic objects and extensible markup language (XML).

Integration Manager

Converting and transferring data (importing) from one database format (ODBC-compliant) to a Great Plains application can be done with the use of Integration Manager. This tool enables the end-user to map the data source to the target field without the need to search from the database tables. SQL queries can also be defined to accompany your integration and data validation. Integration Manager requires development experience with a background in database maintenance, SQL commands and VBA or VBScript to name a few.

SQL Queries

Microsoft SQL Server is a database engine that gives users tools for creating, configuring and maintaining databases. It is integrated directly into the Great Plains database. Its Query Engine enables you to create statements to call up certain information from the database. Although this is a powerful tool, SQL queries should only be done with experienced hands. One false statement could wipe out your database.

The smooth operations of your business depend on YOU. With the right experience and education, these tools for customizing your applications and database can lead your business to a better ground.

Need more information?
Contact us: 1-866-528-0577

help@albaspectrum.com

For customization work and advice, please contact Andrew Karasev, Alba Spectrum Chief Technology Officer. His works include development of applications with the use of Dexterity, SQL, C# .NET, Crystal Reports and Microsoft CRM SDK.

Divine Rigor is the Technical Writer for Alba Spectrum Technologies USA ( http://www.albaspectrum.com ), a Great Plains, Microsoft CRM customization company. We are based in Chicago with locations in California, Arizona, Texas, Florida, Georgia, New York and contacts in international markets.

---

SyncUp ? A File/Folder Synchronizer For Windows

SyncUp, a file synchronizer is designed to assist the home... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

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

How to Choose the BEST Charting Software

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

Navision Attain Database access via C/ODBC in ASP.NET Application

Navision Software was purchased by Microsoft and now it is... Read More

Constructionalist Parsing - Deciphering Natural Language

The research in the field of Natural Language Processing usually... Read More

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

Microsoft Great Plains in Metal Distribution: Implementation & Customization ? Consultant Overview

Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More

Top Questions to Ask Before Buying a Help Desk & Asset Management Software

#5 All your hardware components like Printers, PCs etc come... Read More

Microsoft Great Plains Customization Tools ? Overview

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

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... 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 Implementation for Midsize & Large Corporation: Lockbox Processing

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

Reporting Tools for Microsoft Great Plains ? Overview For Developers

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

Great Plains Dexterity Programming ? Overview For Developer

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

The Importance of Timely Timesheets

Whether you are a small consultancy firm, a medium sized... Read More

Looking for an Alternative to Microsoft Office? You Should Be!

Now is the time to look at an alternative to... Read More

Antivirus Software ? Get The Bugs Before They Get You!

You turn on your computer, and it doesn't look quite... Read More

Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

With this small article we are continuing Microsoft Business Solutions... Read More

RFID: Strengthen the Position for SAP; United States

SAP Inc., a global leader in client/server enterprise application software... Read More

Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

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

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Review on QuarkXpress 6.0

After almost two decades of existence, Quark has become the... Read More

Defining OLAP Solutions and Data Warehouse design

This tutorial covers OLAP solutions used by Data warehouses and... Read More

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

Usually, the easiest way to tell you have spyware is... Read More

Programming Environments And The Software Production Process

Introduction: The creating of a computer program involves a number... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Bridging the Gap between Paper and Data

The cornerstone of successful automated office systems is the ability... 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

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

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

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More