SQL Account Releases

• 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

• 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

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

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

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

• 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

• 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

• 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

• 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

• 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