SQL Accounting Latest Version (v889) Date : 04 Nov 2025

 5.2025.1055.889

November 4, 2025

New report template for MyInvois Transactions and critical bug fixes (889)

Updates

• MyInvois (E-Invoice MY):
  • New report template for MyInvois Transactions

Bug Fixes

• Fixed Cash Flow Inquiry, GL Bank Reconciliation Listing, GL Project Profit Loss with Cash Flow & Sales Point Listing prompt dynamic SQL error when Apply
• Fixed dynamic SQL error when trying to Batch Submit e-Invoice at Sales Invoice entry browse form

SQL Accounting Latest Version (v888) Date : 21 Oct 2025

5.2025.1052.888

October 21, 2025

Enhanced Mobile Connect features with E-Invoice request capabilities, comprehensive bug fixes for Fixed Asset reports, document transfers, tax maintenance, and improved support for e-commerce integrations including TikTok and Lazada. (888)

Updates

• Mobile Connect:
  • Now support E-Invoice Request on Sales Invoice & Cash Sales
  • Added stock item image on document detail
  • Added Date From, Date To and Statement Date under Customer Statement
  • Added Doc Number under Customer Inquiry for Overdue/Outstanding and Aging
• MyInvois (E-Invoice MY):
  • Added log for E-Invoice status reset when resolving submitting status
  • Document listing now includes filter by E-Invoice status and submission type
• Clipboard Import:
  • Added support for update on GL Account, Stock UOM, Customer/Supplier price and BOM
• E-commerce:
  • Added TikTok adjustment's shipping cost to credit note

Bug Fixes

• Mobile Connect: Partial document transfer missing tooltip
• Ecommerce: Fixed Lazada customer refund and knockoff
• Fixed Asset Analysis (12 Months) header not shown on 2nd page
• Fixed Maintain Tax browse grid sorting column issue
• Fixed GL Cash Book detail form - should disable copy voucher if the document posted from AR/AP
• Fixed Customer Invoice Listing - Outstanding Service Tax report tax amt & Tax code not shown at detail
• Fixed Sales Cancelled Note Listing returns incorrect dataset records when filtered by Stock Item
• Sales document submit e-Invoice with SST tax code "SVE" (before version 5.2025.1045.882) prompt floating point value error

 

SQL Accounting Latest Version (v887) Date : 10 Oct 2025

 5.2025.1051.887

October 10, 2025

Database upgrade to v218 featuring new SST-MY Bad Debt Relief tax codes, enhanced Clipboard Import module support, comprehensive bug fixes for report templates, tax handling, and e-commerce integrations. (887)

Database

• Database upgraded to version 218

Updates

• SST-MY:
  • Added new SST tax codes STBD, STBD & SVBD for Bad Debt Relief (field 13d)
  • Removed old SST-02 Format
• Clipboard Import:
  • Extended support for ARAP, sales, purchase, stock and production modules
  • Added support for document transfer status
• Batch Operations:
  • Batch lookup now includes Remark 1 & 2 columns
• Tax Management:
  • Maintain Tax & Tax Lookup now displays grid column showing government report column number for SST-MY & GST-SG
• E-commerce:
  • Adjusted Shopee partial return posting in sales credit note
  • Adjusted Shopee payment form processing
  • Adjusted Shopee coins posting in sales credit note
  • Enhanced tax amount posting using e-commerce module

Bug Fixes

• Report Templates:
  • Fixed customized Profit & Loss and Balance Sheet Report Template removal issue
• SST-MY:
  • Fixed Purchase documents entry with IMSVE tax code preventing double entry of Tax since it is exempted
  • Fixed Preview SST-02 report template (20250916) with Draft process prompting "fields not found" error
• Document Management:
  • Fixed SL/PH Documents incorrectly showing "transfer to" form when users lack execution rights
• E-commerce:
  • Fixed Shopee seller return refund not posting correctly when order cancelled without return
• Batch Import:
  • Fixed batch import prompting "Missing Dataset property" error
• MyInvois (E-Invoice MY):
  • Fixed MyInvois Transaction open filter row prompting "could not convert variant" error

SQL Accounting Latest Version (v886) Date : 26 Sept 2025

 5.2025.1050.886

September 26, 2025

Database upgrade to v217 with Mobile Connect enhancements, e-commerce optimization, and comprehensive bug fixes for SST-MY, item maintenance, stock balance reporting, and invoice classification issues. (886)

Database

• Database upgraded to version 217

Updates

• Mobile Connect:
  • Auto-select all unit price and quantity values when focused
  • Added customer second company name under Maintain Customer
  • Show item details directly after adding item
• E-commerce:
  • Reduced Shopee fetch product limit from 50 to 20

Bug Fixes

• SST-MY:
  • SST Taxable entry with tax code "SVE" no longer includes TaxAmt when user selects tax rate 6% or 8% in Past Customer Invoice
  • Fixed SST-02 (20250916) mapping error
  • SST-02 report for SALES TAX report type no longer displays Service Tax amount
  • Document entry forms clearing SST tax code "SVE" now clears the exempted tax rate and tax amount
• Fixed Maintain Item's Cust/Supp Price grid export to Excel where Company Name column appears blank
• Stock Available Balance form renamed "Qty After SO" to "Available Qty" and "Available Qty" to "Forecast Qty"
• Fixed Customer Balance report returning incorrect dataset records when filtering by Company Category
• Fixed Sales Invoice detail Tax Rate column displaying Classification value when moving UDF field columns position after Description column
• Fixed a bug where no system report template found for report with custom format

SQL Accounting Latest Version (v884) Date : 19 Sept 2025

5.2025.1048.884

September 19, 2025

SST-02 updates and MyInvois batch submit enhancements (884)

Updates

• SST: Added SST-02 (20250916) format
• MyInvois (EIV MY): Added ExtNo and Ref1 columns to Batch submit E-Invoice
• Report: Added QR & Summary Tax for Sales Invoice 8 (SST 3) - Service Exemption

Bug Fixes

• SST: Fixed incorrect SST Return "Total Taxable Payable" amount when there are Invoice & CN with Sales Tax tax code (now deducts instead of summing up)
• MyInvois (EIV MY): Fixed transfer document to exclude EIV_Received_UTC, EIV_Validated_UTC, IRBM_InternalID fields
• Fixed error F2084: Internal Error: I22370 at MyInvois.Common.UI.pas

 

SQL Accounting Latest Version (v883) Date : 12 Sept 2025

5.2025.1047.883

September 12, 2025

Introduces MyInvois Transaction feature, adds new tax codes, enhances clipboard imports, and fixes critical e-Invoice issues. (883)

Database

• Database upgraded to version 216

Features

• MyInvois (EIV MY): New MyInvois Transaction feature to simplify your workflow without the need to browse MyInvois Portal manually anymore

Updates`

• SST:
  • Added new Service tax code for Non-Taxable Services (SVZ)
• Ecommerce:
  • Added TikTok GMV Payment for TikTok Ads
• Clipboard Import:
  • Revised Menu
  • Each import document now has its own template
• API:
  • Support for multiple parameters for PH report

Bug Fixes

• MyInvois: Fixed Sales Invoice 13 and Sales Invoice 3 (Sales Disc) reports showing IRBM_ValidationLink QR code in sandbox environment
• SST: Fixed SST-02 report where Tax "STE35(3)" was incorrectly mapping to 18d instead of 18e
• GST (SG): GST group now uses GST No as TaxRefNo for GST F5 submission instead of UEN
• Ecommerce:
  • Prevented 5 cents rounding for e-Commerce sales invoice editing
  • Fixed Comparison - Monthly (18 Months) Start date not displaying correctly
• API: Fixed issue where AR and AP payment could not be posted and updated with knock off
• Clipboard Import: Fixed issue where Opening SST was unable to be captured in SST-02 Form when imported via Clipboard Excel
• Mobile Connect:
  • Fixed issue allowing edits to DocNo in browse mode
  • Adjusted Lazada document knockoff process
• Auto Bank Recon: HSBC bank statement with overdraft balance

 

SQL Accounting Latest Version (v882) Date : 09 Sept 2025

 5.2025.1046.882

September 9, 2025

Fixed issue where submitting e-Invoice without Tax code would raise Assertion Failure error (882)

Bug Fixes

• MyInvois (E-Invoice MY): Fixed issue where submitting e-Invoice without Tax code would raise Assertion Failure error

SQL Accounting Latest Version (v882) Date : 04 Sept 2025

 5.2025.1045.882

September 4, 2025

Database upgrade to v215 featuring enhanced SST exemption codes, improved MyInvois tax handling, InvoiceNow (SG) resubmission capabilities, licensed Clipboard Import module, and comprehensive bug fixes for GST/SST and e-commerce integrations. (882)

Database

• Database upgraded to version 215

Updates

• SST:
  • Introduced new Exemption Service tax codes - SVGR & SVOE for SST-02 report items 18c2 & 18c3
  • Enhanced SST-02 & Sales Invoice report templates to support new Exemption tax codes
  • Improved SST-02 (20240301) format - Expanded SST Number field & Display both Service & Sales Tax numbers when both are active
  • Enhanced SST Wizard with Special Industries checkbox ID Type UI for grid in form mode with browse-only capability
  • Resolved Sales Credit Note Tax Code SU5 causing duplicate amounts in SST-02 report field 14
  • Modified SST-02 report field 18c to exclude IMSVE posted from GL Payment Voucher
• MyInvois (E-Invoice MY):
  • Document entries - detail records with Tax Code "SVE" now declare as Exempted Tax with Tax Rate of 6% or 8% based on special industries flag
  • Document entries - detail records with Tax Code "SVE" declare as both Service Tax and Exempted Tax using Exempted_TaxRate & Exempted_TaxAmt
• E-commerce:
  • Enhanced DocDate validation during Lazada payment and refund document verification
• InvoiceNow (Peppol SG):
  • Blocks submission when GST has been processed
  • Enables resubmission using the same Doc UUID
  • Implemented Submission Type handling
  • Business Unit management now operates at document level
• WhatsApp Scan:
  • Integrated Access Right Control functionality
  • Redesigned UI with enhanced validation for import text using invalid Item Codes
• Clipboard Import:
  • Converted to licensed module
  • Enables TaxAmt override functionality

Bug Fixes

• GST/SST initialization now uses the most current Tax Codes regardless of effective date
• Document default project or location displays correctly when SQL View is not configured
• Payment Vouchers with submitting status can now reset E-Invoice status properly
• Corrected Lazada sales credit note editing to accurately set return quantities when multiple returns exist for the same item with different refund amounts

SQL Accounting Latest Version (v881) Date : 27 Aug 2025

5.2025.1044.881

August 27, 2025

Mobile Connect now supports alternative port, e-commerce adjustment (881)

Features

• Mobile Connect:
  • Now support alternative port (2764) for on premise setup

Updates

• Ecommerce:
  • Reduce Lazada product fetch limit
  • Adjustment to Shopee return refund variance calculation
  • Adjustment to Lazada sales credit note knockoff

Bug Fixes

• Records not updated correctly during Lazada payment posting

 

SQL Accounting Latest Version (v880) Date : 23 Aug 2025

 5.2025.1043.880

August 23, 2025

Adds Mobile Connect e‑Invoice support plus delivery/branch/stock lookups, e-commerce updates, adds an Info Request removal option, and resolves numerous bug and reporting issues. (880)

Features

• Mobile Connect:
  • Added E-Invoice support on Sales Invoice, Cash Sales, Debit Note & Credit Note
  • Add delivery info on sales documents
  • Add customer branch lookup
  • Add Stock Classification lookup

Updates

• Ecommerce:
  • Adjustment to Lazada sales credit note posting for adjustment related settlements
  • Adjustment to Lazada sales invoices and credit notes editing
  • Adjustment to Shopee return refund variance posting in sales credit note
  • Add Shopee seller order processing fee to sales invoice and credit note
  • Post TikTok violation fee (settlement fee) to credit note
• Clipboard Import:
  • Now support AR & AP Refund
• Info Request: Added option to remove info request in Maintain Customer/Supplier
• Print BOM Planner now shows "JO Qty" after "On Hand" column.

Bug Fixes

• Submitted E-Invoice posted from SQL POS cannot refresh status
• Maintain Customer/Supplier browse screen ID Type not showed when Form Mode is applied
• Pending service tax is not calculated after 12 months if the invoice date falls on the last day of Feb in a leap year
• AR/AP Invoice Fast Entry form unable to close when error prompted, if Sales/Purchase account is not define in Tools > Option
• Maintain Area support Attachment Script
• Cash Sales Payment Change window does not remember the last used payment method
• Set SubmissionType to None for Lazada, Shopee, and TikTok sales invoices and credit notes
• Application GST menu displays GST-SG related menu items after entering a registration code with GST-SG module
• Fix Shopee return refund variance calculation for partial return order
• SST-02 report should exclude SVE transactions that posted by IMSVE in column 18c
• Stock Card Report detail grid's Bal Qty incorrect due to two location codes differing only in letter case (upper vs lower case)
• Editing an asset item's status from active to inactive prompts message Inactive date fall outside acceptable transaction date even though the date is within acceptable range
• GL Document Listing returns incorrect dataset records when filtered by Payment Method
• Sales Profit Loss By Document returns incorrect dataset records when filtered by Customer
• Sales S/N Profit Loss By Document returns incorrect dataset records when filtered by Company Category
• Default project is not always "----" when creating a new document

SQL Accounting Latest Version (v879) Date : 04 Aug 2025

5.2025.1042.879

August 4, 2025

Minor InvoiceNow(Peppol SG) & API fields update (879)

Updates

• API:
  • Remove Ref field
  • Add Doc field on Report
  • Support filtering through query param
• Clipboard Import: Support additional tables

Bug Fixes

• InvoiceNow: Fix Invalid document type and format when submit imported purchase invoice and purchase returned
• InvoiceNow: Fix missing item details and get item allowance charge for credit note import
• Ecommerce: Shopee edit past credit note doc amount for settlement amount less than 0
• General: Maintain GL Bank Deposit enlarge the Bank Slip No. control width

SQL Accounting Latest Version (v878) Date : 29 July 2025

 5.2025.1041.878

July 29, 2025

MyInvois Updates (878)

Features

• MyInvois (E-Invoice MY):
  • Now support UUID linking for existing documents
    • this feature will look for UUID from MyInvois Portal for existing documents without UUID, e.g. imported invoices from other application but forgot to include MyInvois UUID

Updates

• MyInvois (E-Invoice MY):
  • Sales Tax No and Service Tax No will separate by semicolon
  • Customer/Supplier Info Request link will be removed after info had been retrieved

Bug Fixes

• MyInvois (E-Invoice MY):
  • Fixed a bug which caues Test Intermediary to be unusually slow
  • Fix arithmetic exception, numeric overflow, or string truncation string right truncation when update E-Invoice Request

SQL Accounting Latest Version (v877) Date : 25 July 2025

5.2025.1040.877

July 25, 2025

MyInvois Updates (877)

Updates

• MyInvois (E-Invoice MY):
  • E-Invoice Import now support additional discount/fee amount
  • E-Invoice Batch Import add UUID column in field chooser

Bug Fixes

• GL Balance Sheet Statement and GL Profit Loss Statement prompt access violation error when ProjectData is empty
• Fixed a bug where it prompts Dynamic SQL Error when trying to filter by currency code at Supplier Credit Note Listing
• Fixed a bug at AR/AP Due Document where company code is filtered incorrectly
• TikTok check settlement records only contains actual return shipping fee
• Wrong E-Invoice address line when address contains keyword same as city or state