Microsoft,Great,Plains,Account computer Microsoft Great Plains Accounting/ERP implementation finan
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
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 townshipsCustomer 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! [email protected]
Microsoft,Great,Plains,Account