Clients and Projects

Bruce Burlington & Co. Ltd. are a wholesale wines, beers and spirits wholesaler, they commissioned me to create a Pricelist Production System.

This system was written in Microsoft Access 2000 and Visual Dialogscript.

The system produces pricelists for the client, the data for the pricelists is held in a UNIX system, which produces fixed width textual output files, these files are imported into the Pricelist Production System which provides extensive facilities to customise the pricelists produced.

The pricelists are printed with user selectable images for product group as well as user entered blocks of descriptive text.

The Menu

Pricelist customisation facilities:

• Set the descriptions for Departments, Product groups and Individual Products.

• Manage pricing schemes.

• Set the display order of Departments, Product groups and Individual Products.

• Assign various elements of additional data per product to be displayed on the pricelist.

• Activate, De-Activate Departments, Product groups and Individual Products.

• Mark products for highlighting on the pricelists.

In addition the system provides comprehensive management reporting facilities.

Product Overview

Pricelist Customisation

Pricelist Data Selection