Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation > NetSparsh - Viral Content you Love & Share

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,

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( ), 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

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at


7 of the best antivirus software options
Finally, you need software that provides an on-demand malware scan, as well as a vulnerability scan, so that you're always in control of what's going on with your data. Security is a fast-moving field so you want software that keeps on top of new ...

and more »


How An Event Planning Software Platform Went Global Overnight
So, along with designer Mickey Switzer Schubert-Suell and software engineers Niels Schmidt Hansen and Deividas Jackus, Hadzic decided it was time to create a better solution, something that could free up the event organisers' time, be easy to use ...

Financial Times

Paul Allen, software pioneer, 1953-2018
Financial Times
If history gives you only one shot at making a real difference, then Paul Allen seized his with both hands. The Microsoft co-founder, who has died at the age of 65, did not exhibit the charisma and drive that made Bill Gates the main force behind the ...
Paul Allen, who co-founded software company Microsoft, has died age 65The West Australian

all 1,809 news articles »


Perforce To Acquire Perfecto Mobile, Because Software Change Is A Constant
Software changes all the time. Even the most non-technical user will probably know this due to the ubiquity of the smartphone and the fact that we are constantly being told to 'install updates' on our devices and get the latest version of our favorite ...


Review: Google Pixel 3 and Pixel 3 XL
But current iPhone users still might not feel Google's extensive software smarts can outweigh the benefits and conveniences that come with iOS. Maybe all of their friends and family are using iMessage on iPhones, and they're wary of losing cross-device ...
Pixel 3 XL review—Google software deserves better than this hardwareArs Technica
Alphabet's Google Pixel Event Isn't About Phones, It's About the SoftwareYahoo News
Pixel 3 and 3 XL review: Google's hardware takes a backseat to softwareEngadget
XDA Developers (blog) -New Zealand Herald -YouTube -Google Product Forums
all 378 news articles »

Government Technology

Gunshot Detection Company ShotSpotter Acquires Predictive Policing Software
Government Technology
ShotSpotter, a gunfire detection system for police departments, signaled a move toward proactive enforcement this week by acquiring HunchLab and its crime-prediction software, according to a news release. Now called ShotSpotter Missions, HunchLab's ...


Celonis brings intelligent process automation software to cloud
Celonis puts software and machine learning to bear on the problem. Co-founder and CEO Alexander Rinke says that his company deals with massive volumes of data and moving all of that to the cloud makes sense. “With Intelligent Business Cloud, we will ...

and more »


Software issue with Indiana voter registration system appears to be fixed
This was sparked by a software issue. For three days, it slowed the entire voter registration system down. Clerks couldn't check to see if people who wanted to vote with an absentee ballot were even registered to vote. Now that it's fixed, clerks are ...


Reusable software for high performance computing
Chandrasekaran is an expert on parallel programming—writing software code that can run simultaneously on many multi-core processors. Parallel programming is an increasingly important discipline within computer science as more and more universities ...

Information Age

New government software Code of Practice: security must be built from the code up
Information Age
Providing concrete guidance to manufacturers while also raising public awareness of these issues can only help address the gap that currently exists. It's not just about the hardware anymore, it's about the software behind it, and it's really ...
Code of Practice for Consumer IoT Security - Global Data ReviewGlobal Data Review

all 332 news articles »
Google News

Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for... Read More

Know Linux

Linux essentials:It's free for download but you have to pay... Read More

Photoshop Files and Formats

People often ask me: What image file formats will Photoshop... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More

Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

Bad News - the Threat is Bigger than it SeemedHow... Read More

Spyware - The Internet Devil Of Our Times!

Spyware and Adware infest over 90 percent of computers in... Read More

What To Do When Windows Wont Boot

When Windows fails to boot it is normally caused by... Read More

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

Artificial Intelligence And Intuition

The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

Microsoft Great Plains - Microsoft RMS Integration ? overview

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

Microsoft Great Plains Payroll Module Customization Scenarios

It is now common thing when large corporation selects mid-market... Read More

Programming Environments And The Software Production Process

Introduction: The creating of a computer program involves a number... Read More

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Reduce TCO: The Java Database Way

TCO (Total Cost Ownership) is the buzzword in... Read More

How a Bug Challenges to a Software Professional

It is really interesting that a bug can create problem... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More