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: http://www.albaspectrum.com
Elk Grove (east OF 53) Chicago limousine service .. Lockport Chicago limo O’HareThis article illustrates the best practices to improve the performance... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Following tips help you to learn a software in lesser... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
If your company has regional and worldwide operations, you might... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
After seeing many people complain about their weak Internet security... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
The title of "software engineer" has got to be among... Read More
Imagine something that follows you home and sets itself up... Read More
If you have Microsoft Great Plains and support it for... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
Think of this, first we had the HAM Radio, then... Read More
All of us know that Microsoft bought former Great Plains... Read More
For a windows user like me, just can watch with... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
To all web designers out there, this article is for... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
Have you ever noticed that when you look at your... Read More
limousine airport Ackworth ..Microsoft Retail Management System serves retail single store as well... Read More
Are you a whiz at calculating financial information? Not the... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
TikiWiki is open source software - it is written in... Read More
You might think you don't need a firewall... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
The cornerstone of successful automated office systems is the ability... Read More
We'll give you non formal view, based on our consulting... Read More
Accounts payable is just one area of office management where... Read More
If you are software developer or database administrator - we... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
We would like to give you pluses and minuses of... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
In this article you will find some background information about... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
An integral part of any quality CRM system is lead... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
There are certain pluses and minuses in both cases and... Read More
In the new era of internet marketing the problem of... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Linux essentials:It's free for download but you have to pay... Read More
Software |