SQL Accounting Latest Version (v861) Date : 18 Dec 2024

 

SQL Account 5.2024.1013.861

Released on December 18, 2024

Release Notes

• Revise DB upgrade version 207. Run Boolean script convert in main thread to prevent random exception
• Fix E-Invoice submission error "Maximum allowed document size" is overridden by "Checking status" during batch submission
• [GST-SG] #7127: IRAS Guideline menu URL link is invalid
• #7126: Open GST Return form prompt field conversion error
• Fix for TikTok added duplicated entry of fees during sales invoice editing
• Revise database upgrade version 208 to truncate company profile IDNo
• #7121: Test E-Invoice Validation should be allowed in Production Environment only
• Fix unassigned and null boolean field value cases
• #7081: Acceptable transaction date context missing fixed asset module
• #7124: AR/AP Payment, CN, Contra & Refund, edit & save document which company & payment method is foreign currency, the ticked knockoff records will be deleted
• #7122: SQL Control Center DIY Fields should trim the field name if contains trailing spaces
• #7119: Stock Item Assembly Batch Update Cost unable to tick multiple Assembly Doc No
• Fixed GL Ledger-FOREX Gain Loss Knockoff date instead of Invoice Post Date.
• Fix Incomplete credential able to register in if client id is empty
• Fix unable to show production portal if active environment is sandbox
• Database upgrade to version 208
• Add MyInvois_FutureCred to support StartDate logic
• [EIV-MY] Add reminder to use production EIV on logon
• Add MyInvois_FutureCred field in SY_PROFILE table
• Resize MyInvois Info form and change font
• #7117: GL Stock Value should allow negative value
• Fix TikTok incorrectly added free of charge item to sales invoice
• Bug fix for WooCommerce order document item with output tax set for the stock item
• Add IRBM_InternalID column to SL/PH Document Listing
• Feature #7055: Stock documents entry and reports add Agent & Area fields
• Stock Physical Worksheet add Agent & Area filters and fields
• Stock Reorder Advice add Agent & Area filters and fields
• Stock Card Qty add Agent & Area filters and fields
• Stock Card add Agent & Agent columns on Detail grid
• Stock Analysis by Document add Agent & Area filters and fields
• Stock Document Listing add Agent & Area filters and fields
• Stock documents datamap add Agent & Area fields
• Stock Posting add Agent & Area fields
• Stock documents browse and entry forms add Agent & Area fields
• Stock documents data module add Agent & Area fields
• Stock documents entry and ST_TR tables add Agent & Area fields
• Fix MyInvois Dashboard Floating-Point divide by 0 exception on Win64 platform
• Fixed Asset Opening vs GL Maintain Opening Balance not correctly sum for opening balance
• Set tax inclusive to false for E-Commerce modules posted document
• [EIV-MY] Revise import check doc exist and single import
• Fix TikTok posted past invoice with incorrect document amount
• Feature #7100: Audit Trail add Online Approval replied message in Reference field
• AUDIT table Reference field upgrade from 255 to 1000 chars
• Company Profile add IDType & IDNo for Sole Proprietor e-Invoice support
• Add IDType and IDNo field in Company Profile and revise code to get Profile DS for MyInvois
• Add IDType and IDNo field in SY_PROFILE table
• #6763: AR/AP Deposit allow to edit Refund
• Adjustment to TikTok customer shipping fee value in sales invoice
• Includes total tax in WooCommerce sales order and invoices
• Replace the incorrect sku ID in TikTok fetched settlement data
• Check Shopee order is return order before posting shipping fee charge in sales invoices
• Support single day Shopee payment file's adjustment data
• #7110: Load Boolean Datatype DIY Field from file prompt Catatrophic Failure error
• #7107: Boolean Datatype DIY Field without default value prompt invalid argument error
• #7106: Support Boolean Convert for Maintain Form Mode SQL filter
• #7104: Profit Estimator prompt cannot access field as type Integer error
• Fix Year End boolean field bug
• #7103: Stock Month End Balance - Level 4 report prompt conversion error from string "1" error
• #7102: GL Project Profit & Loss with Cash Flow report CN should be grouped into 1 record despite multiple knockoff
• #7090: AR/AP Deposit Refund allow to select Doc Number Set & enter Doc Number manually