You can enable to display stock cards' prices recorded in WOLVOX ERP program, via pricechecker devices. You must configure the settings below in order to integrate with the device.
PERKON VIEW PRICE (FG1200) DEVICE SETTINGS
First, install Firebird ODBC. Firebird ODBC Data Source Administration must be installed. You can download Firebird ODBC Data Source Administration appropriate for your sistem from the links below.
For Windows 32 bit;
For Windows 64 bit;
Add ODBC link from Administrative Tools and Data Sources in Control Panel as below.
Database User Name: SYSDBA
Database Password: masterkey
If you have changed your Firebird password, use your new password.
Install Perkon PriceChecker program. If you don't have set up EXE you can use CD. Run the program and from the ''TERMINALS'' options, select ''Find Devices On Network''. After finding the devices, click adjust selected device button.
On the new page, click network settings button.
Enter user name and password.
User name: admin
Password : fg1200
In this section, enter the host IP and change the host port to100. Then click save to complete process.
Enter Perkon PriceCheck program again and switch to SETTINGS page. Select Remote Data Source from data source section and click adjust ADO Connection button.
For Firebird from the provider section; select ''Microsoft OLE DB Provider for ODBC drivers'', and for SQL; select''Microsoft OLE DB Provider for SQL Server''
Select WOLVOX_FIYATGOR from data source name on connection page and complete the process.
After these steps, you must open a new area under PERKON_FIYATGOR name inside VIEW index in WOLVOX.FDB. To open this area you can call AKINSOFT Call Center and get help from support department or you can install IBExpert program and access database and then create the area taking advantage of SQL code below.
CREATE VIEW PERKON_FIYATGOR(BARKOD,ISIM,FIYAT,DOVIZ) AS SELECT S.BARKODU, S.STOK_ADI,SF.FIYATI, A.PARA_SIMGESI AS DVZ FROM STOK S JOIN AYAR A ON (1=1) JOIN STOK_FIYAT SF ON(SF.BLSTKODU=S.BLKODU AND HESAP=A.PARA_SIMGESI AND ALIS_SATIS=2 AND FIYAT_NO=1)