Microsoft Great Plains Accounting/ERP Implementation ? Finance Industry Customization Example

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: andrewk@albaspectrum.com

---

How To Avoid Getting Hooked By Pfishing

"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

Microsoft CRM Programming Secrets ? Tips For Developers

This article is for advanced Microsoft CRM SDK C# developers.... Read More

5 Time-Saving Tips in Microsoft Word

Whether you have used Microsoft Word for years, have just... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Internet Relay Chat - A Basic Introduction

What is IRC?IRC is Internet Relay Chat. It is a... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More

How to Evaluate Staffing Software

If you are in the market for new staffing software,... Read More

Does your Company have Documentum?

Are you lost in the mess of documents that get... Read More

Microsoft Great Plains Inventory Control ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Microsoft Great Plains PM: Payables Management

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

Choose your Java Wisely

Java has come along a long way. Many would agree... Read More

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

Groove Network. Are you in it?

If you are in a business that passes documents around... Read More

Monitoring Software Can be Used for Spying as Well

We all already got used to computer monitoring both at... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

netstat - Linux Command to Display Networking Information

In linux, one of great commands for finding out information... Read More

Computer Based Language Development and Spell-checking

Language development computer: Computer-based method for aiding language development seems... Read More

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for... Read More

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More