How can we help you today?

Solution home Smart Biz SQL

Script and HotFix

Purchase Supply Listing(Service Tax), TaxCode/Counter Filter not functioning
SmartBiz SQL version 2018.3 Build 0007 - Purchase Supply Listing(Service Tax), Tax Code/Counter filter are not functioning. Run script {PurchaseSupplyListi...
Wed, 7 Nov, 2018 at 10:10 AM
Save Customer Receipt Prompt Error (divide by zero)
SmartBiz SQL 2018.3 Build 0006 - Save Customer Receipt Prompt Error (divide by zero). Run attachment script {SmartSQL2018.3B06_SaveReceiptError_solution...
Sat, 27 Oct, 2018 at 4:23 PM
Receipt Listing/Customer Adjustment Listing/Custsomer CN Listing Show Weird Value in version 2018.3 Build 0005
Kindly run attachment script {View_Related_For_Listing_2018.3Build0005.sql} to fix preview Receipt Listing/Customer Adjustment/Customer CN Listing, some col...
Mon, 15 Oct, 2018 at 10:45 AM
TouchNPOS Server Socket Posting Error "Invalid column name 'sAllowGST' "
Those whose SmartBiz SQL in version 2018.3 Build 0001 and encounter TouchNPOS Server Socket Posting Error "Invalid column name 'sAllowGST' &quo...
Sat, 1 Sep, 2018 at 5:16 PM
TouchNPOS database Stock Item SST Tax Code Has No Value
Try run this view script in SmartBiz SQL database if TouchNPOS encounter download problem.(POS Stock item SST Tax Code has not value).  Then perform a down...
Fri, 31 Aug, 2018 at 5:16 PM
Update All Stock Item SST Tax Code (Supply) To SL0
Update All Stock Item SST Tax Code (Supply) To SL0
Sat, 1 Sep, 2018 at 11:45 AM
Update All Stock Item SST Tax Code (Supply) To SL5
Update All Stock Item SST Tax Code (Supply) To SL5
Sat, 1 Sep, 2018 at 11:46 AM
Update All Stock Item SST Tax Code (Supply) To SL10
Update All Stock Item SST Tax Code (Supply) To SL10
Sat, 1 Sep, 2018 at 11:47 AM
Update All Stock Item SST Tax Code (Supply) To SV0
Update All Stock Item SST Tax Code (Supply) To SV0
Fri, 31 Aug, 2018 at 3:33 PM
Update All Stock Item SST Tax Code (Supply) To SV6
Update All Stock Item SST Tax Code (Supply) To SV6
Fri, 31 Aug, 2018 at 3:35 PM