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
move in cleaning service Mundelein ..Ad-Aware and Spybot are probably the two most well known... Read More
Adware is a type of Spyware program that displays some... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
How many steps does it take you to locate and... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Pirated software is on the increase and now accounts for... Read More
Microsoft Business Solutions is now in process of creating so... Read More
As we could imagine, if you are reading this article... Read More
In the new era of internet marketing the problem of... Read More
I have always regretted how Microsoft price gouges and rips... Read More
A wiki is an editable text-based website. But you don't... Read More
What is Software?Software is a set of instruction written to... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
In part III of this ISDN primer, we learned that... Read More
When you think... Read More
If you look back to the history, you will see... Read More
insured cleaning company Highland Park ..Many reasons made GBM a unanimous choice for experts, one... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
IntroductionPHP can be used for a lot of different things,... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
The most important things you can do for your computer... Read More
The Windows Indexing Service provides you with the ability to... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
When it comes to screenplay software each screenwriter needs to... Read More
Microsoft Business Solutions Great Plains has I'd say end user... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
It could just be me, but my experiences with document... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
A wiki is an editable text-based website. But you don't... Read More
An integral part of any quality CRM system is lead... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Software |