SQL Accounting Latest Version (v823) Date : 19/10/2022

 

SQL Account 5.2022.945.823

Released on October 19, 2022

Release Notes

• #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

SQL Accounting Latest Version (v822) Date : 22/09/2022

 

SQL Account 5.2022.942.822

Released on September 22, 2022

Release Notes

• Fix Lazada combined different date marketing fees.
• Verify transaction by matching released amount to avoid mixing transaction from different account
• Fix Lazada failed delivery order not canceled after shipped back to seller.
• Fix Shopee failed to knockoff order's credit note without invoice.
• Fix Shopee not posting credit note when escrow amount is negative and order is not canceled or returned.
• Fix Shopee showing incorrect discount value.
• Fix Lazada not showing expired token message.
• Fix Shopee fetch cancelled order by buyer show logistic.error_param exception
• Add Customer Listing - Credit Control format
• Fixed GL OR & PV Amount not Including TaxAmt
• Fixed OR & PV batch print for RTM format not correct shown Amount
• Add Supp Local - Deposit Listing - Level 1 - Tally with Balance Sheet format
• #6297: Stock Analysis By Document add RefPrice & RefCost grid columns
• Feature #6291: ComObject add PlainTextToRichText & RichTextToPlainText function
• #6262: GL Bank Reconciliation should use Debit(Net) column for auto bank recon if Merge Bank Charges is ticked
• #6287: GL P&L Statement prompt access violation when filter by project with Ledger Information
• #6284: Sales Invoice Tax "SR" ledger posting is missing when user edit document date that fall in year 2022 which is not GST era
• [GST-SG] #6280: Open Sales Invoice raise Access violation error after start Singapore GST. Revise Company Profile Peppol APIKey & Secret editing issue
• #6283: GL Profit & Loss Print Project comparison prompt error "List index out of ranged" if Project parent nodes have repeated same value
• #6276: Run Repost Stock Transactions prompt arithmetic numeric overflow exception error
• #6300: Fix Maintain Project Range Editor btnMoveUp & btnMoveDown icon and on click error