SQL Account Releases

SQL Account 5.2021.908.802

Released on 29 May 2021
Release Notes
  • #5847: Customer Balance Report’s Current Balance should show PM outstanding instead of 0 when Future Refund knockoff PM (within date range)
  • Fixed GL Payment Voucher – RTM format Currency Rate 1 should hide
  • Fixed GL Bank Reconciliation Report – Clear Transaction not include Opening Balance Information
  • Fix Woocommerce did not fetch product’s variations
  • Fix Shopee order couldn’t be posted when shipping fee charged more than item price
  • Feature: Lazada setting add “Claims” item group
  • Adjust: Lazada payment to use statement description as SQL description
  • Feature: Lazada payment will create customer refund to knock off
  • Feature: Lazada payment will amend invoice detail
  • Feature: Shopee order able to replace sales invoice
  • Feature: Shopee payment able to post past invoice
  • Fix Shopee order did not include seller coin cash back as voucher
  • Fix Shopee order post to Sales Quotation incorrect detail
  • Fix Shopee order incorrect discount amount
  • Fix Shopee, Lazada order refund should post only returned item
  • Fix Shopee order couldn’t be posted when escrow amount is less than 0
  • Fix Lazada order will prompt error when no orders within the selected period
  • Fix eCommerce address filled up wrongly in invoice
  • Fix AutoBankRecon matched to wrong record
  • #5846: GL Bank Deposit Search Form missing Mark & Clear All, Mark & Clear Selected in grid context menu
  • #5833: Sales Profit Estimator’s Total Sales Rounding issue

SQL Account 5.2021.907.801

Released on 28 Apr 2021
Release Notes
  • Upgrade Database Version 183
  • Add Shopee 2 format
  • #5823: SST-02 Report Field 11a, 11b, 11c and B1 should include CN with SU, SU5 & SUV tax code
  • Feature #3595: GL Balance Sheet Report when drill down Customer/Supplier account should apply Sales/Purchase Ledger report accordingly
  • #5764: Job Order Listing Report master record show only when there is detail record
  • Feature #5814: Stock Transfer Listing detail grid add more columns from detail dataset
  • Feature #4701: Production Outstanding Sales Order add ItemType option to suit SO->PO case
  • Feature #5736: Stock Item – BOM add Number, Description2, Description3, Remark1 & Remark2 fields
  • Feature: Lazada payment able to post past invoice
  • Fix Woocommerce product fetch time out
  • Feature – Lazada auto refresh token when expires
  • Fix Shopee order status “To Ship” will always post to QT
  • Fix eCommerce post IV, CN, QT should overwrite the original address
  • Fix Lazada will return error message from the response
  • Feature: Lazada payment with same PaymentRefID with auto open bank deposit
  • Fix Lazada order unable to manual map item code for certain orders
  • Fix Lazada unable to post payment when all orders are posted to invoice
  • Fix eCommerce grid flickering issue when posting IV
  • Fix Shopee shipping fee not tally
  • Add GL.Auto.BankRecon.CITIMY
  • Fix auto bank recon error at RHB Bank Statement
  • #5812: auto bank recon error at Alliance Bank statement
  • Fix dashboard floating point error
  • #5831: Process SST return prompt error “Account code cannot be empty” if an invoice contains detail with tax code SV (payment basis) and SVA
  • #5809: Stock Matrix not working on document entries
  • #5802: GL Official Receipt didn’t prompt bank reconciled warning message even already reconciled
  • #5811: Maintain Stock Item’s BOM SubTotal column should hide when access right “Show Cost in Stock Item Maintenance” unticked
  • #5808: Available Stock Balance and Stock Reports’ item JO Qtyshould show 0 if Stock Assembly’s detail Qty greater than Job Order’s detail Qty
  • #5813: Customer Contra Entry prompt “Unable to commit inactive” error upon save
  • Feature #5791: All entry forms support Edit -> Edit As New

SQL Account 5.2021.906.800

Released on 06 Apr 2021
Release Notes
  • Upgrade Database to Version 182
  • Reduce Column Usage on FR3 Export to excel for Sales Local – Cash Sales Collection Report when full expand
  • Feature #5779: Purchase Price History add Master & Detail Landing Cost 1 & Landing Cost 2
  • #5782: Sales Price History data sorting inconsistent, should sort by DtlKey
  • Feature #5780: Stock Card by Qty Report enable Print Stock Control Item & Non Stock Control Item Options
  • Fixed Sales Invoice 3 (Sales Disc) not include itemcode DISC
  • Adjust AddToCart add column item sku
  • Fix bug: Add supplier bank account without specify bank raise error “Could not convert variant of type Null into type OleStr
  • #5799: Maintain GL Account should remove Parent account from Payment Method if other bank drag under it
  • Fix eCommerce unable to show all products when more than 1 shops are link with SQL
  • Adjust Lazada: Payment disable “Post” button if any order not posted to invoice
  • Adjust Lazada: map sql item code with Shop SKU
  • Fix bug: Woocommerce unable to fetch data
  • Feature: eCommerce order able to post by project
  • Feature: eCommerce order able to manual set item code and uom
  • Fix eCommerce will not post item when price = 0
  • Adjust Shopee shipping fee when posting to invoice
  • Fix AutoBankRecon UOVBMY adjust data positioning
  • Feature AutoBankRecon able to switch between classic and statement view
  • Add AutoBankRecon PIBEMY keyword for matching PDF file
  • Feature #5793: GL Bank Reconciliation Deposit records show any OR record’s Description and Cheque Number
  • #5768: Browse grid not focus on first row if one of the column sort by descending in last saved grid layout
  • #5778: F8 Barcode form cost related UI controls should be hidden if user no right to view cost
  • #5391: Unable to update GL Maintain Opening Balance if project code with /
  • Fix Close company profile window prompt message “You must re-logon for these changes to take effect”
  • Fix Lazada payment split voucher from other fee
  • Fix RHB Statement couldn’t load when balance is negative
  • Fix Lazada product limit per fetch change from 100 to 50
  • Fix Shopee not posting CN when returned order’s escrow amount > 0
  • Fix Lazada Seller Voucher should post as negative
  • #5771: Unable to open attachment file name with special character #

SQL Account 5.2021.903.799

Released on 05 Mar 2021
Release Notes
  • #Fixed Sales Cash Sales 6 – Receipt-TM-U220 (SST) DocNo alignment problem
  • #5757: Bank Recon word will overlay with others when too long
  • Adjust eCommerce to post customer phone to DPhone1, customer id to DocRef4
  • Fixed Bug eCommerce: Credit note did not knock off when posting payment
  • AR/AP PM, CN, Refund & Contra add Knockoff DocNo info for error “Knock off amount must not exceed outstanding amount”
  • Fix bug: Auto bank recon PDF last record not showing

SQL Account 5.2021.901.798

Released on 25 Feb 2021
Release Notes
  • Upgrade Database Version 181
  • #5742: Customer Refund listing preview prompt error “Document_CompanyBankAcc: Could not open DataSet”
  • Feature #5754: AR/AP Contra auto open couple contra form upon save if couple company code is empty
  • Add GL.Auto.BankRecon.UOVBMY
  • Added column Recon At at auto bank recon
  • #5036: GL Journal Entry form mode not working if FromDocType are CN & DN
  • #5745: Different date format for PBB statement (CSV)
  • #5743: Invalid numeric input error when load MAYBANK statement

SQL Account 5.2021.897.797

Released on 08 Jan 2021
Release Notes
  • Fix GL Bank Reconciliation Report – Clear Transaction should exclude cancelled document
  • Fixed Sales Local – Cash Sales Collection Report unable to shown detail information
  • #5704: GL P&L Report Net Sales & Gross Profit/(Loss) have to show out even 0
  • #5726: AR/AP Balance Report Local C/F not 0 due to incorrect local outstanding for CN
  • Fixed Cust Contra Voucher – Full format had invalid character
  • Feature #5727 : Auto Bank Recon – Add OCBC
  • Add E-Commerce: AddToCart
  • #5711: Auto Bank Recon – Support Maybank different statement format
  • #5714: Auto Bank Recon – PBB statement has different format
  • #5707: Auto Bank Recon – HLBB statement has different format

SQL Account 5.2021.897.796

Released on 08 Jan 2021
Release Notes
  • Upgrade Database Version 180
  • Fixed JV Description overlap when Description too long
  • #5715: Unable to Save when Knockoff Invoice for some situation
  • Add E-Commerce: Lazada, Shopee & Woocommerce

SQL Account 5.2020.896.795

Released on 29 Dec 2020
Release Notes
  • Upgrade Database Version 179
  • Add SST-02 (2020) format
  • GL Receipt & Payment Report Prepayment Account should include transaction of Payment that transfer from AP Deposit
  • Add Supplier Deposit Listing Report
  • Enable Support Supplier Deposit for GL OR & GL PV format
  • Feature #5679: Maintain Batch support DIY Views
  • #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
  • Feature #5701: GL Cash Book Detail & Tax ledger transaction “Description2” field should refer to CompanyName field value
  • Feature #5553: Add Supplier Deposit Entry & Report
  • Feature #5565: Stock Assembly, Disassembly & Job Order’s BOM Template become blank once the document has been saved
  • GL Bank Reconciliation support Auto Bank Recon feature

SQL Account 5.2020.895.794

Released on 17 Dec 2020
Release Notes
  • #5678: AR/AP Balance Report’s Current Balance & C/F incorrect when Refund knockoff CN falls in different month
  • Fixed GL Bank Reconciliation Report – Clear Transaction not sorting
  • Fixed GL Bank Reconciliation Report – Clear Transaction Transactions not only shown once when there is Same DocNo
  • Update SST-02 (2019) Add Digital Tax Refund Calculation
  • Fixed GL PnL – Comparison – 22C1P preview error when user use – when 0 as displayformat
  • Auto Get Buying Rate from Maintain Currency when Currency Rate is 1 for GL PnL Currency report
  • Auto Get Buying Rate from Maintain Currency Currency Rate is 1 for GL BS – 3C1P-IFRS-Currency report
  • Fixed SST Listing 4-DST-02(2020) Preview Error when Tariff more the 15
  • #5653: Maintain Stock Item if have multiple UOM with rate=1, should allow to change rate if IsBase is unticked
  • #5690: Prompt access violation error when Customer/Supplier Code format is %.3s-%.0s%.4d
  • Ignore tax return checking on document if GST/SST is not started
  • #5673 User able to access Sales Analysis by document when user did not purchase S&P module
  • Feature #5672: Stock Take sync stock item add new field – Shelf
  • #5669: Supplier bank account lookup does not exclude inactive record

SQL Account 5.2020.885.789

Released on 06 Jun 2020
Release Notes
  • Upgrade Database to Version 178
  • Add Dashboard
  • #5529: Process SST SV with Past IV Project Code is empty
  • #5521: Points Entry Grid Caption for Code incorrect
  • #5512: Grid cell always align to right on display dpi other than 100%

SQL Account 5.2020.880.786

Released on 06 Mar 2020
Release Notes
  • Upgrade Database to Version 176
  • Fixed Sales & Price History Group by DocNo, Tax & Tariff shown incorrect grouping information
  • #5486: Import Serial Number with Prompt Replace Unit Price Dialog prompt error control has no parent window
  • #5494: AR Payment edit and change “From Deposit” to another deposit not update the Deposit Amount in AR Deposit
  • #5492: GL Maintain Opening Balance 2nd Description is empty
  • #5489: Customer Refund slow after choose customer code if knockoff has over 1k records
  • Feature #5427: Maintain Item Template add Location & Project fields
  • #5475: GL Cash Book – Save Prompt Error if user empty the Amount Column

SQL Account 5.2020.879.785

Released on 01 Feb 2020
Release Notes
  • #5391: Sales Profit Estimator should convert to customer currency when click “Update Unit Price” button
  • #5467: SL Invoice unable to posting via BizObject If Exceed Credit Limit with overridden permission
  • #5048: Should not prompt dialog if user set Overdue or Credit Limit to 0 and the user allow to override
  • #5468: Add calculator editor numeric column in GL Cash Book and Journal Entry
  • Feature #5440: Document Transfer Dialog by default filter 7 Months from target document DocDate
  • Feature #5453: AR/AP Documents browse grid add 2nd company name column
  • Feature #5437: All GL Account Lookup add 2nd Description column
  • #5457: COM client cannot capture invalid logon credential

SQL Account 5.2019.878.784

Released on 10 Dec 2019
Release Notes
  • #5417: GL Profit Loss & Balance Sheet – Fixed Date params show as number
  • Stock Purchase Planning (Current & Next 3 months) report file has fixed Get SQty instead of Qty for PO and SO in each months.
  • Fixed Customer CN full page formate Company Header overlaping the Company Logo
  • Fixed Discount Amount not shown when using Disc Column for Sales Invoice 3 (Sales Disc)
  • Feature #5412: Stock Transfer Listing Report add “SubTotal (Tax)” column in detail grid
  • #5413: Stock Transfer Listing “Actual Amount” should sum up for IN qty amount only
  • #5419: GL Ledger untick “Include Zero B/F with Transactions Before” should determine by LocalBalance instead of Balance field as some account has Local value but foreign value is zero
  • #5418: Supplier Analysis by Document grouping 1 level but show level 2 report on screen
  • #5421: GST-SG the box 13 should refer to net sales because box 4 has including CN in F5 return
  • #5433: AR/AP Statement’s Balance not sum correctly
  • Rename SST-02 file name
  • Add Sales Local – Sales Order Listing (Tax 1)-SO2PO Report
  • Add Sales Local – Cash Sales Listing – Z Report
  • Add Sales Local – Cash Sales Collection Report
  • Add Stock Purchase Planning (Current & Next 3 months) report
  • Feature #5410: SL/PH Invoice & Cash Sales add “Transfer To Credit Note” option
  • Feature #3660: Document Entries that has payment info and has been reconciled with bank upon user click edit/delete will prompt confirmation message

SQL Account 5.2019.877.783

Released on 12 Nov 2019
Release Notes
  • #5359: List index out of bound error when double click GL PnL or Balance Sheet Format
  • Add GL Bank Reconciliation Report – Clear Transaction Report
  • #5395: Enable sync via USB cable using Stock Take App
  • #5403: Customer Payment Deposit Drop down unable to show Description
  • #5394: Customer Statement Report same date if got two Payment Transactions (OR) should sort by docno instead of amount
  • #5381: GL Account delete Prepayment Account raise Access Violation error

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info