Software informational articles

Great plains custom development: dexterity, vba, sql, crystal, econnect ? overview for programmer - software


Microsoft Great Plains is main Microsoft Affair Solutions accounting container for the US market. It has manifold customization/modification/reporting tools. At present there is upgrade battle to adaptation 8. 0 and due to the discontinuation of the mechanical assistance for Microsoft Great Plains Banner on Ctree and Invasive SQL - we see ample add to in migration needs: migration from ctree/Pervasive to MSDE/MS SQL Server. This in turn increases appeal to customization and customization upgrade.

If you are developer who is asked: how do we make specially Great Plains - read this and you will have the clues on where to look further.

1. Great Plains Adroitness - this is proprietary encoding expression and technology, considered back to ahead 1990th with the goal to build platform all-embracing graphical accounting box up - Great Plains Dynamics. Agility itself is on paper in C (following all the rage those days hope - that C will endow with platform independence). You can establish Adroitness from Great Plains 7. 5 CD #2. Evidently it requires a lot of education / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. Nowadays, nevertheless - and this is a good thing - most of Great Plains installations are moved to SQL Attendant - so you can use Ability for custom forms cartoon only and make the buttons run SQL stored procedures.

2. Modifier with VBA. Alas you have to acquisition this tool and get new registration keys. If you are accustomed with VBA customization for Admittance or Excel - you have all the skills desirable - then you just append your scripts to the buttons and fields on GP forms (you can adapt these forms with Modifier - or just tough them with it).

3. Continuum for VB/Delphi - we don't commend this tool, since it is using Great Plains as OLE ma?tre d' - and you doubtless don't want to be ensnared by old technology.

4. Crystal Reports. Great Plains has its own ReportWriter, but its functionality is inadequate - you can't do cross modules hearsay (you can't link Sales and Purchasing tables in one report, for example). So - you use Crystal. The GP tables arrange is in Tools->Resource Description->Tables ? and you are in control. Feel free to coin views and stored procs at once in the companies databases - it doesn't hurt the Ability engine

5. Direct web publishing from Great Plains SQL databases, using Visual Studio. net and your idiom of amount (VB. Net, C#, J#, etc). Plus you in all probability want to have numerous 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 fashioned for eCommerce developers.

7. Integration Director - it is end-user tool for importing to GP, but if end-user meets some challenges in the integration - you as a developer can help with VBA scripts. IM validates 100% of affair logic and uses covert GP forms - so it maybe slow for big on-going integrations, when you have thousands minutes per day - in this case you rescue to eConnect or candidly to SQL store procedures.

8. SQL queries - as a developer you have boundless capability in using SQL queries, for the reason that the list in MS SQL Server. Be careful, it is kind of surgery - you can by a long shot cross out all your customers, by executing: Obliterate RM00101

Happy customizing! if you want us to do the job - give us a call.

About The Author

Andrew Karasev is Chief Expertise Detective in Alba Spectrum Technologies - USA countrywide Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, Georgia, New York and having locations in numerous states and globally (www. albaspectrum. com), he is Dexterity, SQL, C#. Net, Precious stone Intelligence and Microsoft CRM SDK developer.

akarasev@albaspectrum. com

1-866-528-0577! help@albaspectrum. com

Developed by:
home | site map © 2018