|
Ecommerce InformationMicrosoft Dynamics GP restored
Microsoft Business Solutions Great Plains ERP
by:
Andrew Karasev
Microsoft Business Solutions Great Plains is now renamed into Microsoft Dynamics GP, as well as Microsoft Navision into Microsoft Dynamics NAV, Microsoft Axapta into Microsoft Dynamics AX, Microsoft King into Microsoft Dynamics SL and Microsoft CRM into Microsoft Dynamcis CRM. Of course Microsoft has the plan to choice the most marketing attractive name for its ERP products, however the else side of the renaming may be in the plan to come Project Green forward. At the final phase of Project Green Microsoft strength
drop GP, NAV, AX, SL and CRM extensions and do final version name to be just Microsoft Dynamics. Exciting fact that Great Plains Software, which was the 1st candidate for Microsoft ERP computer code acquisition had Great Plains Dynamics brand, so probably Microsoft is plying retrospection card, in any case Microsoft technically owns GPS Dynamics brand anyway. In this small article we wish give our retro view on Great Plains Dynamics customization, development and reporting.
1. Great Plains Adroitness 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. Adroitness itself is written in C (following popular those days hope that C wish provide platform independence). You can install Adroitness from Great Plains 7.5 CD #2. Manifestly 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 nice thing most of Great Plains installations are emotional to SQL Server so you can use Adroitness for custom forms drawing only and do the buttons run SQL keep procedures.
2. Modifier with VBA. Regrettably
you have to purchase this tool and get new registration keys. If you are familiar with VBA customization for Access or Stand out you have all the skills required 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. Time
for VB/Delphi we dont recommend this tool, because it is victimisation Great Plains as OLE server and you probably dont want to be treed by old technology.
4. Crystal Reports. Great Plains has its own ReportWriter, but its practicality
is limited you cant do cross modules reports (you cant link Sales and Buying 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 keep procs directly in the companies databases it doesnt hurt the Adroitness engine
5. Direct web business enterprise from Great Plains SQL databases, victimisation Visual Studio.net and your language of choice (VB.Net, C#, J#, etc). Plus you probably want to have several SQL keep 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 commercialism to GP, however if end-user meets several 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 peradventure slow for big on-going integrations, once
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 victimisation SQL queries, because the information 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 1-866-528-0577! help@albaspectrum.com
Just about the author:
Saint andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving clients in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, and Miami and having locations in multiple states and internationally ( http://www.albaspectrum.com), he is Dexterity, SQL, VB/C##.Net, Crystal Reports and Microsoft CRM SDK developer.
Circulated by Article Emporium
| |
