SQL Accounting Latest Version (v865) Date : 28 Mar 2025

 

SQL Account 5.2025.1019.865

Released on March 28, 2025

Release Notes

• [EIV-MY] Change MyInvois Request caption to E-Invoice Request
• #7204: Show FromDoc at Browse Screen for CN, DN, SC, SD and CB
• #6306: GL Balance Sheet report consolidate tick Display Trade debtor and creditor raise assertion error when report's account level set lower than control account's level. Revise to more friendly error message
• [EIV-MY] #7210: Include unsubmitted E-Invoices option missing at batch consolidate
• [EIV-MY] Bug #7196: Consolidate E-Invoice prompt access violation if click next without selecting document
• #6045: Stock Reorder Advice report should show Reorder Level, Reorder Qty, Min/max Qty grid columns by default
• #5788: GL Profit & Loss statement report if Project code in chinese will cause incorrect amount for the Project column in Print Project Comparison
• #6236: Maintain Stock Item Matrix prompt warning message when row/columns contain duplicate values
• Fix entry forms Matrix Profile label position
• #6207: SL/PH Analysis By Document report when filter Company Category and tick "Include Zero Balance" should only show company that match with the filtering only
• #6229: SL/PH Analysis by Document allow to view the Available Stock Balance
• Feature #6567: Stock BOM Material Usage report add Print Active/Inactive Material & Product Item checkboxes
• Fix TikTok prompt access violation during order verification process
• Fix Shopee posted return refund variance in sales credit note incorrectly
• Adjustment to Shopee payment file loading dialog message
• Fix Shopee posted return refund variance in sales credit note incorrectly
• Fix TikTok not posting additional actual shipping fee charge sales invoice
• [EIV-MY] #7216: Remove locking on TaxExemptNo that is not submitted to MyInvois
• [EIV-MY] #7217: MyInvois Config form copy intermediary info does not work
• #7215: Stock Month End Balance Report apply prompt assertion error when having large amount for GL Balance Sheet Stock
• #6406: Production Document Transfer dialog add checkbox indicator and auto fill in Transfer Qty when focused record changed
• Feature #6386: SL/PH Document Listing add new columns Filter Total & Local Filter Total
• #6445: Maintain Document Number deleting record should prompt error when Maintain Payment Method OR/PV Document Set referring to it
• #6604: SL/PH Analysis by Document & Yearly Analysis reports add Stock Category Description
• [EIV-MY] Show LHDN QR in report only for valid status
• [EIV-MY] Prompt password dialog for report to include LHDN QR in sandbox environment
• [EIV - MY] #7205: Consolidate CN submission failed when ID Type and ID No blank using General Public's TIN
• #7201: Revise AR/AP Deposit Refund form labels caption
• #6740: Stock Physical Worksheet Report support View Price Tag
• #6789: Outstanding SL/PH Document Listing report default parameter change to SO / PO
• Feature #7197: Maintain Account support auto create Accumulate Depreciation Account
• #6959: Sales Invoice transfer from Delivery Order after clearing customer code, the document transfer window will show all transfered/untransfered items incorrectly
• [EIV-MY] #7199: BRN with space cannot be input into the field
• [EIV-MY] Revise MyInvois single import to new or edit record without save to database
• [EIV-MY] Remove serial number from MyInvois import
• Adjustment to Lazada sales invoice editing
• Add TikTok affiliate partner commission to sales invoice
• Set Lazada payment reference ID to weekly reference ID
• [EIV-MY] #7190: Connect MyInvois should prompt error message instead of disabled in edit state
• Change Check E-Invoice Status caption to Refresh E-Invoice Status
• #7191: Sales S/N Profit & Loss By Document has duplicate records if have same DocKey & Detail Key in different document type

SQL Accounting Latest Version (v864) Date : 28 Feb 2025

 

SQL Account 5.2025.1017.864

Released on February 28, 2025

Release Notes

• Database upgrade to version 210
• Fixed JO, AS & DS report checkbox not correctly shown due to DataType
• Fixed Local amount if 0, no need to show in item Tax and Item Localamt and exclude from sub total for Profit & Loss with Cash Flow (Amt Exclude Tax) report
• Add IRBM_InternalID to DN, CN, SD and SC to standardize table structure
• #7168: FromDoc field upgrade from 40 to 200 chars
• [GST-SG] Feature #7161: Add Tax Codes: NA and TXNA for year 2025
• #7120: Maintain Tax add new Tax Types - Sales Tax, Service Tax, Tourism Tax, LVG & Tax Exemption for Purchase side MyInvois purpose
• Fix watermark not working properly when multiple form create in thread with Begin Invoke
• [EIV-MY] #7153: Classification submit as 004 if reference to consolidated document
• [EIV-MY] #7155: Submit Consolidated Self-Billed E-Invoice in CashBook prompt list index out of bounds error
• [EIV-MY] #7154: Line item classification code should be 004 for consolidated self-billed e-invoice
• Adjustment to Lazada sales invoice and credit note edit logic during post payment
• Add TikTok affiliate ads commission to sales invoice
• Allow posting order's invoice from Lazada payment
• Fix Lazada posted lost claim reimbursement incorrectly
• Check service fee is found before extracting the value from Shopee payment file
• [EIV-MY] #7188: Consolidate E-Invoice add in post date column
• #7163: Add UOM lookup and Serial Number in MyInvois import
• [EIV-MY] #7187: 3rd party incomplete EIV field posting cause null conversion error
• #7064: Cloud Banking - Show linking feature and notification on Bank Recon when supported bank is selected
• Fix bug: Database upgrade to version 196 prompt "string right truncation" error when execute procedure INSERT_DI_PROJECT
• #7182: [EIV-MY] Check consolidated E-Invoice status prompt out of memory error
• Fix SL Profit & Loss Serial No & SL Profit & Loss Report Doc Cost & Item Cost display format
• #7141: Sales S/N Profit & Loss By Document Item Cost no value when last IN transaction is Stock Transfer. For accurate Item Cost, should refer to costing table
• #7180: Read MyKad auto-fill IDType and IDNo in Maintain Customer
• #7164: Enable to drag and drop from Stock Item Search to Print Bar Code (Window Printer)
• Add item price credit adjustment when editing Lazada sales invoice
• Fix Shopee failed to post refund orders with item price less than fees
• Fix Shopee posted sales credit note without shipping seller protection fee when order is completed without return, but escrow amount is negative
• Fix Lazada LazCoins discount labeled as transaction fee instead of discount
• Add Shopee delivery seller protection fee premium to sales invoice
• #7165: Stock Month End Balance report apply raise Dynamic SQL Error: Count of read-write Columns does not equal count of values
• Optimize performance of Process Deprecation and Open Deprecation
• Convert null values to zero for the number of fields in asset item when saving
• #7157: DIY Field - Boolean Data Type initial default value should be False
• Revise database upgrade scripts to compatible with firebird 3
• #7145: SL Invoice, Cash Sales, DN & CN Different TIN dialog should display company name
• #7148: Stock Batch Qty Lookup by default untick "Show Qty> 0" option
• [EIV-MY] #7149: GL Cash Book Entry Payment voucher default classification code change to 036
• #6944: Data Import - Assertion failure error on AR_Customer template load. Fix DBAccess OPF parameter value issue

SQL Accounting Latest Version (v863) Date : 07 Jan 2025

 

SQL Account 5.2025.1016.863

Released on January 7, 2025

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
• Database upgrade to version 209
• Fixed Stock Card Qty preview generate unlimited page
• #7144: AP & PH Document Listing detail duplicate if have same DocNo for diff supplier and filter this duplicate DocNo in report
• Fixed Shopee not posting shipping fee correctly for order with return item
• [EIV-MY] raise exception when edit and delete Request E-Invoice
• Database upgrade 207 add Progress Text Dialog for Convert Bool Script
• Bug: Database upgrade 207 progress bar not updating
• [EIV-MY] #7139: SL Invoice, Cash Sales, DN & CN upon save should only prompt TIN checking dialog for production environment and Doc Date > MyInvois StartDate
• #7140: Database upgrade 207 prompt unicode character mapping error
• Bug #7138: Access through COM should not prompt E-Invoice reminder
• #7137: Stock Batch Item Lookup add "Show Qty > 0" option
• Fix Lazada not posting promotional charges flexi-combo fees to sales invoices
• Adjustment to Lazada voucher seller amount

SQL Accounting Latest Version (v862) Date : 28 Dec 2024

 

SQL Account 5.2024.1008.860

Released on December 28, 2024

Release Notes

• [MyInvoisAPI]: 2027-12-27 MyInvois Maintenance
• #7130: Consolidate Cash Book E-Invoice and Self-Billed
• Adjust PH document listing "Consolidate No" column default visibility
• #7132: SL/PH Document Discount Value not deducted in Subtotal when Tax Inclusive is ticked
• [EIV-MY] #7133: SL Invoice, Cash Sales, DN & CN upon save prompt confirmation dialog if TIN is blank or different with Maintain Customer
• #7131: Sole Proprietor Company submit consolidate E-Invoice prompt TIN is not matching error
• [EIV-MY] #6952: Submit E-Invoice Buyer's EMAIL is empty even though have filled up Email in Maintain Customer

SQL Accounting Latest Version (v861) Date : 18 Dec 2024

 

SQL Account 5.2024.1013.861

Released on December 18, 2024

Release Notes

• Revise DB upgrade version 207. Run Boolean script convert in main thread to prevent random exception
• Fix E-Invoice submission error "Maximum allowed document size" is overridden by "Checking status" during batch submission
• [GST-SG] #7127: IRAS Guideline menu URL link is invalid
• #7126: Open GST Return form prompt field conversion error
• Fix for TikTok added duplicated entry of fees during sales invoice editing
• Revise database upgrade version 208 to truncate company profile IDNo
• #7121: Test E-Invoice Validation should be allowed in Production Environment only
• Fix unassigned and null boolean field value cases
• #7081: Acceptable transaction date context missing fixed asset module
• #7124: AR/AP Payment, CN, Contra & Refund, edit & save document which company & payment method is foreign currency, the ticked knockoff records will be deleted
• #7122: SQL Control Center DIY Fields should trim the field name if contains trailing spaces
• #7119: Stock Item Assembly Batch Update Cost unable to tick multiple Assembly Doc No
• Fixed GL Ledger-FOREX Gain Loss Knockoff date instead of Invoice Post Date.
• Fix Incomplete credential able to register in if client id is empty
• Fix unable to show production portal if active environment is sandbox
• Database upgrade to version 208
• Add MyInvois_FutureCred to support StartDate logic
• [EIV-MY] Add reminder to use production EIV on logon
• Add MyInvois_FutureCred field in SY_PROFILE table
• Resize MyInvois Info form and change font
• #7117: GL Stock Value should allow negative value
• Fix TikTok incorrectly added free of charge item to sales invoice
• Bug fix for WooCommerce order document item with output tax set for the stock item
• Add IRBM_InternalID column to SL/PH Document Listing
• Feature #7055: Stock documents entry and reports add Agent & Area fields
• Stock Physical Worksheet add Agent & Area filters and fields
• Stock Reorder Advice add Agent & Area filters and fields
• Stock Card Qty add Agent & Area filters and fields
• Stock Card add Agent & Agent columns on Detail grid
• Stock Analysis by Document add Agent & Area filters and fields
• Stock Document Listing add Agent & Area filters and fields
• Stock documents datamap add Agent & Area fields
• Stock Posting add Agent & Area fields
• Stock documents browse and entry forms add Agent & Area fields
• Stock documents data module add Agent & Area fields
• Stock documents entry and ST_TR tables add Agent & Area fields
• Fix MyInvois Dashboard Floating-Point divide by 0 exception on Win64 platform
• Fixed Asset Opening vs GL Maintain Opening Balance not correctly sum for opening balance
• Set tax inclusive to false for E-Commerce modules posted document
• [EIV-MY] Revise import check doc exist and single import
• Fix TikTok posted past invoice with incorrect document amount
• Feature #7100: Audit Trail add Online Approval replied message in Reference field
• AUDIT table Reference field upgrade from 255 to 1000 chars
• Company Profile add IDType & IDNo for Sole Proprietor e-Invoice support
• Add IDType and IDNo field in Company Profile and revise code to get Profile DS for MyInvois
• Add IDType and IDNo field in SY_PROFILE table
• #6763: AR/AP Deposit allow to edit Refund
• Adjustment to TikTok customer shipping fee value in sales invoice
• Includes total tax in WooCommerce sales order and invoices
• Replace the incorrect sku ID in TikTok fetched settlement data
• Check Shopee order is return order before posting shipping fee charge in sales invoices
• Support single day Shopee payment file's adjustment data
• #7110: Load Boolean Datatype DIY Field from file prompt Catatrophic Failure error
• #7107: Boolean Datatype DIY Field without default value prompt invalid argument error
• #7106: Support Boolean Convert for Maintain Form Mode SQL filter
• #7104: Profit Estimator prompt cannot access field as type Integer error
• Fix Year End boolean field bug
• #7103: Stock Month End Balance - Level 4 report prompt conversion error from string "1" error
• #7102: GL Project Profit & Loss with Cash Flow report CN should be grouped into 1 record despite multiple knockoff
• #7090: AR/AP Deposit Refund allow to select Doc Number Set & enter Doc Number manually

SQL Accounting Latest Version (v860) Date : 22 Nov 2024

 

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 Accounting Latest Version (v859) Date : 21 Nov 2024

 

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 Accounting Latest Version (v858) Date : 15 Nov 2024

 

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 Accounting Latest Version (v857) Date : 30 Oct 2024

 

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 Accounting Latest Version (v856) Date : 11 Oct 2024

 

SQL Account 5.2024.999.856

Released on October 11, 2024

Release Notes

• #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 Accounting Latest Version (v855) Date : 09 September 2024

 

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