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
tidy up service Northbrook ..Linux essentials:It's free for download but you have to pay... Read More
Java has come along a long way. Many would agree... Read More
Homeland security, airport security, Internet security ??" these days we???re... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
There are certain pluses and minuses in both cases and... Read More
If you look back to the history, you will see... Read More
A few months back I really got sick of my... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
An integral part of any quality CRM system is lead... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
Best Software Act! is very popular CRM for small and... Read More
One of the things we can be as certain of... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
The most important benefit of XML is its simplicity. Though... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
When you own a small business, time is money. And... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
So, why should you use any O/R mapping tool? I... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
reliable home cleaners Buffalo Grove ..Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Every day millions of new web documents emerge on the... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
The Windows Indexing Service provides you with the ability to... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
When making a decision to buy any piece of software... Read More
Did you ever want to erase everything on your computer?... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
This article is the fourth of a series of articles... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
What is Interactive Mapping?Interactive mapping is a visual display medium... Read More
In order to implement VLANs in a network environment, you'll... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
This article will not attempt to advocate the use of... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
Software |