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
Beecher limo rentals ..Let's first look at your ERP system selection (without Retail... Read More
It's all about turn times in the eMedia industry! The... Read More
Is your PC is slow and wimpy? Then you need... Read More
A UNIX Shell is in simplest terms, a command line... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
Following tips help you to learn a software in lesser... Read More
Spyware and malware are large problems for Internet users today... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Now that spyware is the single most dangerous threat to... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
This is the tutorial where we really get into programming.... Read More
... Read More
Accounts payable is just one area of office management where... Read More
Manufacturing in the USA is far away down from mid... Read More
Research bears that less than 70 percent of development projects... Read More
Viruses and spyware usually show up on your computer one... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
There are several kinds of software piracy. The bottom line... Read More
Microsoft Great Plains fits to majority of industries, in the... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
A few months back I really got sick of my... Read More
IntroductionPHP can be used for a lot of different things,... Read More
Bridgeview limo Chicago ..Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
As seeing large number of implementations ? in our case... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
If you have been running Windows XP for a couple... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Scrapbooks are very popular these days. I think that almost... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
We all already got used to computer monitoring both at... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Not all of us have the luxury of working both... Read More
Enabling Chinese input is quick and easy, there are only... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
We'll give you non formal view, based on our consulting... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
The software giants don't do everything and don't always produce... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Each Industry and market niche has business specific and unique... Read More
Software |