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 ..No matter how much you enjoy your favorite screensavers, sometimes... Read More
And kill the best layout software in the process of... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
If you are to buy a HelpDesk & Asset Management... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
The software giants don't do everything and don't always produce... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
One day, you suddenly realize that your computer started to... Read More
If you look back to the history, you will see... Read More
I love new technology. I am still ready to wait... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
It's no secret that software companies operate in a very... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
In a previous article, I wrote about OpenOffice... Read More
shuttle from Midway Morris ..Microsoft Business Solutions Great Plains has substantial market share among... Read More
Microsoft Business Solutions Great Plains is very popular ERP platform... Read More
This article is the third of a series of articles... Read More
When Windows fails to boot it is normally caused by... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Before being able to choose a secure Internet communication system,... Read More
Not every software testing project can or should be automated.... Read More
Sometimes your PC will start acting strange for no apparent... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
This is the tutorial where we really get into programming.... Read More
If you have been using the Internet for any amount... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
There are plenty of articles out there about how to... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
In today's business world it's all but impossible to escape... Read More
Imagine something that follows you home and sets itself up... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
2005 ? Back to the Future.What does the future hold?... Read More
If you are to buy a HelpDesk & Asset Management... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
People often ask me: What image file formats will Photoshop... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Software |