Estimate and Invoice System – A Stone Supplier
The company is a family-owned stone construction company located in Lansing, IL. The supplier has been in business for over 45 years, and specializes in custom stonework for both residential and commercial construction. The company offers over 100 natural stone products. Its work is handcrafted or machine-cut by talented stone-cutting experts.
The company was using a DOS-based FoxPro database for creating estimates and invoices. They needed to replace their outdated computer equipment by purchasing new computers with an updated Windows operating system.
The FoxPro database was critical to their operations; however it would not work on the new Windows platform. The system needed to be re-written on a contemporary database platform.
The Microsoft Access application developed by alligatortek is used for generating estimates, invoices and reports. The system was specifically designed to work very similar to the FoxPro system. Employees were able to use the new system immediately with minimal re-training.
The company required the database to be robust and able to handle a large amount of transactions. A Microsoft Access Data Project was selected as the front-end platform that would connect to the robust SQL Server database platform.
The system was designed to handle invoice payments so customer receivables can be easily tracked and managed along with their invoices. The system also features robust reporting functionality that provides the company the information they need in order to manage their accounting books.
Start With a Plan: 3 Reasons To Begin Any Development Project With a Discovery Session
Ninety percent of alligatortek clients that begin development with a discovery session will continue to the second part of the process. Want to know why? Here are three reasons why a planning stage will produce better results for you
File-Snapshot Backups to Microsoft Azure Blob Storage
Azure’s SQL Server data files allow us to create a database in an on-premises SQL Server or an available server in the Azure Virtual Machine. This database is tied to our application using a specific location in Azure blob storage. The File-Snapshot backup, introduced in SQL Server 2016, is capable of quickly performing a backup and restore.