Business Situation
They had an unreliable bespoke lettings application.
We did some analysis of the application and realised that it needed to be re-engineered.
Surfraider Solutions developed two applications.
Lease Billing & Reporting Application
Aim: Designed & developed a lease billing system which tracks lease payments, client payments, outstanding balances and produces numerous reports, including yearly/Quarterly statements.
Technology: Visual Basic 6, SQL Server (MSDE), Stored Procedures, DTS, VB Data Reports, SQL Server Enterprise Manager, SQL Query Analyzer, Access
Developed Front Office system to produce yearly/quarterly lease service charge statements.
The System stores data about clients, lease, properties, blocks and payments using a SQL Server database.
Used DTS to transform existing data from legacy Access application into SQL Server.
Letting Billing & Reporting Application
Aim: Designed & developed a complete property letting system which tracks tenant payments, clients payments, outstanding balances and produces numerous reports including monthly statements.
Technology: Visual Basic 6, SQL Server (MSDE), Stored Procedures, DTS, VB Data Reports, SQL Server Enterprise Manager, SQL Query Analyzer, Access
Developed Front Office system to produce rental statements and various other reports.
The System stores data about clients, tenants, properties and payments using a SQL Server database.
Used DTS to transform existing data from legacy Access into SQL Server.