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
Today's business world is fast-paced. No matter what it is... Read More
I suggest that you do not spend a lot of... Read More
How many steps does it take you to locate and... Read More
Finally, you have some time to personalize your desktop with... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
If you've been using MySQL database to store your important... Read More
Before being able to choose a secure Internet communication system,... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
I have recently created my first Php program. I wanted... Read More
While I was in college, if you would have asked... Read More
Some companies that are in need of fleet management may... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
Software development is a risky business.Many software developers are barely... Read More
Best Software Act! is very popular CRM for small and... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Here is some free software tools to help you build... Read More
The cornerstone of successful automated office systems is the ability... Read More
Sometimes your PC will start acting strange for no apparent... Read More
Microsoft CRM is now on the scene and it is... Read More
After seeing many people complain about their weak Internet security... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
So let's begin crunching down these 300 images using Adobe... Read More
NOTE: Please take time to read on - it may... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
In the real world a "fire wall" is a fireproof... Read More
Microsoft Word is one of the most popular office applications... Read More
While Adobe is the most known maker of PDF tools,... Read More
A few months back I really got sick of my... Read More
If you are in the market for new staffing software,... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
XML Server can be a Web Server that stores the... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... 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
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
As seeing large number of implementations ? in our case... Read More
Microsoft CRM is now on the scene and it is... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Enabling Chinese input is quick and easy, there are only... Read More
When you think... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Do you remember that frustrating feeling when you find an... Read More
There are many commands that are used in linux on... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Domino server is a buffer between the operation system and... Read More
This article is the third of a series of articles... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
If you have Microsoft Great Plains and support it for... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
To all web designers out there, this article is for... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Words we choose to describe things and phenomena often show... Read More
Just the thought of a duel-boot scares many people away,... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
When you need a phone number, you do a quick... Read More
Software |