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
disinfecting cleaning services Winnetka ..IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
User interfaces and accessibility are some of the most important... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
Spyware is like the new technological nuclear weapon on the... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
A few months back I really got sick of my... Read More
When you own a small business, time is money. And... Read More
I have yet to see a business that, sometimes in... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Once upon a time not so long ago, there was... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Background: For many organizations like ours, the interim target of... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
We would like to give you several situations, when you... Read More
Let us give you - developer some hints in the... Read More
last minute cleaning help Highland Park ..Considering whether or not your software company should hire a... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
The java programming language is becoming more and more popular... Read More
If you copy something from a Web site or elsewhere...... Read More
It won't matter how effective your WinRunner Team is if... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
What is a Web Database?A web database is a database... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
And kill the best layout software in the process of... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Microsoft Retail Management System serves retail single store as well... Read More
How many steps does it take you to locate and... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
The most important benefit of XML is its simplicity. Though... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
If you would like to pick something from Microsoft, or... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Beginning with Domino version R4 it has integration with the... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Software |