SQL Accounting Latest Version (v837) Date : 30 Sept 2023

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