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.2025.1021.866

Released on April 12, 2025

Release Notes

Update E-Invoice update as at 11 Apr 2025

SQL Account 5.2025.1020.865

Released on April 11, 2025

Release Notes

#7194: Show warning message for compulsory E-Invoice industry on consolidate
#7227: Conso and batch submit tick all should only tick filtered record
Feature #7218: Outstanding Job Order Listing report add detail Item lookup
#7224: Transfer Goods Received to Purchase Debit Note cause double Qty
Fix Maybank notification access violation when notification center not supported
#7223: Unable to Edit & Save if the IV is submitted with 5 cent rounding enabled
Feature #7221: Maintain Stock Item's Category support partial search and list matched result
#6679: Sales Profit Estimator with "Use Serial number Costing" option, retrieve wrong item's cost when the same serial number appeared under different itemcode

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

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

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