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
eco-friendly cleaning service Buffalo Grove ..As Mozilla Firefox nears 10% market share, with well over... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
Research bears that less than 70 percent of development projects... Read More
When you double-click a layer in the Layer Palette, you... Read More
Mike Dunville* had a decision to make. As the new... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
The intentions of this short tutorial are not to teach... Read More
Enabling Chinese input is quick and easy, there are only... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
If you company is small or mid-size special products or... Read More
Shareware is software that you can try before you buy;... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
The purpose of one of our projects was MS Exchange... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
The term "document management" and "paperless office" is the subject... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
express cleaning service Arlington Heights ..Microsoft Great Plains, designed back in 1990th as database transferable... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Microsoft Business Solutions is now in process of creating so... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
Are you one of those people that keeps track of... Read More
When making a decision to buy any piece of software... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
If you are in a business that passes documents around... Read More
When you own a small business, time is money. And... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
The first thing that you will notice about Linux Red... Read More
If you have been running Windows XP for a couple... Read More
Before being able to choose a secure Internet communication system,... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
Software |