Software Information

Microsoft Great Plains: Government & Non-Profit Organization - Workflow Implementation


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


MORE RESOURCES:

GulfNews

New Apple software for iPhone 'bug fixes'
Newsday, NY - 15 hours ago
BY EMI ENDO | emi.endo@newsday.com Apple Inc. has released a software update for its iPhone aimed at improving its connection with faster wireless Internet ...
Apple's iPhone 2.0.2 software update didn't fix much Computerworld
Apple updates iPhone software to fix glitches Reuters
Jobs promises September iPhone software patch InfoWorld
ZDNet - NEWS.com.au
all 567 news articles


BuilderFusion(R) Inc. Named the 11th Fastest-Growing Software ...
MarketWatch - 2 hours ago
"Since its inception eight years ago, the BuilderFusion software has had a dramatic impact on professional associations across the United States, ...


Carnegie Learning(TM) Developmental Math Software Aligns with ...
MarketWatch - 4 hours ago
PITTSBURGH, Aug 21, 2008 (BUSINESS WIRE) -- Carnegie Learning, Inc. announced today that the company's developmental math software for higher education ...


BakBone Software Appoints New Chief Financial Officer
MarketWatch - 1 hour ago
The common shares of BakBone Software are currently subject to cease trade orders in the Canadian jurisdictions of Alberta, British Columbia and Ontario due ...


RTT News

Wall Street Beat: Salesforce, HP, M&A in the Spotlight
PC World - 1 hour ago
Salesforce is often seen as a bellwether for the SaaS (software-as-a-service) market, since it was one of the first companies to jump into hosted software, ...
Salesforce.com shares drop on outlook CNET News
Acquisition Costs Sink Salesforce (Update) TheStreet.com
Salesforce 2Q profit nearly triples, stock plunges Forbes
Register - Wall Street Journal Blogs
all 101 news articles


The Software, Called iClink, Allows Two-Way Wireless ...
MarketWatch - 7 hours ago
The software, called iClink, wirelessly synchronizes contacts, calendar events, and to-do items between the iPhone and Lotus Notes. The iClink software runs ...


American Software, Inc. Invites You to Join Its First Quarter ...
MarketWatch - 6 hours ago
What: American Software, Inc.'s First Quarter Fiscal Year 2009 Earnings Release When: September 4, 2008 5:00 pm ET Where: http://www.amsoftware.com How: ...


Tamale Software Launches Latest Version of Investment-Research ...
MarketWatch - 7 hours ago
The expanded scalability boosts the effectiveness of search and other functions -- making the software an ideal choice for an increasingly wide client base ...


Inc. Magazine Recognizes Nimsoft as the 36th Fastest Growing ...
MarketWatch - 8 hours ago
Last year, Nimsoft was ranked as the 49th Fastest Growing Software Company. This list is part of the Inc. 5000, the magazine's annual list of the fastest ...


Siliconrepublic.com

'No software!' Salesforce.com snaps up software firm
MyCustomer.com, UK - 11 hours ago
Software as a service provider Salesforce.com confirms it has acquired enterprise on-premise player InStranet. It demonstrates the clout of the SaaS sector ...
Salesforce.com To Acquire InStranet For $31.5 Million InformationWeek
Salesforce.com Drops $31.5M for Contact Center Software Firm CRM Buyer
Salesforce Pays $31.5 Million for Product Support Company Barron's Blogs
bMighty.com - IT Business Edge
all 79 news articles

Software - Google News

home | site map
© 2006