Microsoft Business Solutions Great Plains is very generic accounting application out of the box and has multiple modules to address specific horizontal or vertical market requirements. At the same time Great Plains, now being moved on MS SQL Server platform allows you to deploy standard tools to customize and fit to these requirements, when you don't need rich custom functionality, just few touches. In this small article let's take a look at finance industry.
Bonds and Loans. If you are issuing these documents ? you probably already have production system in place. What is often seen ? this loans tracking system is not integrated with accounting application. Another case ? loan tracking system may required manual interest recording, especially when client is state agency working in state subsidized programs, such as loans to farmers or small inland townships
? Customer Link. In Microsoft Great Plains borrowers are usually customers in the Accounts Receivables module (RM00101 table ? customer master). To link customer with loans you can have simple Dexterity or web application/extension to be opened from customer maintenance screen. This custom application will show you all the loans associated with this borrower/customer
? Interest/Principal invoices. In Great Plains you naturally use Receivables Management invoices for this purpose. The first step would be manual entry, based on the interest/principal portion, recorded in the above tracking system.
? Automatic Interest Calculation. Yes ? you could associate loan with repayment schema and program it in the formula. The easiest way is to have this implemented as Stored Procedure in MS SQL Server company database. Using SQL Exec statement you can build formula on the fly, considering multiple case scenarios and calculations.
? Reporting. Reporting could be based on both sources ? Microsoft Great Plains customer records and loan tracking database, even if the last one sits in different platform, such as Microsoft Access. You can create so-called linked server to MS Access in MS SQL Server Enterprise Manager and use OPENROWSET construction to pull the data from heterogeneous sources. Feel free to use popular tools, such as Crystal Reports ? you usually base your Crystal Report on SQL view or stored procedure (the second one allows you to use parameters and build temp tables in the body of your stored procs). If you are building web-application you can incorporate Crystal Report in it or deploy html publishing directly with your result set.
? Tools. Consider these tools first: direct web publishing from Great Plains Company database ? use C# or VB.Net with ADO.Net classes; Great Plains Modifier with VBA ? if you are VBA or VB programmer ? you can create masterpieces here, if you need GP tables structure ? Tools->Resource Description->Tables; direct SQL Programming ? you can create custom SQL views or stored procedures in company and DYNAMICS databases; Great Plains Dexterity ? this tool requires Dexterity knowledge and you should probably contract consultant or programmer to spec out this customization and do the job.
Good luck with implementation and customization and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com
There are several kinds of software piracy. The bottom line... Read More
In a previous article, I wrote about OpenOffice... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
The research in the field of Natural Language Processing usually... Read More
I completed an experiment recently. I wanted to find out... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
When you think... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Before September of 1995, Microsoft ignored the Internet because their... Read More
If you would like to pick something from Microsoft, or... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Buying accounting software is a major investment. It's an important... Read More
Let's first look at your ERP system selection (without Retail... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Many Webmasters have never bothered to view their website's server... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
It is a well known fact that Java as a... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Once a business idea is selected, it is highly recommended... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
We live in a post-industrial age where information is the... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Some companies that are in need of fleet management may... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
Well, even if the combination might look very unusual, we... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
Scrapbooks are very popular these days. I think that almost... Read More
In the new era of internet marketing the problem of... Read More
XML Server can be a Web Server that stores the... Read More
C++ Function templates are those functions which can handle different... Read More
When you think... Read More
We would like to give you pluses and minuses of... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
This is a short article, written in question/answer/FAQ style to... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
The objective for Zandi Digital is to make available clever... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
In order to implement VLANs in a network environment, you'll... Read More
Let's first look at your ERP system selection (without Retail... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
Need help making sense of algebra? Have algebra lectures in... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Viruses and spyware usually show up on your computer one... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
It is a well known fact that Java as a... Read More
If you have been running Windows XP for a couple... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
The world of small business accounting software can be a... Read More
Software |