Best Accounting Software for Small Business | SQL Account HQ

SQL Account - Your Ideal Business Software

SQL Account is suitable for both small businesses and large organization in both on-premise and online accounting software. choose what’s best for the workflow of your accountant and bookkeepers.


SQL Account - your Ideal Accounting Software

Check out why more than 270,000 companies trusted SQL Account.

SQL Account enhances workplace performance, reduces human error, and maximizes profits through our stable, dependable, and developed software functionalities.

Our system’s wide range of functions includes data collection and analysis, accurate reporting formats, inventory maintenance, and SST processing.

When you choose SQL Accounting software, you will also receive an abundance of online resources to support your journey in using this system. Regardless if it’s an on-premise or cloud accounting software, SQL Account is the best. If that’s not enough, we conduct unlimited hands-on free accounting software training in our HQ.

SQL Account Features

General Ledger

It’s easy to manage and track your company’s accounting records

Customer

Keep your customers in touch

Supplier

Manage and keep your supply chain in check

Sales

More time. For Sales.

Purchase

Be cost effective.

Stock

Helps take control of your inventory effortlessly

sql accounting software whatsapp integration

Whatsapp Integration with All Document

Step it up by using Whatsapp to send your business documents!  SQL Account is the first accounting software integrated with Whatsapp feature, now you can send Quotation, Invoice, Statement of account and many more documents to your clients via Whatsapp with a few simple clicks.

Exclusive partnership with CTOS Malaysia

SQL Accounting is the only accounting software that is linked to CTOS Malaysia services. More than 270,000 SQL users are able to directly access CTOS’s full credit reports. With CTOS full credit reports, SQL users have access to see the few year’s financial performances, blacklist history, and trade history through SQL Accounting software.
 
This crucial information will help businesses to make the best well-informed decision before agreeing to any business arrangements. Protect your business with CTOS.
number one accounting software integrated with ctos

Automate bank reconciliation & bank feeds

Perform automated bank reconciliation with SQL Account. There is NO need to reconcile each transaction manually.  SQL Account’s auto bank recon feature is available for more than 20 Malaysian banks. Through AI matching, SQL’s system will match every transaction in your system with the transactions with your bank. You can also immediately create OR/PV for any unmatched transactions with the bank easily. Save time and speed up productivity with SQL Account.

Flexible Unlimited User Defined Fields

SQL Account is the best accounting software can cater from small business to large organisation. SQL Account has user defined fields that can be easily altered and customized.  With user defined fields, you can create the perfect document that suit your business size and workflow.

Click “Learn More” to see SQL special industries.
sql accounting software customizable field
sql accounting software sales report

Salesman Commission Reports

SQL Account supports a variety of commission calculation. We calculate partial-payment commission, profit-margin based commission, and we also support multiple commission rates based on stock groups and agents.

Advance security

SQL Accounting provides the best options when it comes to data privacy. You can have double layer access control on what they can do on SQL Accounting. For example, users whom you granted them access right in cash book entry for recording expenses transactions, but you also wish to “hide of” transactions with sensitive keyword , like ‘Director fees’ or ‘bonus’ etc from them.

By assigning advance security transactions exclusions to your users, you can ensure data confidentiality which only uniquely found in SQL accounting .

sql accounting software security
sql accounting software training

Unlimited monthly free training and Responsive support team

No worries if you are unfamiliar with our system! We provide free accounting software training every month. Contact us to find out more! Our technical support team is fully trained and equipped to assist you via phone, email, and remote access.

Other Must Have Features
Effective Inventory Management
SQL Account
Features
Inventory management is indeed a critical aspect of business profitability. Here are some tips to strike a balance between overstocking and understock...
Multiple Branches Control
SQL Account
Features
It is difficult for business with multi branches and retail stores to manage their combined transactions. With SQL, you can efficiently control branch...
What is Hire Purchase Loan?
SQL Account
Education
Features
Popular
A hire purchase loan is a type of monthly instalment plan you can use to purchase an asset, which will require the buyer to make an initial down payme...

Featured Video

Send Inquiry

Try it for free!

Download brochure

Learn more about SQL Account

User Guide

Account User Guide

Learn how to use and master SQL Account with step-by-step guide
Read the guides

Help Video

Account Help Video

Watch & learn new SQL Account skills you can use today
Watch the videos

Release Notes

SQL Account Releases

Read all current and past software build releases
View all releases

SQL Account Releases

SQL Account 5.2024.1000.857

Released on October 30, 2024
Release Notes
  • #7043: [EIV-MY] Add UUID and LongID in browse and detail mode
  • Fix TikTok not posting cancelled sales invoice
  • Shopee include payment wallet adjustment into order's sales invoice / credit note
  • [WebApp] #7047: Sales document detail added FromDocNo field
  • #7034: Submit a Sales Credit Note referencing a consolidated invoice return error "Identification number is not valid - Buyer"
  • Fixed Access violation when switch storage type for attachments in Cash Book
  • #7053: Consolidate E-Invoice prompt error "is not a valid integer value" if the document number exceed Int64 max value
  • #7050: PostCode change in code should not prompt City and State replace
  • #7048: Maintain GL Stock Value shouldn't allow negative amount
  • #7045: e-Invoice submission buyer and supplier address contain duplicated postcode, city, state and country
  • #7042: SL/PH e-Invoice submission should exclude non-printable and zero amount detail records

SQL Account 5.2024.999.856

Released on October 11, 2024
Release Notes
  • #6903: Mobile Connect - Stock Inquiry add Document Number under Price History
  • Adjustment to TikTok order posting
  • Allow post TikTok order's sales quotation
  • WooCommerce show problematic product info in exception message
  • Posted TikTok settlement's sale price incorrectly to invoices and credit note, and skip posting invoice for adjustment only settlement records
  • WooCommerce displayed number of products fetched incorrectly
  • Adjustment to Shopee return refund variance calculation
  • Incorrectly labeled TikTok order settlement as additional shipping fee charges
  • Adjustment to Shopee prorated return items and coin discount calculation for sales credit note
  • Only allow posting sales invoice for TikTok order with status delivered or completed
  • Add E-Invoice QR for GL Official Receipt format
  • Add Sales Invoice 13 (E-IV v1.1) format
  • Add E-Invoice QR for GL Payment Voucher format
  • Fixed Stock Transfer SerialNumber information not correctly link...
  • Fixed SST-02 (20240301) 11C field should shown zero if not value
  • #7036: Paste Purchase Invoice document doesn't exclude IRBM_InternalID field value
  • #7035: Consolidated sales invoice document contains multi lines, despite the invoice document numbers being consecutive
  • #7032: Submitted document should not allow tick cancelled
  • #7026: SL/PH Invoice shouldn't allow transfer to Extra DO/GR if users no purchase Extra DO module
  • #7023: Cash Sales set Form Mode with Split Browse & Detail raise error when click New
  • #7021: Submit E-Invoice raise Dynamic SQL Error if from doc select document from customer invoice
  • #7022: Batch Submit and Consolidate can't load records with NULL IRBM_Status
  • #7018: AR/AP Refund Entry form, if tick Cancelled no need to prompt error for foreign unapplied amt upon save
  • GL Cash Book data module missing IRBM_INTERNALID field
  • Consolidated Self-Billed change to Self-Billed SubmissionType & imported documents SubmissionType did not change to None
  • SL/PH More panel support delivery postcode logic
  • #6989: Stock Qty Control Dialog add Reorder Level and Reorder Qty columns
  • #6777: Stock Month End Balance report Update GL Stock Value's New value incorrect rounding if compare with Total UTD Cost in the main grid
  • #7014: Company Profile click search Reg. No. prompt access violation error if Country is blank
  • #6956: GST SG Process prompt string truncation error if GL Cash Book Description more then 200
  • #7011: Paste Asset Item record does not exclude Code value
  • #7010: Refresh Open Depreciation form after process Depreciation
  • #7009: Unable to save the Cashbook Entry and prompt the record has been changed by other user error

SQL Account 5.2024.996.855

Released on September 9, 2024
Release Notes
  • Database upgrade to version 205
  • [General] Note will prompt Dataset Not in Edit mode
  • [General] Fix Values in the first grid column are empty on the Cancel Consolidated Invoice form
  • [General] Process SST return raise Error : Arithmetic Exception, numeric overflow, or string truncation string right truncation expected length 300, actual 311
  • [General] Duplicate DN document number in item flow where DN transferred from DO
  • [General] Fix GL Cash Book company name should visible for Malaysia only
  • [General] Cash Sales & Cash Purchase entry didn't follow the default Journal set in Tool | Options
  • [General] Fix SST-02 (20240301) not include SUV
  • [General] SL/PH document entries Batch should allow to edit although it has been transferred to other documents
  • [General] SL/PH Debit Note shouldn't prompt Qty Control dialog if transfered from DO/GR
  • [General] Show invoice currency code instead of currency ISO code on Consolidate Invoice form
  • [General] Stock Aging add "Exclude Stock Transfer Date" option, stock age follow original receive date regardless stock transfer date
  • [General] SL/PH Outstanding Listing reports add Permit Number field
  • [EIV-MY] Import: Tax Rate Not Reflected When Selecting Tax Code PSV
  • [EIV-MY] Check document size
  • [EIV-MY] GL Cash Book support e-Invoice
  • [EIV-MY] Add Batch Submit for GL Cash Book
  • [EIV-MY] Add batch submit e-invoice
  • [EIV-MY] Add batch check e-invoice status
  • [EIV-MY] Cancelled Document should not allow to submit e-iv
  • [EIV-MY] Fix Incorrect Malaysia country related control visibility
  • [EIV-MY] Fix submit e-Invoice prompt error "TIN and identity type combination is invalid" when only TIN provided but ID Type is none
  • [EIV-MY] Maintain Supplier, SL/PH Document entries allow user to clear detail Classification code
  • [EIV-MY] Submited E-IV with cancelled status after Edit SUBMISSIONTYPE to None can't change back
  • [EIV-MY] Submit DN/CN where FromDoc field reference consolidated invoice return the error "The reference document UUID doesn't exist"
  • [EIV-MY] Add batch consolidate invoice
  • [EIV-MY] Sales invoice submission type is not set to Consolidate after upgrade database version from 203 if the sales invoice was already submitted as a consolidate invoice
  • [E-Commerce] Increase Lazada product fetch limit and wait for 2 seconds before retry failed request
  • [E-Commerce] Adjustment to Shopee adjusted coin discount calculation
  • [E-Commerce] Show Shopee voucher and coin in Ecommerce Invoice 3 report
  • [E-Commerce] Fix Shopee not posting return refund variance adjustment in sales credit note
  • [E-Commerce] Check return quantity for posting Shopee order's credit note
  • [E-Commerce] Shopee add product protection payment to buyer view sales invoice
  • [E-Commerce] Adjustment to Shopee buyer view sales invoice data
  • [E-Commerce] Adjustment to TikTok customer paid shipping fee refund logic
  • [E-Commerce] Skip TikTok platform discount refund in sales credit note
  • [E-Commerce] TikTok showed seller discount incorrectly in buyer view sales invoice
  • [E-Commerce] "Rowindex Out of Range" Prompt After Searching Non-Mapped Item Code in TikTok Product Tab

SQL Account 5.2024.992.854

Released on August 8, 2024
Release Notes
  • Database upgrade to version 204
  • Allow edit for PH except self-billed
  • Remove import from cloud menu & revise import form UI
  • Solve assertion when import and revise UI
  • Fix TikTok does not post additional actual shipping fee credit note document
  • #6950: SL/PH documents submission type default to E-Invoice if company profile country is MY
  • SL/PH document entries support auto fill up City & State after postcode entered
  • Submit E-Invoice is only applicable when the document submission type is MyInvois
  • #6951: SL/PH document entry forms if customer has TIN but TIN lookup return empty shouldn't prompt Replace TIN dialog
  • #6948: Sales Credit Note submit prompt error "Reference Document is missing"
  • #6943: Maintain Customer change IDType from BRN to NRIC and back to BRN will cause application clashed stack overflow error
  • #6942: SL/PH Debit Note missing View Item Flow

SQL Account 5.2024.991.853

Released on August 5, 2024
Release Notes
  • Database upgrade to version 203
  • Add invoice upload and downlaod action for SL/PH documents
  • [EIV-MY] Consolidate self-billed invoice
  • [EIV-MY] Add IRBM_InternalID column to PH_PI, PH_CP tables
  • SL/PH More panel support auto assign TIN and TIN drop down values
  • [EIV-MY] Add SandBox watermark form
  • [EIV-MY] Revise MyInvois API calling method
  • [EIV-MY] Revise import form GetRecentDocuments & validation url
  • [EIV-MY] Add MyInvois config form & Sandbox UI
  • [EIV-MY] Add IRBM Env field
  • [EIV-MY] Revise Consolidate UI
  • [EIV-MY] Consolidate IV support check status
  • [EIV-MY] Check Status add EIV log
  • [EIV-MY] Revise MyInvois operation exception message
  • [EIV-MY] Revise Check Status Form UI
  • [EIV-MY] Adjustment on Status Icon
  • [EIV-MY] Change AddToEIVTable function to class TMyInvoisEIV
  • Add support submission type - None, MyInvois, MyInvois Consolidate
  • [EIV-MY] SL/PH document entries added SubmissionType field
  • [EIV-MY] SL/PH data modules added SubmissionType field
  • [EIV-MY] SL/PH tables add SubmissionType column
  • Remove Classification field from Maintain Customer entry form
  • #5539: Application crashed when filter by account in Maintain Budget form
  • Adjustment to TikTok customer paid shipping fee refund check
  • Add TikTok customer paid shipping fee refund value in order record
  • #6902: Open Stock Card prompt VCLTee error in Win64 platform
  • #6919: Stock Transfer entry form add Customer Item detail grid column
  • [Peppol-SG] Revise BuyerReference when export to sg gov
  • #6934: Submit e-Invoice if postcode unable to locate state code will raise error "State is required - Buyer" even State has been manual entered by user
  • #6927: GL Receipt & Payment report when filter Payment Method shouldn't show Bank Charge transaction for bank account in GL Cash Book Detail as the Bank Charge belong to Cash Book master's Payment Method
  • Fixed Profit & Loss with Cash Flow export to Excel some field is empty
  • #6930: Consolidated invoices doesn't exclude cancelled invoices
  • #6929: Maintain Customer/Supplier & Item classification code should empty
  • Ignore duplicated payment record for in Shopee payment file
  • Post TikTok sales credit note for non cancelled order if actual return shipping fee exists
  • Adjustment to Shopee return refund variance calculation
  • Adjustment to Shopee prorated shopee voucher offset return value in credit note
  • Fix TikTok not knock off invoice with edited credit note
  • Do not knockoff credit note with invoice if credit note amount is 0
  • Adjustment to Shopee prorated seller voucher offset return value in credit note and skip adding return refund variance when refund amount is same as returned item amount
  • Use assigned working date for calculate stock take instead of current session's working date
  • Add TikTok ads top up as adjustment
  • Resize SL/PH More Panel
  • #6915: Tax codes are deleted and SL/PH documents tax codes are cleared after changing profile country
  • [EIV-MY] Single Send e-Invoice doc set City & State to NA
  • [EIV-MY] Add c_MyInvoisStatusIcons & Apply ImageList to ImageComboBox for Import form
  • #6925: MyInvois invoice document subtotal and total discount are incorrect if the source document detail has a discount rate of 100%
  • Block document editing and deletion if the document has already been submitted to MyInvois portal
  • #6923: Maintain Supplier's TIN click to send WhatsApp, prompt "Please enter mobile no" error even the mobile no. has value entered
  • #6881: Stock Reorder Advice - Double Click to drill down to outstanding PO/SO/JO
  • #6852: Print BOM Material Usage add drill down for BOM Item
  • #6907: GST/SST Taxable button enabled only when entry form in browse mode
  • #5578: Create DIY Quick Form Template prompt access violation error due to core commit 8a271e6d
  • #6900: Edit Sales Invoice with 2 detail records (post to AR Invoice), Audit Trail has last edited detail record log only
  • #6904: Stock Physical Worksheet's report JO Qty should include Cancelled Qty. Production Outstanding Job Order Listing Transfer Qty & Outstanding Qty incorrect when transaction is not base UOM

SQL Account 5.2024.990.852

Released on July 23, 2024
Release Notes
  • Add E-IV QR with Link for FR3
  • Remove previously posted other fees in posted TikTok credit note when editing sales credit note
  • Includes TikTok additional platform shipping fee discount into platform discount refund check
  • Fix Shopee adjustment posting doesn't check whether document has been posted
  • Bug: Incorrect country related control visibility
  • Bug: Company profile always show MyInvois tab
  • [EIV-MY] Fix preview Sales Invoice prompt sql error when profile country is blank and Revise MyInvois credential and environment code
  • Fix bug: Maintain Customer prompt access violation error if Company Profile Country is not set
  • Database upgrade to version 202
  • [EIV-MY] Add Malaysia MyInvois
  • [EIV-MY] MyInvois add access right for submit, cancel and reject
  • Prompt warning message if user modifies a document that has already been submitted to MyInvois Portal
  • [EIV-MY] Add EIV Import to Purchase Invoice
  • [EIV-MY] Add EIV Countdown to SL UI
  • Revise More Panel to Vertical Grid
  • Others UI with address field add PostCode, City, State & Country
  • [EIV-MY] PH UI add e-Invoice fields
  • [EIV-MY] SL UI add e-Invoice fields
  • Add MyInvois QRCode to report
  • Add Consolidate IV form
  • Add IV consolidator and testcase
  • [EIV-MY] Add MyInvois check e-Invoice status action
  • [EIV-MY] Add MyInvois view action
  • [EIV-MY] Add single MyInvois document cancel
  • [EIV-MY] Add single MyInvois document reject
  • [EIV-MY] SL/PH Invoice, Cash Sales, DN & CN reports Main dataset add Validation Link url
  • [EIV-MY] Add single MyInvois document submission for SL/PH IV, CS, DN & CN
  • Get info actions add e-Invoice fields
  • Others BO with address field add PostCode, City, State & Country
  • Others datamodule with address field add PostCode, City, State & Country
  • [EIV-MY] Document Transfer exclude e-Invoice fields
  • [EIV-MY] PH datamodule add e-Invoice fields
  • [EIV-MY] SL datamodule add e-Invoice fields. Revise dmaACCompany
  • [EIV-MY] Add general TIN to TTIN_UI
  • [EIV-MY] Maintain Supplier add SIC, IRBM_SelfBilled and IRBM_Classification, Maintain Customer add IRBM_Classification
  • GST Audit will output full country name based on country code
  • Convert GL Cash Book & Journal country from 50 to 2 characters
  • DB init and sample add currency ISO code
  • Maintain Currency add ISO Code
  • Purchase Debit Note UI add FromDoc field
  • [EIV-MY] SL/PH add e-Invoice fields. Tables with address field have PostCode, City, State & Country added. Maintain Customer & Supplier table add SIC.
  • [EIV-MY] Company Profile support IRBM Client ID & Secret and Test Intermediary
  • [EIV-MY] Add IRBM Client Secret 2 field
  • [Peppol-SG] Add Purchase Order, Invoice Response, Peppol Log (EIV) and revise UBL format
  • [Peppol-SG] Add Invoice Response for Purchase Invoice & Peppol Log form for both SL/PH Invoice & CN
  • [Peppol-SG] Add Purchase Order Export & Import
  • [Peppol-SG] Import to non GST company
  • [Peppol-SG] Add splitter in import form
  • [Peppol-SG] Tax rounding for item and document
  • [Peppol-SG] Add EIV Payload SG Tester class and testcase
  • Add EIV Payload Tester class
  • [Peppol-SG] Define EIV Peppol SG Constants
  • [Peppol-SG] Refactor Peppol Send logic
  • [Peppol-SG] Move all Peppol units to Peppol folder
  • [Peppol-SG] Revise Peppol Import coding
  • [Peppol-SG] Revise IV & CN Export Address Condition
  • [Peppol-SG] Peppol Send IV/CN Client Reference GUID ommitted dash symbols
  • [Peppol-SG] Move Peppol Import to Cloud menu
  • Fix posted TikTok adjustment document number not displayed in grid
  • Post TikTok platform commission adjustment as separate document
  • Post TikTok transaction fee adjustment as separate document
  • Adjustment to TikTok platform discount refund and reduction on platform shipping fee discount checking
  • Apply item code and UOM changes across fetched order items with same item ID
  • Update product map if item ID exists in alternative barcode
  • Fetch "View By" column value in Shopee payment file to check whether the record is order payment or SKU details
  • Fix #6913: [GST-SG] Submitted date display incorrectly with UTC timestamp
  • [EIV-MY] Batch TIN Update form officially perform actual TIN update
  • Check Shopee payment Excel file's adjustment reason column is not empty before getting the string value
  • Skip TikTok order date column for old excel payment file
  • #6901: Maintain Item Advance Search (CTRL+F) missing Search Field for Price tag
  • Close Cash Book Entry prompt access violation when no internet connection
  • #6898: Maintain Agent - Wrong function for attachment

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 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 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 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 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 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 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 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 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 Software
Average Rating: 4.9 / 5.0 (524 reviews)

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info

SQL Account & SQL Payroll - Number 1 Accounting Software
We are the Number 1 accounting software in South East Asia use by more than 270,000 companies!