Whitman Point of Sale (POS)

This is a fully functioning point of sale system written in VB6, utilizing an MS Access database.

Overview

I wrote this way back in 2003 for a friend, who actually used it in his business for quite a number of years. The only reason it went away is because he needed something more robust, with a multi-location and multi-user ability. Maybe I'll share that code in the future.

There is no print functionality in this application. However, if someone wants to send me a USB receipt printer, I would be more than happy to add the printing functionality.

I've included a small piece of the national UPC code database, for demo and testing purposes.

Concepts

There are number of concepts being demonstrated here. Working with an Access database is the main thing to look at though. String processing and formatting, as well as user interface design are also things to pay attention to.

One thing I strive for is not requiring the use of funky third party controls or libraries, so you won't find strange, no-longer-supported OCXs or DLLs with this package.

Compatibility

Compiled, this application works with no problem Windows versions through Windows 10.

Features

Point of Sale

Scrolling receipt display
"Pole" display
Running total
Current price and tax rate per item
Barcode reader ready

Inventory Maintenance

Add/edit/remove items
Mark individual items as taxable or non-taxable
Categorization
Set stock level
Put individual items on sale

Reporting

Re-order report
Product listing by Department
Products on Sale
Taxable products
Non-taxable products
Receipt details

System Settings

Seven configurable receipt fields
Tax rate settings
Product re-order level

Screenshots

Thumbnail click for bigger	Description
	Main menu, where all aspects of the POS are accessed from.
	The point of sale screen. This was built to look like an actual cash register display. Note the scrolling receipt in the lower left, and the barcode field that can be leveraged for use with a keyboard wedge style barcode reader.
	The settings screen, where you adjust tax rates, re-order levels, and fields to be shown on the receipt.
	Inventory maintenance screen, where individual items are added, removed, or edited. This is also where you can mark an item as taxable or non-taxable, or mark it as being on sale. For sale items, you can enter a percentage of discount for the item.
	Keep a finger on the pulse of your inventory by using this reporting screen. Note the use of unique receipt codes, which allows you to view what was sold on a particular transaction. Anyone else see the mistake on this screen? ;)

About this post

Posted: 2017-12-30
By: vb6boy
Viewed: 1,922 times

Requirements

Microsoft ActiveX Data Objects (ADO) is required. This is included with current Windows versions as of the writing of this post.

Loading Comments ...

Comments

AnonymousCoward posted this comment on 2020-10-01:

You must be logged in to make a comment.