Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently we see increased interest for Great Plains customers to do in-house Dexterity development and customization. Dexterity itself is written on C programming language and its initial architecture was based on the Graphical and Database platform independence, which C programming language was believed to provide. Initially back in 1994 Great Plains Software Dynamics and Dynamics C/S+ were realized for Macintosh and Windows and pretty similar Dexterity DYNAMICS.DIC dictionary worked for Ctree/Faircomm and Microsoft SQL Server 6.5. In our days Microsoft Great Plains is available for Windows and MS SQL Server only (since version 8.0). In this small article we would like to give you highlights on the most typical entry level Dexterity development questions

? How do I install Dexterity. If you have Microsoft Great Plains Standard or Professional license, you Great Plains CD #2 has Dexterity installation files. However you need license from Microsoft Business Solutions if you plan to do in-house software development. If you have Small Business Manager / Small Business Financials ? your distributive doesn't have Dexterity ? you need to call your MBS partner and have them to do the job.

? DYNAMICS.DIC. This is your core dictionary which should be used for your customization.

? New Custom forms vs. Alternate Forms. If you are beginner, please try to stick to new Great Plains Forms. Do not customize existing forms. If you open existing form in Dexterity ? you should be aware that field scripts are stripped off and if you place your own script over the original one ? you will destroy the field logic

? Dexterity Triggers. You register them in Startup script ? look Dexterity manual. If you have to deal with existing fields logic alteration you register before or after original script trigger. Please see the examples.

? SQL Stored Procs. Latest version of Microsoft Great Plains is available for MS SQL Sevrer/MSDE only and you should consider combination of Dexterity and Stored procs. Try to avoid using old Dexterity cursors, statements, like: start range. Hint ? ranges were the instrument of database platform independence and it seems to be not the case anymore.

? Dexterity Chunk. You should be aware that Dexterity reserves certain range of the resources for MBS internal developers, you can not modify and use these resources, all the custom resources you create in your customization will use the numbers outside of the proprietary range. Your new resources will be packed into so called chunk. Please refer to the manual on how to create the chunk.

? Customization Upgrade. The most challenging portion of upgrade is Alternate Great Plains forms. If you place custom fields and logic on the existing forms then, you should know that Great Plains can change the form for the new version and you will have to review and redo the custom logic.

? Localization. Dexterity has string resources ? this is where you can translate the strings and have Great Plains work with your native language. However your native language code should be single byte, not Unicode. If you need Dex to work with Chinese, Japanese or Korean ? there is special utility to enable this feature.

Happy customizing! You can always appeal to us to help you with your system. Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ( http://www.albaspectrum.com ), Microsoft Business Solutions Great Plains, Microsoft CRM, Navision, Microsoft RMS, Microsoft Business Portal customization company, serving clients in Chicago, Boston, New York, Miami, Atlanta, Houston, Dallas, Denver, Los Angeles, San Francisco, San Diego, Seattle, Minneapolis, Phoenix, Toronto, Montreal, Brazil, Mexico, UK, Australia, Canada, UK, Europe, Russia an having small offices in multiple states and internationally.

---

Can Group Collaboration Software Meet Business Needs?

According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

Why Java RDBMS?

It is a well known fact that Java as a... Read More

Blind CC (Bcc): Master Its Use When E-Mailing

If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

Mapping Software: Putting Data Visualization on the Map

Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

A Symons Mark II Function Point Counting Example

I provide, here clear explanations and a count of function... Read More

Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

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

Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

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

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... 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

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

1. What determines the software price? Is it Per Seat... Read More

Groupware and Online Collaboration: Collaboration Series #4

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

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... 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

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

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

Software: What Suits Me?

Almost all new and major brand of PCs come with... Read More

How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software

Fortunately one of the most common reasons cited for the... Read More

Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

This is intermediate level SQL scripting article for DB Administrator,... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

Create ASP in Minutes

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

20 Extra Hours Per Week: What Would You Do?

While I was in college, if you would have asked... Read More

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

Free Software for Newbies and Web Developers

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

The Secret of the Layer Styles Dialogue

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

Microsoft Great Plains Integration Manager ? Working With Text File

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

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

The Dreaded Paper Label - Should it be Used?

While paper labeling CDs and DVDs may appear to be... Read More