SQL Account Releases
SQL Account 5.2024.987.851
Released on June 18, 2024
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
