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

SQL Accounting Latest Version (v863) Date : 07 Jan 2025

 

SQL Account 5.2025.1016.863

Released on January 7, 2025

Release Notes

• Fixed Disposal Asset Card-Journal Voucher no decimal point
• System report script convert Boolean
• #5588: Convert Boolean field to actual Boolean Type
• Database upgrade to version 207
• Database upgrade to version 209
• Fixed Stock Card Qty preview generate unlimited page
• #7144: AP & PH Document Listing detail duplicate if have same DocNo for diff supplier and filter this duplicate DocNo in report
• Fixed Shopee not posting shipping fee correctly for order with return item
• [EIV-MY] raise exception when edit and delete Request E-Invoice
• Database upgrade 207 add Progress Text Dialog for Convert Bool Script
• Bug: Database upgrade 207 progress bar not updating
• [EIV-MY] #7139: SL Invoice, Cash Sales, DN & CN upon save should only prompt TIN checking dialog for production environment and Doc Date > MyInvois StartDate
• #7140: Database upgrade 207 prompt unicode character mapping error
• Bug #7138: Access through COM should not prompt E-Invoice reminder
• #7137: Stock Batch Item Lookup add "Show Qty > 0" option
• Fix Lazada not posting promotional charges flexi-combo fees to sales invoices
• Adjustment to Lazada voucher seller amount

SQL Accounting Latest Version (v862) Date : 28 Dec 2024

 

SQL Account 5.2024.1008.860

Released on December 28, 2024

Release Notes

• [MyInvoisAPI]: 2027-12-27 MyInvois Maintenance
• #7130: Consolidate Cash Book E-Invoice and Self-Billed
• Adjust PH document listing "Consolidate No" column default visibility
• #7132: SL/PH Document Discount Value not deducted in Subtotal when Tax Inclusive is ticked
• [EIV-MY] #7133: SL Invoice, Cash Sales, DN & CN upon save prompt confirmation dialog if TIN is blank or different with Maintain Customer
• #7131: Sole Proprietor Company submit consolidate E-Invoice prompt TIN is not matching error
• [EIV-MY] #6952: Submit E-Invoice Buyer's EMAIL is empty even though have filled up Email in Maintain Customer

SQL Accounting Latest Version (v861) Date : 18 Dec 2024

 

SQL Account 5.2024.1013.861

Released on December 18, 2024

Release Notes

• Revise DB upgrade version 207. Run Boolean script convert in main thread to prevent random exception
• Fix E-Invoice submission error "Maximum allowed document size" is overridden by "Checking status" during batch submission
• [GST-SG] #7127: IRAS Guideline menu URL link is invalid
• #7126: Open GST Return form prompt field conversion error
• Fix for TikTok added duplicated entry of fees during sales invoice editing
• Revise database upgrade version 208 to truncate company profile IDNo
• #7121: Test E-Invoice Validation should be allowed in Production Environment only
• Fix unassigned and null boolean field value cases
• #7081: Acceptable transaction date context missing fixed asset module
• #7124: AR/AP Payment, CN, Contra & Refund, edit & save document which company & payment method is foreign currency, the ticked knockoff records will be deleted
• #7122: SQL Control Center DIY Fields should trim the field name if contains trailing spaces
• #7119: Stock Item Assembly Batch Update Cost unable to tick multiple Assembly Doc No
• Fixed GL Ledger-FOREX Gain Loss Knockoff date instead of Invoice Post Date.
• Fix Incomplete credential able to register in if client id is empty
• Fix unable to show production portal if active environment is sandbox
• Database upgrade to version 208
• Add MyInvois_FutureCred to support StartDate logic
• [EIV-MY] Add reminder to use production EIV on logon
• Add MyInvois_FutureCred field in SY_PROFILE table
• Resize MyInvois Info form and change font
• #7117: GL Stock Value should allow negative value
• Fix TikTok incorrectly added free of charge item to sales invoice
• Bug fix for WooCommerce order document item with output tax set for the stock item
• Add IRBM_InternalID column to SL/PH Document Listing
• Feature #7055: Stock documents entry and reports add Agent & Area fields
• Stock Physical Worksheet add Agent & Area filters and fields
• Stock Reorder Advice add Agent & Area filters and fields
• Stock Card Qty add Agent & Area filters and fields
• Stock Card add Agent & Agent columns on Detail grid
• Stock Analysis by Document add Agent & Area filters and fields
• Stock Document Listing add Agent & Area filters and fields
• Stock documents datamap add Agent & Area fields
• Stock Posting add Agent & Area fields
• Stock documents browse and entry forms add Agent & Area fields
• Stock documents data module add Agent & Area fields
• Stock documents entry and ST_TR tables add Agent & Area fields
• Fix MyInvois Dashboard Floating-Point divide by 0 exception on Win64 platform
• Fixed Asset Opening vs GL Maintain Opening Balance not correctly sum for opening balance
• Set tax inclusive to false for E-Commerce modules posted document
• [EIV-MY] Revise import check doc exist and single import
• Fix TikTok posted past invoice with incorrect document amount
• Feature #7100: Audit Trail add Online Approval replied message in Reference field
• AUDIT table Reference field upgrade from 255 to 1000 chars
• Company Profile add IDType & IDNo for Sole Proprietor e-Invoice support
• Add IDType and IDNo field in Company Profile and revise code to get Profile DS for MyInvois
• Add IDType and IDNo field in SY_PROFILE table
• #6763: AR/AP Deposit allow to edit Refund
• Adjustment to TikTok customer shipping fee value in sales invoice
• Includes total tax in WooCommerce sales order and invoices
• Replace the incorrect sku ID in TikTok fetched settlement data
• Check Shopee order is return order before posting shipping fee charge in sales invoices
• Support single day Shopee payment file's adjustment data
• #7110: Load Boolean Datatype DIY Field from file prompt Catatrophic Failure error
• #7107: Boolean Datatype DIY Field without default value prompt invalid argument error
• #7106: Support Boolean Convert for Maintain Form Mode SQL filter
• #7104: Profit Estimator prompt cannot access field as type Integer error
• Fix Year End boolean field bug
• #7103: Stock Month End Balance - Level 4 report prompt conversion error from string "1" error
• #7102: GL Project Profit & Loss with Cash Flow report CN should be grouped into 1 record despite multiple knockoff
• #7090: AR/AP Deposit Refund allow to select Doc Number Set & enter Doc Number manually