Microsoft Great Plains Customization and Development ? Overview for Programmer

When Great Plains Software was designing and developing Great Plains Dynamics/Dynamics CS+/eEnterprise - it placed several fundamental principles into the system

1. Computer platform independence. If you consider the situation in the computer software industry those days (earlier 1990-th) - nobody knew which office computer platform will be the winner: IBM PC clones with Microsoft Windows, Apple Macintosh with Mac OS or something like Sun SPARC. This is why graphical multiplatform idea was popular among software developers. Also there was a myth about C/C++ languages, working similar on all computers.

2. Database platform independence - there was the need for future surviving. Competition on the database market was also very tough: Oracle, Ingress, Sybase, DB2, Ctree/Faircom, Btrieve (Pervasive SQL 2000 later on)

In order to realize these two principles Great Plains Software created its own development environment and programming language - Great Plains Dexterity (DYNAMICS.DIC, REPORTS.DIC, FORMS.DIC are Dexterity dictionaries).

At this point customization standards were clarified:

1. If you need seamless integration with Great Plains Dynamics, working in the realm of Dynamics security and database independent data access/modification - you do it in Great Plains Dexterity.

2. If your customization should be light then you appeal to the customization tools coming with your computer platform. Very soon Microsoft Windows took the market, so VBA was the way to go.

3. As soon as Microsoft Windows kicked Mac OS from the office computers market, standard third party Microsoft-friendly tools were recommended - good example is Crystal Reports

4. When Microsoft SQL Server won the database market - Great Plains Software began migration campaign from Ctree/Faircom, Btrieve/Pervasive SQL to MS SQL Server 7.0 and later 2000

Finally, when Microsoft bought Great Plains Software, Microsoft Business Solutions turned to be more concerned about its ERP products migration and transformation into so-called suites: Microsoft Financial, Microsoft Logistics, Microsoft Manufacturing, Microsoft Human Resources and pretty much abandoned the promotion of traditional tools: Great Plains Dexterity, VBA, ReportWriter, Continuum, Integration Manager. As a temporary patch to enable .Net programming it released such tools as eConnect.

Right now (2004-2005) we are in the transformation phase when old tools, such as Dexterity are still playing important role, but if you are thinking about customization, you probably better consider SQL Server scripts/views/stored procs, if you have customization budget - make a research on eConnect. Try to make as much web publishing in Visual Studio.Net as possible. Use Crystal Reports design and our recommendation is to base Crystal Report on SQL View or Stored Procedure.

Good luck with installation, implementation, customization, development, upgrade and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Washington, Minnesota, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com; akarasev@albaspectrum.com

---

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

Free PDF Publishing Software

In a previous article, I wrote about OpenOffice... Read More

Downloading Spyware Removers: Think Before, not After

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

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Microsoft Great Plains Customization Tools ? Overview

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

Microsoft Great Plains Integration Manager ? Working With Text File

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

Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

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

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

An Easy Way to Deal with Email Viruses and Worms

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

Spyware Statistics -- Whats New in May 2005?

Although statistics often is blamed for various deadly sins --... Read More

Fleet Maintenance Software Reviews

Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

Cisco Certification: Introduction To ISDN, Part V

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

Inherent Dangers Of File Sharing Via The Internet.

Cyberspace has opened up a new frontier with exciting possibilities... Read More

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

Vlans

In order to implement VLANs in a network environment, you'll... Read More

Software For Your Hard-Drive

All your software is stored on a hard-drive. But how... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

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

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Microsoft and Webmasters

Does Microsoft care for WebmastersIt's always been a problem with... Read More

How to Make Own CMS

Every day millions of new web documents emerge on the... Read More

Beware of Spyware

One day, you suddenly realize that your computer started to... Read More

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... Read More

Microsoft Great Plains Middle East - Arabic Language Support

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

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

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

Beware of The Pirated Software E-Mail Scams!

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

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

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

The Death of Windows

I have always regretted how Microsoft price gouges and rips... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Your Computer May Be Infected, Heres How To Check (NOT about virus)

NOTE: Please take time to read on - it may... Read More

Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... 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

Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

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

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More