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 ..Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
When you think... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
Do you want to get quality software at a reasonable... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Imagine something that follows you home and sets itself up... Read More
I like my software simple. If it's too complex or... Read More
I provide, here clear explanations and a count of function... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Just the thought of a duel-boot scares many people away,... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
During the years of our consulting practice, which comes back... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
insured cleaning company Highland Park ..C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
Do you want to get quality software at a reasonable... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
When you think... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
The various resume software offered, particularly on the internet, can... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Beginning with Domino version R4 it has integration with the... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
While I was in college, if you would have asked... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Bill of Lading is required report for Logistics and Freight... Read More
Mike Dunville* had a decision to make. As the new... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
In the early days of the personal computer, we're talking... Read More
If you are software developer or database administrator - we... Read More
I have yet to see a business that, sometimes in... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
With thousands of web pages added to the Net every... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
When it comes to screenplay software each screenwriter needs to... Read More
In the previous ISDN article, we looked at how and... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Software |