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
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
Great Plains Inventory Management (IV) module gives your business a... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
Let us give you - developer some hints in the... Read More
While I was in college, if you would have asked... Read More
Software development is a risky business.Many software developers are barely... Read More
Let's say that you have a software project that's under... Read More
Our hosted solution allow you to run your own search... Read More
ERP Consulting industry is on the way to serve clients... Read More
This article will not attempt to advocate the use of... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
The most important benefit of XML is its simplicity. Though... Read More
Is your PC is slow and wimpy? Then you need... Read More
I have yet to see a business that, sometimes in... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Are you a database professional? Do you work with a... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
This is a short article, written in question/answer/FAQ style to... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
For those who are unclear on the differences between the... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
And kill the best layout software in the process of... Read More
Do you remember that frustrating feeling when you find an... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Well, even if the combination might look very unusual, we... Read More
Find out why Spyware Removal from computers is important and... Read More
In our case ? we serve Microsoft Business Solutions ERP... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
If you company is small or mid-size special products or... Read More
Once upon a time not so long ago, there was... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
You might think you don't need a firewall... Read More
When you need a phone number, you do a quick... Read More
If you are in a business that passes documents around... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
The Internet is reshaping every form of communications medium, and... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
The world of small business accounting software can be a... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
Usually, the easiest way to tell you have spyware is... Read More
Software |