|
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 Male monarch
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 different side of the renaming may be in the plan to come Project Green forward. At the final phase of Project Green Microsoft power drop GP, NAV, AX, SL and CRM extensions and do final version name to be just Microsoft Dynamics. Engrossing fact that Great Plains Software, which was the 1st candidate for Microsoft ERP 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 Adeptness 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. Adeptness itself is written in C (following popular those days hope that C wish provide platform independence). You can install Adeptness from Great Plains 7.5 CD #2. Apparently 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 captive to SQL Server so you can use Adeptness for custom forms drawing only and do the buttons run SQL hold on
procedures.
2. Modifier with VBA. Alas you have to purchase this tool and get new registration keys. If you are familiar with VBA customization for Access or Surpass
you have all the skills necessary 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 mistreatment Great Plains as OLE server and you probably dont want to be cornered 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 Purchase
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 hold on
procs directly in the companies databases it doesnt hurt the Adeptness engine
5. Direct web business from Great Plains SQL databases, mistreatment Visual Studio.net and your language of choice (VB.Net, C#, J#, etc). Plus you probably want to have several SQL hold on
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 commerce 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 mayhap 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 mistreatment SQL queries, because the info
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 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
| |