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

SQL Accounting Latest Version (v854) Date : 08 August 2024

SQL Account 5.2024.992.854

Released on Aug 8, 2024

Release Notes

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

SQL Accounting Latest Version (v853) Date : 05 August 2024

SQL Account 5.2024.991.853

Released on Aug 5, 2024

Release Notes

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

SQL Accounting Latest Version (v852) Date : 23 July 2024

SQL Account 5.2024.990.852

Released on July 23, 2024

Release Notes

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

SQL Accounting Latest Version (v851) Date : 18 June 2024

SQL Account 5.2024.987.851

Released on June 18, 2024

Release Notes

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

 

SQL Accounting Latest Version (v850) Date : 28 May 2024

SQL Account 5.2024.986.850

Released on May 28, 2024

Release Notes

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

SQL Accounting Latest Version (v849) Date : 17 May 2024

SQL Account 5.2024.984.849

Released on May 17, 2024

Release Notes

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

 

SQL Accounting Latest Version (v848) Date : 13 May 2024

SQL Account 5.2024.983.848

Released on May 13, 2024

Release Notes

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

 

SQL Accounting Latest Version (v847) Date : 08 May 2024

SQL Account 5.2024.982.847

Released on May 8, 2024

Release Notes

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

 

SQL Accounting Latest Version (v846) Date : 01 April 2024

SQL Account 5.2024.981.846

Released on April 1, 2024

Release Notes

• Fixed Cust Multi - Invoice & Debit Note Listing - Level 1 (with other CNnOR Info) -
  Local OS Amount not shown when no Knock off Information
• Add SST Listing 1-SVE6 & SVE8 reports
• Fix Lazada editing sales invoice item's UOM incorrectly
• Add Shopee reverse shipping fee SST to sales credit note
• Fix EasyStore posted discount incorrectly
• Fix TikTok not posting non refund order with negative settlement amount incorrectly
• Fix TikTok shipping fee adjustment calculation in sales credit note
• #6857: SST-02A after apply prompt dynamic SQL error
• [Peppol-SG] Fix Sales Invoice/CN send peppol failed prompt Access Violation error and
  refine error message
• #6855: Asset disposal cost, accum depreciation, net book value are not updated after
  select an asset item
• [SST-MY] #6853: Opening SST Taxable in Past Invoice on 31/12/2023 should show 6%
  instead of 8%
• #6795: Maintain Customer & Supplier Listing report form should follow entry form's access
  right setting