Setting up a database

The dPos database understands and tracks four tables or lists of things:

Customers – the first of which must be Cash, and the second must be Cards (ie credit or debit cards), and the rest may be names, companies or anything else you wish to regard as a customer.

Items – these are the items you sell at the point of sale. Each has a name, a price, a VAT/Sales tax code, and a barcode to identify it. It may also have a product code of your choice, an identifiable supplier, and stock and reorder levels; but it MUST have the first four!

Suppliers – this list allows you to identify the supplier of each item you sell – if you wish to.

Sales – this is a dated list of sales that have been made. This list allows you to track the income (and tax) at the end of each day or tax reporting period.

 

The first three tables may be accessed directly using dPos forms which allow entries to be added, edited or deleted. The Sales table may be viewed, and is used as the basis of various reports, but it cannot be edited from a form. Its contents are added to automatically each time a sale is recorded.