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
Alto Pass chicago limos ..Microsoft Business Solutions ? Great Plains has captured the US... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Remember back in the days where screensavers were the coolest... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
It???s easy to understand why you might be drawn to... Read More
Not every software testing project can or should be automated.... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Looks like Microsoft Great Plains becomes more... Read More
There are several kinds of software piracy. The bottom line... Read More
... Read More
(1) Avoid using the same variable again and again for... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
We would like to give you several situations, when you... Read More
The US House of Representatives has recently passed the "Spy... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
If you are in a business that passes documents around... Read More
It is really interesting that a bug can create problem... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
Alto Pass cool limo ..Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
At the end of XX century, in the late 1990th... Read More
It is possible that if one avoided all sources of... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
How do you run a program on a remote server... Read More
We would like first emphasize the change in the paradigm.... Read More
If you would like to pick something from Microsoft, or... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Usually workflow & messaging is realized in CRM and then... Read More
IntroductionPHP can be used for a lot of different things,... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
Music downloads are off the charts! We're listening to digital... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Finally, you have some time to personalize your desktop with... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
Crystal Reports is the most flexible tool on the market... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
It's no secret that software companies operate in a very... Read More
As seeing large number of implementations ? in our case... Read More
The adware and spyware definitions list is very long. But... Read More
It is now common thing when large corporation selects mid-market... Read More
Not all of us have the luxury of working both... Read More
Software |