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
|
|
|
Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan Faq
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM require existing customer to be ...(related: Software)
Microsoft Crm Data Conversion Faq
Microsoft Business Solutions CRM data conversion deserves FAQ type of article, where IT people could get initial directions. Even if it seems as a trivial task, we would suggest you to think about these possible scenarios: objects mapping between your legacy CRM: GoldMine, ACT, Siebel, Lotus Notes Domino. When you think about MS CRM switch over ? do...(related: Software)
Sql Scripts For Project Accounting: Microsoft Great Plains Series ? Overview For Developer
Microsoft Business Solutions Great Plains has Project Accounting module where you can budget the project, assign it to customer contract and then log expenses, timesheets, inventory spending, and finally bill the customer against the project or contract. Microsoft Great Plains Project Accounting does excellent job, but there are cases when you need developer or MS SQL DB ...(related: Software)
Software Process Improvement -a Successful Journey
Background:For many organizations like ours, the interim target of achieving ISO 9001 or CMM levels ...(related: Software)
Ecommerce Development For Microsoft Great Plains: Tools And Highlights For Programmer
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise was designed in earlier 1990th as ERP, which can be easily transferable to the winning Database and OS platform and it was originally available on Mac and PC ? Mac OS and Microsoft Windows respectively. Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure:? Naming Convention. Great Plains was designed to be ready to move to the winning database platform and probably this is why we see this a bit complicated naming convention in place: SOP10100, RM00101, IV00101 ? these are samples: SOP header, Customer master, Inventory master. First ? we see module prefix: SOP ? Sales Order Processing, RM ? Receivables management, IV ? Inventory control, ...(related: Software)
Free Program Removes Spyware Not Detected By Premium Security Scan
What is Spyware?Spyware monitors your surfing habits and sends the data off to some remote server in cyberland. Your computer can get infected with spyware easily by visiting a web page or installing a software program. Kazza is a classic example of a free software download riddled with spyware. More info here: http://compactURL.com/sd...(related: Software)
What You Must Know About Spyware Right Now
Spyware is like the new technological nuclear weapon on the internet. Spyware can not only damage the health of your computer but it can also steal your personal identity other personal information. Spyware is software that is hidden inside legitimate downloads that you come across on the internet. An example wouldbe the growing number of file sharing programs and free mobile ring tone advertisements that you come across on the internet. If you have teenagers in your household, it's imperative that they know the dangers of using these programs as what takes 2 minutes to download and listen to, can take a good few hours to remove the damage left behind after being infected with spyware.Spyware can slip past anti virus programs and firewalls as...(related: Software)
Ukraine It Myths Dispersed
While Ukraine is becoming a new popular IT outsourcing destination, there are still many myths about it and no clear understanding of the opportunities outsourcing to Ukraine can present. Let us look closely at some of those myths and find out whether there is any truth behind them.Myth No. 1 ? Ukraine is politically unstableThis myth has seen its rise in November-December 2004 during the events around the presidential elections that led to the Orange Revolution. However, presently there are no grounds for concerns. During the Orange Revolution, the Ukrainian people have shown their devotion to the democratic ideals and prevented the worst scenario from happening, bringing the legitimately elected president to the power. The new Ukrainian government has clearly voi...(related: Software)
Antivirus Software ? Get The Bugs Before They Get You!
You turn on your computer, and it doesn't look quite right. Maybe your icons have changed, or the background picture is wrong. Some options are disabled. Even worse, you may not be able to boot your computer up at all. Guess what ? it's probably got a virus.In today's online world, protecting your computer from all the nasty things online is vital. Viruses can cause obvious issues, as described above, but they can also run silently in the background, propagating themselves acros...(related: Software)
What Is Preventive Maintenance Software?
Preventive Maintenance (PM) is defined as scheduled work done on a system to identify and fix any occurring issues before they become problems. The concept of preventive maintenance applies to many different industries. PM is often done on buildings, various types of machines, computers, institutions, as well as personal assets, including finances and property.A common example of preventive maintenance is a car getting its oil changed. Usually, this is done when the car is in good working order to prevent any future problems resulting from the car running on old oil.In the past, preventive maintenance ...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software