Great Plains Custom Development: Dexterity, Vba, Sql, Crystal, Econnect ? Overview For Programmer
|
Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. It has multiple customization/modification/reporting tools. Currently there is upgrade campaign to version 8.0 and due to the discontinuation of the technical support for Microsoft Great Plains Standard on Ctree and Pervasive SQL - we see substantial increase in migration needs: migration from ctree/Pervasive to MSDE/MS SQL Server. This in turn increases interest to customization and customization upgrade.
If you are developer who is asked: how do we customize Great Plains ? read this and you will have the clues on where to look further.
1. Great Plains Dexterity ? this is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package ? Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope ? that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. Nowadays, however ? and this is a good thing ? 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.
2. Modifier with VBA. Unfortunately you have to purchase this tool and get new registration keys. If you are familiar with VBA customization for Access or Excel ? you have all the skills needed ? then you just attach your scripts to the buttons and fields on GP forms (you can modify these forms with Modifier ? or just tough them with it).
3. Continuum for VB/Delphi ? we don't recommend this tool, because it is using Great Plains as OLE server ? and you probably don't want to be trapped by old technology.
4. Crystal Reports. Great Plains has its own ReportWriter, but its functionality is limited ? you can't do cross modules reports (you can't link Sales and Purchasing tables in one report, for example). So ? you use Crystal. The GP tables structure is in Tools->Resource Description->Tables ? and you are in control. Feel free to create views and stored procs directly in the companies databases ? it doesn't hurt the Dexterity engine
5. Direct web publishing from Great Plains SQL databases, using Visual Studio.net and your language of choice (VB.Net, C#, J#, etc). Plus you probably want to have several SQL stored procs.
6. eConnect ? this tool is type of SDK with VB.net samples. It allows you to feed data into Great Plains and was primarily created for eCommerce developers.
7. Integration Manager ? it is end-user tool for importing to GP, however if end-user meets some challenges in the integration ? you as a developer can help with VBA scripts. IM validates 100% of business logic and uses hidden GP forms ? so it maybe slow for big on-going integrations, when you have thousands records per day ? in this case you rescue to eConnect or directly to SQL store procedures.
8. SQL queries - as a developer you have unlimited potential in using SQL queries, because the database in MS SQL Server. Be careful, it is kind of surgery - you can easily delete all your customers, by executing: DELETE RM00101
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, Arizona, Texas, 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.
1-866-528-0577! help@albaspectrum.com
|
|
|
Spyware: What It Is And How To Combat It
Spyware is software or hardware installed on a computer without the user's knowledge which gathers information about that user for later retrieval by whomever controls the spyware.Spyware can b...(related: Software)
Freight Forwarding Erp: Microsoft Business Solutions Great Plains Customization & Setup ? Overview
Microsoft Great Plains may be recommended for international freight forwarding / transportation company. Great Plains has such features as multicurrency (Euro, Pound, Yuan, Yen, Peso, Real), Spanish, French, Brazilian Portuguese (and if needed Unicode-specific languages such as Chinese, Japanese). ...(related: Software)
Call Alert Notifications - Free Answering Machine Software For Pcs
If you're online using a dialup Internet connection, you'll probably want to download one of the free call alert software applications like Callwave or AOL Call Alert that can answer, record, and forward incoming calls to your home, office or cell phone. In fact, if you run a small business, Call Wave also offers a dedicated business fax service too. These software offerings are fully reviewed online at http://www.callalertreviews.com.Call alerts are important if ...(related: Software)
Four Easy Ways To Prevent Spyware
How would you like to prevent spyware and adware from getting into your computer? You need to stop adware and spyware before it gets into your files. That way you're protecting your private information such as passwords, credit card numbers and other documents that you don't want to share with anyone.Spyware and adware removers are important because they clean your computer of malicious files. But the best thing you can do is prevent spyware from ever being installed in the first place. Her...(related: Software)
Online Powerpoint Presentation ? Convert Powerpoint To Flash
Although we don't know whether Microsoft ever envisioned such a big market about PowerPoint on its first release. Today this software is impacting profoundly on education and corporation's activities in the way that nobody could ignore. With a wealth of visual and audio effects people rely on it to express their ideas, plans more intuitively with more effective communication outcomes.One of most wildly PowerPoint application exists in education. With the booming of Internet, traditional education approaches have been eclipsing by various new emerging ways. And in spite of heavy promotion of supposedly new television educational approaches in recent years, from my point of view, the real innovation and revolution is taking place somewhere els...(related: Software)
Microsoft Navision Customization Upgrade ? Tips For Programmer/it Specialist
Currently Microsoft Business Solutions is on the way of creating so-called suites: Microsoft Financials, Microsoft Distributions, Microsoft HR, Microsoft Manufacturing. It is very difficult to say which product will be the core of which suite, but the best guess is this: Microsoft Great Plains - Microsoft Financials and probably Distribution/Supply Chain Management and HR, Solomon - Microsoft Project or Professional Services, Navision - Microsoft Manufacturing. If you have Microsoft Business Solutions Navision and support it for your company then you need to know some technical details about Navision version upgrade and what is going on behind the scenes, which options do you have in case of C/SIDE customization or Jet Reports.The challenge of Navision Upgrade This should be unde...(related: Software)
Where To Find Free Fleet Maintenance Software
Costs of fleet maintenance software can vary widely. It is generally expected that the fleet manager will look at the needs of the company to determine what software package is best suited for their particular needs. Depending upon the size of the company, number of vehicles to be maintained and services of ...(related: Software)
Lotus Domino Implementation And Development: Infrastructure ? Present And Future
Domino server is a buffer between the operation system and the application. On the other hand Domino server ? consists of the services which support development processing and executing of dynamic, secure applications for Internet, Intranet, or Extranet. Domino server role is to provide functionality both: within and between Domino-applications....(related: Software)
The Importance Of Timely Timesheets
Whether you are a small consultancy firm, a medium sized accountancy practice, or a code warrior for hire in a back room of your house then you have at least one thing in common: you are in business to get paid quickly, and for the work you have done. Timesheets are the usual method for tracking time you spent working and thus are the key to timely invoice generation. Timely invoice generation and despatch is impo...(related: Software)
Spyware, Adware, Etc. -- Terms And Common Sense
When reading an article where some term is used often, it is useful to make sure the author of the article and you mean the same. Not surprisingly for those who still remember English lessons at school, every noun ending with "ware" is a mixture of objects having something in common--usually used for similar purposes. So it tends to be when "ware" is short for "software"; sometimes it's pretty tricky ...(related: Software)
.net Charts And Graphs Interact With Businesses And Customers
Bar charts, bar graphs, and any other chart or graph used in financial statements, inventory reports, sales reports, and a slew of other types of reports have typically been paper reports or online reports depicting various levels of complex information for tracking, investing, planning, and buying. However, until the .net graph, .net chart, .net map, and other .net charts came along, the relationship between management and the company, companies and their investors, and companies and their customers was missing.Interactivity is just one attribute of .net technology, a technology which is spreading across the nation as companies recognize it as a bridge over the gap between them and investors, customers, clients, a...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software