SQL Accounting Latest Version (v851) Date : 18 June 2024

SQL Account 5.2024.987.851

Released on June 18, 2024

Release Notes

• Revise database upgrade script version 200 for db upgrade error in certain pc
• Unknockoff TikTok credit note before editing TikTok sales invoice
• Skip posting TikTok platform discount refund
• Adjustment to Shopee voucher adjustment logic
• Support linking with Shopee SIP account
• #6896: Make TEncoding.UTF8 as default encoding using TStringList in DIY script
• Database upgrade to version 201
• Attachment support Database Blob storage & GL Cash Book support OCR
• Add SY_BLOB table
• Add OCR
• Support Database Storage in External Attachment
• GL_CBDTL add OCR field
• Add WebApp
• Add logon by QR authentication
• Add customer aging format with 6 months local amount
• AR and Sales modules support SQL Views
• Fixed Customer/Supplier Multi Balance Listing report not error when preview
• Adjustment to TikTok sales invoice editing logic
• Adjustment to TikTok logic on checking platform shipping fee discount reduction
• Add adjustment grid view for listing Shopee adjustment in payment file, and allow
  posting Shopee adjustment together with payment
• Maintain Customer & Supplier support single company TIN update
• #6891: Job Order transfer from Sales Order the Transfer Qty column unable to enter
  more than 2 decimal places
• [EIV-MY] Batch TIN Update form revise MyInvois calling part to prevent memory leaks
  in thread
• #6883: GL Receipt and Payment Report Balance B/F should based on by Project, Agent
  & Area filtering

 

SQL Accounting Latest Version (v850) Date : 28 May 2024

SQL Account 5.2024.986.850

Released on May 28, 2024

Release Notes

• Revise database upgrade script version 200 for db upgrade error in certain pc
• Tin Batch Update form support user enter TIN
• #6885: AR/AP Post Dated Cheque Listing Amount & LocalAmount footer summary
  values incorrect when filter grid
• Maintain Customer & Supplier add TIN batch lookup
• Company Profile, Maintain Customer & Supplier validate TIN shouldn't raise exception
  if users unable to online (perform silently)
• Company Profile, Maintain Customer & Supplier remove spaces for old/new BRN & TIN
• Feature #5225: Production Job Order and Stock Disassembly add Show Cost access right
• Remove bottom line border from TcxDBImage

SQL Accounting Latest Version (v849) Date : 17 May 2024

SQL Account 5.2024.984.849

Released on May 17, 2024

Release Notes

• Fix TikTok additional shipping fee checking logic
• Remove redundant actual shipping fee entry in TikTok sales credit note
• Re-enable sales invoices editing during load TikTok payment file to add in missing
  transaction fee and SFP service fee
• Fix TikTok posted duplicated platform shipping fee discount adjustment
• Fix Shopee voucher adjustment calculation for return refund
• Fixed SST-02 (20240301) Draft no value
• Fixed Ledger - Detail Description2 get wrong information when record is BA
• Fix Database upgrade version 200 for certain db upgrade failed issue
• #6877: Maintain Customer & Supplier open in Entry mode prompt access violation
  error
• [EIV-MY] Prompt for Company Profile TIN dialog show only if is standalone startup
  mode
• #6876: Stock Item Batch Edit form hide Classification label if company profile is not
  Malaysia

 

SQL Accounting Latest Version (v848) Date : 13 May 2024

SQL Account 5.2024.983.848

Released on May 13, 2024

Release Notes

• Database upgrade to version 200
• Fix process hang when running automation server registration or unregistration
• Switch rounded rectangle TShape to TSkPaintBox
• Import TIN from Excel
• Maintain Customer & Supplier remove GST No lookup function
• [EIV-MY]: Maintain Customer & Supplier form add EIV fields
• [EIV-MY]: Maintain Stock Item form add product Classification field
• [EIV-MY]: Company Profile form add e-Invoice tab. Move GST & SST No fields to 
  GST/SST tab accordingly
• [SST-MY] #6861: SST Tax code "SVE" Description should include for Group J
• Apply adjustment to TikTok platform shipping fee discount when actual shipping fee
  is lower than original shipping fee
• Fix Shopee missing prorated seller voucher offset return in sales credit note
• Fix TikTok calculated other fees incorrectly
• Revise WooCommerce HTTP Authentication implementation
• Trim returned products JSON list data by WooCommerce API
• Fix TikTok posted shipping fee adjustment incorrectly
• Fix TikTok incorrectly listed refund as additional shipping fee charge

 

SQL Accounting Latest Version (v847) Date : 08 May 2024

SQL Account 5.2024.982.847

Released on May 8, 2024

Release Notes

• Fix process hang when running automation server registration or unregistration
• Add SST-02 (20240301) Format
• Split Diff TaxRate for Same Tax Code for SST Listing Report
• Fix Sales & Purchase 8 (SST 1) format tax rate field not correct position when have
  more description
• Skip TikTok buyer paid shipping fee for other fees calculation
• #6874: Auto Bank Recon - Fix always show bank statement have been fully matched
  after error raise
  on load statement
• RHB Reflex - Fix payment method AccNo not update after link
• Prompt error for Shopee escrow detail call after 10 failed attempts
• Adjustment to Shopee access token refresh
• Add TikTok Platform Discount Refund to sales credit note
• Post separate credit note for TikTok additional actual shipping fee charge
• Fix Shopee added shipping fee SST twice in printed order invoice
• Added Shopee reverse shipping fee SST incorrectly in credit note
• Revise TikTok orders fetch
• #6869: Sales P&L by S/N report's Cost will incorrect if same S/N IN & Out same day
• Solve flicker when resize for controls hosted in TdxDockPanel and TPageControl in
  MDI child form.
• #6870: AR Payment's Currency Rate different with Cash Sales when user change the
  Currency Rate
• #6868: AR/AP Balance Report's Document_Currency pipeline is empty
• SSM RegNo Lookup Form switch new and old RegNo columns position
• Company Profile prompt re-login dialog when user change Country

 

SQL Accounting Latest Version (v846) Date : 01 April 2024

SQL Account 5.2024.981.846

Released on April 1, 2024

Release Notes

• Fixed Cust Multi - Invoice & Debit Note Listing - Level 1 (with other CNnOR Info) -
  Local OS Amount not shown when no Knock off Information
• Add SST Listing 1-SVE6 & SVE8 reports
• Fix Lazada editing sales invoice item's UOM incorrectly
• Add Shopee reverse shipping fee SST to sales credit note
• Fix EasyStore posted discount incorrectly
• Fix TikTok not posting non refund order with negative settlement amount incorrectly
• Fix TikTok shipping fee adjustment calculation in sales credit note
• #6857: SST-02A after apply prompt dynamic SQL error
• [Peppol-SG] Fix Sales Invoice/CN send peppol failed prompt Access Violation error and
  refine error message
• #6855: Asset disposal cost, accum depreciation, net book value are not updated after
  select an asset item
• [SST-MY] #6853: Opening SST Taxable in Past Invoice on 31/12/2023 should show 6%
  instead of 8%
• #6795: Maintain Customer & Supplier Listing report form should follow entry form's access
  right setting

 

SQL Accounting Latest Version (v845) Date : 15 March 2024

SQL Account 5.2024.980.845

Released on March 15, 2024

Release Notes

• Database upgrade to version 199
• #6832: Maintain Stock Item's browse grid show no responding when search on Barcode column
• Fix TikTok access token expiry check
• Include Shopee shipping fee SST in sales order and print order invoice
• Fix EasyStore calculated discount adjustment incorrectly
• Fix Shopee not including shipping fee SST in sales invoice
• TikTok fetch order date from payment file instead of calling API
• #6848: Import payment voucher or journal entry from SQL Payroll prompt error "Access Violation"
• #6826: Maintain GL Account and Opening Balance forms preview report prompt Access Violation error
• #6833: Maintain Stock Value preview report raise error "RTTI objects cannot be manually destroyed by application code"
• #6845: Sales Invoice Unit Price incorrect when Customer Price Tag Discount Field change from Null to empty
• #6841: TCommDevice PrintFromString and PrintFromBytes does not work in script
• #6839: SST IMSV Tax double entry not tally if change document date from Mar (8%) to Feb 2024 (6%)

SQL Accounting Latest Version (v844) Date : 07 March 2024

SQL Account 5.2024.979.844

Released on March 7, 2024

Release Notes

• Fix Invoke IBizApp.IsLogin prompt error "Catastrophic failure"
• Add Maybank cloud banking
• #6831: Document Entry forms click "Edit as New" button shouldn't remain 6% Tax Amt on March 2024
• #6834: Access violation in Show Chart
• #6829: SST tax code with Tax Inclusive by default will cause Tax Amt incorrect when Sales Order Date before 01 Mar & transfer to IV for Date after 01 Mar 2024
• Fix Incomplete captions of menu items under SST/GST menu
• #6820: SQL Power Search prompt "Could not convert variant of type (Null) into type (OleStr)" when tick a table to search

SQL Accounting Latest Version (v843) Date : 29 Feb 2024

SQL Account 5.2024.977.843

Released on February 29, 2024

Release Notes

• Database upgrade to version 198
• #3445: Job Order add Cancelled Date & Cancelled Qty
• Auto Select Bank for Giro bank info when BankID is selected and Giro is null
• #6806: Maintain Location default location should set default GL Stock Project for new database (db upgrade only)
• Convert Stock Received to FR3 format
• Recognize TikTok payment type "Deductions incurred by seller" as adjustment
• #5558: Serial Number Qty lookup labels at the bottom not display properly
• #6815: Create asset disposal prompt error "Problematic key value"

SQL Accounting Latest Version (v842) Date : 21 Feb 2024

SQL Account 5.2024.976.842

Released on February 21, 2024

Release Notes

• Database upgrade to version 197
• [SST-MY] #6779: Update new SST Tax Rate for Malaysia SST tax codes started 2023-03-01 (SV, SVA, SU, PSV, DTR)
• Disable AddToCart option
• Fix TikTok not posting ARIV for past invoice
• Fix Shopee return refund variance calculation
• [SST-MY] Maintain Tax display new SST tax rates according to industries (effective from 1st March 2024)
• Fixed Batch Print Sales Invoice 8 (SST 2) format tax rate not correctly shown
• #6810: System Calculate Bank Closing not calculate after apply
• #6812: Process SST Return raise access violation error when the IV (Tax: SV) have outstanding more than 1 year
• #6801: Weighted Average costing for Stock Transfer IN Qty UTD Cost should be 0 when UTD Qty <=0
• TikTok sales credit note doesn't add shipping fee adjustment correctly
• Use TikTok payment file "Related order ID" as order adjustment ID when payment type is "Order"
• #6806: Maintain Location default location should set default GL Stock Project for new database

SQL Accounting Latest Version (v841) Date : 15 Feb 2024

SQL Account 5.2024.974.841

Released on February 15, 2024

Release Notes

• Database upgrade to version 196
• Fix Shopee return refund variance calculation
• Add TikTok shipping fee subsidy to platform shipping fee discount adjustment calculation
• Add Shopee prorated coin value refund items to sales credit note and fix return refund variance calculation
• Add Shopee seller protection fee claim for reverse shipping fee in sales credit note
• Avoid posting TikTok platform shipping fee discount in credit note
• Add TikTok SFP service fee and transaction fee to credit note if sales invoice is knocked off with credit note
• Fix Shopee debug mode showing load file dialog instead of save file dialog when new debug file option is selected
• Skip checking for TikTok payment's order type when verifying post status
• Fix TikTok posted shipping fee adjustment incorrectly
• Add TikTok platform discount refund and actual return shipping fee to sales credit note for partial refund order
• Revise posting cancelled order to sales invoice
• Allow WooCommerce cancelled order to be posted as cancelled sales invoice
• Fix EasyStore not including additional discount in sales invoice
• Replace sales invoices in Shopee order section when verify status is "Replace"
• Fix Lazada does not knockoff sales invoice with reversal item price credit note properly
• Include UOM when looking for BOM sub item
• Fix Lazada edited sales invoice without adjusting Lazada Bonus - LZD co-fund
• Fix Lazada posted sales credit note incorrectly included Lazcoin discount
• Fix Lazada posted sales credit note incorrectly for order with payment fee only
• Fix TikTok posted sales credit note incorrectly for partial refund order
• #6697: Asset disposal by qty
• Add Qty column to FA_ITEM_PROJECT, FA_DI table; add FA_DI_PROJECT table; FA_DI table rename Project column to PaymentProject
• Add Sales Picking List (Barcode) format
• Add Sales Cash Sales 6 - Receipt-TM-U220 (SST)-With PM KO format
• Add Customer & Supplier SBank Details Request Form (E-Payment) format
• #6804: Continue pressing shortcut key on the a child form will trigger the action in other child form
• #6803: Asset disposal prompt error upon save if payment method is non-payment method GL code
• #6797: Maintain Stock Item, Customer & Supplier open Analysis code entry forms (e.g Stock Group, Agent, Area and etc) should check access right
• #6768: Asset item status date does not change after edit the asset disposal post date
• #6799: Show system conversion date value in the message "System conversion date in between depreciation date range"
• Fix Audit Trail Summary form Apply button position and form enlarge to 70% of monitor screen
• #6798: JV contains SV tax code is allowed to delete after process SST return
• #6775: A document type can utilize document number set of other document type
• #6794: Purchase Invoice, Cash Purchase & Returned Outstanding label incorrect when there are documents with same doc no
• Fix Asset item detail datasets scroll to last record upon save
• Fix Fixed asset test suite prompt duplicate GL account code 924-000
• #6778: Application prompt error "Conversion error from string" if windows region format is Thai
• [GST-SG] #6783: Singapore Maintain Tax display Tax Rate should be 9% instead of 8%
• #6746: Default value for DIY field is not working

SQL Accounting Latest Version (v840) Date : 29 Dec 2023

SQL Account 5.2023.973.840

Released on December 29, 2023

Release Notes

• Cater damaged parcel for TikTok order
• Fix Lazada edited sales invoice with unadjusted Lazada bonus amount
• Fix for fetch specific shop's products and orders
• Create credit note for Lazada order with damaged item while shipping
• Try to update alternative code if record inserted before
• Add adjusted coin discount to Shopee order's credit note
• Fix for e-commerce account form updated settings to incorrect shop when main account is used
• Fixed GL Cash Flow Statement 2 & 4 Columns format on export to excel title missing
• Fixed Asset Analysis (12 Months) - Group By Level 2 mapping dataset not correct
• Fixed error when description is using [] for SST Listing 3 report
• Fixed Sales Local - Invoice Collection Report not including Contra Amount
• #6764: Asset item depreciation schedule supports batch edit
• #6680: Import asset item through batch entry window prompt "Schedule total depreciation must be equal" error
• #6748: Asset analysis show zero disposal amount when filtered by asset group
• #6732: Add journal entry document number to asset depreciation process
• #6765: Open Depreciation Listing prompt "Access Violation" error

SQL Accounting Latest Version (v839) Date : 08 Dec 2023

SQL Account 5.2023.972.839

Released on December 08, 2023

Release Notes

• Database upgrade to version 195
• Feature #6749: GL Bank Reconciliation add Attachment field
• Feature #6752: Maintain Location add GL Stock Project field for auto post GL Stock value by project
• #6760: Maintain GL Stock Value prompt "Invalid Transaction Object" error when save
• #6757: AR/AP Deposit Entry once change the date from after conversion date to before conversion date the ledger transactions for detail records still exists
• #6762: Rich Text Editor multi select different rows with different font size and click font size combo box prompt "'' is not valid integer" error
• Fixed Cust-Multi-F1-12 Mths Statement-Jun 2004, May 2004....xml error when Batch Email
• Shopee fallback to individual order fetch when empty array is received from API endpoint
• Fix TikTok fetch order item's SKU info causes access violation on multi-thread execution
• TikTok allow ignore cipher when get request query
• Fix TikTok failed to post order with shipping fee only
• #6761: Stock Transfer open barcode form (F8) search by serial number prompt access violation error
• Feature #6738: SL/PH Yearly Sales Analysis add Item Desc 2, Remark 1 & Remark 2 grid columns
• #6734: GL P&L report Taxation account should be positive for debit side value
• #6759: Open GL Cash Book raise error "overflow error while converting a variant of type (Double) into Type (Currency)" due to a large value enter for bank charge
• #6758: AR/AP Deposit Entry Deposit Acc lookup should include Other Liabilities & Other Assets deposit accounts accordingly
• #6754: GL P&L Statement, Balance Sheet Statement and Trial Balance report should not auto update GL Stock Value if fall outside maintain acceptable trans date