CONCEPT SOFTWARE SDN BHD

Friday, June 20, 2025

SQL Accounting Latest Version (v871) Date : 16 June 2025

 5.2025.1032.871

New Taxpayer QR Code autofill feature, Mobile Connect access right control & minor bug fixes. (871)

Features

  • Maintain Customer/Supplier: Now support reading MyInvois Taxpayer QR Code to fill in taxpayer info under Tax tab. (Only work in Production)

Updates

  • MyInvois (E-Invoice MY): E-Invoice implementation timeline update for 2025-06-05 changes
  • Mobile Connect: Add Access Right control on Browse and Entry form
  • GL Bank Recon: Add Description2 grid column

Bug Fixes

  • E-Invoice implementation phase 5 description update
  • Fixed Purchase Invoice 8 (SST 1) caption not correct
  • Fixed Sales Local - Invoice Collection Report - Level 1 SubTotal Description not correctly shown

SQL Accounting Latest Version (v870) Date : 07 June 2025

5.2025.1031.870

New features (Chatbot, Helpdesk, Whatsapp Scan, Clipboard Import), improved e-Invoice handling, enhanced integrations, and important bug fixes. (870)

Database

  • Database upgraded to version 213

Features


Updates

  • MyInvois (E-Invoice MY): E-Invoice implementation timeline update for 2025-06-05 changes
  • MyInvois (E-Invoice MY): Consolidation of documents over RM10,000 will prompt warning
  • MyInvois (E-Invoice MY): Show Consolidate No. on browse screen for CN & DN
  • MyInvois (E-Invoice MY): Added E-Invoice Validation QR for Cash Sales 6 - Receipt-TM-U220
  • AR CN: Optmized AR Credit Note editing for better performance
  • E-Commerce(Lazada): Knockoff Lazada sales invoices with sales credit note for returned orders

Bug Fixes

  • Fix Shopee posted same final shipping fee charge in both sales invoice and sales credit note
  • Fix access violation when submitting new document through Peppol (SG)

 

SQL Accounting Latest Version (v869) Date : 29 May 2025

5.2025.1027.869

New delivery performance reports, enhanced e-Invoice handling, improved e-Commerce integration, and key bug fixes across the board. (869)

Database

  • Database upgraded to version 212

Features

  • New Reports:
    • Sales Outstanding SO - Delivery Performance
    • Purchase Outstanding PO - Delivery Performance
  • Module Control: Enable Customer or Supplier features based on whether the Sales or Purchase module is available
  • Sales Debit/Credit Notes: Added 5 Cents Rounding options for Sales DN & CN under Tools | Option | Customer
  • Sales S/N Profit Loss by Document: Add Use Last Serial No. Doc Unit Cost option
  • Mobile Connect: Added support for Mobile Connect setup in application

Updates

  • MyInvois (E-Invoice MY):
    • Now supports joining multiple Permit Numbers in document details
    • MyInvois import now replaces UUID only when the document already exists
    • E-Invoice submission now uses the billing email instead of delivery branch email
    • New currency ISO Code CNH
    • Classification field is now excluded during transfer from SO to PO
    • E-Invoice now submit tax exemption reason with combination of tax exemption no & reason
  • E-Commerce(WooCommerce):
    • Now uses preemptive authentication for better compatibility
    • IRBM classification set to "008"
  • E-Commerce(Lazada):
    • Improved calculation of item price adjustments and handling of refund sales
    • Sales CN now posted during payment instead of on return
    • Payment posting date adjustment
  • E-Commerce(Shopee): Enhanced logic for voucher offset returns and coins offset in Sales Credit Note posting
  • Maintain Tax: Renamed "General Tax - (Tourism Tax)" to "General Tax - (Purchase Tourism Tax)"

Bug Fixes

  • MyInvois (E-Invoice MY): Fixed access violation error when clicking "Next" on Consolidate E-Invoice from Cash Book
  • MyInvois (E-Invoice MY): Fixed DocNo filter not working in Consolidate E-Invoice
  • E-Commerce(Lazada): Fixed Lazada missing promotional charges vouchers on negative settlement orders
  • E-Commerce(Shopee): Fixed incorrect assignment when multiple same items exist in an order
  • Resolved error when saving sales document with initial purchase cost and qty > 0
  • Fixed issue where Unit Price became 0 due to 3-decimal Max Cost/Price settings and missing user rights
  • Corrected issue with unit cost value increasing when reference cost and stock transaction are missing
  • Fixed incorrect TaxRate in destination documents when partially transferred with Tax Inclusive enabled
  • Prevented access to Stock Month End Balance report S/N view for users without S/N module rights
  • Fixed missing pipeline value in AP Bill & Payment Analysis report Document_CompanyBranch
  • Sales document entries click on Profit Estimator button prompt Access Violation error
  • Fixed Customer payment uses invalid default payment method if supplier deposit is the first record in payment method
  • Fixed a bug where creating a Sales Point document appends a record with year 1899 to the document number set when it is configured with monthly reset frequency

 

SQL Accounting Latest Version (v868) Date : 16 May 2025

 5.2025.1023.868

Database upgrade to version 211 with new MyInvois CN & DN consolidation, SG GST InvoiceNow, customer/supplier info request, and key bug fixes. (868)

Database

  • Database upgraded to version 211

Features

  • Maintain Customer & Supplier: Added "Info Request" action
  • MyInvois (E-Invoice) MY: Support Credit Note & Debit Note Consolidate Submission
  • InvoiceNow SG: Support GST InvoiceNow
  • Access Rights: Added MyInvois group

Bug Fixes

  • InvoiceNow SG: Fixed duplicate item details when sender code is empty during import
  • GST SG: Fixed invalid TaxRefNo on GST F5 submission
  • E-Commerce: Adjusted Lazada load payment file paid status checking
  • Fixed Access Violation error when using "Update Cost" in Stock Documents Entry with Serial Number Costing
  • Fixed application crash when sorting "Transfer Qty" column in Job Order transfer from Sales Order

    5.2025.1023.868

    Database upgrade to version 211 with new MyInvois CN & DN consolidation, SG GST InvoiceNow, customer/supplier info request, and key bug fixes. (868)

    Database

    • Database upgraded to version 211

    Features

    • Maintain Customer & Supplier: Added "Info Request" action
    • MyInvois (E-Invoice) MY: Support Credit Note & Debit Note Consolidate Submission
    • InvoiceNow SG: Support GST InvoiceNow
    • Access Rights: Added MyInvois group

    Bug Fixes

    • InvoiceNow SG: Fixed duplicate item details when sender code is empty during import
    • GST SG: Fixed invalid TaxRefNo on GST F5 submission
    • E-Commerce: Adjusted Lazada load payment file paid status checking
    • Fixed Access Violation error when using "Update Cost" in Stock Documents Entry with Serial Number Costing
    • Fixed application crash when sorting "Transfer Qty" column in Job Order transfer from Sales Order

Saturday, April 26, 2025

SQL Accounting Latest Version (v867) Date : 23 April 2025

 

SQL Account 5.2025.1022.867

Released on April 23, 2025
Release Notes
  • Fix cant get details when only have one record and refactor MyInvois import
  • Ignore return refund variance in sales credit note for Shopee partial return order
  • Include Shopee shipping fee SST in return refund variance calculation
  • Include TikTok shipping cost to platform shipping fee discount adjustment
  • #7232: AR/AP Due Document Listing report's Document_Company pipeline is empty when master record having negative outstanding amount
  • #7233: Sales/Purchase Price History Grid add e-Invoice columns
  • #7240: GL Bank Recon Listing Recon Date column not sorting correctly
  • Update Cust/Supp 06 Months Aging-GainLoss Posting Account to New Option CXGainAccount_Unrealised & CXLossAccount_Unrealised
  • #7236: GL Balance Sheet drill down to Ledger report the Date From parameter should have value
  • Feature #6434: GL Foreign Bank Adjustment Bank Revalue should post to Unrealised Foreign Exchange Gain/Loss accounts instead of Realised (in Tools | Options | GL)
  • [Peppol-SG] Fix empty company name and unable to get customer code when import

SQL Accounting Latest Version (v866) Date : 12 April 2025

 

SQL Account 5.2025.1021.866

Released on April 12, 2025
Release Notes
  • Update E-Invoice update as at 11 Apr 2025

Saturday, April 5, 2025

SQL Accounting Latest Version (v865) Date : 28 Mar 2025

 

SQL Account 5.2025.1019.865

Released on March 28, 2025
Release Notes
  • [EIV-MY] Change MyInvois Request caption to E-Invoice Request
  • #7204: Show FromDoc at Browse Screen for CN, DN, SC, SD and CB
  • #6306: GL Balance Sheet report consolidate tick Display Trade debtor and creditor raise assertion error when report's account level set lower than control account's level. Revise to more friendly error message
  • [EIV-MY] #7210: Include unsubmitted E-Invoices option missing at batch consolidate
  • [EIV-MY] Bug #7196: Consolidate E-Invoice prompt access violation if click next without selecting document
  • #6045: Stock Reorder Advice report should show Reorder Level, Reorder Qty, Min/max Qty grid columns by default
  • #5788: GL Profit & Loss statement report if Project code in chinese will cause incorrect amount for the Project column in Print Project Comparison
  • #6236: Maintain Stock Item Matrix prompt warning message when row/columns contain duplicate values
  • Fix entry forms Matrix Profile label position
  • #6207: SL/PH Analysis By Document report when filter Company Category and tick "Include Zero Balance" should only show company that match with the filtering only
  • #6229: SL/PH Analysis by Document allow to view the Available Stock Balance
  • Feature #6567: Stock BOM Material Usage report add Print Active/Inactive Material & Product Item checkboxes
  • Fix TikTok prompt access violation during order verification process
  • Fix Shopee posted return refund variance in sales credit note incorrectly
  • Adjustment to Shopee payment file loading dialog message
  • Fix Shopee posted return refund variance in sales credit note incorrectly
  • Fix TikTok not posting additional actual shipping fee charge sales invoice
  • [EIV-MY] #7216: Remove locking on TaxExemptNo that is not submitted to MyInvois
  • [EIV-MY] #7217: MyInvois Config form copy intermediary info does not work
  • #7215: Stock Month End Balance Report apply prompt assertion error when having large amount for GL Balance Sheet Stock
  • #6406: Production Document Transfer dialog add checkbox indicator and auto fill in Transfer Qty when focused record changed
  • Feature #6386: SL/PH Document Listing add new columns Filter Total & Local Filter Total
  • #6445: Maintain Document Number deleting record should prompt error when Maintain Payment Method OR/PV Document Set referring to it
  • #6604: SL/PH Analysis by Document & Yearly Analysis reports add Stock Category Description
  • [EIV-MY] Show LHDN QR in report only for valid status
  • [EIV-MY] Prompt password dialog for report to include LHDN QR in sandbox environment
  • [EIV - MY] #7205: Consolidate CN submission failed when ID Type and ID No blank using General Public's TIN
  • #7201: Revise AR/AP Deposit Refund form labels caption
  • #6740: Stock Physical Worksheet Report support View Price Tag
  • #6789: Outstanding SL/PH Document Listing report default parameter change to SO / PO
  • Feature #7197: Maintain Account support auto create Accumulate Depreciation Account
  • #6959: Sales Invoice transfer from Delivery Order after clearing customer code, the document transfer window will show all transfered/untransfered items incorrectly
  • [EIV-MY] #7199: BRN with space cannot be input into the field
  • [EIV-MY] Revise MyInvois single import to new or edit record without save to database
  • [EIV-MY] Remove serial number from MyInvois import
  • Adjustment to Lazada sales invoice editing
  • Add TikTok affiliate partner commission to sales invoice
  • Set Lazada payment reference ID to weekly reference ID
  • [EIV-MY] #7190: Connect MyInvois should prompt error message instead of disabled in edit state
  • Change Check E-Invoice Status caption to Refresh E-Invoice Status
  • #7191: Sales S/N Profit & Loss By Document has duplicate records if have same DocKey & Detail Key in different document type

Tuesday, March 4, 2025

SQL Accounting Latest Version (v864) Date : 28 Feb 2025

 

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

Friday, January 17, 2025

SQL Accounting Latest Version (v863) Date : 07 Jan 2025

 

SQL Account 5.2025.1016.863

Released on January 7, 2025
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
  • Database upgrade to version 209
  • Fixed Stock Card Qty preview generate unlimited page
  • #7144: AP & PH Document Listing detail duplicate if have same DocNo for diff supplier and filter this duplicate DocNo in report
  • Fixed Shopee not posting shipping fee correctly for order with return item
  • [EIV-MY] raise exception when edit and delete Request E-Invoice
  • Database upgrade 207 add Progress Text Dialog for Convert Bool Script
  • Bug: Database upgrade 207 progress bar not updating
  • [EIV-MY] #7139: SL Invoice, Cash Sales, DN & CN upon save should only prompt TIN checking dialog for production environment and Doc Date > MyInvois StartDate
  • #7140: Database upgrade 207 prompt unicode character mapping error
  • Bug #7138: Access through COM should not prompt E-Invoice reminder
  • #7137: Stock Batch Item Lookup add "Show Qty > 0" option
  • Fix Lazada not posting promotional charges flexi-combo fees to sales invoices
  • Adjustment to Lazada voucher seller amount

Tuesday, December 31, 2024

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