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
|
|
|
Quarkxpress Tips: How To Move Content Between Print And Web Layouts
Since its release in 1987, QuarkXpress had made an immediate impact to computer enthusiasts. QuarkXPress introduced precision typography, layout and color control to the desktop computer, and delivered those features to des...(related: Software)
Popular Fleet Maintenance Programs
Some companies that are in need of fleet management may choose to utilize the services of a fleet maintenance program. These programs can generally handle all of you fleet management needs. Tracking vehicles, keeping up with maintenance, handling fuel budgeting and logging work are among a few examples of what fleet maintenance programs can offer your company.For example, Enterprise Fleet Services is one of the leading fleet maintenance programs in the U.S. In their regular Fleet Maintenance Program, the company receives easy-to-understand reports concerning fleet management. Enterprise can analyze a...(related: Software)
What Is A Document Manager Without Version History?
Document Manager and Version HistoryIn previous articles I have discussed the usefulness of a document manager, such as groupware, in organizing document sharing. I have also discussed the role that a Version History plays in a good document manager. In this article I wish to elaborate on Version History and its ability to make or break your document manager. The reason a document manager benefits so much from Version History is that Version History presents a visual flow chart of the editorial ...(related: Software)
Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting
Manufacturing in the USA is far away down from mid 20th century top of the hill or its golden time. However ...(related: Software)
Microsoft Blues
With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really made the forums hum.Every forum on computer problems is replete with complaints that since downloading and installing 'SP2', many 'third party' appli...(related: Software)
Software Process Improvement -a Successful Journey
Background:For many organizations like ours, the interim target of achieving ISO 9001 or CMM levels ...(related: Software)
Why Do Manufacturers Invest In Business Management Software?
With many manufacturing shops heading over seas in favor of lower cost, it is tough to compete in today's marketplace. As a result, the goal for manufactures who want to compete going forward is to run leaner, faster and more accurately.The manufacturing industry is heading toward a technology revolution. Many of the leading software vendors have created vertical solutions developed specifically for manufacturers. These vertical solutions help automate the entire process from the shop flo...(related: Software)
Navision Customization: C/side, C/odbc, C/front, Xbrl ? Development Options
Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. Now Microsoft Business Solutions offers following ERP applications: Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta. Formerly Navision had strong positions in Europe. Now it is promoted in USA and Europe. Navision has pretty advanced manufacturing module.We would like to give you: programmer, software developer, database administrator the ori...(related: Software)
Beware Of The Pirated Software E-mail Scams!
You have gotten those E_Mails buy software at deep discounts. It is very tempting to save 85% to 95% on your favorite Software Titles. Why would you pay $279 for Windows XP when you can pay $49. Most of the times these are Pirated copies of the Software. You can run into huge problems later when you seek upgrades, Support or Security patches.Anyone can rationalize buying Pirated software. Who are you hurting? Bill Gates is so rich he can afford to loose a few sales. No you won't hurt Bill Gates to much. But what about the Microsoft Employee with a wife and a Child or 2. If Microsoft looses enough sales tom these pirates who do you think will be laid off. The Working Man with a wife and children ...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software