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
cleaning help near Mundelein ..In our small article we'll consider Microsoft Business Solutions Great... Read More
Whether you have used Microsoft Word for years, have just... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
What is installation in the language of technology? Installation... Read More
Having from five to ten and more favorite screensavers is... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
All of us know that Microsoft bought former Great Plains... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
How many steps does it take you to locate and... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Considering whether or not your software company should hire a... Read More
Today's business world is fast-paced. No matter what it is... Read More
Fundraising software lets you connect with donors in a way... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
Linux essentials:It's free for download but you have to pay... Read More
NOTE: Please take time to read on - it may... Read More
The most important things you can do for your computer... Read More
ERP Consulting industry is on the way to serve clients... Read More
reliable maid service Wilmette ..Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
It would be easy to think, like most people apparently... Read More
Domino server is a buffer between the operation system and... Read More
There are plenty of articles out there about how to... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
During the years of our consulting practice, which comes back... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
(1) Avoid using the same variable again and again for... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
IntroductionPHP can be used for a lot of different things,... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Usually, the easiest way to tell you have spyware is... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Having from five to ten and more favorite screensavers is... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
Music downloads are off the charts! We're listening to digital... Read More
Software |