SQL Account Releases

• 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

• 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

• 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

• 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

• 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

• 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

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

• 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

• 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”

• 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

• 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

• 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

• 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

• 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

• 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