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