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

SQL Accounting Latest Version (v866) Date : 12 April 2025

 

SQL Account 5.2025.1021.866

Released on April 12, 2025

Release Notes

• Update E-Invoice update as at 11 Apr 2025

SQL Accounting Latest Version (v865) Date : 28 Mar 2025

 

SQL Account 5.2025.1019.865

Released on March 28, 2025

Release Notes

• [EIV-MY] Change MyInvois Request caption to E-Invoice Request
• #7204: Show FromDoc at Browse Screen for CN, DN, SC, SD and CB
• #6306: GL Balance Sheet report consolidate tick Display Trade debtor and creditor raise assertion error when report's account level set lower than control account's level. Revise to more friendly error message
• [EIV-MY] #7210: Include unsubmitted E-Invoices option missing at batch consolidate
• [EIV-MY] Bug #7196: Consolidate E-Invoice prompt access violation if click next without selecting document
• #6045: Stock Reorder Advice report should show Reorder Level, Reorder Qty, Min/max Qty grid columns by default
• #5788: GL Profit & Loss statement report if Project code in chinese will cause incorrect amount for the Project column in Print Project Comparison
• #6236: Maintain Stock Item Matrix prompt warning message when row/columns contain duplicate values
• Fix entry forms Matrix Profile label position
• #6207: SL/PH Analysis By Document report when filter Company Category and tick "Include Zero Balance" should only show company that match with the filtering only
• #6229: SL/PH Analysis by Document allow to view the Available Stock Balance
• Feature #6567: Stock BOM Material Usage report add Print Active/Inactive Material & Product Item checkboxes
• Fix TikTok prompt access violation during order verification process
• Fix Shopee posted return refund variance in sales credit note incorrectly
• Adjustment to Shopee payment file loading dialog message
• Fix Shopee posted return refund variance in sales credit note incorrectly
• Fix TikTok not posting additional actual shipping fee charge sales invoice
• [EIV-MY] #7216: Remove locking on TaxExemptNo that is not submitted to MyInvois
• [EIV-MY] #7217: MyInvois Config form copy intermediary info does not work
• #7215: Stock Month End Balance Report apply prompt assertion error when having large amount for GL Balance Sheet Stock
• #6406: Production Document Transfer dialog add checkbox indicator and auto fill in Transfer Qty when focused record changed
• Feature #6386: SL/PH Document Listing add new columns Filter Total & Local Filter Total
• #6445: Maintain Document Number deleting record should prompt error when Maintain Payment Method OR/PV Document Set referring to it
• #6604: SL/PH Analysis by Document & Yearly Analysis reports add Stock Category Description
• [EIV-MY] Show LHDN QR in report only for valid status
• [EIV-MY] Prompt password dialog for report to include LHDN QR in sandbox environment
• [EIV - MY] #7205: Consolidate CN submission failed when ID Type and ID No blank using General Public's TIN
• #7201: Revise AR/AP Deposit Refund form labels caption
• #6740: Stock Physical Worksheet Report support View Price Tag
• #6789: Outstanding SL/PH Document Listing report default parameter change to SO / PO
• Feature #7197: Maintain Account support auto create Accumulate Depreciation Account
• #6959: Sales Invoice transfer from Delivery Order after clearing customer code, the document transfer window will show all transfered/untransfered items incorrectly
• [EIV-MY] #7199: BRN with space cannot be input into the field
• [EIV-MY] Revise MyInvois single import to new or edit record without save to database
• [EIV-MY] Remove serial number from MyInvois import
• Adjustment to Lazada sales invoice editing
• Add TikTok affiliate partner commission to sales invoice
• Set Lazada payment reference ID to weekly reference ID
• [EIV-MY] #7190: Connect MyInvois should prompt error message instead of disabled in edit state
• Change Check E-Invoice Status caption to Refresh E-Invoice Status
• #7191: Sales S/N Profit & Loss By Document has duplicate records if have same DocKey & Detail Key in different document type

SQL Accounting Latest Version (v864) Date : 28 Feb 2025

 

SQL Account 5.2025.1017.864

Released on February 28, 2025

Release Notes

• Database upgrade to version 210
• Fixed JO, AS & DS report checkbox not correctly shown due to DataType
• Fixed Local amount if 0, no need to show in item Tax and Item Localamt and exclude from sub total for Profit & Loss with Cash Flow (Amt Exclude Tax) report
• Add IRBM_InternalID to DN, CN, SD and SC to standardize table structure
• #7168: FromDoc field upgrade from 40 to 200 chars
• [GST-SG] Feature #7161: Add Tax Codes: NA and TXNA for year 2025
• #7120: Maintain Tax add new Tax Types - Sales Tax, Service Tax, Tourism Tax, LVG & Tax Exemption for Purchase side MyInvois purpose
• Fix watermark not working properly when multiple form create in thread with Begin Invoke
• [EIV-MY] #7153: Classification submit as 004 if reference to consolidated document
• [EIV-MY] #7155: Submit Consolidated Self-Billed E-Invoice in CashBook prompt list index out of bounds error
• [EIV-MY] #7154: Line item classification code should be 004 for consolidated self-billed e-invoice
• Adjustment to Lazada sales invoice and credit note edit logic during post payment
• Add TikTok affiliate ads commission to sales invoice
• Allow posting order's invoice from Lazada payment
• Fix Lazada posted lost claim reimbursement incorrectly
• Check service fee is found before extracting the value from Shopee payment file
• [EIV-MY] #7188: Consolidate E-Invoice add in post date column
• #7163: Add UOM lookup and Serial Number in MyInvois import
• [EIV-MY] #7187: 3rd party incomplete EIV field posting cause null conversion error
• #7064: Cloud Banking - Show linking feature and notification on Bank Recon when supported bank is selected
• Fix bug: Database upgrade to version 196 prompt "string right truncation" error when execute procedure INSERT_DI_PROJECT
• #7182: [EIV-MY] Check consolidated E-Invoice status prompt out of memory error
• Fix SL Profit & Loss Serial No & SL Profit & Loss Report Doc Cost & Item Cost display format
• #7141: Sales S/N Profit & Loss By Document Item Cost no value when last IN transaction is Stock Transfer. For accurate Item Cost, should refer to costing table
• #7180: Read MyKad auto-fill IDType and IDNo in Maintain Customer
• #7164: Enable to drag and drop from Stock Item Search to Print Bar Code (Window Printer)
• Add item price credit adjustment when editing Lazada sales invoice
• Fix Shopee failed to post refund orders with item price less than fees
• Fix Shopee posted sales credit note without shipping seller protection fee when order is completed without return, but escrow amount is negative
• Fix Lazada LazCoins discount labeled as transaction fee instead of discount
• Add Shopee delivery seller protection fee premium to sales invoice
• #7165: Stock Month End Balance report apply raise Dynamic SQL Error: Count of read-write Columns does not equal count of values
• Optimize performance of Process Deprecation and Open Deprecation
• Convert null values to zero for the number of fields in asset item when saving
• #7157: DIY Field - Boolean Data Type initial default value should be False
• Revise database upgrade scripts to compatible with firebird 3
• #7145: SL Invoice, Cash Sales, DN & CN Different TIN dialog should display company name
• #7148: Stock Batch Qty Lookup by default untick "Show Qty> 0" option
• [EIV-MY] #7149: GL Cash Book Entry Payment voucher default classification code change to 036
• #6944: Data Import - Assertion failure error on AR_Customer template load. Fix DBAccess OPF parameter value issue