Hello, i am new here.
I hope you guys can give some suggestion here. I am in the end of developing a software for my company. I am not sure what to call it, an ERP/CRM/MIS system with accounting function. The system is developed mainly using Visual Basic 6, MS SQL Server 2000 and Crystal Reports 8.5 Developer. My boss then raised out a problem regarding the closing account and bring forward. After the system is implemented, and run for 2 years or more, the database will be full of transaction and records. The report generation will be slower due to this reason. Me and another senior are the only programmers in the company and we are not familiar with Accounting concepts. We only use basic skills i.e like View or temporary tables for some Report generation and we want to avoid using Triggers or Store Procedures. Please advise. Thanks.