SQL Accounting Latest Version (v862) Date : 28 Dec 2024

 

SQL Account 5.2024.1008.860

Released on December 28, 2024

Release Notes

• [MyInvoisAPI]: 2027-12-27 MyInvois Maintenance
• #7130: Consolidate Cash Book E-Invoice and Self-Billed
• Adjust PH document listing "Consolidate No" column default visibility
• #7132: SL/PH Document Discount Value not deducted in Subtotal when Tax Inclusive is ticked
• [EIV-MY] #7133: SL Invoice, Cash Sales, DN & CN upon save prompt confirmation dialog if TIN is blank or different with Maintain Customer
• #7131: Sole Proprietor Company submit consolidate E-Invoice prompt TIN is not matching error
• [EIV-MY] #6952: Submit E-Invoice Buyer's EMAIL is empty even though have filled up Email in Maintain Customer

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

SQL Accounting Latest Version (v860) Date : 22 Nov 2024

 

SQL Account 5.2024.1008.860

Released on November 22, 2024

Release Notes

• Fixed Disposal Asset Card-Journal Voucher no decimal point
• System report script convert Boolean
• #5588: Convert Boolean field to actual Boolean Type
• Database upgrade to version 207

SQL Accounting Latest Version (v859) Date : 21 Nov 2024

 

SQL Account 5.2024.1006.859

Released on November 21, 2024

Release Notes

• Add Dashboard in MyInvois form
• Adjustment to TikTok invoices and credit notes posting
• Adjustment to Shopee return refund variance posting in sales credit note
• Add TikTok actual shipping fee adjustment to sales invoice
• Adjustment to TikTok other fee amount posting
• #7094: Maintain Customer/Supplier if Code end with --, add Branch cause two rows appended and prompt "RecordIndex out of range" error
• #7070: Maintain Customer BRN search replace company name
• #7084: SQL Control Center unable to change DIY Field Defs when click save directly after edit
• #7088: AR/AP Deposit Refund's Description should post to GL Cash Book's Description2
• #7086: Stock card prompt access violation when detail grid is cleared
• #7087: E-Inv Submit Date prompt access violation when using application theme
• #7075: Stock Month End Balance tick Include Zero Balance option, UOM field is blank for no transaction items
• #7074: Enable classification code 016 on self-billed classification lookup

SQL Accounting Latest Version (v858) Date : 15 Nov 2024

 

SQL Account 5.2024.1005.858

Released on November 15, 2024

Release Notes

• Fix "Could not convert variant of type (UnicodeString) into type (Integer)" when grid focused row is grouping row
• Include TikTok customer shipping fee and platform shipping fee discount adjustment
• #7077: Member Points delete entry record prompt "You are about to save date before 01 Jan 2000" dialog message
• #7069: Sales Order transfer to Purchase Order's Total Qty should deduct the Qty transferred to Sales Cancelled Note
• Support new Shopee payment file format
• Add TikTok bonus cashback service fee to sales invoices or credit note
• #7076: Production Job Order prompt access violation on open
• #7073: E-Invoice Submission Error: CodeType Tax Types is mandatory and was not provided in the document
• #7072: GL P&L and Balance Sheet report consolidation grid's Company Remark should display the user defined style properly
• #7057: Self Bill e-Invoice for Imported Service Tax IMSV & IMSVE should include in when submit e-Invoice
• #7066: e-Invoice Submission support Total tax amount per tax type if the invoice document consists of mixed tax types and per document detail support multiple tax type
• Consolidated invoice support total tax amount per tax type and document detail support multiple tax type
• AP and PH modules support SQL View
• #7071: Incorrect Name for Adding Intermediary in Production/Sandbox Mode
• Use net sales amount for TikTok SKU transaction's gross sales amount equals to 0, but settlement amount is larger than 0
• Adjustment to E-Commerce module order's item mapping
• Database upgrade to version 206
• #7003: Support sales document change SIC at document level
• [EIV-MY] Add EIV Local date time in UI and reports
• Rename table field EIVDateTime to EIV_UTC
• [EIV-MY] Company Profile add MyInvois Start Date
• [EIV-MY] Support MyInvois_StartDate in E-Invoice action
• #6559: Add LastModified field in SL/PH/AR/AP/GL document table
• Support DIY script highlight compile error line
• #6995: Add search BRN at document entry (SL/PH/Cash Book)