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

---

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

Screenshots Vista Windows

Features Additionally, Vista will include many other new features.Aero Vista... Read More

The Secret of the Layer Styles Dialogue

When you double-click a layer in the Layer Palette, you... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

Microsoft CRM Modification ? Overview for IT Specialist

Microsoft CRM is now on the scene and it is... Read More

The Opera Alternative

Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

Microsoft CRM ? Consulting in the Post-Recession Time

New post-recession era has new features, which didn't exist in... Read More

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

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

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

1. What determines the software price? Is it Per Seat... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

Microsoft Great Plains BR: Bank Reconciliation

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

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

... Read More

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

During the years of our consulting practice, which comes back... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

Microsoft Great Plains is one of the Microsoft Business Solutions... Read More

When is a Software Engineer Not a Software Engineer?

The title of "software engineer" has got to be among... Read More

Microsoft Great Plains Integration Manager ? Working With Text File

Microsoft Business Solutions main middle market ERP application - Microsoft... Read More

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More

Internet Faxing Service Review

The Internet is reshaping every form of communications medium, and... Read More

Software For Your Hard-Drive

All your software is stored on a hard-drive. But how... Read More

Are You Waiting for Microsoft Longhorn Operating System

I love new technology. I am still ready to wait... Read More

A Symons Mark II Function Point Counting Example

I provide, here clear explanations and a count of function... Read More

Monitoring Software Can be Used for Spying as Well

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

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

Microsoft CRM or Siebel

Siebel is traditional CRM market leader, however and mostly due... Read More

Manufacturing Solutions for Microsoft Great Plains ? Overview for Consultant

Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

Microsoft Business Solutions Partner ? How to Launch New IT Consulting Practice

In the new era of internet marketing the problem of... Read More

Linux ? Keyboard Or Mouse

Just stress testing one of the latest Linux distributions. Been... Read More