|
Microsoft Great Plains: Government & Non-Profit Organization - workflow implementation
By Andrew Karasev
Usually workflow &
messaging is realized in CRM and then transactions are just logged into
Accounting/ERP/MRP. In the case of Microsoft Business Solutions products:
Microsoft Great Plains, Navision, Solomon, Axapta the natural CRM choice would
be Microsoft CRM. However typical CRM application targets Sales automation,
which is usually not applicable to government structure, non-profit or public
company (community services, public utilities, churches, charities, etc.).
Not-for-profit organization needs purchasing and requisition workflow, payroll
approval workflow, and in certain cases special General Ledger (GL) transactions
workflow. Microsoft CRM doesn’t provide the functionality. Then how could this
be realized? We'll provide two scenarios to realize this customization:
Lotus Notes/Domino
approach. In Great Plains you
could realize either Great Plains Dexterity triggers or MS SQL database
trigger on certain events (Purchase Order creation, Payroll Transaction, GL
transaction). This event calls COM+ application and this one in turn creates
Lotus objects via Java agent (Lotus Notes Domino should be version 6.0 or
newer). This is basically the bridge. Then in Lotus you have to design
workflow – but this is natural task for Lotus and it is not difficult. Users
should work in Lotus to get transactions approved and when it should be posted
in Great Plains – Lotus calls SQL script against Great Plains company
database. Developer should know Microsoft Great Plains tables structure
Microsoft
Exchange/Outlook approach. This
is the second way – when you do not want to deploy Lotus Domino, and would be
OK with simple messaging and notification through Microsoft Exchange. The
technical realization should either involve Dexterity or SQL trigger, calling
COM object (Dexterity) or simply sending notification email from MS SQL
Server. The scenario to post or take off hold from Great Plains transaction
could be realized via MS Exchange event sink – this MS Exchange event handler
will check all the messages and when the one has certain criteria – it calls
MS SQL Server stored procedure in the Great Plains company database
Programming Tools.
Java agent to address Lotus – you need either Sun JDK or somewhat more
advanced: VisualCafe or JBuilder. Great Plains Dexterity trigger should be
done in Dexterity IDE – this language requires expertise and it is difficult
to code without experience, Microsoft Exchange event sink should be programmed
in Visual Studio as COM+ application, then you need to register COM+
application through Control Panel->System->Component Services
Feasibility. To be honest and do not set unrealistic expectations – this
Workflow implementation is pretty serious project and we do not recommend if
for small non-profit organization – it is rather for large and
mid-size-to-large structure.
We encourage you to
analyze your alternatives. You can always appeal to our help, give us a call:
1-866-528-0577 or 1-630-961-5918,
help@albaspectrum.com About the Author Andrew Karasev is Chief
Technology Officer at Alba Spectrum Technologies (
http://www.albaspectrum.com ), serving Microsoft Great Plains, CRM, Navision
to mid-size and large clients in California, Illinois, New York, Georgia,
Florida, Texas, Arizona, Washington, Minnesota, Ohio, Michigan
Article Source: http://www.simplysearch4it.com/article/4305.html
If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/4305.html" as shown above and make it hyperlinked. |
Some other articles by Andrew Karasev | SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would like to recommend SAP BO as ...
SAP Business One in Illinois: implementation, upgrade, customization, integration Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size businesses, engaged in light assembly, shipping and ...
SAP Business One Chicago Market Review, plus customization, integration & data conversion SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, now it is part of SAP ERP brand. This ERP application ...
Microsoft Dynamics GP Office Stack Integration advances – Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity is still a core of fat client workstation plus it defines ODBC Dex database access, requiring ...
eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and ...
Microsoft Dynamics GP Dexterity Customization Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual Studio development, eConnect, XML: Web Services.
Alba Spectrum Group ...
|
|
| |