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 ..This article will not attempt to advocate the use of... Read More
Do you want to get quality software at a reasonable... Read More
When it comes to screenplay software each screenwriter needs to... Read More
A wiki is an editable text-based website. But you don't... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
It is a well known fact that Java as a... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
The software giants don't do everything and don't always produce... Read More
It's all about turn times in the eMedia industry! The... Read More
When you think... Read More
After seeing many people complain about their weak Internet security... Read More
Using professional icons in your application or website can bring... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Fundraising software lets you connect with donors in a way... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
So, you've bought a new Macintosh, and now you may... Read More
With any good luck and a good amount of hard... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
The most important benefit of XML is its simplicity. Though... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
tidy up service Arlington Heights ..Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
If you have Microsoft Great Plains and support it for... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Did you ever want to erase everything on your computer?... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Think of this, first we had the HAM Radio, then... Read More
We would like first emphasize the change in the paradigm.... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Remember back in the days where screensavers were the coolest... Read More
The title of "software engineer" has got to be among... Read More
Once a business idea is selected, it is highly recommended... Read More
Fundraising software lets you connect with donors in a way... Read More
If there still are few unprotected computers left, I haven't... Read More
Although statistics often is blamed for various deadly sins --... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
In the case when you represent mid-size or mid-size-to-large business,... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
ERP Consulting industry is on the way to serve clients... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Background: For many organizations like ours, the interim target of... Read More
Google Inc. has launched a new software package that allows... Read More
Software |