Friday, October 6, 2023

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