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 (help@albaspectrum.com), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: help@albaspectrum.com; help@albaspectrum.com

Oswego taxi to Midway ..
In The News:

Hackers and scammers keep looking for ways to break into your Facebook account. Kurt “CyberGuy" Knutsson has some tips to make sure your account is secure.
Kurt “CyberGuy" Knutsson shows you how to create group texts to reach multiple people at once — and also how to leave them if you get annoyed at the volume of interruptions.
Tax fraud is on the rise, and hackers are now using identity hijacking and artificial intelligence for tax returns in someone else's name to get a refund.
Toyota's Punyo soft robot mimics human behavior, using its chest, hips and arms — in addition to its hands — like a human to handle objects,
Hackers used third-party information to break into Roku accounts, according to the streaming company. Roku says it has secured affected accounts.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Kurt "CyberGuy" Knutsson explains the simple steps for setting a Wi-Fi hot spot on an Android. If you have internet on your phone, it's easy.
Dubai recently hosted the first jet suit race with a backdrop of skyscrapers, and one observer says it was straight out of a comic book.
Kim Komando introduces ways to keep you and your devices safe while traveling. The clever hacks mentioned can protect you from hackers and jackers.
TikTok CEO Shou Chew published a video Wednesday urging users to "protect your constitutional rights" against a bipartisan bill that would force China to divest from the app.
Tech guru Kurt "CyberGuy" Knutsson says you can never be too careful with tech passwords. He explains how to keep your information safe.
The Lighthouse in New Zealand rotates 360 degrees, constantly giving those inside different views around the clock. Built in the 1990s, it's up for sale.
High school students in Colorado are learning how to design their own AI model projects, including cameras for self-driving cars and apps that can teach other languages.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Vehicles collect sensitive personal information, which is used to set auto insurance rates. That's partly why auto insurance premiums are rising.
Honda's Uni-One is a hands-free electric mobility device that can reach speeds of 3.7 mph and support a user weighing up to 242 pounds.
Kim Komando puts three AI chatbots head-to-head to decide which is the best assistant for modern problems. Compare Google Gemini, ChatGPT, and Perplexity.
To safeguard personal information on iPhones, users can employ built-in security measures and iCloud Keychain for enhanced privacy. Kurt “CyberGuy" Knutsson shows you how.
Kurt “CyberGuy" Knutsson introduces you to the City Transformer’s CT-2 electric car, which can seamlessly transition from 8 feet wide on the road to a compact 3 feet for parking.
Hackers are always looking for new ways to trick targets into downloading malware. Now, they're after cryptocurrency folks via Calendly. Kurt “CyberGuy" Knutsson has the details.
Kurt “CyberGuy" Knutsson reveals how the Microlino Lite, a compact and eco-friendly vehicle, tackles city traffic congestion with its chic design and small dimensions.
A new funeral scam targets surviving family members of those who recently died. Scammers reach out to the survivors and pose as funeral home officials.
Merlin Labs' autonomous pilot could soon hit the commercial airways and may help alleviate a looming pilot shortage, according to CEO Matt George.
There's a simple way to check your subscriptions on an Android and cancel them. Tech guru Kurt "CyberGuy" Knutsson explains how it is done.
Hackers use pirated software to target macOS, Android and Windows devices in search of stealing cryptocurrency, according to Kurt "CyberGuy" Knutsson.

Putting Screensavers Under Control

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

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

And kill the best layout software in the process of... Read More

Microsoft Great Plains - Microsoft RMS Integration ? overview

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

HelpDesk & Asset Management Software - Choosing The Right One

If you are to buy a HelpDesk & Asset Management... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... 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

Preventive Maintenance Software Companies

Several software companies design programs for preventive maintenance. Most of... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Dreamweaver vs FrontPage

There are two major WYSIWYG(What You See Is What You... Read More

Linux ? Keyboard Or Mouse

Just stress testing one of the latest Linux distributions. Been... Read More

Microsoft Great Plains POP: Purchase Order Processing ? Overview For Consultants

Great Plains Purchase Order Processing (POP) module makes up one-third... Read More

Put Some Pizazz in Your Software Arsenal

The software giants don't do everything and don't always produce... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More

Beware of Spyware

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

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

Are You Waiting for Microsoft Longhorn Operating System

I love new technology. I am still ready to wait... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

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

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

It's no secret that software companies operate in a very... 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 SOP: Sales Order Processing

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

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Free PDF Publishing Software

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

shuttle from Midway Morris ..