SQL Accounting Latest Version (v893) Date : 24 Apr 2026

5.2026.1080.893

April 24, 2026

E-Commerce adjustments, AR/AP payment fixes, and various bug fixes. (893)

Updates

• E-Commerce:
  • Adjusted Shopee Ads Escrow Top Up Fee posting in sales credit note.
  • Lazada order items with 0 paid price are now separated.

Bug Fixes

• Stock:

  • Fixed Available Stock Balance Back Order Detail showing incorrect Job Order component quantity — it should now multiply with UOM Rate (#7830).

• Reports:

  • Fixed Supplier Analysis by Document showing inconsistent payment amounts depending on date range selection (#7828).

• InvoiceNow (Peppol SG):

  • Fixed assertion error when testing API connection.

• General:

  • Fixed AR/AP Payment transfer from Deposit for foreign currency not auto-converting to local amount (#7826).
  • Fixed Tool > Options > AR > Perform Tax / Local Amount Rounding not being disabled when Sales Invoice form is opened.
  • Fixed Company Profile GST & SST tab visibility not being based on Tax Start Date (#7820).

SQL Accounting Latest Version (v893) Date : 20 Apr 2026

 5.2026.1079.893

April 20, 2026

WebApp enhancements, MyInvois improvements, InvoiceNow updates, and various bug fixes. (893)

Updates

• Mobile Connect:

  • Added Maintain Document Number.
  • Added Maintain Currency.

• MyInvois (E-Invoice MY):

  • Now shows sync progress error in MyInvois Transactions.
  • Improved postcode lookup.
  • Updated MyInvois Transactions UI after executing E-Invoice actions.

• InvoiceNow (Peppol SG):

  • Added character validation for item description in B2G transactions.

• Reports:

  • Added Show Daily by Company & Item Code at last page.
  • Added Group Footer print position script for Sales Invoice 13.

• General Ledger (GL):

  • Bank Reconciliation form now prompts a confirmation dialog when clicking Apply to save changes before proceeding (#7785).

• General:

  • Added ability to update company item code.

• E-Commerce:

  • Adjusted TikTok sales invoice editing.

Bug Fixes

• Reports:

  • Fixed Customer Statement 12 Months 1 & 2 (Group) unable to show month 7 to 12.

• MyInvois (E-Invoice MY):

  • Fixed supplier name incorrectly mapped in MyInvois Batch Import (#7795).
  • Fixed Submission Type still allowing changes for MyInvois Import when reselecting supplier code (#7799).
  • Fixed access violation on Journal Entry Custom E-Invoice Submission when using SVE tax rate (#7787).

• Sales / Purchase:

  • Fixed "Save Price Below Cost" checking in SL/PH entry forms to allow empty item code (#7784).

• General:

  • Fixed AR/AP Payment transfer from Deposit where Doc Amount might have a one cent difference for foreign currency even when the currency rate is the same (#7806).
  • Fixed all document entries unable to cancel document through logic posting without UI form (#7791).
  • Fixed DIY Script editing a document without MainDataSet.Post not prompting Acceptable Transaction Date error (#7807).
  • Fixed Next DocNo field showing extra unknown numbers (#7755).

SQL Accounting Latest Version (v893) Date : 04 Apr 2026

5.2026.1078.893

April 4, 2026

MyInvois submission in Journal Entry, Auto Bank Recon improvements, Partial Document Transfer enhancements, and various bug fixes. (893)

Updates

• Mobile Connect:
  • Added Purchase module
  • Added Supplier module
  • Added Maintain Terms, Agent
  • Now support MyInvois Rejection
• E-Commerce:
  • Adjustment to TikTok sales invoice & credit note posting
  • Adjustment to TikTok shipping cost calculation in sales credit note

Bug Fixes

• MyInvois (EIV-MY):
  • Fixed a bug where MyInvois environment reset without resetting submitted and validated datetime (#7776)
  • Cashbook should auto fill previous submission type based on company name (#7777)
• E-Commerce:
  • Fixed Lazada item price credit adjustment calculation'
• Clipboard Excel Import:
  • Failure to import batch list if item code column is empty (#7782)
• General:
  • All Documents entry unable to cancel document. (#7775)

SQL Accounting Latest Version (v893) Date : 28 Mar 2026

5.2026.1076.893

March 28, 2026

MyInvois submission in Journal Entry, Auto Bank Recon improvements, Partial Document Transfer enhancements, and various bug fixes. (893)

Updates

• MyInvois (E-Invoice MY):

  • Added MyInvois submission selection in Journal Entry (#7679).

• Sales / Purchase:

  • Added Unit Price column to Partial Document Transfer form for Sales side only (#7750).
  • Partial Document Transfer form's Documents grid now supports drill down (#7761).

• E-Commerce:

  • Adjusted TikTok document posting.

• General:

  • All entry forms now have a minimum width and height set. The baseline resolution for UI layouts is 1024 x 640.
  • Auto Bank Recon now supports partial match for cheque number (#7762).
  • Added sort by description on bank list in Auto Bank Recon (#7757).
  • Revised warning message for documents reconciled with bank to include "Bank Reconciliation should be unticked before changing the payment method" (#7747).

Bug Fixes

• MyInvois (E-Invoice MY):

  • Fixed taxpayer TIN search for a company returning an individual IG TIN instead.

• General Ledger (GL):

  • Fixed Payment Method control disappearing and overlapping with the Bank Balance label when GL Cash Book and AR/AP Payment & Refund forms are resized to a smaller width (#7759).

• Sales / Purchase:

  • Fixed "Transfer To" context menu options not being disabled for draft documents in SL/PH document entry (#7758).
  • Fixed error "Dynamic SQL Error SQL error code = -206 Column unknown B.Account" when applying QT, SO, or DO in SL/PH Price History (#7749).

• General:

  • Fixed document cancellation being allowed outside the acceptable transaction date range (#7767).

SQL Accounting Latest Version (v893) Date : 13 Mar 2026

 5.2026.1075.893

March 13, 2026

E-Commerce improvements for Lazada and TikTok, Peppol SG enhancements, SST fixes, and various bug fixes. (893)

Updates

• InvoiceNow (Peppol SG):

  • Peppol import now removes prepaid amount.

• E-Commerce:

  • Adjusted TikTok sales invoice and credit note posting.
  • Included TikTok platform discount in sales invoice.
  • Adjusted TikTok other fees calculation.

• General:

  • Added Account grid column to Sales & Purchase Price History (#7735).

Bug Fixes

• E-Commerce:

  • Fixed Lazada not posting sales credit note when settlement amount is 0.

• Reports:

  • Fixed GL Local Ledger Level 1 SSTDeferred preview error.
  • Fixed CashBook Listing Report (Cash Book by EIV Submission Type) only displaying the first detail's amount (#7736).
  • Fixed Stock Item report's Category pipeline to sort by Category field (#7738).

• Stock:

  • Fixed Stock Analysis By Doc Total In/Out to include Stock Assembly, Stock Disassembly, Stock Adjustment & Stock Transfer (#7740).

• SST (MY):

  • Fixed SST return not excluding pending Service Tax Exempted (> 12 months) from cancelled invoice (#7728).
  • Fixed SST-02 (20250916) SST No not correctly showing when both ST & SV are present.

• MyInvois (E-Invoice MY):

  • Fixed MyInvois Trans report datamap incorrect field name.

• AI Easy Scan:

  • Fixed form prompting "Could not convert variant of type (Null) into type (Boolean)" error.

SQL Accounting Latest Version (v893) Date : 06 Mar 2026

 5.2026.1074.893

March 6, 2026

TikTok integration, Rich Text Editor improvements, MyInvois enhancements, and various bug fixes. (893)

Updates

• E-Commerce:

  • Added TikTok platform support fee to sales invoice.
  • Adjusted Lazada sales credit note knockoff.

• Rich Text Editor:

  • Added Left to Right & Right to Left paragraph formatting buttons (#7700).

• MyInvois (E-Invoice MY):

  • Changed MyInvois TaxPayers QR Code field to be editable for QR scanner purpose (#7551).

Bug Fixes

• SST (MY):

  • Fixed Maintain Tax "PSV" tax report column showing 13c instead of blank (#7731).

• General:

  • Fixed access violation when right-clicking at Journal Entry if country is not Malaysia (#7726).
  • Fixed GL P&L and Balance Sheet reports prompting error when user defines Chinese words in Tools > Options > GL > GL Financial Reports (#7727).
  • Fixed RHB Reflex Bank Balance Inquiry always showing offline (#6612).
  • Fixed Maintain Item's Customer/Supplier Price's Price Tag data column prompting conversion error when clicked (#7725).
  • Fixed unable to copy and paste Journal Entry (#7720).

• Sales:

  • Fixed sales documents entry with empty detail prompting "Item not found" error upon save when user has no "Save below cost" access right (#7722).

• MyInvois (E-Invoice MY):

  • Fixed Batch Submit E-Invoice not following filtered document (#7721).

SQL Accounting Latest Version (v893) Date : 03 Mar 2026

 5.2026.1073.893

March 3, 2026

Document Transfer speed optimization and MyInvois bug fixes. (893)

Updates

• General:
  • Optimized Document Transfer speed for partial transfers.

Bug Fixes

• MyInvois (E-Invoice MY):
  • Fixed pressing Edit in "Draft for Custom E-Invoice Submission" after creating a new document returning an empty document (#7678).

SQL Accounting Latest Version (v893) Date : 26 Feb 2026

 5.2026.1072.893

February 26, 2026

Database upgrade to version 223. Peppol SG aggregated submission, AI EasyScan improvements, MyInvois enhancements, and various bug fixes. (893)

Database

• Database upgraded to version 223

Updates

• AI Easy Scan (OCR):

  • Only available for registered database use only.
  • Now support file upload.

• InvoiceNow (Peppol SG):

  • Added support for Aggregated submission type.

• Access Rights:

  • Added Administrative group to access rights.

• MyInvois (E-Invoice MY):

  • MyInvois import now includes Open Document Entry action.
  • MyInvois import now includes currency code and rate.
  • Documents created before E-Invoice start date can now be submitted as E-Invoice (#7705).
  • Allow updating Payment info for Cash Sales after creating E-Invoice Request (#7618).
  • Added submission status display in Journal Entry (#7687).
  • Opening MyInvois Document now triggers Sync MyInvois Transaction if not found (#7690).
  • Renamed "Draft MyInvois Document" to "Draft for Custom E-Invoice Submission..." (#7689).
  • Added User Access Rights for MyInvois Transactions (#7684).
  • Block user from editing validated JV E-Invoice (#7688).

• E-Commerce:

  • Added Shopee Thailand import duty and VAT on imported goods.

• Clipboard Import:

  • Added support for duplicate DocNo on AP & PH documents.

Bug Fixes

• General:

  • Win64: Fixed 'Abnormal Program Termination' on BCD DefaultExpression (#7712).

• Stock:

  • Fixed View > Stock Available Balance > Back Order Detail showing incorrect Stock Card Qty balance with multiple locations (#7714).

• Reports:

  • Fixed Sales Invoice 8 (SST 2) Aging Batch Print not showing TaxRate.
  • Fixed GL Multi-Ledger Detail Level 1 preview error when record only has opening balance.
  • Fixed Production Outstanding Job Order Listing to show O/S Qty for cancelled O/S qty in Component Back Order Summary (#7708).
  • Fixed Sales Invoice 8 (SST 3) Service Exemption summary not correct for documents in Foreign Currency.
  • Fixed Sales & Purchase 3 (Simple) format to force get 1 record FromDocNo at header when FromDocNo is not empty.

• SST (MY):

  • Fixed unable to process SST return for service tax on accrual basis (#7698).

• E-Commerce:

  • Fixed Lazada item price adjustment calculation when editing sales invoice.

• Clipboard Import:

  • Fixed edit on detail dataset.

• SDK:

  • Fixed unable to save document if item contains negative value for RTN5Cents (#7709).

• WebApp:

  • Fixed memory leak.

SQL Accounting Latest Version (v892) Date : 09 Feb 2026

 5.2026.1070.892

February 9, 2026

Stock Item and GL report improvements, Shopee integration enhancements, and bug fixes. (892)

Updates

• Stock:

  • Stock Item Assembly, Disassembly & Job Order now prompts a warning message when raw material contains the BOM master item (#7558).
  • Added line number column (#) to Maintain Stock Item's BOM grid (#7681).

• General Ledger (GL):

  • Added Description2 column to GL Profit & Loss and Balance Sheet report's Project Comparison tree (#7657).
  • Added Account 2nd Description field to GL Cash Flow Statement report grid and report (#5649).

• E-Commerce:

  • Added Shopee Ads Escrow Top Up Fee and Technical Support Fee to Sales Invoice and Credit Note.

• Mobile Connect:

  • Updated browsing screen layout.

Bug Fixes

• General Ledger (GL):

  • Fixed GL Project Profit & Loss Cash Flow report to include Tax Amount in Cash Book Amount (#7686).
  • Fixed GL Cash Flow Statement with 3 levels of taxation accounts causing figures not to tally (#7674).

• Dashboard:

  • Fixed Top Product to exclude non-stock control items (#7656).

• MyInvois (E-Invoice MY):

  • Fixed Total Including Tax calculation for MyInvois Transaction report.

SQL Accounting Latest Version (v892) Date : 04 Feb 2026

5.2026.1069.892

February 4, 2026

Bug fixes for reports, MyInvois, and API improvements. (892)

Bug Fixes

• Reports:

  • Fixed Sales Invoice 13 batch printing header problem.
  • Fixed GL Multi-Ledger Detail Level 1 Only to hide foreign Currency DR & CR only when currency is not '----'.
  • Fixed Profit & Loss with Cash Flow (Amt Exclude Tax) to use Supplier Code for Purchase documents to get correct Tax Amount, and exclude CN with date greater than Date To.

• MyInvois (E-Invoice MY):

  • Important: Fixed an issue where e-invoice might be submitted into sandbox wrongly due to Test Validate bug.
  • Fixed an issue where cancelling or rejecting a MyInvois document without a reason was allowed.
  • Fixed an access violation error when cancelling a MyInvois document.

• API:

  • Fixed PUT method on Currency returning "Duplicates not allowed" error (#7677).

SQL Accounting Latest Version (v892) Date : 30 Jan 2026

5.2026.1068.892

January 30, 2026

Database upgrade to version 222. Major MyInvois enhancements including Draft Document Submission, SST improvements, and various bug fixes. (892)

Database

• Database upgraded to version 222

Updates

• General:

  • Added LastModified field for Stock & Production Module (#7589).
  • Increased GST_PROCESS and SST_PROCESS Ref1 and Ref2 field lengths to 50 characters.
  • Removed "Analyse Data Integrity" from Access Rights.
  • Removed "Clipboard Import" from Access Rights.

• MyInvois (E-Invoice MY):

  • Added support for MyInvois Draft Document Submission. (Now GL Cashback & Journal Entry can choose which line items to be submitted)
  • Added GL Journal Entry (GL_JE) support for MyInvois documents.
  • Added new fields (FromDocType, FromDocKey, Payload, TypeCode, ISOCode) to MyInvois Transaction.

• AI Easy Scan (OCR):

  • Added Re-OCR action to reprocess documents.
  • Added duplicate posting detection.
  • Optimized display messages.

• SST (MY):

  • Service tax codes SVE, SVGR, SVOE, and SVZ now follow payment basis instead of accrual/billing basis (#7597).
  • SST Return now supports calculation of pending Service Tax Exempted over 12 months.

Bug Fixes

• MyInvois (E-Invoice MY):

  • Fixed an issue where double-clicking a Payment Voucher under the E-Invoice tab would cause an access violation (#7663).
  • Fixed a dynamic SQL error for Firebird 3.0 when accessing From Doc header (#7666).

• General:

  • Fixed GL Profit & Loss Statement report Gross Margin % formula to use Gross Profit divided by Net Sales instead of Gross Sales (#7665).
  • Fixed Sales Picking List report Description2 field to show the document item's 2nd Description instead of Stock Item's 2nd Description (#7662).
  • Fixed RHB Reflex Bank Balance error when Microsoft MSXML is not installed (#7669).
  • Fixed Entry's Detail form to show "Browse" button caption instead of "Detail" when "Split Browse & Detail window" mode is enabled (#7668).

 

SQL Accounting Latest Version (v891) Date : 26 Jan 2026

5.2026.1067.891

January 26, 2026

E-commerce tweaks for Shopee and Lazada, and various system fixes and improvements. (891)

Updates

• MyInvois (E-Invoice MY):

  • Now support E-Invoice v1.1.

• Clipboard Import:

  • Added support for Stock Item Customer & Supplier Item

• E-Commerce:

  • Fixed TikTok total fees calculation when editing sales credit note
  • Adjusted Lazada sales invoice editing for item price credit adjustment calculation
  • Adjusted Shopee payment file header name to load Shopee Philippines payment file

Bug Fixes

• Fixed EIV Request double submission (#7654)
• Fixed Cashbook unable to find submitted documents in E-Invoice Linking (#7647)
• Fixed inability to reference past invoices using FromDoc (#7631)
• Fixed GL Bank Reconciliation not prompting Acceptable Transaction Dialog (#7600)
• Fixed Analysis Data Integrity - Check Document Integrity being incorrect when different Supplier Codes have the same DocNo (#7644)
• Fixed AR/AP Contra entry prompting "Transaction Date falls outside acceptable transaction date" even after ADMIN override (#7643)
• Resolved keyboard shortcut conflict in entry form (#7012)
• Fixed Sales Invoice 3 (Sales Disc) E-Invoice QR code displaying wrong info during batch print
• Fixed View > Stock Available Balance > Back Order Detail's Balance field being incorrect when Extra DO module is turned on (#7655)

 

SQL Accounting Latest Version (v891) Date : 16 Jan 2026

 5.2026.1065.891

January 16, 2026

This version introduces MyInvois enhancements, Stock Report API support, and Fixed Assets clipboard import, alongside critical fixes for document transfers and stock balance calculations. (891)

Updates

• MyInvois (E-Invoice MY):

  • Removed warning for E-Invoice consolidation using classification 005 (construction materials)
  • Allowed customers to have a default classification code (#7628)

• API:

  • Added support for Stock Report

• E-Commerce:

  • Adjusted Shopee payment file header name
  • Adjusted EasyStore discount calculation

• Clipboard Import:

  • Added support for Fixed Assets

• General:

  • Removed Auto Size option for summary description in Invoice Listing
  • Added company's Account Open Date grid column to SL/PH Outstanding Document Listing and Price History reports (#7601)

Bug Fixes

• MyInvois (E-Invoice MY):
  • Fixed Dynamic SQL Error in batch import caused by Chinese characters (#7630)
  • Fixed issue where Reject in MyInvois Trans did not insert logs correctly
  • Fixed "Invalid field value for DocAmt" error caused by Accounting Value format
• Fixed error during Document Transfer from Sales Order to multiple Invoices with large quantities: "Transferred qty cannot be more than Balance qty", even when quantities were equal (#7640)
• Fixed tabbed docking grey shadow overlay issue (#7529)
• Fixed "Low Stock Qty" dialog prompt in Deemed Supply when "Prompt Negative Stock Qty Dialog" is disabled (#5643)
• Fixed Stock Analysis by Document Total In / Out (Qty & Value) to sum based on document types correctly (#7632)
• Fixed warning message in AR/AP Payment, CN, and Contra entry forms when Knockoff Tax Date is earlier than Knockoff Doc Date (#7613)
• Fixed issue where available stock balance for S.O. and P.O. quantities was zero in v891, despite Stock Physical Worksheet report showing values (#7627)