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
express cleaning service Arlington Heights ..Microsoft Business Solutions ? Navision is an integrated solution for... Read More
If there still are few unprotected computers left, I haven't... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
You turn on your computer, and it doesn't look quite... Read More
Following tips help you to learn a software in lesser... Read More
Need help making sense of algebra? Have algebra lectures in... Read More
If you have been using the Internet for any amount... Read More
I love new technology. I am still ready to wait... Read More
What is Software?Software is a set of instruction written to... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
It could just be me, but my experiences with document... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
I have yet to see a business that, sometimes in... Read More
I provide, here clear explanations and a count of function... Read More
Imagine something that follows you home and sets itself up... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
A few months back I really got sick of my... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
tidy up service Arlington Heights ..Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
Having from five to ten and more favorite screensavers is... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
When making a decision to buy any piece of software... Read More
Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
While I was in college, if you would have asked... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Fleet Maintenance Management is a critical position in any company... Read More
We would like to give you several situations, when you... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
When you double-click a layer in the Layer Palette, you... Read More
One of the main reasons business owners and entrepreneurs use... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
You might think you don't need a firewall... Read More
Remember back in the days where screensavers were the coolest... Read More
Software |