Software Information |
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
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Microsoft Moves to Small Business Accounting/Retail Market - Stakes and Thoughts In this small article we will be looking at the new opportunities for Microsoft Small Business Server specialists, but rather look at the global business strategy and possible ways of future ERP modules standardizing and interoperability. This is important to get into consideration for midsize and large corporate business IT decision makers. Microsoft Great Plains Integration with Microsoft Access - Overview for Developer Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market. At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor to Oracle, PeopleSoft, SAP, IBM. Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management Let's first look at your ERP system selection (without Retail Solution). Your options are:Microsoft Great Plains. RFID: Strengthen the Position for SAP; United States SAP Inc., a global leader in client/server enterprise application software that for years been the backbone to RFID application has seen a 1,000% spike year-over-year in customers, interested in RFID deployment. 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 or Per User or Per Processor?The cost of software is determined in many ways. Groove Network. Are you in it? If you are in a business that passes documents around to be reviewed and edited over and over before they are ready to be posted for advertising or for a client, then you have probably already heard of a software solution to help keep your "floating" documents organized from Groove Network. You may not be aware that there is another option out there. How To Develop Software For Your Business Software development is a risky business.Many software developers are barely skilled at their trade, much less at business. Alien Intruders! You probably didn't casually invite, or extend a formal attendance requestto, these undesirables known as viruses.Regardless of your opinions, such cyber-nomads may call on you, complete andactive, with their destructive payloads. Basic Steps To Optimize Your Internet Security After seeing many people complain about their weak Internet security I decided to write down some things that will help you for your Internet security.First, here are some tips to make windows safer :For basic security and update patches install Service Pack 2 for Windows XP or Service Pack 4 for Windows 2000. Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware Spyware and malware are large problems for Internet users today and can be both annoying and a real threat to you and your computer. There exist a number of different spy and malware of which some are relatively friendly and only spies on your surfing habits, while others like the Trojans can be used to corrupt your hard drive or steal your usernames and passwords. How a Bug Challenges to a Software Professional It is really interesting that a bug can create problem for a learned person even the bug is not alive. One day my one friend was working and a bug created much problem. Lotus Domino: Reports and Connectors - Crystal Reports, XML, ODBC/JDBC, OLE Lotus Notes Domino is very efficient in electronic document workflow automation. Unfortunately the electronic document workflow can not replace paper documents completely. DVD Burning Tips CD and DVD replication is a process that works by creating discs from scratch. Not to be confused with duplication (the act of burning information onto readymade, commercially-available blank CD-Rs and DVD-Rs), replication relies on the use of molds to produce actual discs that already contain digital data. 6 Easy Steps for a Smoother CD/DVD Order It's all about turn times in the eMedia industry! The speed with which your vendor can get your CD or DVD project completed is vital to many customers. However, responsibility for these projects meeting their completion dates starts with the customer and ends with the vendor. Dashboard Widgets for Windows For a windows user like me, just can watch with envy the new eye candy features in Mac OS X and wondering how I can have the same feature on my belove windows.Before Apple introduce dashboard in their latest Mac OS X, most of mac users already can have widget on their desktop using Konfabulator by Pixoria Inc. Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve - Tips For Developer Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. Software Development in 2005 - Back to the Future 2005 - Back to the Future.What does the future hold? A big question and initially the answer is anything and everything. Are You Waiting for Microsoft Longhorn Operating System I love new technology. I am still ready to wait long for Longhorn. Microsoft Navision Customization and Reporting - Tips For Programmer/IT Specialist C/SIDE (Client/Server Integrated Development Environment) - The core of Navision is the C/SIDE. C/SIDE is the foundation for all the business management functionality of Navision. Fleet Maintenance Software Reviews Innovative Maintenance Systems (IMS) is one company that offers solutions for companies in need of fleet maintenance software. One of their most popular products is Fleet Maintenance ProŽ. |
home | site map | contact us |