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, 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

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

CNBC

VW's CEO was told about emissions software months before ...
CNBC
Volkswagen Chief Executive Herbert Diess was told about the existence of cheating software in cars two months before regulators blew the whistle on a ...
VW's CEO was told about emissions software months before scandal: Der SpiegelReuters

all 41 news articles »

Forbes

Could Software Analytics Platforms Extinguish The Threat Posed By Hackers?
Forbes
RYAZAN, RUSSIA - JUNE 28, 2017: The silhouette of a young man with a mobile phone against a red background with a projected message related to the Petya ransomware; on 27 June 2017 a variant of the Petya ransomware virus hit computers of ...


GeekWire

Five experts explain how software development and operations teams are adjusting to the rapid changes caused by ...
GeekWire
While software continues to eat the world, the philosophies and tactics used to build that software are constantly changing. Getting from idea to working software has never been easy, and companies that never needed cutting-edge expertise in software ...


Inverse

Tesla V9.0 Software Isn't Out Yet but Elon Musk Has Plans for Version 10
Inverse
With the upcoming release of its V9.0 software, Tesla CEO Elon Musk put out the call for game developers to produce games for the car's touch screens in early August. But Musk may already have plans for other forms of in-car streaming entertainment for ...

and more »

South Bend Tribune

Were red flags with 911 dispatch software overlooked by St. Joseph County?
South Bend Tribune
In 2014, St. Joseph County and the cities of South Bend and Mishawaka shopped for dispatch software needed at the consolidated center that was then being set up. A national search drew interest from a handful of companies. After some debate, the ...


MIT Technology Review

Why adding bugs to software can make it safer
MIT Technology Review
This can be serious, but there is a large class of software, such as background microservices, that is designed to handle crashes gracefully by restarting the software while the user is none the wiser. These bugs are much less serious than ones that ...


MSPoweruser

Microsoft shares ways for software vendors to minimize false positives
MSPoweruser
The company shed light on the false positive issue which basically means labelling a genuine software/program as a virus. Usually, this poses a security issue as people don't know if they can trust a software after it has been flagged by the Anti-virus ...


Hamilton Journal News

Software may change how 911 calls are dispatched in Butler County
Hamilton Journal News
Smart 911 is new software being used by Butler County law enforcement agencies.

and more »

CoinDesk

Zcash Sets Stage for 'Sapling' Upgrade With New Software Release
CoinDesk
Privacy coin zcash is gearing up for a major upgrade with the first release of network software compatible with its upcoming Sapling hard fork. Zcash version 2.0.0 was released Thursday, according to a blog post penned by Sean Bowe, an engineer with ...


The Economist

New software helps uncover Mafia crime masked as ordinary business
The Economist
That has made it harder to spot extortion by analysing a business's books, says Antonio Basilicata of the Anti-Mafia Investigation Directorate (DIA) in Rome. But software developed by Crime&tech, a firm in Milan, can still help identify companies with ...

Google News

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Pros and Cons of Using FREE Software in Your Business

Itâ??s easy to understand why you might be drawn to... Read More

Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

Great Plains Fixed Assets Management module is a robust tool... Read More

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and... Read More

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

Microsoft Great Plains Inventory Control ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Review on QuarkXpress 6.0

After almost two decades of existence, Quark has become the... Read More

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Spyware Statistics -- Whats New in May 2005?

Although statistics often is blamed for various deadly sins --... Read More

Microsoft CRM Lotus Notes Domino Connector FAQ

Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

What You Should Know About Installing Screensavers

Do you remember that frustrating feeling when you find an... Read More

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Your Computer May Be Infected, Heres How To Check (NOT about virus)

NOTE: Please take time to read on - it may... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

If you are software developer or database administrator - we... Read More

Beware of Spyware

One day, you suddenly realize that your computer started to... Read More

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More

Microsoft Great Plains Accounting/ERP Implementation ? Finance Industry Customization Example

Microsoft Business Solutions Great Plains is very generic accounting application... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More