SQL Account - Releases
SQL Account 5.2021.908.802
Released on May 29, 2021
Release Notes
-
#5847: Customer Balance Report's Current Balance should show PM outstanding instead of 0 when Future Refund knockoff PM (within date range)
-
Fixed GL Payment Voucher - RTM format Currency Rate 1 should hide
-
Fixed GL Bank Reconciliation Report - Clear Transaction not include Opening Balance Information
-
Fix Woocommerce did not fetch product's variations
-
Fix Shopee order couldn't be posted when shipping fee charged more than item price
-
Feature: Lazada setting add "Claims" item group
-
Adjust: Lazada payment to use statement description as SQL description
-
Feature: Lazada payment will create customer refund to knock off
-
Feature: Lazada payment will amend invoice detail
-
Feature: Shopee order able to replace sales invoice
-
Feature: Shopee payment able to post past invoice
-
Fix Shopee order did not include seller coin cash back as voucher
-
Fix Shopee order post to Sales Quotation incorrect detail
-
Fix Shopee order incorrect discount amount
-
Fix Shopee, Lazada order refund should post only returned item
-
Fix Shopee order couldn't be posted when escrow amount is less than 0
-
Fix Lazada order will prompt error when no orders within the selected period
-
Fix eCommerce address filled up wrongly in invoice
-
Fix AutoBankRecon matched to wrong record
-
#5846: GL Bank Deposit Search Form missing Mark & Clear All, Mark & Clear Selected in grid context menu
-
#5833: Sales Profit Estimator's Total Sales Rounding issue
SQL Account 5.2021.907.801
Released on April 28, 2021
Release Notes
-
Upgrade Database Version 183
-
Add Shopee 2 format
-
#5823: SST-02 Report Field 11a, 11b, 11c and B1 should include CN with SU, SU5 & SUV tax code
-
Feature #3595: GL Balance Sheet Report when drill down Customer/Supplier account should apply Sales/Purchase Ledger report accordingly
-
#5764: Job Order Listing Report master record show only when there is detail record
-
Feature #5814: Stock Transfer Listing detail grid add more columns from detail dataset
-
Feature #4701: Production Outstanding Sales Order add ItemType option to suit SO->PO case
-
Feature #5736: Stock Item - BOM add Number, Description2, Description3, Remark1 & Remark2 fields
-
Feature: Lazada payment able to post past invoice
-
Fix Woocommerce product fetch time out
-
Feature - Lazada auto refresh token when expires
-
Fix Shopee order status "To Ship" will always post to QT
-
Fix eCommerce post IV, CN, QT should overwrite the original address
-
Fix Lazada will return error message from the response
-
Feature: Lazada payment with same PaymentRefID with auto open bank deposit
-
Fix Lazada order unable to manual map item code for certain orders
-
Fix Lazada unable to post payment when all orders are posted to invoice
-
Fix eCommerce grid flickering issue when posting IV
-
Fix Shopee shipping fee not tally
-
Add GL.Auto.BankRecon.CITIMY
-
Fix auto bank recon error at RHB Bank Statement
-
#5812: auto bank recon error at Alliance Bank statement
-
Fix dashboard floating point error
-
#5831: Process SST return prompt error "Account code cannot be empty" if an invoice contains detail with tax code SV (payment basis) and SVA
-
#5809: Stock Matrix not working on document entries
-
#5802: GL Official Receipt didn't prompt bank reconciled warning message even already reconciled
-
#5811: Maintain Stock Item's BOM SubTotal column should hide when access right "Show Cost in Stock Item Maintenance" unticked
-
#5808: Available Stock Balance and Stock Reports' item JO Qtyshould show 0 if Stock Assembly's detail Qty greater than Job Order's detail Qty
-
#5813: Customer Contra Entry prompt "Unable to commit inactive" error upon save
-
Feature #5791: All entry forms support Edit -> Edit As New
SQL Account 5.2021.906.800
Released on April 6, 2021
Release Notes
-
Upgrade Database to Version 182
-
Reduce Column Usage on FR3 Export to excel for Sales Local - Cash Sales Collection Report when full expand
-
Feature #5779: Purchase Price History add Master & Detail Landing Cost 1 & Landing Cost 2
-
#5782: Sales Price History data sorting inconsistent, should sort by DtlKey
-
Feature #5780: Stock Card by Qty Report enable Print Stock Control Item & Non Stock Control Item Options
-
Fixed Sales Invoice 3 (Sales Disc) not include itemcode DISC
-
Adjust AddToCart add column item sku
-
Fix bug: Add supplier bank account without specify bank raise error "Could not convert variant of type Null into type OleStr
-
#5799: Maintain GL Account should remove Parent account from Payment Method if other bank drag under it
-
Fix eCommerce unable to show all products when more than 1 shops are link with SQL
-
Adjust Lazada: Payment disable "Post" button if any order not posted to invoice
-
Adjust Lazada: map sql item code with Shop SKU
-
Fix bug: Woocommerce unable to fetch data
-
Feature: eCommerce order able to post by project
-
Feature: eCommerce order able to manual set item code and uom
-
Fix eCommerce will not post item when price = 0
-
Adjust Shopee shipping fee when posting to invoice
-
Fix AutoBankRecon UOVBMY adjust data positioning
-
Feature AutoBankRecon able to switch between classic and statement view
-
Add AutoBankRecon PIBEMY keyword for matching PDF file
-
Feature #5793: GL Bank Reconciliation Deposit records show any OR record's Description and Cheque Number
-
#5768: Browse grid not focus on first row if one of the column sort by descending in last saved grid layout
-
#5778: F8 Barcode form cost related UI controls should be hidden if user no right to view cost
-
#5391: Unable to update GL Maintain Opening Balance if project code with /
-
Fix Close company profile window prompt message "You must re-logon for these changes to take effect"
-
Fix Lazada payment split voucher from other fee
-
Fix RHB Statement couldn't load when balance is negative
-
Fix Lazada product limit per fetch change from 100 to 50
-
Fix Shopee not posting CN when returned order's escrow amount > 0
-
Fix Lazada Seller Voucher should post as negative
-
#5771: Unable to open attachment file name with special character #
SQL Account 5.2021.903.799
Released on March 5, 2021
Release Notes
-
#Fixed Sales Cash Sales 6 - Receipt-TM-U220 (SST) DocNo alignment problem
-
#5757: Bank Recon word will overlay with others when too long
-
Adjust eCommerce to post customer phone to DPhone1, customer id to DocRef4
-
Fixed Bug eCommerce: Credit note did not knock off when posting payment
-
AR/AP PM, CN, Refund & Contra add Knockoff DocNo info for error "Knock off amount must not exceed outstanding amount"
-
Fix bug: Auto bank recon PDF last record not showing
SQL Account 5.2021.901.798
Released on February 25, 2021
Release Notes
-
Upgrade Database Version 181
-
#5742: Customer Refund listing preview prompt error "Document_CompanyBankAcc: Could not open DataSet"
-
Feature #5754: AR/AP Contra auto open couple contra form upon save if couple company code is empty
-
Add GL.Auto.BankRecon.UOVBMY
-
Added column Recon At at auto bank recon
-
#5036: GL Journal Entry form mode not working if FromDocType are CN & DN
-
#5745: Different date format for PBB statement (CSV)
-
#5743: Invalid numeric input error when load MAYBANK statement
