----------------------------------------------------------------------------- - References ----------------------------------------------------------------------------- ======================= GST Sample Stock Update ======================= update mas_stock set m_tax1 = 'T', m_tax2 = 'T', m_tax3 = 'F', m_tax4 = 'F', m_gst_code_input = 'TX', m_gst_code_output= 'SR', m_gst_trans_input= 'I', m_gst_trans_output= 'O', m_gst_type_input= 'S', m_gst_type_output= 'S' ================= Add Firebird User ================= eg. C:\Program Files\Firebird\Firebird_2_0\bin\gsec -user xxxx -pa xxxx -add ABCD -pw 1234 ==================== Modify Firebird User ==================== eg. C:\Program Files\Firebird\Firebird_2_0\bin\gsec -user xxxx -pa xxxx -modify ABCD -pw 1234 ==================== Delete Firebird User ==================== eg. C:\Program Files\Firebird\Firebird_2_0\bin\gsec -user xxxx -pa xxxx -delete ABCD ================== Firebird Reference ================== 1) If FireWall On, Please Open Port 3050. 2) If Interbase Installed, Please Removed Completely. Included gds32.dll - Win2000 C:\winnt\system32 WinXP C:\windows\system32 ================= Version Reference ================= eg. 3.000.0.0 a) 3 - Product Version b) .000 - Database Version c) .0.0 - Program Version ======================== Database.db & Default.db ======================== - M_STATUS 01=Server, 0=Local 1=Remote 02=Version, 00=FB1.5 01=FB2.0 02=IB6.0 03=IB7.0 04=OS, 0=Windows 1=Linux 05=Log Ext, 000=Start 999=end 08=Write Log, 0=No 1=DB 2=File 09=Load Photo, 0=No 1=DB 2=File 10=Clear Log, 0=No 1=Yes 11=Clear Days, 001=Days 999=Days 14=Picture Size 00=KB 99=KB ===================== 12.215.0.0 2012-04-01 ===================== 1) New QubeBack.exe ===================== 12.215.1.0 2012-04-26 ===================== 1) Add Access Right - Change Table - Price Change ===================== 12.216.0.0 2012-05-09 ===================== 1) Change Master Username - QASDEV 2) Enable The Condiment 3) Stock To Print Label On FRontPos ===================== 12.216.1.0 2012-06-18 ===================== 1) Security Command Changed 2) Add POSOFF - Log Off 3) Add POSMAP - Mapping Floor ===================== 12.216.1.0 2012-06-18 ===================== 1) Command Changed 2) Payment With Fixed Value 3) Add Open Member ===================== 12.216.2.0 2012-07-14 ===================== 1) Minor Changes ===================== 12.216.3.0 2012-07-21 ===================== 1) Re-assign User Group Access 2) Security Level : a) Item/All Discount b) Sales Remark c) Open Discount 3) Membership Report - Membership Payment Report - Membership Payment Report By Date - Membership Spending Report ===================== 12.217.0.0 2012-07-21 ===================== 1) Discount For : - Item Discount - Subtotal Discount 2) VOIDHL - Item Void After Hold 3) Add Reports - Bill Summary Report - Bill Audit Report - Table Performance Report ===================== 12.217.1.0 2012-07-24 ===================== 1) Fixed User Group Access - POS ===================== 12.218.0.0 2012-07-28 ===================== 1) Meal Count - With Report 2) Setup.Ini [Meal_Count] Range01=0,9.50 Range02=150,9.20 Range03=250,8.70 Range04=350,7.20 Range05=400,7.00 Range06=450,6.80 Range07=500,6.50 Range08=99999999,0 Range09=99999999,0 Range10=99999999,0 ===================== 12.218.1.0 2012-08-23 ===================== 1) Meal Count Report - Report\Sales\Customer Meal Count Report-Date.rtm - Report\Sales\Customer Spending Report No Cons-SKU.rtm 2) Add Security Access - COMTBL - SPLTBL ===================== 12.218.2.0 2012-08-24 ===================== 1) Reason - Add Kitchen Message 2) Add Security Access - KPMSGS ===================== 12.218.3.0 2012-09-11 ===================== 1) Add Customer Spending Count Report 2) Add Customer Meal Count Summary Report ===================== 12.218.4.0 2012-09-22 ===================== 1) Add Security Access - TBLCXZ ===================== 12.219.0.0 2012-09-29 ===================== 1) Linear Format - Add Customer Meal Count Summary Report ===================== 12.219.1.0 2012-10-09 ===================== 1) Add Security Access - TRFTBL ===================== 12.219.2.0 2012-10-30 ===================== 1) Add Security Access - FOC_XZ - AGT_XZ - HOB_XZ 2) Customer Meal Count By Date Report - Report\Sales\Customer Meal Count By Date ===================== 12.220.0.0 2012-11-07 ===================== 1) Add Salesperson Card ID 2) Sales update Fix for House Bon Features 3) New rtm ====================== XE3.223.0.0 2013-02-10 ====================== 1) New Out look 2) Reason - Item Cancel 3) Report Access Level - Item Cancel Report ====================== XE3.223.1.0 2013-03-26 ====================== 1) Bugs Fixed (DLDLG) ====================== XE3.225.0.0 2013-05-04 ====================== 1) Stock Card DB Connection Error 2) Optional To Update Document With Period 3) Auto unlock Document ====================== XE3.225.1.0 2013-06-08 ====================== 1) View Group By (Updated) ====================== XE3.225.2.0 2013-08-01 ====================== 1) PK+Main Set -> PK -> Raw Material 2) Click Tab 'Description' Next To '=' 3) Copy & Paste All For Stock - Except Menu Item, Raw Material & Pull Down Item 4) Set Stock Queue Link - Clear Then Link ====================== XE3.225.3.0 2013-09-18 ====================== 1) Support KDS ====================== XE3.225.4.0 2013-11-18 ====================== 1) Q-FNB POS Version 2) Plu Wih Price/Weight 3) Security POS - Condiment Sales Report 4) Condiment Max Default = 1 ====================== XE3.225.5.0 2014-01-02 ====================== 1) Encryption 2) Customer Code Max 16 3) Membership Code Max 16 ====================== XE3.226.0.0 2014-03-06 ====================== 1) Prepaid Card - PaidCard.ini - NecoList.txt - SCL.exe - OTP.dll 2) Fix Batch File - db\FixPos_XXXX.bat 3) Sales Report By X Changed - Group - Department - Sub-Department - Category 4) Hide Unused Function 5) Support Firebird 2.5 ====================== XE3.226.1.0 2014-04-04 ====================== 1) Minor Bug Fixed 2) Option To Disable Function Password 3) Customer Meal Count Summary By Account Report - Report\Sales\SS051.rtm ====================== XE3.227.0.0 2014-05-09 ====================== 1) Tax Symbol (GST) 2) Tax Report Option To Exclude Transaction Void 3) Tax Table 4) Stock - Input Tax - Output Tax 5) Supplier & Customer Document With Tax Code 6) Revamp Front Pos Reports ====================== XE3.227.1.0 2014-05-22 ====================== 1) Documents Add GST Format - Supplier - Customer ====================== XE3.227.2.0 2014-07-24 ====================== 1) Payment Add EFT Payment 2) User Group Access Add EFT Payment Report ====================== XE3.228.0.0 2014-09-19 ====================== 1) Tax System Add Tax Link 2) Customer and Supplier Add GST ID 3) Document Add Tax Trans and Tax Type ====================== XE3.228.1.0 2014-10-22 ====================== 1) Add Area Maintenance FOR CLIENT :- a) update mas_customer set m_area = 'EMP' b) update mas_customer set m_area = 'CON' WHERE M_CODE > 'C' and M_CODE < 'D' 2) Auto Disable GST Code If No GST No For - Supplier - Customer ====================== XE3.228.2.0 2014-11-01 ====================== 1) Stock Tax Auto Link ====================== XE3.228.3.0 2014-11-17 ====================== 1) Add GST Summary Report ====================== XE3.228.4.0 2015-03-05 ====================== 1) Requisition Option To Not Allow To Edit Unit Cost 2) Support SCL011 3) Utilities - Copy Price Shift - Preset Stock GST ====================== XE3.228.5.0 2015-03-13 ====================== 1) Support SCL011G 2) FPOS - Transaction Void Report ====================== XE3.229.0.0 2015-04-27 ====================== 1) Price Auto Updating By Date 2) Data Clear - Stock Item, Group, Department, Sub-Department, Category 3) Tax Set Exempt Selection 4) Printer Queue Summary Default 'F' ====================== XE3.230.0.0 2015-05-26 ====================== 1) GST Started Stock No Output Tax Will Prompt Message 2) Add CLOUD 3700 Mifare Reader 3) PaidCard.ini [Setting] Timer_Delay=250 4) Add Customer Monthly Processing 5) Monthly/Yearly Sales Report Add Rounding 6) Avg Cost Will Not Calculate if Current Balance < 0 ====================== XE3.230.1.0 2015-06-17 ====================== 1) Transaction Detail Analysis - Support Tax Inclusive ====================== XE3.230.2.0 2015-06-19 ====================== 1) Customer Credit Limit Range Copy 2) Show Credit Balance At Customer Limit Adjustment ====================== XE3.230.3.0 2015-06-25 ====================== 1) Sales Average Report - TR023.rtm ====================== XE3.230.4.0 2015-07-07 ====================== 1) Sales Average Report - Fixed Filter ====================== XE3.230.5.0 2015-07-27 ====================== 1) Receipt Analysis Report - Add Fields for Membership ====================== XE3.230.6.0 2015-08-18 ====================== 1) Some Report Multi Selection No Function ====================== XE3.230.7.0 2015-11-25 ====================== 1) Check Digit EAB8 & EAN-13 ====================== XE3.230.8.0 2015-12-04 ====================== 1) Default Stock Input & Output Tax 2) Terminal Can Same if Different Outlet ====================== XE3.230.9.0 2016-08-23 ====================== 1) If Set Menu Change To Normal M_SET_MENU_1 - 6 Set To 0 2) Sales Consolidate & Sales Import Got Date Selection ====================== XE3.230.10.0 2016-09-23 ====================== 1) Time Attendance Report Fixed ====================== XE3.230.11.0 2017-02-14 ====================== 1) Add Prepaid Card Balance - Payemnt Analysis Report - Cash Management Report ====================== XE3.230.12.0 2017-02-24 ====================== 1) Stock Print Label Able To Assign Printer 1 or Printer 2 ====================== XE3.230.12.1 2017-04-12 ====================== 1) Sales Person Commission Report By Stock Rate