Results 1 to 3 of 3

Thread: liquor inventory

  1. #1
    tuica Guest

    liquor inventory

    Hello,

    I need some help with inventory. We purchased a bar code scanner from BPA and hooked it up. It works fine but I can not figure out how to do what we want to do. First thing we did was scan each bottle in the system so that the UPC number from the bottle matches the correct item in the product database. Now I want to do a physical count of inventory using the bar code scanner. As I scan each item, I want that item quantity to increment in inventory. Also the beer wine and liqour are stored in the liquor room downstairs. When we recieve a bottle in the liquor room I want to scan it in the system. When I remove a bottle from the liquor room to take upstairs to the bar I want to scan it out of the liquor room inventory, and have it show up somehow in the bar inventory. I also want to scan what is in the bar so i can keep a physical count of two locations. I want to view a report that says I have x amount of inventory at the bar, and x amount of inventory in the liquor room. I need to keep track of variances. If the systems say I have 10 bottles of Jack Daniels, I want to see where those 10 bottles are at. For example two bottles of Jack Daniels at the bar and 8 bottles of Jack Daniels in the liquor room. How can I do this?

    regards,

    Erik Koehler
    BPA re-seller

  2. #2
    billmh Guest
    I asked this same question a while ago. The UPC code is only read via the sales process. You cannot use it to find a product and update via the Inventory system.

    I suggested this be chnaged. It would make liquor inventory a snap.

  3. #3
    Join Date
    Jan 2002
    Location
    UTAH
    Posts
    304
    This is not entirely true.

    If you setup your liquor products so that they use the upc code from the bottle as the product/service code(product id) you can then go into Inventory Management->Modify and when you go to enter the the product id just scan the barcode instead.

    You can also create Vendor Purchase Orders/Product Receiving in the same way if you have setup your liquor products as described above.

    What makes more sense is to print out a barcode book for your liquor which uses the existing product ids as barcodes. Then just scan the appropiate barcode in Inventory Management->Modify to locate the inventory product record. You can also do Vendor Purchase Orders/Product Receiving this way.
    Joe

    BSS Tech Support Manager / Software Engineer

Similar Threads

  1. Liquor/Mixed Drink Sales
    By billmh in forum Restaurant Sales
    Replies: 3
    Last Post: 08-04-2008, 01:51 PM
  2. Liquor Sales/Inventory
    By billmh in forum Inventory Management
    Replies: 1
    Last Post: 06-13-2005, 11:37 AM
  3. Replies: 0
    Last Post: 03-13-2002, 03:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •