Skip to content

SQL Account Version Releases

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

SQL Account 5.2024.996.855

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

SQL Account 5.2024.992.854

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

SQL Account 5.2024.991.853

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

SQL Account 5.2024.990.852

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

SQL Account 5.2024.987.851

Released on June 18, 2024
 
    Release Notes
  • Revise database upgrade script version 200 for db upgrade error in certain pc
  • Unknockoff TikTok credit note before editing TikTok sales invoice
  • Skip posting TikTok platform discount refund
  • Adjustment to Shopee voucher adjustment logic
  • Support linking with Shopee SIP account
  • #6896: Make TEncoding.UTF8 as default encoding using TStringList in DIY script
  • Database upgrade to version 201
  • Attachment support Database Blob storage & GL Cash Book support OCR
  • Add SY_BLOB table
  • Add OCR
  • Support Database Storage in External Attachment
  • GL_CBDTL add OCR field
  • Add WebApp
  • Add logon by QR authentication
  • Add customer aging format with 6 months local amount
  • AR and Sales modules support SQL Views
  • Fixed Customer/Supplier Multi Balance Listing report not error when preview
  • Adjustment to TikTok sales invoice editing logic
  • Adjustment to TikTok logic on checking platform shipping fee discount reduction
  • Add adjustment grid view for listing Shopee adjustment in payment file, and allow posting Shopee adjustment together with payment
  • Maintain Customer & Supplier support single company TIN update
  • #6891: Job Order transfer from Sales Order the Transfer Qty column unable to enter more than 2 decimal places
  • [EIV-MY] Batch TIN Update form revise MyInvois calling part to prevent memory leaks in thread
  • #6883: GL Receipt and Payment Report Balance B/F should based on by Project, Agent & Area filtering

SQL Account 5.2024.986.850

Released on May 28, 2024
 
    Release Notes
  • Revise database upgrade script version 200 for db upgrade error in certain pc
  • Tin Batch Update form support user enter TIN
  • #6885: AR/AP Post Dated Cheque Listing Amount & LocalAmount footer summary values incorrect when filter grid
  • Maintain Customer & Supplier add TIN batch lookup
  • Company Profile, Maintain Customer & Supplier validate TIN shouldn’t raise exception if users unable to online (perform silently)
  • Company Profile, Maintain Customer & Supplier remove spaces for old/new BRN & TIN
  • Feature #5225: Production Job Order and Stock Disassembly add Show Cost access right
  • Remove bottom line border from TcxDBImage

SQL Account 5.2024.984.849

Released on May 17, 2024
 
    Release Notes
  • Fix TikTok additional shipping fee checking logic
  • Remove redundant actual shipping fee entry in TikTok sales credit note
  • Re-enable sales invoices editing during load TikTok payment file to add in missing transaction fee and SFP service fee
  • Fix TikTok posted duplicated platform shipping fee discount adjustment
  • Fix Shopee voucher adjustment calculation for return refund
  • Fixed SST-02 (20240301) Draft no value
  • Fixed Ledger – Detail Description2 get wrong information when record is BA
  • Fix Database upgrade version 200 for certain db upgrade failed issue
  • #6877: Maintain Customer & Supplier open in Entry mode prompt access violation error
  • [EIV-MY] Prompt for Company Profile TIN dialog show only if is standalone startup mode
  • #6876: Stock Item Batch Edit form hide Classification label if company profile is not Malaysia

SQL Account 5.2024.983.848

Released on May 13, 2024
 
    Release Notes
  • Database upgrade to version 200
  • Fix process hang when running automation server registration or unregistration
  • Switch rounded rectangle TShape to TSkPaintBox
  • Import TIN from Excel
  • Maintain Customer & Supplier remove GST No lookup function
  • [EIV-MY]: Maintain Customer & Supplier form add EIV fields
  • [EIV-MY]: Maintain Stock Item form add product Classification field
  • [EIV-MY]: Company Profile form add e-Invoice tab. Move GST & SST No fields to GST/SST tab accordingly
  • [SST-MY] #6861: SST Tax code “SVE” Description should include for Group J
  • Apply adjustment to TikTok platform shipping fee discount when actual shipping fee is lower than original shipping fee
  • Fix Shopee missing prorated seller voucher offset return in sales credit note
  • Fix TikTok calculated other fees incorrectly
  • Revise WooCommerce HTTP Authentication implementation
  • Trim returned products JSON list data by WooCommerce API
  • Fix TikTok posted shipping fee adjustment incorrectly
  • Fix TikTok incorrectly listed refund as additional shipping fee charge

SQL Account 5.2024.982.847

Released on May 8, 2024
 
    Release Notes
  • Fix process hang when running automation server registration or unregistration
  • Add SST-02 (20240301) Format
  • Split Diff TaxRate for Same Tax Code for SST Listing Report
  • Fix Sales & Purchase 8 (SST 1) format tax rate field not correct position when have more description
  • Skip TikTok buyer paid shipping fee for other fees calculation
  • #6874: Auto Bank Recon – Fix always show bank statement have been fully matched after error raise on load statement
  • RHB Reflex – Fix payment method AccNo not update after link
  • Prompt error for Shopee escrow detail call after 10 failed attempts
  • Adjustment to Shopee access token refresh
  • Add TikTok Platform Discount Refund to sales credit note
  • Post separate credit note for TikTok additional actual shipping fee charge
  • Fix Shopee added shipping fee SST twice in printed order invoice
  • Added Shopee reverse shipping fee SST incorrectly in credit note
  • Revise TikTok orders fetch
  • #6869: Sales P&L by S/N report’s Cost will incorrect if same S/N IN & Out same day
  • Solve flicker when resize for controls hosted in TdxDockPanel and TPageControl in MDI child form.
  • #6870: AR Payment’s Currency Rate different with Cash Sales when user change the Currency Rate
  • #6868: AR/AP Balance Report’s Document_Currency pipeline is empty
  • SSM RegNo Lookup Form switch new and old RegNo columns position
  • Company Profile prompt re-login dialog when user change Country

SQL Account 5.2024.981.846

Released on 01 Apr 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 15 Mar 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 07 Mar 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 29 Feb 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 21 Feb 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 15 Feb 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 29 Dec 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 08 Dec 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 27 Oct 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 30 Sep 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

SQL Account 5.2023.965.836

Released on 24 Aug 2023
Release Notes
  • Allow posting Shopee canceled order
  • Fix Shopee incorrectly posted refund variance adjustment to sales credit note
  • Database upgrade to version 193
  • #6653: Add Description2, DocNoEx and Qty fields to Asset Item data entry window
  • #6632: Asset item allow to input useful life up to 4 decimals
  • Fixed Profit & Loss with Cash Flow (Amt Exclude Tax) report Unable to show Total Cost if do not have cost Adjustment.
  • #6659: Auto Bank Recon – Bank Islam current account cash line-i statement format
  • Fixed Sales Local – Cash Sales Collection Report not including Contra amount
  • Fix TikTok does not create sales credit note for returned item in partial returned order with status completed
  • Fix Lazada posting sales credit note without reversal item price for refund order
  • Fix Lazada does not include lost claims and adjustments item charge when editing sales invoices
  • Fix Woocommerce to use item ID instead of SKU to store alternative code
  • Avoid checking for Lazada payment file using empty cheque number
  • Delete Lazada sales invoice details while retaining stock record
  • Fix Lazada merged item incorrectly
  • Adjustment to Shopee return refund variance calculation
  • Adjustment to TikTok token refresh logic
  • Fix Lazada not adding returned stock items in sales credit note
  • Fix EasyStore does not include gift voucher in sales invoice
  • #6641: Calculate Costing post duplicate stock transfer or missing documents issue in multi user network environment
  • #6393: Asset item can be imported without verifying valid asset group
  • #6640: Customer Balance Report incorrect Local C/F when Payment’s GainLoss Posting Date > DateTo
  • #6656: Sales Price History report prompt out of memory error
  • #6651: Maintain Withholding Tax allow Tax Account (DR) leave blank to follow document accounts
  • #6643: GL Ledger incorrect BF balance if group by Project alone. Account code should be compulsory to tick for grouping
  • #6645: Calculate Costing prompt “Out of Memory” error even item using Fixed Cost method
  • #6610: Two Good Received created at the same with same Serial Number for same item code shouldn’t allow to save if access right “Allow Non-existent/Duplicate Serial Number” is unticked
  • #6639: Prompt error “cannot focus a disabled or invisible window” when double click on item flow document in tabbed docking mode

SQL Account 5.2023.963.835

Released on 04 Aug 2023
Release Notes
  • #6635: All SL/PH Browse grid add Billing Attention, Phone, Mobile & Fax columns
  • Update on HomeScreen debit credit icon
  • Ignore adjustment to quantity and discount when editing Lazada sales invoice
  • Ignore item ID when constructing Lazada post order details
  • Fix Lazada get transaction details with incorrect limit number
  • Fix TikTok posted refund seller discount incorrectly
  • #6634: All document entries upon save prompt message if Doc Date less then 01 Jan 2000
  • #6289: Stock Transfer View Price Tag should display Unit Price based on selected customer
  • #6626: GL Cash Book split form mode click New PV but show as OR entry. Same issue happen on AR/AP DN & CN
  • #6621: Stock Card Qty report tick Include Zero Balance Transaction show incorrect result
  • Fix Stock Card Qty report data form caption
  • #6628: GL Cash Book, AR/AP Payment & Refund Forms Bank Balance label change to grey color without bold
  • #6629: AR/AP Deposit Entry add Deposit Account column in browse grid
  • #6535: Auto Bank Recon – HSBC Bank Statement new format
  • #6577: Auto Bank Recon – RHB Bank New Cambodia Statement Format
  • #6591: GL Ledger Report group by Account & Project transactions not show if untick “Include zero B/F with Transaction” option
  • #6627: GL Cash Book, AR/AP Invoice, DN & CN forms 2nd side button position wrongly when using split browse & detail form mode
  • #6613: Sales Invoice save prompt conversion date error if Region format is Thai and Start GST with United Arab Emirates Country
  • #6620: Purchase Order transfer from Sales Order Document tab’s Amount, Local Amount, Currency Code & Project are blank
  • #6624: Cash Sales & Cash Purchase unable to select Payment Method if user manually enter Doc No
  • #6616: Location lookup add Description 2 field
  • #6617: Customer Payment unable to save if using Rich Text Editor

SQL Account 5.2023.962.834

Released on 20 Jul 2023
Release Notes
  • Database upgrade to version 192
  • Feature #6603: Document attachment support cloud SQL Drive
  • #6596: Calculate Costing post duplicate stock issue and missing documents issue in multi user network environment
  • Feature #6497: Serial Number field upgrade from 30 to 50 characters
  • Show Shopee Refresh Token expiry date instead of shop authorization expiry date
  • Include seller discounts in sales credit note for TikTok refund order
  • Lazada allow posting item quantity in sales invoice even item has been returned
  • Fix Lazada does not include Reversal Promotional Charges Flexi-Combo in sales credit note
  • Fix Lazada added additional Lazcoin discount
  • Exclude empty company item code in stock take items list
  • Prevent order fetching with date to earlier than date from
  • #6598: Auto running number for Asset Item doesn’t follow Acquire Date
  • Enable support up to 4 levels for GL BS – 6C1P – FA format
  • #6611: Maintain GL Account rename account “Sales” and “Sales Adjustment” to “Revenue” and “Revenue Adjustment”
  • #6614: Supplier Deposit Grid Caption not corect
  • #6605: Entry Forms browse mode unable to view images in Rich Text Editor fields
  • #6609: GL Cash Book, AR/AP DN & CN Forms new document access right not working
  • #6601: SL/PH Invoice, DN & Cash Purchase entry forms show Outstanding Amount
  • #6599: Fix Member Point raise error : BO Class (Sales.Point.BO.UI) Not found

SQL Account 5.2023.961.833

Released on 06 Jul 2023
Release Notes
  • Remove leading space on customer statement report name
  • Feature #5522: Entry forms support access right approvalfor New, Edit and Delete buttons
  • Fixed GL BS – 6C1P – FA start date should follow financial start date
  • Fixed Sales DN FromDocNo & FromDocDate not shown for RTM format
  • Fixed GL Balance Sheet & PnL Project Comparison Total Project no line
  • Enable support both show & unshow zero balance GL Trial Balance – This Year
  • Fix Lazada does not edit sales invoice correctly during payment posting
  • Verify Lazada endpoint stored in shop account is not empty
  • Fix Lazada fetch product’s SKU variation prompt error “SKU not exist”
  • Include additional characters to be encode in Lazada API HTTP request call
  • Fix TikTok incorrect posting of shipping fee adjustment in sales credit note, and remove platform discount from sales credit note
  • Fix TikTok posted platform discount and platform promotion incorrectly
  • Fix Lazada fetch product’s variation failed due to improper encode of seller SKU
  • #6560: AR/AP Payment edit & save prompt “MainDataSet: Dataset not in edit or insert mode” error
  • #6593: All document entries upon save prompt message if Doc Date is more than 13 months from Working Date
  • #6592: Stock & Production documents preview show blank after user changed posting date
  • #6571: GL Balance Sheet – Unable to show full for Consolidation
  • #6583: Document Entry remove Prompt for Cheque Number for bank if cheque no is empty
  • #6595: GL Profit & Loss and Balance Sheet open column properties prompt error
  • #6581: Sales Profit & Loss by Document & Item Margin should show in negative for CN document
  • #6540: Auto Bank Recon – Add RAK Bank Statement Format (CSV)
  • #6387: Auto Bank Recon – Add Bank Islam Statement Format (PDF)
  • #6582: Print BOM Listing click apply prompt access violation error when choose Chinese language
  • #6586: GL Ledger report make Project & Tax grid columns visible by default
  • #6585: Job Order with more then 600 items transfer to Stock Assembly very slow

SQL Account 5.2023.958.832

Released on 24 May 2023
Release Notes
  • Change new HomeScreen
  • #6534: Calculate Stock Costing issues in multi user environment. Stock Item has qty balance in Stock Physical Worksheet but no data in Stock Card report. Error “Cannot update erased record” occurred when perform same item costing calculation simultaneously
  • Improve TikTok load payment file performance
  • Fix TikTok failed to post partial refund order
  • Fix Shopee failed to post partial refund order
  • Fix Lazada post credit note with missing partial refund info, and Reversal Promotional Charges Vouchers not included in posted credit note
  • Add confirmed status to Lazada order view
  • Fixed GL Ledger-FOREX Gain Loss error arithmetic exception, numeric overflow. Floating point divide by zero….
  • [GST-SG] Open GST Return Form disable “Submit GST Return to IRAS” option for draft records

SQL Account 5.2023.957.831

Released on 15 May 2023
Release Notes
  • Disable invoice editing when loading TikTok payment file
  • Fix TikTok not posting shipping fee adjustment correctly
  • Fix TikTok not showing actual exception message while posting payment
  • Fix TikTok credit note does not apply shipping fee charges by TikTok for canceled order
  • Fix Woocommerce not excluding auto-draft order
  • Fix Lazada credit note does not knock off invoice
  • Fix Shopee order to include original platform discount into estimated escrow amount and invoice amount calculation
  • Fix TikTok not posting order with just shipping fee charge
  • Add Comparison – Monthly (18 Months) format for GL Profit & Loss report
  • Fixed PV & OR displayformat not follow option
  • Fixed Export to excel Account Description empty for GL BS – 4C0P format
  • #6531: Rename Asset Disposal to Asset Disposal/Write Off
  • Fix PopupControl.TaxRate inaccurate buttons position
  • #6525: Maintain Stock Item search Stock Category prompt access violation error
  • #6526: Customer Statement with incorrect Aging info if date from is blank
  • #6529: Stock Card report’s Merge Same Cost option by default untick
  • #6527: Auto Bank Recon – Auto match first same amount but different date transaction with bank statement record
  • Fix Bank Account Number is missing for some Supplier Payment when preview Supplier Payment Listing
  • #6523: Improper function on Access Right Setting for “Hide Dashboard” under View menu
  • #6522: Unable to process subsequent month depreciation if asset cost is negative
  • Feature #6385: Allow stock item to batch edit stock group
  • #6521: Edit & Save Invoice (Note field has value), prompt error “Could not convert variant of type (Array Byte) into type (Integer)”
  • #6518: Preview AR/AP Payment, payment method description is empty if the payment transfer from Deposit
  • #6519: View Price History – Record should always Go to first

SQL Account 5.2023.955.830

Released on 19 Apr 2023
Release Notes
  • #6512: Hide Dashboard access right should move to View instead of Inquiry
  • #6327: Auto Bank Recon – Match button not showing for DR amount match with Net DR when merge bank charges is checked
  • Remove Entry Forms “Close” button
  • #6088: DIY Advance Form Design’s Component Palette not display fully
  • Change Page 2 Title to Year To Date
  • Fixed rounding error for Asset Opening vs GL Maintain Opening Balance report
  • Fixed Journal Voucher Spelling Error
  • Add SST-02 (2023) format
  • Fixed Profit & Loss with Cash Flow (Amt Exclude Tax) label not correctly shown
  • Support batch product map for E-Commerce product page
  • Fix TikTok not showing exception message when attempt to store duplicate order number
  • Fix AddToCart export JSON file prompt exception when product name is empty
  • Fix AddToCart not showing mapped item code in Order page. Removed AddToCart SKU code.
  • Fix TikTok not include SFP Service Fee in sales invoice, and prevent duplicate records added when editing sales invoice and credit note
  • Fix TikTok not including customer paid shipping fee in credit note for cancelled order
  • #6510: GL Ledger Purchase Invoice with same document number, but different supplier when double click will show first document
  • #6509: SL/PH Price History default show latest price by document type instead of oldest
  • #6508: Sales P&L by Document UnitPrice not follow the decimal point set at option
  • #6505: Sales P&L By Doc report add DocUnitPrice (original document unit price)
  • Feature #3882: GL Bank Deposit support Payment Voucher
  • #6500: Profit Estimator unit price amount different with unit price in Invoice
  • #6489: Add Auto Bank Recon – Standard Charted Bank Format
  • #6501: Year End auto post Stock Received for Serial No. Opening, set the document Description as “Opening Stock (Serial Number Items)”
  • SL/PH document posting to AR/AP should include Note field
  • #6492: Data entry form supports OnBeforeSave DIY event
  • Feature #6440: Stock Aging add Aging Type “Monthly (60 Months)” and quarterly support up to 5 years
  • #6336: Show Chart unable to close line chart after focused records
  • #6487: Supplier Deposit Entry New Refund & Forfeit options are missing. (Fixed commit 0948fd9c)
  • #6466: Purchase Invoice copy foreign doc & paste to another DB which currency code not exists. The Local Net Total field remain unchanged even after change supplier code
  • #6476: Customer Payment transfer from Deposit prompt “Payment Amount Cannot More Than Deposit’s Unapplied Amount” error even is same amount

SQL Account 5.2023.953.829

Released on 09 Mar 2023
Release Notes
  • #6469: Asset reports prompt dynamic SQL error when filtered by asset group, agent, area
  • Fix Sample db load profile logo error
  • Database upgrade to version 191
  • #6455: Add Ref field to Customer and Supplier Bank Account datasets
  • Add Ref column to AP_SUPPLIERBANKACC, AR_CUSTOMERBANKACC tables
  • Add Online Approval for access right
  • Add Online Approval message to access rights
  • SY_User add Mobile & OpenID_Google fields
  • Feature #6401: Points entry add Agent, Area and Project fields
  • Points Listing add Group/Sort By, Area, Agent, Project, Company Category fields and filtering
  • Sales Points entry add Area, Agent & Project fields
  • SL_PT add Area, Agent & Project fields
  • [GST-SG] Set SROVR tax code inactive and add DEPRECATED word to Description
  • Feature #6270: Sales & Purchase DN able to transfer from QT, SO & DO and transfer to CN & Extra DO
  • SL/PH document entries form (related to DN) add Debit Note document transfer actions
  • SL/PH DN Entry form support document transfer and rename existing master table FromDocNo to FromDoc
  • SL/PH DN tables add fields to support document transfer, add DeliveryDate field and rename existing master table FromDocNo to FromDoc
  • Feature #6467: SL/PH entries browse grid add 2nd Company Name column
  • Add Profit & Loss with Cash Flow (Amt Exclude Tax) format
  • Fixed GL Official Receipt – Detail – Full (with other CNnOR info) Label not correct
  • Update GL Ledger Level 1 – Only shown Summary total for Trade debtor & Creditor when not filter
  • Change Balance Sheet Comparison – Monthly (12 Months) to print as Single Page format
  • Increase width for Month & Year column for GL PnL – 13C1P-SinglePage
  • Add Sales Invoice & Cash Sales Collection Report
  • Fixed Customer & Supplier Listing ROC not correctly shown
  • Fixed Sales Invoice 7 (GST 1) – SG Currency & TaxRate not correctly shown
  • Fixed Stock Assembly-JO vs AS Variance Seq show big value
  • Support TikTok new payment file format
  • Fix Shopee failed to post credit note
  • Fix lPaymentAmt compares failed to work properly
  • Fix #6468: Auto Bank Recon – RHB Bank invalid numeric input
  • #6464: Document Transfer didn’t prompt error message in target doc when transfer Qty is more than source doc with zero Qty
  • #6461: Cash Sales & Cash Purchase browse grid add Payment Project column
  • Add sum footer to Lazada and Shopee payment’s grid columns footer
  • Add Delete Posted SKU option
  • Document Entries add Audit Trail log for Override Credit Control
  • #6458: AR/AP Payment, CN & Contra entry form upon save will check to make sure update AR/AP IV & DN Payment Amount is not negative
  • Feature #6459: Add Analysis Data Integrity – Update AR/AP Invoice/Debit Note Outstanding Amount
  • #6457: GL Trial Balance Period To Date column incorrect when Opening in CR & YTD in DR
  • #6456: Cash Flow Forcast form UI adjustment
  • #6453: Stock Analysis By Doc apply prompt integer overflow error
  • #6451: Profit Estimator – Change Label Use Actual Cost to Use Actual On-Hand Cost
  • #6446: Sales PnL by Doc – UnitPrice should divide by Base Qty
  • #6449: Supplier CN & DN entry forms button rename caption to New CN & New DN
  • #6424: Stock Card main grid add Qty column
  • #6443: Maintain Stock Item become not responding when save after Copy from Item A and Paste into existing Item Code (which Customer Price has 192 records)
  • #6430: Enable web-style row selection for grid view on “Bad Debt Relief” form
  • #6435: Sales Order unable to change document date by pressing ENTER to the next field

SQL Account 5.2023.951.828

Released on 30 Jan 2023
Release Notes
  • Fix Shopee failed to create sales credit note for refund order
  • Include store ID in generated Lazada payment reference ID
  • Fix EasyStore does not include shipping fee, item discount, and transaction fee in sales invoice
  • #6429: Supplier payment with invalid bank account allowed to save
  • #6431: Customer payment unable to unchecked knockoff service tax invoice after process draft SST return
  • #6423: GL Ledger report grid do not save last used layout
  • #6428: GL Ledger Group by Project – Balance incorrect if untick Include zero closing balance
  • #6413: Maintain Customer Credit Control unable to tick multiple document types when choose Chinese language
  • #6414: Form Mode Filter By Agent cannot work if use “Transfer To”

SQL Account 5.2022.949.827

Released on 31 Dec 2022
Release Notes
  • Add GL Trial Balance – This Month vs This Year with Opening format
  • Fixed Report Seq field show big figure
  • [GST-SG] #6410: SL/PH Document Entry Tax amount not calculated after transfered from other document between GST Transition Period 7% & 8% different tax rate
  • #6400: Not allow delete past depreciation if asset item is disposed on future date
  • Feature #6390: GL Trial Balance add Opening Balance & Period to Date column
  • #6404: Tools | Option | GL | Conversion Date prompt Access Violation when exit application if error occurred when save option
  • #6405: License Module “Special Aging” replaced by “Project Profit & Loss with Cash Flow”
  • #6394: Maintain Price Tag enable DIY Fields
  • #6402 Auto Bank Recon – OCBC Bank unable to load amount when balance overdraft
  • Feature #6403: GL P&L and Balance Sheet report Project Comparison tree list add header built-in menu, columns filtering and Find Panel
  • #6399: Alert user when try to save asset disposal record if asset depreciation is not processed up to dispose date
  • Change asset disposal date doesn’t refresh accum depreciation
  • #6397: GL Trial Balance – Year To Date Retained Earning B/F incorrect when Start Date is not 1st day of month
  • #6398: Supplier Bills & Payment Analysis report grid enable multi select
  • #6396: Maintain Stock Value should remain when Clone DB for Master Data Only
  • #6391: Customer Analysis By Document report when filter grid column > 0 some zero value records still show
  • #6317: Show “New Taxable” button on past invoice

SQL Account 5.2022.948.826

Released on 10 Dec 2022
Release Notes
  • Account Inquiry adjust the aging grid height
  • Database upgrade to version 190
  • [GST-SG] Support seamless filing for SG GST Return F5 & F8 submission via API
  • Add GST F5 Return-2023 format
  • Maintain User add Phone field
  • Fixed PO unit price display format not follow tools | options
  • Fixed Stock Analysis By Document – Level 1 sometime hang due to summary hight
  • Remove Voucher from Item Discount for Sales P&L By Doc – eCommerce reports
  • Fixed #6275 OR not auto select when WhatsApp
  • Add Yearly Depreciation – Group By Level 1 format
  • Fixed Seq big number for Report format with (Tax 1)
  • Fixed Asset Analysis BF not correct
  • Fixed Stock Item List Query error
  • Add Asset Disposal Listing & Asset Card (with Schedule Depreciation) report
  • Add New report format for New feature 6326
  • Enable Batch email for Cash Sales Format
  • Add Summary total for Trade debtor & Creditor for GL Ledger Level 1
  • Fixed GL Payment Voucher – Detail – Full (with other SCnPV info) display format error
  • Post TikTok credit note from payment when escrow amount is 0 and no credit note is posted for order
  • Show Lazada order with status “confirmed” under status “delivered”
  • Support TikTok V2 authorization API
  • Fix EasyStore missing order item’s ID
  • Check EasyStore’s customer’s phone number is null or not
  • Remove empty spaces in EasyStore SKU and variant ID
  • Fix Shopee not including shipping variance in credit note
  • Fix Lazada payment added marketing fee as voucher
  • Fix TikTok UpdateDate displayed incorrectly
  • Fix Shopee return refund variance calculation
  • Shopee remove Shopee coin from refund amount calculation
  • Shopee try refresh token during get or post request when invalid access token error is received
  • Fix Lazada does not include items that’s free in print order
  • #6384: SL/PH Cancelled Document not allow Transfer To Others Document
  • #6381: Fix SL & PH Document Entries UI controls at top right position not align neatly
  • Stock Available Balance change IDockSiteView.SetOnDockClientClose
  • #6325: Auto Bank Recon – UOB New Statement Format
  • #6370: Auto Bank Recon – AMBANK New Statement Format
  • Feature #6380: AR/AP Deposit Refund Entry allow COM access to set Doc No
  • #6375: Maintain Stock Item delete first record in Customer Price (that contain 3 records) cause incorrect record sequence
  • #6298: Job Order Browse Grid add Remark, Line Supervisor and Production Info columns
  • #6352: Fix location DIY Field unable to view from Browsing Screen
  • #6377: Asset item allow project rate lower than 100%
  • Feature #6376: Add Asset code auto running
  • #6373: Unable to load default or last used layout for Supplier Payment KnockOff Grid
  • #6374: Production Outstanding JO & SO negative outstanding balance (over transfered) should treat as fulfilled item
  • #6299: Auto Bank Recon Alliance Bank – Unable to load complete bank statement
  • #6368: SL/PH Document Entry Currency Rate should follow periodic currency rate if using copy and paste document
  • Feature #6326: Add GL Project Profit & Loss with Cash Flow report
  • #6364: Unable to process depreciation without fill in fixed asset acquire date
  • #6360: Document Entry Detail first record Seq shouldn’t been changed when user delete second record