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
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
I've been active in the Cisco Certification track for four... Read More
Spyware is software or hardware installed on a computer without... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
If you have Microsoft Great Plains and support it for... Read More
Microsoft Business Solutions Great Plains has I'd say end user... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
In the new era of internet marketing the problem of... Read More
Viruses and spyware usually show up on your computer one... Read More
Domino server is a buffer between the operation system and... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
For those who are unclear on the differences between the... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Now there are Three Steps To Heaven Just listen and... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
In a previous article, I wrote about OpenOffice... Read More
Remember old good days when your company probably had Great... Read More
Remember old good days when your company probably had Great... Read More
Microsoft CRM is new player on the CRM software... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
If you company is small or mid-size special products or... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
While I was in college, if you would have asked... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Microsoft Word is one of the most popular office applications... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
How many steps does it take you to locate and... Read More
It's all about turn times in the eMedia industry! The... Read More
There are certain pluses and minuses in both cases and... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
The java programming language is becoming more and more popular... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
The title of "software engineer" has got to be among... Read More
The world of small business accounting software can be a... Read More
Software |