fbpx

Dream Big, Count Smart,
Ignite Your Finances
With

SQL ACCOUNTING SOFTWARE


3

Accounting Software

SQL ACCOUNTING

SQL Financial Accounting or SQL Accounting is designed to deliver business-critical functionality to large deployments of network environments. At its core lies a robust client-server architecture that allows significant advantages in flexibility, reliability, performance, and stability. Self-tuning features include cost-based query optimization and dynamic re-balancing of report structures, which enhance performance and provide a wide range of business reports. More importantly, SQL Financial Accounting is an open-period solution that enables you to collect more data over a wider time frame for better decision-base analysis.

Why choose SQL Accounting ?

PERFORMANCE

Software Architecture designed for network environment, serving even up to 100 users in one network, with system speed maintain.

STABILITY

In event of power, network or hardware failure, incomplete transactions are automatically ‘rolled back’.

DATA INTEGRITY

Data never loss between linked modules when performing data posting action. Data integrity is always guaranteed.

SPEED OF DATA ACCESS

The server utility only sends what is needed to the workstations (eg. Specific customer and date), whereas a file based (basic database) will send ALL invoices.

Feature

Built In Features

  • Open Period, auto calculation of b/f figures to provide yearly comparative reports. (No year end)
  • Budget, multi time intervals (monthly, quarterly, half-yearly and yearly)
  • Export to external file format : Text file, MS Word, MS Excel, Lotus, Quattro pro, PDF, JPEG, HTML, XHTML & etc.)
  • Unlimited level of Sub Account
  • Simple drill down to source document.
  • Copy & paste on document level and detail records.
  • External file tracking (fax, email, letter & etc).
  • Unlimited customer shipping / branch address.
  • Post dated cheque report.
  • SQL Power Search. (search anything anywhere)
  • Built in Report Builder ( customise printing format ie. Invoice & etc ).

Interested?

Try it, it’s free.

Plans & Pricing

SQL ACCOUNTING PRICING

Have something more custom in mind? Get A Quote

COMPARISON

SBE & PRO

Module

SBE

PRO

Category 1 : Core

General Ledger, Customer, Supplier

\

\

Sales, Purchase

\

\

Stock

\

\

Category 2 : Accounting

Basic Currency

\

Project Departmental t

\

\

Advance Credit Control

\

Multiple Document Number Set t

\

GST / VAT

\

\

Royal Malaysian Customs Department GST No Lookup

\

\

Category 3 : Sales / Purchase

Profit Estimator t

\

\

Deposit t

\

Multiple Pricing t

\

Picking List

\

Advance Price History t

\

Sales, Purchase Price Assistant t

\

\

Stock Status Assistant

\

\

Maintain Font Style

\

Item Template t

\

Landing Cost t

\

Partial Deliver

\

Category 4 : Stock

Alternative Item t

\

\

Category 5 : Management

Cash Flow Forecast t

\

Advance Drill Down t

\

\

DIY Fields

\

COMPARISON

SBE & PRO

ADD ON MODULES

Enhance your performance, make it perfect

SALES

PURCHASE

Stock

PRODUCTION

CUSTOMIZE

TOOLS

Learn more

About SQL Account

Account User Guide

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

SQL Account Releases

Read all current and past software build releases here!

Unlock Your Potential Today!

Embark on a journey of seamless financial management and elevated efficiency, trusted by numerous companies in Malaysia
Take Your Business to New Heights with
Our Advanced SQL POS System - Start Your Free Trial Now!

We Serve You Better !

My Software Solution Sdn Bhd is a software consulting firm that mainly focus on business management software, especially accounting software. We provide top notch solution for businesses from various industries in assisting growth and strengthen their business operation.

Office Hours

Closed Sundays  |  Open All Day

Monday To Friday

Open  9am - 6pm

Saturday

Open  9am - 1pm

Contact

Copyright © 2023 My Software Solutions Sdn Bhd. All Rights Reserved. Web Design.

Open chat
mySoftware Support
Hello! Have a question? Let's talk on WhatsApp.

Our support team will get back to you within 24 hours.

SQL Account Releases

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 June 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 Account 5.2024.976.842


Released on February 21, 2024

Release Notes

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

 

SQL Account 5.2024.974.841


Released on February 15, 2024

Release Notes

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

 

SQL Account 5.2023.973.840


Released on December 29, 2023

Release Notes

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

 

SQL Account 5.2023.972.839


Released on December 8, 2023

Release Notes

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

 

SQL Account 5.2023.968.838


Released on October 27, 2023

Release Notes

  • Fix posted incorrect amount of EasyStore gift voucher to sales invoices
  • Enable Auto Post Reverse Unrealise GainLoss on 01 of Next Month for Customer & Supplier 06 Months Aging-GainLoss format
  • Reduce Level support to 3 for GL BS - 6C1P - FA format
  • Database upgrade to version 194
  • #6723: GL Balance Sheet & GL P&L reports Project Tab add Full Expand & Full Collapse options
  • #6707: AR/AP Deposit Entry Deposit Account lookup filter by current asset or current liabilities
  • Force TikTok confirmed order status to canceled for order canceled due to item not shipped out
  • Add prorated Shopee voucher offset return to Shopee order's sales credit note
  • Fix replace as canceled sales invoices does not tick canceled checkbox
  • #6702: Auto Bank Recon - Ambank new deposits combined statement format
  • Auto Bank Recon - Fix Public Bank format capture Balance as Dr Amount
  • #6717: Auto Bank Recon - Add Affinmax Bank format
  • #6715: Purchase Invoice unable to save if cancel document with serial number and user has no right for "Allow Non-existent/Duplicate Serial Number"
  • #6704: Entry Form Note field should follow application default font type
  • #6720: Sales Entry forms open Profit Estimator form slow when costing detail table has big data
  • #6716: Stock Physical Worksheet & Stock Reorder Advice reports drag and drop to Stock Transfer should assign Location to From Location field
  • Add adjusted coin discount for Shopee sales invoice
  • Fix for Shopee displaying incorrect return quantity amount
  • Post TiktTok platform reimbursement and shipping fee compensation with the use of new TikTok payment file format
  • Bug fix for posting TikTok logistics reimbursement, and post TikTok sample shipping fee adjustment with the use of new TikTok payment file format
  • Fix TikTok posting sales invoice incorrectly
  • Support TikTok main account
  • Switch to new TikTok API (202309)
  • Fix Shopee posted incorrect discount amount in sales credit note
  • Fix Lazada post payment for order with missing item(s) and lost claim
  • Post TikTok logistics reimbursement adjustment with the use of new TikTok payment file format
  • Skip empty row in TikTok payment excel file
  • #6713: SL/PH CN add Access Rights for Prompt Knockoff for CN
  • #6672: E-Commerce forms support access rights
  • [GST-SG] GST SG tax rate increase to 9% start from 1/1/2024
  • #6714: Stock Assembly entry browse grid unable to show Asm Cost column from field chooser
  • #6709: Document Transfer dialog add Batch column for Sales Order ->Job Order & Job Order -> Stock Assembly
  • #6703: Stock Assembly & Disassembly reports add master batch, detail item & batch pipelines
  • Fix GL P&L & Balance Sheet report condolidate display empty database in SQL Connect, which window registry Connection.Pool is blank for normal users
  • #6708: SL Invoice edit save prompt error "2149900253" is not a valid integer value
  • #6700: Maintain Stock delete a BOM item cause invalid sequence for other BOM items
  • #6699: Stock Costing not calculated for old item code if edit document change to another item code
  • #6696: CN Transfer from Sales Invoice show "Insufficient memory for this operation" error when Invoice has 400k+ records

 

SQL Account 5.2023.967.837


Released on September 30, 2023

Release Notes

  • Add QR Payment for Sales Invoice 8 (SST 2)-Aging format
  • Fixed Cust Local - Payment Listing - Collection Report Amount not reset when record not found
  • Fixed Sales DN rtm format FromDocDate show 30/12/1899
  • Update Job Order 1 format Remove the Unit Cost, Overhead Cost and Subtotal, Group by detail location & Add batch and signatory ie. Prepared by, Processed by
  • Fixed GL Local - Ledger - Detail - Level 2 Total balance by group not correct
  • Fixed Sales Local Invoice & Cash Sales Collection Report Grand Total not correctly map
  • Update Sales Invoice 8 (SST 2)-Aging for Pay only shown outstanding amt instead of docamt
  • Add new Asset Analysis (12 Months) - Group By Level 2
  • Remove net book value column and replace with gain/loss from disposal of assets in Asset Analysis
  • Adding Shopee order's note to document's note
  • Show country for Lazada, Shopee, and TikTok shops
  • Support linking with Lazada cross border account
  • Support linking with Shopee main account
  • Support new TikTok payment file format
  • Include note property for sales order and quotation
  • Fix Lazada payment posted refund with wrong amount
  • Increase number of records fetched from 250 to 500 for Lazada transaction details
  • Remove duplication check for Lazada transaction details
  • Do not post sales credit note for order that posted with canceled sales invoices
  • Fix TikTok HTTP request retries bug
  • Fix post cancelled order using option "Post As Cancelled Sales Invoice" does not tick "Cancelled" in sales invoice
  • Allow user to ignore Lazada payment for unposted order
  • Allow user to ignore Shopee payment for unposted order
  • Fix Shopee incorrectly posted "Product discount rebate from Shopee" in sales credit note
  • Fix TikTok assigned document number even document failed to post
  • Retry HTTP request if error code 500 Internal Server Error received
  • Check cell value is not empty before assigning Shopee payment header index
  • Allow user to select specific account(s) before fetch products
  • Allow user to select specific account(s) before fetch orders
  • Auto Bank Recon - Revise Bank Islam current account cash line-i statement format
  • #6575: Auto Bank Recon - Maybank Bank Statement Bank Closing not match ending balance
  • #6647: Auto Bank Recon - Maybank invalid numeric input for bank statement that contain gst type column
  • #6574: Auto Bank Recon - CIMB Bank did not auto fill Bank Statement Bank Closing balance
  • #6685: Stock Assembly unable to save if users no right for Allow Non-existent/Duplicate Serial Number even the Serial Number is valid
  • #6694: Sales Profit Loss By Document & Sales S/N Profit Loss By Document tick Cash Sales by default
  • View | SL/PH Price History form should focus on first record by default if user last saved grid layout sort by date descending
  • #6692: Rich Text Editor unable to change font type, size or color when selection text have mix Font settings (if user change to same current value of combo box)
  • #6686: SQL Connect unable to do Consolidation when DCF file saved in SQL Drive folder
  • #6642: RHB Reflex cloud banking "remark2" field is filled in as payment advice
  • #6681: Missing asset group, agent and area lookup on asset item batch edit window
  • #6683: Entry form "Edit as New" button click should prompt access denied if users don't have "New" access right
  • #6584: SL/PH CN right click add "Show KnockOff" option to open AR/AP CN entry form
  • #5738: Stock Physical Worksheet drill down open different forms based on Qty, SO Qty, PO Qty and JO Qty column's click
  • #6671: Add Journal No. on Asset Disposal entry window
  • #6674: Sales Price History report prompt Assertion failure error when tick Latest n records option
  • #6670: Sales Picking list report add DtlKey field
  • #6666: SL/PH Document Entries shouldn't allow to save if Discount contains comma
  • #6667: Stock Transfer unable to save if don't have the right for Allow Non-existent/Duplicate Serial Number