#6534: Calculate Stock Costing issues in multi user environment. Stock Item has qty balance in Stock Physical Worksheet but no data in Stock Card report. Error “Cannot update erased record” occurred when perform same item costing calculation simultaneously
Improve TikTok load payment file performance
Fix TikTok failed to post partial refund order
Fix Shopee failed to post partial refund order
Fix Lazada post credit note with missing partial refund info, and Reversal Promotional Charges Vouchers not included in posted credit note
Add confirmed status to Lazada order view
Fixed GL Ledger-FOREX Gain Loss error arithmetic exception, numeric overflow. Floating point divide by zero….
[GST-SG] Open GST Return Form disable “Submit GST Return to IRAS” option for draft records
SQL Account 5.2023.957.831
Released on May 15, 2023
Release Notes
Disable invoice editing when loading TikTok payment file
Fix TikTok not posting shipping fee adjustment correctly
Fix TikTok not showing actual exception message while posting payment
Fix TikTok credit note does not apply shipping fee charges by TikTok for canceled order
Fix Woocommerce not excluding auto-draft order
Fix Lazada credit note does not knock off invoice
Fix Shopee order to include original platform discount into estimated escrow amount and invoice amount calculation
Fix TikTok not posting order with just shipping fee charge
Add Comparison – Monthly (18 Months) format for GL Profit & Loss report
Fixed PV & OR displayformat not follow option
Fixed Export to excel Account Description empty for GL BS – 4C0P format
#6531: Rename Asset Disposal to Asset Disposal/Write Off
Fix PopupControl.TaxRate inaccurate buttons position
#6526: Customer Statement with incorrect Aging info if date from is blank
#6529: Stock Card report’s Merge Same Cost option by default untick
#6527: Auto Bank Recon – Auto match first same amount but different date transaction with bank statement record
Fix Bank Account Number is missing for some Supplier Payment when preview Supplier Payment Listing
#6523: Improper function on Access Right Setting for “Hide Dashboard” under View menu
#6522: Unable to process subsequent month depreciation if asset cost is negative
Feature #6385: Allow stock item to batch edit stock group
#6521: Edit & Save Invoice (Note field has value), prompt error “Could not convert variant of type (Array Byte) into type (Integer)”
#6518: Preview AR/AP Payment, payment method description is empty if the payment transfer from Deposit
#6519: View Price History – Record should always Go to first
SQL Account 5.2023.955.830
Released on April 19, 2023
Release Notes
#6512: Hide Dashboard access right should move to View instead of Inquiry
#6327: Auto Bank Recon – Match button not showing for DR amount match with Net DR when merge bank charges is checked
Remove Entry Forms “Close” button
#6088: DIY Advance Form Design’s Component Palette not display fully
Change Page 2 Title to Year To Date
Fixed rounding error for Asset Opening vs GL Maintain Opening Balance report
Fixed Journal Voucher Spelling Error
Add SST-02 (2023) format
Fixed Profit & Loss with Cash Flow (Amt Exclude Tax) label not correctly shown
Support batch product map for E-Commerce product page
Fix TikTok not showing exception message when attempt to store duplicate order number
Fix AddToCart export JSON file prompt exception when product name is empty
Fix AddToCart not showing mapped item code in Order page. Removed AddToCart SKU code.
Fix TikTok not include SFP Service Fee in sales invoice, and prevent duplicate records added when editing sales invoice and credit note
Fix TikTok not including customer paid shipping fee in credit note for cancelled order
#6510: GL Ledger Purchase Invoice with same document number, but different supplier when double click will show first document
#6509: SL/PH Price History default show latest price by document type instead of oldest
#6508: Sales P&L by Document UnitPrice not follow the decimal point set at option
#6505: Sales P&L By Doc report add DocUnitPrice (original document unit price)
Feature #3882: GL Bank Deposit support Payment Voucher
#6500: Profit Estimator unit price amount different with unit price in Invoice
#6489: Add Auto Bank Recon – Standard Charted Bank Format
#6501: Year End auto post Stock Received for Serial No. Opening, set the document Description as “Opening Stock (Serial Number Items)”
SL/PH document posting to AR/AP should include Note field
#6492: Data entry form supports OnBeforeSave DIY event
Feature #6440: Stock Aging add Aging Type “Monthly (60 Months)” and quarterly support up to 5 years
#6336: Show Chart unable to close line chart after focused records
#6487: Supplier Deposit Entry New Refund & Forfeit options are missing. (Fixed commit 0948fd9c)
#6466: Purchase Invoice copy foreign doc & paste to another DB which currency code not exists. The Local Net Total field remain unchanged even after change supplier code
#6476: Customer Payment transfer from Deposit prompt “Payment Amount Cannot More Than Deposit’s Unapplied Amount” error even is same amount
SQL Account 5.2023.953.829
Released on March 9, 2023
Release Notes
#6469: Asset reports prompt dynamic SQL error when filtered by asset group, agent, area
Fix Sample db load profile logo error
Database upgrade to version 191
#6455: Add Ref field to Customer and Supplier Bank Account datasets
Add Ref column to AP_SUPPLIERBANKACC, AR_CUSTOMERBANKACC tables
Add Online Approval for access right
Add Online Approval message to access rights
SY_User add Mobile & OpenID_Google fields
Feature #6401: Points entry add Agent, Area and Project fields
Points Listing add Group/Sort By, Area, Agent, Project, Company Category fields and filtering
#6457: GL Trial Balance Period To Date column incorrect when Opening in CR & YTD in DR
#6456: Cash Flow Forcast form UI adjustment
#6453: Stock Analysis By Doc apply prompt integer overflow error
#6451: Profit Estimator – Change Label Use Actual Cost to Use Actual On-Hand Cost
#6446: Sales PnL by Doc – UnitPrice should divide by Base Qty
#6449: Supplier CN & DN entry forms button rename caption to New CN & New DN
#6424: Stock Card main grid add Qty column
#6443: Maintain Stock Item become not responding when save after Copy from Item A and Paste into existing Item Code (which Customer Price has 192 records)
#6430: Enable web-style row selection for grid view on “Bad Debt Relief” form
#6435: Sales Order unable to change document date by pressing ENTER to the next field
SQL Account 5.2023.951.828
Released on January 30, 2023
Release Notes
Fix Shopee failed to create sales credit note for refund order
Include store ID in generated Lazada payment reference ID
Fix EasyStore does not include shipping fee, item discount, and transaction fee in sales invoice
#6429: Supplier payment with invalid bank account allowed to save
#6431: Customer payment unable to unchecked knockoff service tax invoice after process draft SST return
#6423: GL Ledger report grid do not save last used layout
#6428: GL Ledger Group by Project – Balance incorrect if untick Include zero closing balance
#6413: Maintain Customer Credit Control unable to tick multiple document types when choose Chinese language
#6414: Form Mode Filter By Agent cannot work if use “Transfer To”
