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.

---

Bridging the Gap between Paper and Data

The cornerstone of successful automated office systems is the ability... Read More

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More

Spyware Protection: A Must for Any Home Computer

Now that spyware is the single most dangerous threat to... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... Read More

Lowering The Risks In Developing Do-It-Yourself Software Projects

Mike Dunville* had a decision to make. As the new... Read More

The Hidden Power of Online Manual

Writing software manuals is boring, isn't it? We often think:... Read More

Free Program Removes Spyware not Detected by Premium Security Scan

What is Spyware?Spyware monitors your surfing habits and sends the... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

Linux Vs. Windows

This article will not attempt to advocate the use of... Read More

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

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

Guide to Software Marketing

Intro This concise article will tell you in plain English... Read More

Microsoft CRM Implementation for Large Corporation ? overview

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

Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

As we could imagine, if you are reading this article... Read More

Fundraising Software ? How Can That Help Me?

Fundraising software lets you connect with donors in a way... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

.Net Charts and Graphs Interact with Businesses and Customers

Bar charts, bar graphs, and any other chart or graph... Read More

Beware of The Pirated Software E-Mail Scams!

You have gotten those E_Mails buy software at deep discounts.... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

Microsoft CRM Development

Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

Protect Your Computer...and Your Business!

We all take the computer for granted. I mean, all... Read More

.NET :Solving the Multiple Inheritance Issue Under .NET Platform

.NET platform does not support multiple inheritance. Do not confuse... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often,... Read More

Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... 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 Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More