SQL Account 5.2025.1017.864
Released on February 28, 2025
Release Notes
- Database upgrade to version 210
- Fixed JO, AS & DS report checkbox not correctly shown due to DataType
- Fixed Local amount if 0, no need to show in item Tax and Item Localamt and exclude from sub total for Profit & Loss with Cash Flow (Amt Exclude Tax) report
- Add IRBM_InternalID to DN, CN, SD and SC to standardize table structure
- #7168: FromDoc field upgrade from 40 to 200 chars
- [GST-SG] Feature #7161: Add Tax Codes: NA and TXNA for year 2025
- #7120: Maintain Tax add new Tax Types - Sales Tax, Service Tax, Tourism Tax, LVG & Tax Exemption for Purchase side MyInvois purpose
- Fix watermark not working properly when multiple form create in thread with Begin Invoke
- [EIV-MY] #7153: Classification submit as 004 if reference to consolidated document
- [EIV-MY] #7155: Submit Consolidated Self-Billed E-Invoice in CashBook prompt list index out of bounds error
- [EIV-MY] #7154: Line item classification code should be 004 for consolidated self-billed e-invoice
- Adjustment to Lazada sales invoice and credit note edit logic during post payment
- Add TikTok affiliate ads commission to sales invoice
- Allow posting order's invoice from Lazada payment
- Fix Lazada posted lost claim reimbursement incorrectly
- Check service fee is found before extracting the value from Shopee payment file
- [EIV-MY] #7188: Consolidate E-Invoice add in post date column
- #7163: Add UOM lookup and Serial Number in MyInvois import
- [EIV-MY] #7187: 3rd party incomplete EIV field posting cause null conversion error
- #7064: Cloud Banking - Show linking feature and notification on Bank Recon when supported bank is selected
- Fix bug: Database upgrade to version 196 prompt "string right truncation" error when execute procedure INSERT_DI_PROJECT
- #7182: [EIV-MY] Check consolidated E-Invoice status prompt out of memory error
- Fix SL Profit & Loss Serial No & SL Profit & Loss Report Doc Cost & Item Cost display format
- #7141: Sales S/N Profit & Loss By Document Item Cost no value when last IN transaction is Stock Transfer. For accurate Item Cost, should refer to costing table
- #7180: Read MyKad auto-fill IDType and IDNo in Maintain Customer
- #7164: Enable to drag and drop from Stock Item Search to Print Bar Code (Window Printer)
- Add item price credit adjustment when editing Lazada sales invoice
- Fix Shopee failed to post refund orders with item price less than fees
- Fix Shopee posted sales credit note without shipping seller protection fee when order is completed without return, but escrow amount is negative
- Fix Lazada LazCoins discount labeled as transaction fee instead of discount
- Add Shopee delivery seller protection fee premium to sales invoice
- #7165: Stock Month End Balance report apply raise Dynamic SQL Error: Count of read-write Columns does not equal count of values
- Optimize performance of Process Deprecation and Open Deprecation
- Convert null values to zero for the number of fields in asset item when saving
- #7157: DIY Field - Boolean Data Type initial default value should be False
- Revise database upgrade scripts to compatible with firebird 3
- #7145: SL Invoice, Cash Sales, DN & CN Different TIN dialog should display company name
- #7148: Stock Batch Qty Lookup by default untick "Show Qty> 0" option
- [EIV-MY] #7149: GL Cash Book Entry Payment voucher default classification code change to 036
- #6944: Data Import - Assertion failure error on AR_Customer template load. Fix DBAccess OPF parameter value issue
