	Government Job
	Home Site Map Powered by WhyPark.com

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



Government is a Franchise System; just not a very good one Few understand the Franchising Format and even fewer have correlated that to our modern government structure. The United States Government is set up much like a franchising system. With QScend's QContent as Featured Tool, Littleton, MA, Earns Open Government Award The Town of Littleton, Massachusetts, using the QContent? suite of web-based content management tools provided by QScend Technologies, Inc., recently won an award from the Massachusetts Campaign for Open Government for its commitment to e-government initiatives. Government Assistance For Single Mothers - Daycare Support For Single Parents Nearly all single parents have to work to meet their financial needs It is not possible for them to look after their preschool children while at work Input Opens Library with Over 3,000 Government Contracts Adding more federal and state & local contracts and task orders daily. The Great Flu Pandemic of 2009 is Coming: No One Can Stop It in New Novel -- Everything Your Government Said Would Protect You Is a Lie In 1919 a worldwide flu pandemic killed 50 million people. The next pandemic could wipe out as many as 500 million … and the bad news, it might already be here. Read 'Another Place to Die' by Sam North before the next round of winter flu. It might just save your life. Fantastic New Resources from THRASS UK Set to Make Major Contribution to Two New UK Government Programmes THRASS UK has earned a reputation for producing highly successful innovative resources for helping children to read and spell, and it has just announced the launch of a new set of resources that, in addition to being fantastic resources in their own right, look set to make a major contribution to the effectiveness of two new UK Government programmes. The THRASS Family SING-A-LONG Resources, to be launched at the end of January, will have the potential to make a major contribution to the effectiveness of the Government's 2008 National Year of Reading and also to that of 'Sing Up', the new Government-sponsored singing programme for primary school children. Knowledge Management Solutions, Inc. and RWD Technologies, Inc. Create Partnership to Provide eLearning Solutions to Government Agencies Leading providers of learning technology and services establish agreement to provide the next generation in Learning Management Systems (LMS) Talent Management; Learning Content Management (LCM) and Human Capital Management (HCM) solutions to Government Agencies. Government of Honduras Accelerates Activation of Aidmatrix Network?: COPECO Honduras and the First Lady's Office - Government of Honduras Now Linked- The Aidmatrix Foundation, a nonprofit using supply-chain technology to create an exchange network for humanitarian aid and disaster relief, announces the Republic of Honduras has formally joined the network for Hurricane Felix Relief as well as ongoing relief efforts and donations management. Federal Government Reorganization from a Canadian Immigration Standpoint Prime Minister Stephen Harper's recent cabinet shuffle seeks to encourage the interaction between immigration and human resources. Why Government Car Auctions Are Not Good Almost everyone wants to own a car, and yet only a few will be able to afford it. This is because they're very expensive. However, if you aren't really looking for something new, or if you like to settle for something that's really cheap, you can always go to auctions. EM&I Launches ACART to Help Government Agencies Address Enterprise Architecture and Requirements Compliance New Offering Helps Agencies Compare Systems against Architectures, Requirements and Regulations and Then Document and Report on Compliance Status CyberSecurity Institute Awarded Contract to Provide Computer Forensic Training and Certification for Government Agencies and Employees CyberSecurity Institute, a leading provider of computer forensics and information security training, has been awarded GSA contract number GS-35F-0338T, which allows them to deliver training as well as administer the CyberSecurity Forensic Analyst (CSFA)? certification test for government agencies and employees. Should the Government Compensate the Clients of TAT? This, of course, is a political decision. There is no "right" thing to do. Auctions by Government What do governments do with their surplus and/or impounded merchandise? Surplus merchandise is government owned goods that are no longer needed. They may be office furnishings, guns, ships, buildings, office equipment. Also included in surplus merchandise is military equipment, Coast Guard equipment, and fire equipment. If there is a default on a government guaranteed mortgage that results in foreclosure, there are houses that are auctioned. The government also sells at auction goods that it has seized from criminals. This can include almost anything ? cars, boats, planes, houses, jewelry, and antiques, any of their personal possessions because they were purchased with the proceeds acquired from criminal activities. All levels of gove... Vocus Launches Issues Wire News Distribution Service for Government Relations Professionals New service reaches millions turning to the Internet for news to maximize the impact of GR efforts.