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
![]() |
|
![]() |
|
![]() |
|
![]() |
I'm not talking about posting the HBO schedule on your... Read More
Does the competition drive you crazy?Are they relentless about taking... Read More
If you own a mobile franchise business and wish to... Read More
"Rubbish!" shouted the large, aggressive man in the red-striped shirt... Read More
One of the key challenges for any business is to... Read More
A piano tuner recently moved to Buffalo, NY, and would... Read More
Does your overall business strategy include the recruitment of college... Read More
From time to time there seems to be a flurry... Read More
One Research Scientist at the Hewlett-Packard (HP) Imaging Systems laboratory... Read More
Building a dynamic small business is a constantly evolving, increasingly... Read More
Every new business owner knows that a business plan is... Read More
You have invested a lot of time and energy on... Read More
Growth through acquisition should not be considered an option reserved... Read More
Some analysts credit [Larry] Ellison with anticipating the consolidation in... Read More
Is your business growing as fast and effectively as it... Read More
Private equity firms have raised so much capital over the... Read More
If you are looking for a partner, funding, angle investor... Read More
As a franchisor it is imperative that you seek, find... Read More
One of the most powerful driving forces in human nature... Read More
Writing a business plan can be tricky when all the... Read More
A well known, national chain of restaurants discovered that certain... Read More
No matter what product or service you provide you will... Read More
Have you ever done a SWOT analysis? No, it's not... Read More
Can you imagine going on a road trip without knowing... Read More
Many business start-up kits or consultants will tell you one... Read More
Cassy was an employee of a nonprofit who had been... Read More
The new check cashing instant clearing will take some time... Read More
Microsoft Great Plains fits horizontal markets clientele and in case... Read More
When in doubt, cut that out! Yeah, yea, doubting Thomas... Read More
Why do so many companies languish and watch as their... Read More
Strategic alliances are increasing at a rapid rate. It is... Read More
A survey released by the American Institute of Certified Public... Read More
Although North Americans were the dominant population on the Internet,... Read More
Storytelling and writing a business plan actually go hand in... Read More
We have been spending many hours surveying the market for... Read More
If you own the mid-size business and actively work in... Read More
Experts estimate that 90 percent of Australian businesses are overspending... Read More
How are you feeling today? Good, not so good, great?... Read More
Let us look at a few of the big distribution... Read More
If you're a solo professional like I am, you know... Read More
How often does your company make a quantum leap forward?... Read More
Writing a business plan can be tricky when all the... Read More
Obviously, there will never be an actual water shortage since... Read More
We all know that nothing runs without a plan, and... Read More
The Accountability/Alignment Process: Three Steps to an Accountable Organization Generating... Read More
Business seems to drop, slow or even stop during the... Read More
If you own a pressure washing business one of the... Read More
How you finance the expansion of your business is important.... Read More
1. Attempt Succession Planning Without Other Strategic Plans. Succession plans... Read More
Have you ever done a SWOT analysis? No, it's not... Read More
It is always said "If you Fail to Plan, you... Read More
Growth through acquisition should not be considered an option reserved... Read More
Business plan financial projections seem daunting because they are so... Read More
Remember reading "Alice in Wonderland?"She asks the Cheshire Cat, "which... Read More
No matter what business you plan to start in your... Read More
The day you decide to take the plunge and work... Read More
Too much goal setting and strategic planning can leave you... Read More
You might be thinking to yourself, "Why should I waste... Read More
Microsoft Great Plains fits multiple services market niche and healthcare... Read More
"Rubbish!" shouted the large, aggressive man in the red-striped shirt... Read More
This will make some people angry as hell, but it's... Read More
One Research Scientist at the Hewlett-Packard (HP) Imaging Systems laboratory... Read More
Part 1A few weeks ago I attended a seminar sponsored... Read More
If you are looking for a partner, funding, angle investor... Read More
You have heard that there is extra money on the... Read More
David E. Gumpert, author of Burn Your Business Plan, often... Read More
Strategic Planning |