SQL Account Release Note
SQL Account 5.2022.949.827
Released on December 31, 2022
- Add GL Trial Balance - This Month vs This Year with Opening format
- Fixed Report Seq field show big figure
- [GST-SG] #6410: SL/PH Document Entry Tax amount not calculated after transfered from other document between GST Transition Period 7% & 8% different tax rate
- #6400: Not allow delete past depreciation if asset item is disposed on future date
- Feature #6390: GL Trial Balance add Opening Balance & Period to Date column
- #6404: Tools | Option | GL | Conversion Date prompt Access Violation when exit application if error occurred when save option
- #6405: License Module "Special Aging" replaced by "Project Profit & Loss with Cash Flow"
- #6394: Maintain Price Tag enable DIY Fields
- #6402 Auto Bank Recon - OCBC Bank unable to load amount when balance overdraft
- Feature #6403: GL P&L and Balance Sheet report Project Comparison tree list add header built-in menu, columns filtering and Find Panel
- #6399: Alert user when try to save asset disposal record if asset depreciation is not processed up to dispose date
- Change asset disposal date doesn't refresh accum depreciation
- #6397: GL Trial Balance - Year To Date Retained Earning B/F incorrect when Start Date is not 1st day of month
- #6398: Supplier Bills & Payment Analysis report grid enable multi select
- #6396: Maintain Stock Value should remain when Clone DB for Master Data Only
- #6391: Customer Analysis By Document report when filter grid column > 0 some zero value records still show
- #6317: Show "New Taxable" button on past invoice
SQL Account 5.2022.948.826
Released on December 10, 2022
- Account Inquiry adjust the aging grid height
- Database upgrade to version 190
- [GST-SG] Support seamless filing for SG GST Return F5 & F8 submission via API
- Add GST F5 Return-2023 format
- Maintain User add Phone field
- Fixed PO unit price display format not follow tools | options
- Fixed Stock Analysis By Document - Level 1 sometime hang due to summary hight
- Remove Voucher from Item Discount for Sales P&L By Doc - eCommerce reports
- Fixed #6275 OR not auto select when WhatsApp
- Add Yearly Depreciation - Group By Level 1 format
- Fixed Seq big number for Report format with (Tax 1)
- Fixed Asset Analysis BF not correct
- Fixed Stock Item List Query error
- Add Asset Disposal Listing & Asset Card (with Schedule Depreciation) report
- Add New report format for New feature 6326
- Enable Batch email for Cash Sales Format
- Add Summary total for Trade debtor & Creditor for GL Ledger Level 1
- Fixed GL Payment Voucher - Detail - Full (with other SCnPV info) display format error
- Post TikTok credit note from payment when escrow amount is 0 and no credit note is posted for order
- Show Lazada order with status "confirmed" under status "delivered"
- Support TikTok V2 authorization API
- Fix EasyStore missing order item's ID
- Check EasyStore's customer's phone number is null or not
- Remove empty spaces in EasyStore SKU and variant ID
- Fix Shopee not including shipping variance in credit note
- Fix Lazada payment added marketing fee as voucher
- Fix TikTok UpdateDate displayed incorrectly
- Fix Shopee return refund variance calculation
- Shopee remove Shopee coin from refund amount calculation
- Shopee try refresh token during get or post request when invalid access token error is received
- Fix Lazada does not include items that's free in print order
- #6384: SL/PH Cancelled Document not allow Transfer To Others Document
- #6381: Fix SL & PH Document Entries UI controls at top right position not align neatly
- Stock Available Balance change IDockSiteView.SetOnDockClientClose
- #6325: Auto Bank Recon - UOB New Statement Format
- #6370: Auto Bank Recon - AMBANK New Statement Format
- Feature #6380: AR/AP Deposit Refund Entry allow COM access to set Doc No
- #6375: Maintain Stock Item delete first record in Customer Price (that contain 3 records) cause incorrect record sequence
- #6298: Job Order Browse Grid add Remark, Line Supervisor and Production Info columns
- #6352: Fix location DIY Field unable to view from Browsing Screen
- #6377: Asset item allow project rate lower than 100%
- Feature #6376: Add Asset code auto running
- #6373: Unable to load default or last used layout for Supplier Payment KnockOff Grid
- #6374: Production Outstanding JO & SO negative outstanding balance (over transfered) should treat as fulfilled item
- #6299: Auto Bank Recon Alliance Bank - Unable to load complete bank statement
- #6368: SL/PH Document Entry Currency Rate should follow periodic currency rate if using copy and paste document
- Feature #6326: Add GL Project Profit & Loss with Cash Flow report
- #6364: Unable to process depreciation without fill in fixed asset acquire date
- #6360: Document Entry Detail first record Seq shouldn't been changed when user delete second record
SQL Account 5.2022.947.825
Released on November 11, 2022
- Add Asset Label 80mm X 45mm format
- Reduce Lazada fetch order limit from 100 to 50
- #6363: AR/AP Analysis by Document report's Payment column should be no value if the payment and bounce date are fall in the same date range.
- Lazada combine "Other Services-Marketing Fees" and "Wrong Weight Adjustment" record into single order's payment
- Fix Stock Take IsValid batch number check doesn't check for batch number with no item code bind to it
- Lazada change payment form voucher column value type to FMTBcd
- Fix Shopee transfer sales invoice to credit note raised transferred quantity is greater than balance quantity
- Fix transfer sales invoice using wrong IVDTLKey value when transferring item from sales invoice
- Allow non stock item in Shopee sales order to be transferred to sales invoice
- Fix AddToCart export stock JSON file prompt exception when description is empty.
- Fixed Tax & TaxRate Grouping Summary not correctly group if have mixture empty & null data
- #6351: AP/AR Fast Entry prompt invalid class typecast error
- #6356: Incorrect decimal place on stock card grid
- #6353: SL/PH document entries transfer from other document the SubTotal will be incorrect if user modify SubTotal in the source document
- GL Account Entry should check if the deleted bank/cash account's parent is not root account before add the parent account to payment method
- #6347: Stock Item Assembly Detail UOM lookup's Cost column should hide if user no right to View Cost
- #6349: Audit Trail Summary open form slow when data is large
- #6340: Customer Payment unable to back to Browse if using Tab docking & Form Mode with Split Browse & Detail Option
SQL Account 5.2022.946.824
Released on October 28, 2022
- Add Asset Opening vs GL Maintain Opening Balance format
- Add Remark1,Remark2, Description2 and StockGroup Fields for MergeItemCode pipeline for Sales & Purchase Data Entry format
- Fixed GL Ledger - Detail Reports 2nd Description not correct shown
- #6343: Asset analysis report depreciation summary doesn't filter by trans date
- Fix Shopee return refund variance and reverse shipping fee calculation for partial refund credit note
- Accept Shopee return details with status ACCEPTED instead of just REFUND_PAID status is allowed
- Add stock item's remark 1 and 2 fields to Stock Take import JSON file
- Remove Lazada transaction records that does not contain paid status
- #6339: Unable to save after paste an asset item already disposed
- #6337: Process Date does not follow Date To on Process Depreciation window
- #6342: Accum depreciation account wrongly posted in JV if process depreciation group by project only
- #6285: GL Cash Book, AR/AP Payment, Refund & Deposit Listing include bounced document and show as red color in report grid
- Feature #6338: Add AcquireDate field to Yearly Depreciation, Asset Analysis reports
- #6288: Journal Entry - Show label out of balance if not tally
- #6329: GL Profit & Loss Statement allow to print opening balance 1 day before System Conversion Date
- #5480: Stock Assembly's Show in Tree Mode dialog OK & Cancel buttons misaligned when resize the form
- #6332: Supplier payment unchecked knockoff invoice prompt "Dynamic SQL error"
- #6330: AR/AP Deposit Refund & Forfeit's Agent & Area should follow Maintain Customer/Supplier by default
SQL Account 5.2022.945.823
Released on October 19, 2022
- #6328: Document Entries prompt invalid value for field "Seq" error when insert more than 32 detail records
- Fixed Stock Assembly-JO vs AS Variance format the variance % value to returns as 100% if JO qty is zero
- Add Security Deposit Amt for Supp Statement 06 & 12 Mths 1 format
- #6296: SL/PH Doc Entries search From Doc No in detail grid's filter row raise error
- #6274: Stock Item Assembly disable the transfer from Job Order in browse mode
- #6323: Stock Analysis By Document report's grouping tick Stock Group prompt error "Field Item Code Not Found"
- Lazada payment should exclude balance transactions amount into transaction details
- #6308: User can cancel customer credit note knockoff invoice contains SV although knockoff tax date already processed
- #6320: Incorrect value for SQty in print outstanding production job order listing report
- Fix TikTok does not include shipping fee in credit note for full refund order.
- Fix Lazada does not open credit note for marketing fee payment
- Fix TikTok combine payment information doesn't sum up fields value
- Support Shopee payment file in Thai language
- Fix TikTok shipping fee not included in adjusted credit note
- Fix TikTok credit note does not include discounted shipping fee by platform
- Add applied Shopee coin amount per order item for partial refund calculation
- Fix Shopee not applying shipping fee to order and fix refund variance calculation for partial refund order
- Fix fetch product show incorrect item code when similar SKU is used across multiple item code
- Remove buyer ship from Shopee shipping calculation and fix Shopee partial refund posted incorrect invoice and credit note.
- Prevent Shopee payment form from editing invoice and credit note
- Fix Shopee refund order with negative escrow amount failed to post invoice and credit note
- Fix TikTok sent empty array to API server
- Fix TikTok doesn't fetch all products
- Database upgrade to version 189
- Fixed Check Different Between Ledger vs Aging should exclude cancelled document
- Fixed Shown unknown value when company Logo empy for GL Official Receipt - Detail - Full report
- Update GL Multi - Ledger - Detail - Level 1 show Currency Data if have mix currency
- Add Fixed Asset module
- Add report templates
- Add license module - Fixed Asset
- Add Asset Disposal data entry
- Add Open Depreciation window
- Add Depreciation Listing report
- Add Process Depreciation window
- Add Depreciation Processor
- Add Asset Analysis report
- Add Yearly Depreciation report
- Add Asset Item data entry
- Add Asset Group data entry
- Add Asset module tables
- Fix Multiple audit trail records posted after create a new stock batch record with detail batch item
- Feature #5927: Maintain Item's BOM grid add move up & down buttons
- Feature #6266: GL Cash Book, AR/AP Payment, Refund, Deposit, SL/PH Order, Cash Sales and Cash Purchase add BankChargeAccount fields
- Add BankChargeAccount field to report form
- Add change BankChargeAccount dialog to ui form
- Add BankChargeAccount field to data module
- GL_CB, AR/AP Payment, Refund, Deposit, SL/PH Order, Cash Sales and Cash Purchase add BankChargeAccount fields
- #6315: All report grids enable Filter Row except Stock Card
- #5951: Cannot focus a disabled or invisible window if split browse & detail window have ticked in form mode
- #6006: SL/PH Doc Entries should clear Discount last memorized value when user edit any existing doc entry
- #6318: Auto Bank Recon CIMB Bank empty result
- #5142: Add Landing Cost with Currency Symbol
- #6319: Exclude Deposit Account in Cash Sales Payment method
- Feature #6292: Document Entry grids add Insert Row Above & Insert Row After options in context menu
- Maintain Item - Adjust buttons position
- #6314: Sales PnL S/N by Document report & Sales Profit Estimator S/N Cost are incorrect if a serial number has more In/Out transactions (e.g stock transfer or CN)
- #6307: Apply P&L Statement with ledger information raise Error : conversion error from string "C1"
- Feature #6206: Barcode (F8) Form add search item by serial number for stock qty out documents
- Fix AR/AP Deposit Refund form label font height to default settings