DDH Software, LLC Making a big world smaller


Author:martyr99@bellsouth.net [Send Author Email]

August 27, 2012
Description:This is a simple inventorying app that demonstrates how to use scanned barcodes to adjust stock levels. There are 2 files: Item_Master & ItemConsumption, each with a few sample records to demonstrate. The Item_Master constains an item description, item# (UPC_EAN8 barcode), starting inventory quantity, and link/relationship to the other file to obtain a running total of consumption quantities for an item. The final field calculates the inventory balance (starting quantity minus running total of consumed inventory). This file supports scanning of the barcoded item# or it can be just typed into the UPC_EAN8 field. The itemConsumption file contains a field that's used to capture the barcode that will be stored in the "UPC_EAN8" item# field, a default quantity of 1 to represent the quantity to be removed from inventory, and a running total field that shows the sum of all inventory records. The final field is a link/relationship field that gets the item description from the Item_Master file. The type of barcode is not restricted--you can scan any supported the barcode types including QR codes, although the item# field size would need to be increased if you need to capture values longer than 15 characters.
Has Data:No
Has Forms:No
Comments:Unzip the two HanDBase "pdb" files, then install them.
Version:HanDBase v.4.x Enhanced or greater
File:b_itemconsumption.zip          Downloads: This Month 3 / Total* 2423
Note:MAC Users will need to enter the filename b_itemconsumption.zip when saving this file.
* since October 1, 2000.

Other Titles from martyr99@bellsouth.net