As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into Microsoft Great Plains and Microsoft Business Solutions is in process of merging all its accounting applications: Great Plains, Solomon, Navision and Axapta into somewhat granular: Microsoft Financials, Microsoft HR, Microsoft Distributions, Microsoft Project Accounting, etc. So the original design of Great Plains should be deemphasized. But even now - Great Plains is written on the programming language and technology, created in early 1990-th, named Great Plains Dexterity. And the graphical interface looks very user friendly and nice - these are all Dexterity forms and screens.
The original architect of Dexterity, Tim Brookins, pursued several goals, the main are these:
1. Engine, supporting graphical interface, which is computer platform independent - if you remember those days - the main competition was between Macintosh and Microsoft Windows. Mac was graphical and very popular, but Windows, backed by IBM cloning/platform openness was very dangerous competitor. The new engine was targeted to work on both: Mac and Windows. On the other hand - nobody could look at the future far enough to be sure that other competitors from both Hardware and Operating Systems sides not going to take over. This is why the graphical platform independent engine was required for the new type - Graphical accounting/ERP system: Great Plains Dynamics.
2. Database platform independence - initially Great Plains used Ctree (available for both PC and Mac) and Btrieve, later on with Microsoft SQL Server 6.5 Great Plains relatively easy introduced it as a new alternative: Dynamics C/S+ on SQL Server. Again - nobody could guarantee which DB will be a winner. Technically Dexterity could easy provide DB switch. Unfortunately - the necessity to support "cheap" databases, such as ctree forced Dexterity architect to use cursors or loops instead of providing aggregation, available on all SQL blends.
To resolve these goals, and following popular those days believe that C programming language is platform independent, C was chosen as the low level language to write dexterity itself.
This was the story, now to the practical side. You can install Dexterity from Great Plains 7.5 or 8.0 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface.
1. Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases ? you use Dexterity ranges and loops to manipulate the records
2. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server ? so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.
3. COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects ? you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet.
4. Dexterity Forms ? if you like VBA and are comfortable to do all the business logic in VBA ? you can use Dexterity as new forms creator/editor. This is OK ? but you have to purchase VBA/Modifier and Customization Site Enabler from MBS.
Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary ? DYNAMICS.DIC. If you need cross dictionaries customization ? consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary.
Happy customizing! if you want us to do the job - give us a call!
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, Arizona, Florida, Georgia, New York and having locations in multiple states and internationally www.albaspectrum.com, he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
disinfecting cleaning services Arlington Heights ..In our opinion, traditional approach when you select ERP/MRP system... Read More
Sales are all about leverage, because there is only so... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
Is your PC is slow and wimpy? Then you need... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
If you have been running Windows XP for a couple... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
(1) Avoid using the same variable again and again for... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Designing without tables by using CSS layouts is fast becoming... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Every day millions of new web documents emerge on the... Read More
If you would like to pick something from Microsoft, or... Read More
Program Flow is what you think it is. How the... Read More
The fact that a software tester is a most infamous... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Software development is a risky business.Many software developers are barely... Read More
How many steps does it take you to locate and... Read More
When it comes to screenplay software each screenwriter needs to... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
bathroom cleaning service Mundelein ..SOFTWARE PIRACY We regularly hear reports... Read More
When you think... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Are you lost in the mess of documents that get... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Is your PC is slow and wimpy? Then you need... Read More
One day, you suddenly realize that your computer started to... Read More
How to delete the user? This is the first problem... Read More
Accounts payable is just one area of office management where... Read More
The title of "software engineer" has got to be among... Read More
When Windows fails to boot it is normally caused by... Read More
Buying accounting software is a major investment. It's an important... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
Handling character strings in Java is supported through two final... Read More
I have recently created my first Php program. I wanted... Read More
This short paper will expand on two key reasons to... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
You've finally created databases that you can actually use to... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
When you visit department stores and see that majority of... Read More
Software |