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.
![]() |
|
![]() |
|
![]() |
|
![]() |
The world of small business accounting software can be a... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More
Once upon a time not so long ago, there was... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
This article is the first of a series of articles... Read More
In today's business world it's all but impossible to escape... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
Microsoft Business Solutions Great Plains is very popular ERP platform... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
Microsoft CRM is now on the scene and it is... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
Sometimes your PC will start acting strange for no apparent... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
Navision Software was purchased by Microsoft and now it is... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Now that spyware is the single most dangerous threat to... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
... Read More
If there still are few unprotected computers left, I haven't... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
1. With mapping software you can create a report that... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Remember old good days when your company probably had Great... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
I've been active in the Cisco Certification track for four... Read More
When you double-click a layer in the Layer Palette, you... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
At the end of XX century, in the late 1990th... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
Looking at all the ads which promise to get rid... Read More
Having from five to ten and more favorite screensavers is... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
Spyware and malware are large problems for Internet users today... Read More
If you have Microsoft Great Plains and support it for... Read More
You might think you don't need a firewall... Read More
While Adobe is the most known maker of PDF tools,... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
After almost two decades of existence, Quark has become the... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Find out why Spyware Removal from computers is important and... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Considering whether or not your software company should hire a... Read More
And kill the best layout software in the process of... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
Software |