#6831: Document Entry forms click “Edit as New” button shouldn’t remain 6% Tax Amt on March 2024
#6834: Access violation in Show Chart
#6829: SST tax code with Tax Inclusive by default will cause Tax Amt incorrect when Sales Order Date before 01 Mar & transfer to IV for Date after 01 Mar 2024
Fix Incomplete captions of menu items under SST/GST menu
#6820: SQL Power Search prompt “Could not convert variant of type (Null) into type (OleStr)” when tick a table to search
SQL Account 5.2024.977.843
Released on February 29, 2024
Release Notes
Database upgrade to version 198
#3445: Job Order add Cancelled Date & Cancelled Qty
Auto Select Bank for Giro bank info when BankID is selected and Giro is null
#6806: Maintain Location default location should set default GL Stock Project for new database (db upgrade only)
Convert Stock Received to FR3 format
Recognize TikTok payment type “Deductions incurred by seller” as adjustment
#5558: Serial Number Qty lookup labels at the bottom not display properly
#6680: Import asset item through batch entry window prompt “Schedule total depreciation must be equal” error
#6748: Asset analysis show zero disposal amount when filtered by asset group
#6732: Add journal entry document number to asset depreciation process
#6765: Open Depreciation Listing prompt “Access Violation” error
SQL Account 5.2023.972.839
Released on December 8, 2023
Release Notes
Database upgrade to version 195
Feature #6749: GL Bank Reconciliation add Attachment field
Feature #6752: Maintain Location add GL Stock Project field for auto post GL Stock value by project
#6760: Maintain GL Stock Value prompt “Invalid Transaction Object” error when save
#6757: AR/AP Deposit Entry once change the date from after conversion date to before conversion date the ledger transactions for detail records still exists
#6762: Rich Text Editor multi select different rows with different font size and click font size combo box prompt “” is not valid integer” error
Fixed Cust-Multi-F1-12 Mths Statement-Jun 2004, May 2004….xml error when Batch Email
Shopee fallback to individual order fetch when empty array is received from API endpoint
Fix TikTok fetch order item’s SKU info causes access violation on multi-thread execution
TikTok allow ignore cipher when get request query
Fix TikTok failed to post order with shipping fee only
#6761: Stock Transfer open barcode form (F8) search by serial number prompt access violation error
#6734: GL P&L report Taxation account should be positive for debit side value
#6759: Open GL Cash Book raise error “overflow error while converting a variant of type (Double) into Type (Currency)” due to a large value enter for bank charge
#6758: AR/AP Deposit Entry Deposit Acc lookup should include Other Liabilities & Other Assets deposit accounts accordingly
#6754: GL P&L Statement, Balance Sheet Statement and Trial Balance report should not auto update GL Stock Value if fall outside maintain acceptable trans date
SQL Account 5.2023.968.838
Released on October 27, 2023
Release Notes
Fix posted incorrect amount of EasyStore gift voucher to sales invoices
Enable Auto Post Reverse Unrealise GainLoss on 01 of Next Month for Customer & Supplier 06 Months Aging-GainLoss format
Reduce Level support to 3 for GL BS – 6C1P – FA format
Database upgrade to version 194
#6723: GL Balance Sheet & GL P&L reports Project Tab add Full Expand & Full Collapse options
#6707: AR/AP Deposit Entry Deposit Account lookup filter by current asset or current liabilities
Force TikTok confirmed order status to canceled for order canceled due to item not shipped out
Fix GL P&L & Balance Sheet report condolidate display empty database in SQL Connect, which window registry Connection.Pool is blank for normal users
#6708: SL Invoice edit save prompt error “2149900253” is not a valid integer value
#6700: Maintain Stock delete a BOM item cause invalid sequence for other BOM items
#6699: Stock Costing not calculated for old item code if edit document change to another item code
#6696: CN Transfer from Sales Invoice show “Insufficient memory for this operation” error when Invoice has 400k+ records
SQL Account 5.2023.967.837
Released on September 30, 2023
Release Notes
Add QR Payment for Sales Invoice 8 (SST 2)-Aging format
Fixed Cust Local – Payment Listing – Collection Report Amount not reset when record not found
Fixed Sales DN rtm format FromDocDate show 30/12/1899
Update Job Order 1 format Remove the Unit Cost, Overhead Cost and Subtotal, Group by detail location & Add batch and signatory ie. Prepared by, Processed by
Fixed GL Local – Ledger – Detail – Level 2 Total balance by group not correct
Fixed Sales Local Invoice & Cash Sales Collection Report Grand Total not correctly map
Update Sales Invoice 8 (SST 2)-Aging for Pay only shown outstanding amt instead of docamt
Add new Asset Analysis (12 Months) – Group By Level 2
Remove net book value column and replace with gain/loss from disposal of assets in Asset Analysis
Adding Shopee order’s note to document’s note
Show country for Lazada, Shopee, and TikTok shops
Support linking with Lazada cross border account
Support linking with Shopee main account
Support new TikTok payment file format
Include note property for sales order and quotation
Fix Lazada payment posted refund with wrong amount
Increase number of records fetched from 250 to 500 for Lazada transaction details
Remove duplication check for Lazada transaction details
Do not post sales credit note for order that posted with canceled sales invoices
Fix TikTok HTTP request retries bug
Fix post cancelled order using option “Post As Cancelled Sales Invoice” does not tick “Cancelled” in sales invoice
Allow user to ignore Lazada payment for unposted order
Allow user to ignore Shopee payment for unposted order
Fix Shopee incorrectly posted “Product discount rebate from Shopee” in sales credit note
Fix TikTok assigned document number even document failed to post
Retry HTTP request if error code 500 Internal Server Error received
Check cell value is not empty before assigning Shopee payment header index
Allow user to select specific account(s) before fetch products
Allow user to select specific account(s) before fetch orders
Auto Bank Recon – Revise Bank Islam current account cash line-i statement format
#6575: Auto Bank Recon – Maybank Bank Statement Bank Closing not match ending balance
#6647: Auto Bank Recon – Maybank invalid numeric input for bank statement that contain gst type column
#6574: Auto Bank Recon – CIMB Bank did not auto fill Bank Statement Bank Closing balance
#6685: Stock Assembly unable to save if users no right for Allow Non-existent/Duplicate Serial Number even the Serial Number is valid
#6694: Sales Profit Loss By Document & Sales S/N Profit Loss By Document tick Cash Sales by default
View | SL/PH Price History form should focus on first record by default if user last saved grid layout sort by date descending
#6692: Rich Text Editor unable to change font type, size or color when selection text have mix Font settings (if user change to same current value of combo box)
#6686: SQL Connect unable to do Consolidation when DCF file saved in SQL Drive folder
#6642: RHB Reflex cloud banking “remark2” field is filled in as payment advice
#6681: Missing asset group, agent and area lookup on asset item batch edit window
#6683: Entry form “Edit as New” button click should prompt access denied if users don’t have “New” access right
#6584: SL/PH CN right click add “Show KnockOff” option to open AR/AP CN entry form
#5738: Stock Physical Worksheet drill down open different forms based on Qty, SO Qty, PO Qty and JO Qty column’s click
#6671: Add Journal No. on Asset Disposal entry window
#6674: Sales Price History report prompt Assertion failure error when tick Latest n records option
#6670: Sales Picking list report add DtlKey field
#6666: SL/PH Document Entries shouldn’t allow to save if Discount contains comma
#6667: Stock Transfer unable to save if don’t have the right for Allow Non-existent/Duplicate Serial Number