Inventory Template

Copper Contributor

I am using the Microsoft Inventory Template, I have loaded barcodes and inventory data, I am trying to figure out how to scan the barcode and have it deleted from the inventory automatically.



1 Reply
I guess the excel template do not provide mimus number of inventory.
Barcode scanner just similar to keyboard.
if you want to minus the quantity of stock,you need write some program codes to automate it.
if by sql,maybe like
update inventory set quantity-1 where inventoryId=scanedId