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
tidy up service Northbrook ..You might think you don't need a firewall... Read More
Just the thought of a duel-boot scares many people away,... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
One day, you suddenly realize that your computer started to... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
Research bears that less than 70 percent of development projects... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
While Adobe is the most known maker of PDF tools,... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
You've finally created databases that you can actually use to... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Microsoft Business Solutions is now in process of creating so... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
We all already got used to computer monitoring both at... Read More
reliable home cleaners Buffalo Grove ..MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
When you think... Read More
Before September of 1995, Microsoft ignored the Internet because their... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
New post-recession era has new features, which didn't exist in... Read More
Introduction: The creating of a computer program involves a number... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
How many steps does it take you to locate and... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
Microsoft Outlook is one of the most widely used software... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
People often ask me: What image file formats will Photoshop... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Around the same time Microsoft made its move with .Net... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Software |