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

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.

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.

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 .

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

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

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?

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

SQL Account Releases

SQL Account 5.2024.1016.863

Released on January 7, 2025

Release Notes

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

SQL Account 5.2024.1014.862

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 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 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 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 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)

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 Accounting Software

Average Rating: 4.9 / 5.0 (524 reviews)

We are the Number 1 accounting software in South East Asia use by more than 270,000 companies!