Solution for an invoice system used in the field of optometry

Abstract

This paper presents the design, development and implementation of the database and application for the book-keeping of goods of a small trade. The goal is to portray the invoice system and the solutions for the practical conveniences with the emphasis on the customerspsila view on it. The application is created specially to meet the needs of an optometrist and his workshop. The following aspects are included in this article: defining the goods, giving offers, creating the invoice and finally, the methods of presenting the invoice to the customer and the book-keeper. The majority of the data input is automated. The application is written in VB6 using MSAccess for the database. The complete invoice can be printed and exported to PDF or XML format, which can be sent via email and is easily processed by any other application.