Microsoft Great Plains in Agriculture ? implementation highlights

In this small article we'll concentrate on farmers associations and non-profit state-sponsored organizations, dealing with subsidized state and federal programs distribution and management ? loans to farmers and rural communities. As we realized this is relatively narrow market niche and it is almost ignored by software developers. In the typical case you should take generic ERP application, such as Microsoft Great Plains and integrate it with legacy systems or create custom piece in Great Plains to serve your association needs.

? Loan Tracking System. Your customers ? farmers are customers in Microsoft Great Plains Accounts Receivables (AR) module, however the association doesn't have the loan on its balance ? it is managing the program for the fee. This is why Loan Tracking system is usually custom application. It is often written in Microsoft Access. You need a link from Great Plains Customer Maintenance screen to the customer loan record in the MS Access. This could be realized via smart tag.

? Loan marketing. You can improve your results by analyzing loans by farmers segments and offer related and associated financial products to farmers community. This is excellent field for Crystal Reports designer

? State regulation. As the association you need to file numerous state-dependent reports, related to your financial activity. The reporting is based on Microsoft Great Plains company database as well as your custom made loan tracking system/database. In MS SQL Server you should create linked server and heterogeneous SQL queries and stored procedures

? Non-profit chart of accounts. Great Plains handles non-profit accounting. Chart of accounts is flexible from Microsoft Great Plains side ? the often case is implementing the same chart of accounts as you have in your legacy accounting application.

? Customization & Integration. Association service loan programs and dealing with numerous banks. Expect EFT and bank transactions integration, which should be considered individually with each specific case. Portion of the above mentioned loan system logic you may bring to Great Plains. Good candidate would be interest calculation and AR interest and principal reimbursement invoices automatic creation ? SQL stored procedures with Great Plains Dexterity setup screen will do the job. In this case you can verify statements from the bank and match them with your own calculations in Great Plains.

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

---

6 Steps To Laying Out Your Competitive Strategy

Why do so many companies languish and watch as their... Read More

Ten Steps To A Great Strategic Plan

Ask a small business owner about their strategic plan and... Read More

The Magic Of Exponential Business Growth

Is there a 'magical' way to exponentially grow your business?It's... Read More

Business Strategy Planning Made Easy

Ask Yourself three simple questions that affect your strategy planning...... Read More

Business Results - Four Critical Success Factors

Scenario OneDuring a recent presentation, a business owner was given... Read More

Why 9 in 10 Businesses are Overspending on Day-to-day Expenses

Experts estimate that 90 percent of Australian businesses are overspending... Read More

Alice In Wonderland - A Parable for A Business Plan

Remember reading "Alice in Wonderland?"She asks the Cheshire Cat, "which... Read More

Describing Intellectual Property in Your Business Plan

Most companies that are worthy of raising venture capital have... Read More

Becoming Wise - Wild & Free - Writing A Successful Business Plan - Part 2 - Do It In Steps

So you've decided to write your own business plan because... Read More

Own Your Niche by Building a Niche Community

In 1997, David Steele was making the transition from a... Read More

Invalid Excuses for Poor Business Results - Rising costs

Note to Northwest Airlines ? It's not about fuel costsFor... Read More

Microsoft Great Plains Implementation: Placement/Recruiting Agency example ? overview for consultant

Microsoft Great Plains does wonderful ERP job for horizontal markets... Read More

Why Create an Annual Plan?

Can you imagine going on a road trip without knowing... Read More

The Top Ten Rules of Effective Networking

Many of us are discouraged by the networking events that... Read More

Legal Strategies in Business Plans

Writing a Business Plan these days is tough, venture capitalists... Read More

Five Crucial Components of a Business Plan

The format of a Business Plan is something that has... Read More

How Copying the HBO Schedule Can Boost Your Business

I'm not talking about posting the HBO schedule on your... Read More

Sony?s PSI Project

In 1989, Sony founded its Institute of Wisdom at the... Read More

Invalid Excuses for Poor Business Results - The Economy

Note to Rite Aid and CVS: It's not about the... Read More

Microsoft Great Plains Implementation: Pharmaceutical Corporation Specifics ? overview

Microsoft Business Solutions Great Plains serves mid-size and large clients... Read More

How Good Is a Business Plan To Your Business?

You know you need a business plan. You probably realize... Read More

Making a Decision to Outsource: Strategic Constraints

Many companies are reluctant to dive into outsourcing ocean because... Read More

Is Plan B Ready?

Business owners and entrepreneurs are, by nature, risk takers and... Read More

Strategic Planning Fundamentals

Strategic planning is vital while starting a new business or... Read More

GOT MEME? How to Attract Your Clients and Customers Attention

No "meme" isn't a typo and Got Milk, the more... Read More

Offense: Beat the Odds

When in doubt, cut that out! Yeah, yea, doubting Thomas... Read More

Water Conservation and Water Issues for Mobile Car Washers and Auto Detailers

Obviously, there will never be an actual water shortage since... Read More

Business Plan: Planning the Operations

Writing a business plan is no easy task, sure you... Read More

Designing an Efficient Distribution System

Let us look at a few of the big distribution... Read More

To Go or No Go, That Is The Question

Last week we talked about a few of the ways... Read More

Be Like Bill - Think!

Twice a year, Bill Gates goes to a remote island... Read More

I Always Play by the Rules and It Stinks!

This week I coached a wonderfully lovely woman I'll call... Read More

Secrets Of Effective Brainstorming

Have you been in a "brainstorming" session where each person... Read More