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

 

SQL Accounting Latest Version (v876) Date : 22 July 2025

5.2025.1039.876

July 22, 2025

Revamped SQL View (876)

Updates

• SQL View revamped to support more modules:
  • GL Account
  • GL Cash Book
  • Stock Group
  • Stock Item
  • Stock Location
  • Stock Document
  • Production Document
  • Area
  • Payment Method
  • Project

---

Bug Fixes

• MyInvois (E-Invoice MY): Fixed Could not convert type (null) into type (integer) when trying to Save document with null SubmissionType & IRBM_Status
• Cashbook detail tax field should be empty string when no tax selected
• SL/PH documents entry, modifying Qty causes the Tax Inclusive become unticked
• Maintain Stock Item Bal Qty incorrect for newly created Item that contains few opening balance Qty

SQL Accounting Latest Version (v875) Date : 18 July 2025

5.2025.1038.875

July 18, 2025

SQL Account API release (875)

Features

• Introduce SQL Account API

---

Updates

• MyInvois (E-Invoice MY):
  • Hide uuid and longid from more panel for document without E-Invoice operation
  • Add Received (submit) & Validated date time and remove version for Sales Invoice 13 report format
• E-Commerce:
  • Adjustment to Lazada sponsored affiliates refund posting in sales invoice
  • Adjustment to Shopee prorated returned fees posting in sales credit note
  • Adjustment to Lazada document knockoff
• Auto Bank Recon: Maybank Cloud linking show by default to encourage more usage, click here for more info
• Stock BOM Planner report template add JO column
• Maintain Customer/Supplier Credit Control options rename Unblock to Allow to avoid confusion

---

Bug Fixes

• MyInvois (E-Invoice MY):
  • Fix e-Invoice submission Total Net Amount should be exclude tax
  • Fix e-Invoice submission Total Rounding Amount should be 0 since 5 cents rounding already included in detail lines
  • Fix Null conversion for TotalLocalAmount
• Import did not include rounding amount causing document amount mismtch
• Maintain Deposit user shouldn't allow to delete deposit Forfeit/Refund when outside acceptable transaction date

SQL Accounting Latest Version (v874) Date : 12 July 2025

5.2025.1036.874

July 12, 2025

Introduces support for Firebird 5.0 database engine (874)

Database

• Added support for Firebird 5.0
  • New databases will be created using Firebird 5.0 automatically
  • Once upgraded to Firebird 5.0, there is no rollback path to version 3.0
  • For 3rd party integrations:
    • No update required if you're using our SDK
    • Direct database connections will need client updates to avoid incompatibility
    • Please review our upcoming API release for seamless integration

SQL Accounting Latest Version (v873) Date : 11 July 2025

5.2025.1035.873

July 11, 2025

Important MyInvois & Whatsapp Scan updates (873)

Database

• Database upgraded to version 214

Updates

• MyInvois (E-Invoice MY):
  • Add Received (Submit) DateTime and Validated DateTime fields
  • Show EIV_Received_UTC & EIV_Validated_UTC on UI
  • MyInvois import add GL code
  • Rename Industries Code in More section to Industries Code (Supplier) to avoid confusion
  • Fixed Microsoft MSXML is not installed prompt when trying to email during batch submit
  • Company Profile & Maintain Customer/Supplier now allowed to edit ID Number (for E-IV usage) if ID Type is New/Old BRN
• Whatsapp Scan:
  • Now support phone number deregistration
  • Able to batch edit DocType & DocDate
  • Support Text Import to Document
  • Added Drill Down to Document feature for PM, SP, PV documents
• Add Permit No. field for SL/PH Price History report

---

Bug Fixes

• Whatsapp Scan:
  • Fixed exception when no default account is selected
  • Remove duplicate file extension when attached
• Fixed Supplier Deposit entry should check acceptable transaction date
• Purchase documents delivery mobile should not get from maintain supplier when change supplier
• Fixed Maintain Stock Item Bal Qty incorrect when there is error "attempt to store duplicate value" in Barcode
• Fixed Shopee order with seller return refund does not post correctly when no item is returned for the order
• Fixed performance issue when apply debtor account in Account Inquiry

SQL Accounting Latest Version (v872) Date : 7 July 2025

5.2025.1034.872

July 7, 2025

Important MyInvois Enhancement & new Tourism Tax (TTx) in Sales document (872)
Important MyInvois Enhancement & bug fixes (872)

Features

• MyInvois (E-Invoice MY):
  • Added Self-Billed E-Invoice import in Sales document
  • Able to create new Customer/Supplier during MyInvois Import
• Sales: Added Tourism Tax (TTx)

---

Updates

• MyInvois (E-Invoice MY):
  • Revised e-Invoice submission percent tax rate code
  • Always load Taxpayer QR Code in Production mode
  • Display TimeAgo in MyInvois import (e.g. 1 hour ago, 1 day ago, etc)
  • Remove MyInvois single import
  • Allow to load taxpayer QR Code in all environment (Sandbox & Production)
  • Validate tax type exemption before retrieving amount exempted from tax
• SL & PH document entry forms and Account Inquiry show CompanyName2
• Clipboard Import:
  • Now support Access Right
  • Support AR & AP branch detail update
  • Support quick create Maintenance
  • Support auto generated document number
• Allow AR/AP Deposit Description to be edited after transferred

---

Bug Fixes

• Enhanced batch submitting performance and prevent duplicated submission tightly
• Fix MyInvois import facing Access Violation when InvoicedQuantity is missing
• MyInvois (E-Invoice MY):
  • Fixed not a valid GUID value when trying to load MyInvois notifications
  • Fixed Myinvois field editable for Submitting status document
• Fixed Customer/Supplier Contra full preview error due to company logo set as PNG by default
• Fixed Account Inquiry account closing balance label overlapped with Apply button
• Fixed incorrect Subtotal & Subtotal Tax when Tax Inclusive is ticked and Qty changed at SL/PH Documents entry
• Refresh Navigates to Last Record When Split Browse & Detail Window is enabled in Form Mode

SQL Accounting Latest Version (v871) Date : 16 June 2025

 5.2025.1032.871

June 16, 2025

New Taxpayer QR Code autofill feature, Mobile Connect access right control & minor bug fixes. (871)

Features​

• Maintain Customer/Supplier: Now support reading MyInvois Taxpayer QR Code to fill in taxpayer info under Tax tab. (Only work in Production)

---

Updates​

• MyInvois (E-Invoice MY): E-Invoice implementation timeline update for 2025-06-05 changes
• Mobile Connect: Add Access Right control on Browse and Entry form
• GL Bank Recon: Add Description2 grid column

---

Bug Fixes​

• E-Invoice implementation phase 5 description update
• Fixed Purchase Invoice 8 (SST 1) caption not correct
• Fixed Sales Local - Invoice Collection Report - Level 1 SubTotal Description not correctly shown

SQL Accounting Latest Version (v870) Date : 07 June 2025

5.2025.1031.870

June 7, 2025

New features (Chatbot, Helpdesk, Whatsapp Scan, Clipboard Import), improved e-Invoice handling, enhanced integrations, and important bug fixes. (870)

Database​

• Database upgraded to version 213

---

Features​

• Introduce Whatsapp Scan feature
• Introduce Clipboard Import
• New Chatbot feature (🤖 on top right)
• New SQL Helpdesk (❔ on top right)

---

Updates​

• MyInvois (E-Invoice MY): E-Invoice implementation timeline update for 2025-06-05 changes
• MyInvois (E-Invoice MY): Consolidation of documents over RM10,000 will prompt warning
• MyInvois (E-Invoice MY): Show Consolidate No. on browse screen for CN & DN
• MyInvois (E-Invoice MY): Added E-Invoice Validation QR for Cash Sales 6 - Receipt-TM-U220
• AR CN: Optmized AR Credit Note editing for better performance
• E-Commerce(Lazada): Knockoff Lazada sales invoices with sales credit note for returned orders

---

Bug Fixes​

• Fix Shopee posted same final shipping fee charge in both sales invoice and sales credit note
• Fix access violation when submitting new document through Peppol (SG)

 

SQL Accounting Latest Version (v869) Date : 29 May 2025

5.2025.1027.869

May 29, 2025

New delivery performance reports, enhanced e-Invoice handling, improved e-Commerce integration, and key bug fixes across the board. (869)

Database​

• Database upgraded to version 212

---

Features​

• New Reports:
  • Sales Outstanding SO - Delivery Performance
  • Purchase Outstanding PO - Delivery Performance
• Module Control: Enable Customer or Supplier features based on whether the Sales or Purchase module is available
• Sales Debit/Credit Notes: Added 5 Cents Rounding options for Sales DN & CN under Tools | Option | Customer
• Sales S/N Profit Loss by Document: Add Use Last Serial No. Doc Unit Cost option
• Mobile Connect: Added support for Mobile Connect setup in application

---

Updates​

• MyInvois (E-Invoice MY):
  • Now supports joining multiple Permit Numbers in document details
  • MyInvois import now replaces UUID only when the document already exists
  • E-Invoice submission now uses the billing email instead of delivery branch email
  • New currency ISO Code CNH
  • Classification field is now excluded during transfer from SO to PO
  • E-Invoice now submit tax exemption reason with combination of tax exemption no & reason
• E-Commerce(WooCommerce):
  • Now uses preemptive authentication for better compatibility
  • IRBM classification set to "008"
• E-Commerce(Lazada):
  • Improved calculation of item price adjustments and handling of refund sales
  • Sales CN now posted during payment instead of on return
  • Payment posting date adjustment
• E-Commerce(Shopee): Enhanced logic for voucher offset returns and coins offset in Sales Credit Note posting
• Maintain Tax: Renamed "General Tax - (Tourism Tax)" to "General Tax - (Purchase Tourism Tax)"

---

Bug Fixes​

• MyInvois (E-Invoice MY): Fixed access violation error when clicking "Next" on Consolidate E-Invoice from Cash Book
• MyInvois (E-Invoice MY): Fixed DocNo filter not working in Consolidate E-Invoice
• E-Commerce(Lazada): Fixed Lazada missing promotional charges vouchers on negative settlement orders
• E-Commerce(Shopee): Fixed incorrect assignment when multiple same items exist in an order
• Resolved error when saving sales document with initial purchase cost and qty > 0
• Fixed issue where Unit Price became 0 due to 3-decimal Max Cost/Price settings and missing user rights
• Corrected issue with unit cost value increasing when reference cost and stock transaction are missing
• Fixed incorrect TaxRate in destination documents when partially transferred with Tax Inclusive enabled
• Prevented access to Stock Month End Balance report S/N view for users without S/N module rights
• Fixed missing pipeline value in AP Bill & Payment Analysis report Document_CompanyBranch
• Sales document entries click on Profit Estimator button prompt Access Violation error
• Fixed Customer payment uses invalid default payment method if supplier deposit is the first record in payment method
• Fixed a bug where creating a Sales Point document appends a record with year 1899 to the document number set when it is configured with monthly reset frequency

 

SQL Accounting Latest Version (v868) Date : 16 May 2025

 5.2025.1023.868

May 16, 2025

Database upgrade to version 211 with new MyInvois CN & DN consolidation, SG GST InvoiceNow, customer/supplier info request, and key bug fixes. (868)

Database​

• Database upgraded to version 211

Features​

• Maintain Customer & Supplier: Added "Info Request" action
• MyInvois (E-Invoice) MY: Support Credit Note & Debit Note Consolidate Submission
• InvoiceNow SG: Support GST InvoiceNow
• Access Rights: Added MyInvois group

Bug Fixes​

• InvoiceNow SG: Fixed duplicate item details when sender code is empty during import
• GST SG: Fixed invalid TaxRefNo on GST F5 submission
• E-Commerce: Adjusted Lazada load payment file paid status checking
• Fixed Access Violation error when using "Update Cost" in Stock Documents Entry with Serial Number Costing
• Fixed application crash when sorting "Transfer Qty" column in Job Order transfer from Sales Order

  5.2025.1023.868

  May 16, 2025

  Database upgrade to version 211 with new MyInvois CN & DN consolidation, SG GST InvoiceNow, customer/supplier info request, and key bug fixes. (868)

  Database​

  • Database upgraded to version 211

  Features​

  • Maintain Customer & Supplier: Added "Info Request" action
  • MyInvois (E-Invoice) MY: Support Credit Note & Debit Note Consolidate Submission
  • InvoiceNow SG: Support GST InvoiceNow
  • Access Rights: Added MyInvois group

  Bug Fixes​

  • InvoiceNow SG: Fixed duplicate item details when sender code is empty during import
  • GST SG: Fixed invalid TaxRefNo on GST F5 submission
  • E-Commerce: Adjusted Lazada load payment file paid status checking
  • Fixed Access Violation error when using "Update Cost" in Stock Documents Entry with Serial Number Costing
  • Fixed application crash when sorting "Transfer Qty" column in Job Order transfer from Sales Order

SQL Accounting Latest Version (v867) Date : 23 April 2025

 

SQL Account 5.2025.1022.867

Released on April 23, 2025

Release Notes

• Fix cant get details when only have one record and refactor MyInvois import
• Ignore return refund variance in sales credit note for Shopee partial return order
• Include Shopee shipping fee SST in return refund variance calculation
• Include TikTok shipping cost to platform shipping fee discount adjustment
• #7232: AR/AP Due Document Listing report's Document_Company pipeline is empty when master record having negative outstanding amount
• #7233: Sales/Purchase Price History Grid add e-Invoice columns
• #7240: GL Bank Recon Listing Recon Date column not sorting correctly
• Update Cust/Supp 06 Months Aging-GainLoss Posting Account to New Option CXGainAccount_Unrealised & CXLossAccount_Unrealised
• #7236: GL Balance Sheet drill down to Ledger report the Date From parameter should have value
• Feature #6434: GL Foreign Bank Adjustment Bank Revalue should post to Unrealised Foreign Exchange Gain/Loss accounts instead of Realised (in Tools | Options | GL)
• [Peppol-SG] Fix empty company name and unable to get customer code when import