Whitman Point of Sale (POS)

Posted On 2017-12-30 by VB6Boy
Keywords:
Tags: VB6 Complete Applications VB6 Databases VB6 Miscellaneous Windows
Views: 307

Download Attachment


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? ;)

Requirements

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


About the Author

VB6Boy has posted a total of 28 articles.


Comments On This Post

No comments on this post yet!


Do you have a thought relating to this post? You can post your comment here. If you have an unrelated question, you can use the Q&A section to ask it.

Or you can drop a note to the administrators if you're not sure where you should post.


Your IP address is:54.82.57.154

Before you can post, you need to prove you are human. If you log in, this test goes away.




Code Links