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

In The News:


pen paper and inkwell


cat break through


The Chief Cause of Business Failure & Success

Business rises and falls on leadership. According to business guru,... Read More

Changing Strategy Without Losing Your Customers - Three Vital Steps to Refining Your Strategy

American Eagle Outfitters and Wet Seal Stores have issued statements... Read More

How to Write a Business Plan Market Analysis

Writing a business plan is an essential part of the... Read More

Business Plan Financial Projections: Stop Worrying About Being Right...

Business plan financial projections seem daunting because they are so... Read More

Mobile Franchise Business Expansion Strategy

If you own a mobile franchise business and wish to... Read More

Business Results - Four Critical Success Factors

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

Idaho Market for Automotive Businesses; Doing it Right

Anyone who has been watching the Idaho Market Carefully for... Read More

Connecting Your Offline Business to Your Online Business

These may sound like no brainers, but you'd be surprised.... Read More

Regroup - How To Do It And Why It Works

Regroup?is this a new management trend? Not a chance! Regroup... Read More

Pave the Way to a Successful Strategic Plan

Many very successful business owners may never have had a... Read More

The Accountability/Alignment Process: Three Steps to an Accountable Organization

The Accountability/Alignment Process: Three Steps to an Accountable Organization Generating... Read More

19 Questions to Supercharge Your Business Plan

Whether you are seeking capital for your company or are... Read More

Strategic Acquisition Strategies for Small Businesses

Growth through acquisition should not be considered an option reserved... Read More

What Every Service Provider Ought To Know About Writing A Business Plan

It's easy to lose sight of what needs to be... Read More

Laying It Out On Paper

You might be thinking to yourself, "Why should I waste... Read More

Rules to Setting Business Goals and Objectives: Why and How to be SMART

We all know that nothing runs without a plan, and... Read More

Strategy Without Tactics is Futile

From time to time there seems to be a flurry... Read More

Buying Used Detailing Equipment and Rainy Day Services

Mobile auto detailing equipment becomes very inexpensive around March each... Read More

Top Ten Reasons To Create A One Page Business Plan

There is a story, about a business owner who wasn't... Read More

Menu Driven Business Planning

A menu is the foundation of any restaurant; Guests will... Read More

How Good Is a Business Plan To Your Business?

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

Invalid Excuses for Poor Business Results - The Economy

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

What is a Shared Vision?

So what makes a vision successful? Everyday companies try to... Read More

Strategic Planning Fundamentals

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

Will and Vision

Remember Chux? The disposable diaper that took the market by... Read More

Insurance Requirements in Franchised Companies

Franchised companies often require what some believe to be excessive... Read More

Do You Have A Customer Identity Crisis?

The trick is to determine what uniquely identifies your best... Read More

Three Easy Ways To Know Thy Competitor

"Did you hear what your competitor is doing?" This question... Read More

Thinking Like A Farmer

One of the difficulties we face in our industrialized age... Read More

How to Develop a Successful Board of Advisors (...and Why You Should!)

In today's rapidly changing and highly competitive markets, many privately... Read More

Take A Systems View To Ensure Your Business Stays Healthy

How are you feeling today? Good, not so good, great?... Read More

Akron OH; A great place to do business

When looking at Akron carefully one cannot help but notice... Read More

Microsoft Great Plains in Aerospace & Defense industries ? implementation & customization highlights

Microsoft Great Plains fits horizontal markets clientele and in case... Read More