Monday, August 28, 2023

SQL Accounting Latest Version (v836) Date : 24 August 2023

SQL Account 5.2023.965.836

Released on August 24, 2023
Release Notes
  • Allow posting Shopee canceled order
  • Fix Shopee incorrectly posted refund variance adjustment to sales credit note
  • Database upgrade to version 193
  • #6653: Add Description2, DocNoEx and Qty fields to Asset Item data entry window
  • #6632: Asset item allow to input useful life up to 4 decimals
  • Fixed Profit & Loss with Cash Flow (Amt Exclude Tax) report Unable to show Total Cost if do not have cost Adjustment.
  • #6659: Auto Bank Recon - Bank Islam current account cash line-i statement format
  • Fixed Sales Local - Cash Sales Collection Report not including Contra amount
  • Fix TikTok does not create sales credit note for returned item in partial returned order with status completed
  • Fix Lazada posting sales credit note without reversal item price for refund order
  • Fix Lazada does not include lost claims and adjustments item charge when editing sales invoices
  • Fix Woocommerce to use item ID instead of SKU to store alternative code
  • Avoid checking for Lazada payment file using empty cheque number
  • Delete Lazada sales invoice details while retaining stock record
  • Fix Lazada merged item incorrectly
  • Adjustment to Shopee return refund variance calculation
  • Adjustment to TikTok token refresh logic
  • Fix Lazada not adding returned stock items in sales credit note
  • Fix EasyStore does not include gift voucher in sales invoice
  • #6641: Calculate Costing post duplicate stock transfer or missing documents issue in multi user network environment
  • #6393: Asset item can be imported without verifying valid asset group
  • #6640: Customer Balance Report incorrect Local C/F when Payment's GainLoss Posting Date > DateTo
  • #6656: Sales Price History report prompt out of memory error
  • #6651: Maintain Withholding Tax allow Tax Account (DR) leave blank to follow document accounts
  • #6643: GL Ledger incorrect BF balance if group by Project alone. Account code should be compulsory to tick for grouping
  • #6645: Calculate Costing prompt "Out of Memory" error even item using Fixed Cost method
  • #6610: Two Good Received created at the same with same Serial Number for same item code shouldn't allow to save if access right "Allow Non-existent/Duplicate Serial Number" is unticked
  • #6639: Prompt error "cannot focus a disabled or invisible window" when double click on item flow document in tabbed docking mode

Tuesday, August 8, 2023

SQL Accounting Latest Version (v835) Date : 04 August 2023

SQL Account 5.2023.963.835

Released on August 04, 2023
Release Notes
  • #6635: All SL/PH Browse grid add Billing Attention, Phone, Mobile & Fax columns
  • Update on HomeScreen debit credit icon
  • Ignore adjustment to quantity and discount when editing Lazada sales invoice
  • Ignore item ID when constructing Lazada post order details
  • Fix Lazada get transaction details with incorrect limit number
  • Fix TikTok posted refund seller discount incorrectly
  • #6634: All document entries upon save prompt message if Doc Date less then 01 Jan 2000
  • #6289: Stock Transfer View Price Tag should display Unit Price based on selected customer
  • #6626: GL Cash Book split form mode click New PV but show as OR entry. Same issue happen on AR/AP DN & CN
  • #6621: Stock Card Qty report tick Include Zero Balance Transaction show incorrect result
  • Fix Stock Card Qty report data form caption
  • #6628: GL Cash Book, AR/AP Payment & Refund Forms Bank Balance label change to grey color without bold
  • #6629: AR/AP Deposit Entry add Deposit Account column in browse grid
  • #6535: Auto Bank Recon - HSBC Bank Statement new format
  • #6577: Auto Bank Recon - RHB Bank New Cambodia Statement Format
  • #6591: GL Ledger Report group by Account & Project transactions not show if untick "Include zero B/F with Transaction" option
  • #6627: GL Cash Book, AR/AP Invoice, DN & CN forms 2nd side button position wrongly when using split browse & detail form mode
  • #6613: Sales Invoice save prompt conversion date error if Region format is Thai and Start GST with United Arab Emirates Country
  • #6620: Purchase Order transfer from Sales Order Document tab's Amount, Local Amount, Currency Code & Project are blank
  • #6624: Cash Sales & Cash Purchase unable to select Payment Method if user manually enter Doc No
  • #6616: Location lookup add Description 2 field
  • #6617: Customer Payment unable to save if using Rich Text Editor