1 | Bevcon Dispense System Setup

This page covers the setup process for the Bevcon Dispense Control System interface that can be used to access databases in Bepoz. This system utilises an Access database. It should be located on the same actual computer as SmartController to miminise connection problems. SmartController will connect to the Access database using no password or security settings. If SmartController cannot connect to the database, it will retry to connect every 30 seconds.

This page covers the setup process for the Bevcon Dispense Control System interface that can be used to access databases in Bepoz.

This system utilises an Access database. It should be located on the same actual computer as SmartController to miminise connection problems. SmartController will connect to the Access database using no password or security settings. If SmartController cannot connect to the database, it will retry to connect every 30 seconds. The interface connects to their database and adds rows directly to the 'posdata' table inside.

Prerequisites​​​​​​​

• To begin the implementation process, the Implementation Operator must have the following privileges enabled:
• Ability to use BackOffice
• Access to & maintenance of Venue, Stores & Tills

Bevcon Dispense Device

• After logging into Backoffice, go to System Setup > Venues, Stores & Tills
• Select the server workstation which will open a window with a list of all the devices integrated into the workstation
• From the header, click on the 'Add New Device' button and select a blank device
• Configure the device with the following settings:
  • Device Type: Dispense
  • External DLL Name: Stdlibrary.Dll
  • Bev Con

Device Settings

• Read Flow Data:
  • This should be ON
  • This is supported by Flowtech
  • It will request the dispense data from Flowtech and enable the Dispense Summary Report
• Sales Transfer Database:
  • If the access database is on the same directory as the Bepoz database, this is not required
  • If it is located elsewhere put that directory name here
  • Only 20 characters are available
• Bevcon Database:
  • This is the Main Bevcon Database file name
  • It may be an Access Filename or a SQL Server database name

Technical Details

• The Table that received the data is called "posdata"
• The data fields sent across is as follows: 
  • Field Name Data Type BEpoz Data
• Sequence Autonumber (none)
• PLU Long Integer ExportCode1 + Size Number
• DatetimeofTrans DateTime Transaction Datetime
• Qty Double Item Sold Qty
• Location Text (length=4) StoreID
• Register Integer Till's WorkstationID