SQL Account Releases | SQL Account Releases & History updates

SQL Account Releases

SQL Account 5.2022.947.825

Released on 11 Nov 2022
Release Notes
  • Add Asset Label 80mm X 45mm format
  • Reduce Lazada fetch order limit from 100 to 50
  • #6363: AR/AP Analysis by Document report’s Payment column should be no value if the payment and bounce date are fall in the same date range.
  • Lazada combine “Other Services-Marketing Fees” and “Wrong Weight Adjustment” record into single order’s payment
  • Fix Stock Take IsValid batch number check doesn’t check for batch number with no item code bind to it
  • Lazada change payment form voucher column value type to FMTBcd
  • Fix Shopee transfer sales invoice to credit note raised transferred quantity is greater than balance quantity
  • Fix transfer sales invoice using wrong IVDTLKey value when transferring item from sales invoice
  • Allow non stock item in Shopee sales order to be transferred to sales invoice
  • Fix AddToCart export stock JSON file prompt exception when description is empty.
  • Fixed Tax & TaxRate Grouping Summary not correctly group if have mixture empty & null data
  • #6351: AP/AR Fast Entry prompt invalid class typecast error
  • #6356: Incorrect decimal place on stock card grid
  • #6353: SL/PH document entries transfer from other document the SubTotal will be incorrect if user modify SubTotal in the source document
  • GL Account Entry should check if the deleted bank/cash account’s parent is not root account before add the parent account to payment method
  • #6347: Stock Item Assembly Detail UOM lookup’s Cost column should hide if user no right to View Cost
  • #6349: Audit Trail Summary open form slow when data is large
  • #6340: Customer Payment unable to back to Browse if using Tab docking & Form Mode with Split Browse & Detail Option

SQL Account 5.2022.946.824

Released on 28 Oct 2022
Release Notes
  • Add Asset Opening vs GL Maintain Opening Balance format
  • Add Remark1,Remark2, Description2 and StockGroup Fields for MergeItemCode pipeline for Sales & Purchase Data Entry format
  • Fixed GL Ledger – Detail Reports 2nd Description not correct shown
  • #6343: Asset analysis report depreciation summary doesn’t filter by trans date
  • Fix Shopee return refund variance and reverse shipping fee calculation for partial refund credit note
  • Accept Shopee return details with status ACCEPTED instead of just REFUND_PAID status is allowed
  • Add stock item’s remark 1 and 2 fields to Stock Take import JSON file
  • Remove Lazada transaction records that does not contain paid status
  • #6339: Unable to save after paste an asset item already disposed
  • #6337: Process Date does not follow Date To on Process Depreciation window
  • #6342: Accum depreciation account wrongly posted in JV if process depreciation group by project only
  • #6285: GL Cash Book, AR/AP Payment, Refund & Deposit Listing include bounced document and show as red color in report grid
  • Feature #6338: Add AcquireDate field to Yearly Depreciation, Asset Analysis reports
  • #6288: Journal Entry – Show label out of balance if not tally
  • #6329: GL Profit & Loss Statement allow to print opening balance 1 day before System Conversion Date
  • #5480: Stock Assembly’s Show in Tree Mode dialog OK & Cancel buttons misaligned when resize the form
  • #6332: Supplier payment unchecked knockoff invoice prompt “Dynamic SQL error”
  • #6330: AR/AP Deposit Refund & Forfeit’s Agent & Area should follow Maintain Customer/Supplier by default

SQL Account 5.2022.945.823

Released on 19 Oct 2022
Release Notes
  • #6328: Document Entries prompt invalid value for field “Seq” error when insert more than 32 detail records
  • Fixed Stock Assembly-JO vs AS Variance format the variance % value to returns as 100% if JO qty is zero
  • Add Security Deposit Amt for Supp Statement 06 & 12 Mths 1 format
  • #6296: SL/PH Doc Entries search From Doc No in detail grid’s filter row raise error
  • #6274: Stock Item Assembly disable the transfer from Job Order in browse mode
  • #6323: Stock Analysis By Document report’s grouping tick Stock Group prompt error “Field Item Code Not Found”
  • Lazada payment should exclude balance transactions amount into transaction details
  • #6308: User can cancel customer credit note knockoff invoice contains SV although knockoff tax date already processed
  • #6320: Incorrect value for SQty in print outstanding production job order listing report
  • Fix TikTok does not include shipping fee in credit note for full refund order.
  • Fix Lazada does not open credit note for marketing fee payment
  • Fix TikTok combine payment information doesn’t sum up fields value
  • Support Shopee payment file in Thai language
  • Fix TikTok shipping fee not included in adjusted credit note
  • Fix TikTok credit note does not include discounted shipping fee by platform
  • Add applied Shopee coin amount per order item for partial refund calculation
  • Fix Shopee not applying shipping fee to order and fix refund variance calculation for partial refund order
  • Fix fetch product show incorrect item code when similar SKU is used across multiple item code
  • Remove buyer ship from Shopee shipping calculation and fix Shopee partial refund posted incorrect invoice and credit note.
  • Prevent Shopee payment form from editing invoice and credit note
  • Fix Shopee refund order with negative escrow amount failed to post invoice and credit note
  • Fix TikTok sent empty array to API server
  • Fix TikTok doesn’t fetch all products
  • Database upgrade to version 189
  • Fixed Check Different Between Ledger vs Aging should exclude cancelled document
  • Fixed Shown unknown value when company Logo empy for GL Official Receipt – Detail – Full report
  • Update GL Multi – Ledger – Detail – Level 1 show Currency Data if have mix currency
  • Add Fixed Asset module
  • Add report templates
  • Add license module – Fixed Asset
  • Add Asset Disposal data entry
  • Add Open Depreciation window
  • Add Depreciation Listing report
  • Add Process Depreciation window
  • Add Depreciation Processor
  • Add Asset Analysis report
  • Add Yearly Depreciation report
  • Add Asset Item data entry
  • Add Asset Group data entry
  • Add Asset module tables
  • Fix Multiple audit trail records posted after create a new stock batch record with detail batch item
  • Feature #5927: Maintain Item’s BOM grid add move up & down buttons
  • Feature #6266: GL Cash Book, AR/AP Payment, Refund, Deposit, SL/PH Order, Cash Sales and Cash Purchase add BankChargeAccount fields
  • Add BankChargeAccount field to report form
  • Add change BankChargeAccount dialog to ui form
  • Add BankChargeAccount field to data module
  • GL_CB, AR/AP Payment, Refund, Deposit, SL/PH Order, Cash Sales and Cash Purchase add BankChargeAccount fields
  • #6315: All report grids enable Filter Row except Stock Card
  • #5951: Cannot focus a disabled or invisible window if split browse & detail window have ticked in form mode
  • #6006: SL/PH Doc Entries should clear Discount last memorized value when user edit any existing doc entry
  • #6318: Auto Bank Recon CIMB Bank empty result
  • #5142: Add Landing Cost with Currency Symbol
  • #6319: Exclude Deposit Account in Cash Sales Payment method
  • Feature #6292: Document Entry grids add Insert Row Above & Insert Row After options in context menu
  • Maintain Item – Adjust buttons position
  • #6314: Sales PnL S/N by Document report & Sales Profit Estimator S/N Cost are incorrect if a serial number has more In/Out transactions (e.g stock transfer or CN)
  • #6307: Apply P&L Statement with ledger information raise Error : conversion error from string “C1”
  • Feature #6206: Barcode (F8) Form add search item by serial number for stock qty out documents
  • Fix AR/AP Deposit Refund form label font height to default settings

SQL Account 5.2022.942.822

Released on 22 Sep 2022
Release Notes
  • Fix Lazada combined different date marketing fees.
  • Verify transaction by matching released amount to avoid mixing transaction from different account
  • Fix Lazada failed delivery order not canceled after shipped back to seller.
  • Fix Shopee failed to knockoff order’s credit note without invoice.
  • Fix Shopee not posting credit note when escrow amount is negative and order is not canceled or returned.
  • Fix Shopee showing incorrect discount value.
  • Fix Lazada not showing expired token message.
  • Fix Shopee fetch cancelled order by buyer show logistic.error_param exception
  • Add Customer Listing – Credit Control format
  • Fixed GL OR & PV Amount not Including TaxAmt
  • Fixed OR & PV batch print for RTM format not correct shown Amount
  • Add Supp Local – Deposit Listing – Level 1 – Tally with Balance Sheet format
  • #6297: Stock Analysis By Document add RefPrice & RefCost grid columns
  • Feature #6291: ComObject add PlainTextToRichText & RichTextToPlainText function
  • #6262: GL Bank Reconciliation should use Debit(Net) column for auto bank recon if Merge Bank Charges is ticked
  • #6287: GL P&L Statement prompt access violation when filter by project with Ledger Information
  • #6284: Sales Invoice Tax “SR” ledger posting is missing when user edit document date that fall in year 2022 which is not GST era
  • [GST-SG] #6280: Open Sales Invoice raise Access violation error after start Singapore GST. Revise Company Profile Peppol APIKey & Secret editing issue
  • #6283: GL Profit & Loss Print Project comparison prompt error “List index out of ranged” if Project parent nodes have repeated same value
  • #6276: Run Repost Stock Transactions prompt arithmetic numeric overflow exception error
  • #6300: Fix Maintain Project Range Editor btnMoveUp & btnMoveDown icon and on click error

SQL Account 5.2022.940.821

Released on 30 Aug 2022
Release Notes
  • Database upgrade to version 188
  • Fixed SST-02 (2020) 13(3)(i) Description not fully shown
  • Fixed SST Listing 4-DST-02 (2020) preview error
  • Fixed GL PnL – Comparison format Column 1 header not consistent & add Custom_Header & Use_Year_Info functions
  • Fixed GL BS – Comparison format Column 1 header not consistent & add Custom_Header & Use_Year_Info functions
  • Add SerialNumber List for Merge Same Itemcode for Purchase Invoice, DN, CN, GRN & Cash Purchase
  • Add SerialNumber List for Merge Same Itemcode for Sales Invoice, DN, CN, DO & Cash Sales
  • Fixed GL PV Report Amount Incorrect Shown if Company is Foreign Currency
  • Fixed GL OR Report Amount Incorrect Shown if Company is Foreign Currency
  • Add Peppol SG export and import
  • User can set or change company profile country except GST or SST is started
  • Feature #3366: Increase DocNo, Ref & DocRef fields length to 40 characters
  • Data modules increase Ref/DocRef fields length from 25 to 40 characters
  • Data modules and logic increase DocNo field length from 20 to 40 characters
  • Increase D_DocRef field length from 25 to 40 characters
  • Increase D_DocNo field length from 20 to 40 characters
  • Feature #6265: Stock BOM Listing report add Detail Batch lookup
  • #6271: Maintain Location support DIY Field
  • Fix Shopee escrow amount negative unable post as cancelled invoice
  • Fix Shopee customer refund shouldn’t have unapplied amount
  • Fix Shopee incorrect shipping Fee, should be bundle discount
  • Fix Lazada fetch product raise access violation
  • Shopee load payment error total amount is less than payment amount
  • Fix Shopee order did not show cancel reasons
  • Fix Auto Bank Recon Maybank empty result
  • Fix Shopee load payment error missing dataset property
  • Fix item code and leading description not shown in credit note.
  • Fix Lazada payment amount cannot less than or equal to zero.
  • Fix Woocommerce order mapping item will prompt access violation
  • Fix tiktok payment new excel file format
  • Fix Shopee payment did not amend IV and CN if release amount < 0
  • Revise Shopee order refund variance description from Shipping Fee to Return Refund Variance
  • Revise Shopee retry fetching to show appropriate error message
  • Feature: Shopee able to batch enable and disable accounts
  • eCommerce order should show “Posted” when user post posted orders again
  • Feature #6245: Journal entry prompt error message to show amount not balance
  • Feature #6097: Show Last Doc Information by Company
  • #6242: GL Bank Reconciliation – Mark All and Highlighted not update Balance Figure
  • #6257: Unable to shown Full in Category Code in Maintain Item
  • #6255: Fix Customer & Supplier Deposit some UI not fully shown
  • #6247: Maintain Opening Balance – change message Account Not Balance to Out of Balance
  • #6176 Auto Bank Recon – Add CIMB BizChannel format
  • #6150 Auto Bank Recon – AMBANK New Statement Format
  • #6268: Maintain Customer running code format if contain fixed numeric char will cause the code keep increasing digits
  • #6269: Tools | Options | Misc | Show Document Project by default ticked for new database
  • Feature #2421: BOM Planner report add JO Qty & Avail Qty columns
  • #6172: AR/AP Bill & Collection/Payment report add Option Show in Foreign Currency
  • #6264: GL Bank Recon prompt confirmation message when user click Clear All
  • #6225: AR & AP Aging Report – Move the position of the Apply button
  • Feature #6256: AR/AP Deposit master data support DIY Field
  • Stock Take json file add customer/supplier items
  • #6118: Maintain Stock Item BOM’s Batch column will be truncated if length exceed 20
  • Feature #6219: Analyst Data Integrity – Unticked SQL Control Center
  • Feature #6248: GL Account Lookup enable New label
  • #6252: AR/AP Invoice Fast Entry button enabled state should follow New Button
  • #6258: Customer & Supplier Currency Code should not allow to change if any tables have transactions reference to it
  • #6263: Customer Due Listing – TaxAmt for CN should be in negative value
  • #6261: Maintain GL Account should remove new parent deposit account in Maintain Payment Method when drag child account under it
  • #5770: Unable to perform transfer from document using region format (Indonesia)
  • #6260: Stock Month End Balance report Unit Cost Display format not correct
  • Feature #6240: Customer/Supplier Balance Report – Add Sort & Filter by Control Account
  • #6250: GL PnL & Balance Sheet reports add missing options in parameter dataset
  • #6254: Maintain GL Opening Balance remove Open Deposit entry button

SQL Account 5.2022.939.820

Released on 03 Aug 2022
Release Notes
  • Fixed GL Local – Ledger – Level 1-SSTDeferred error when DocType is JE & OR
  • Fixed GL Opening Balance not fully shown amount
  • Fixed Cust Local – Due Document Listing – Outstanding Service Tax Linking detail not correct
  • Fix Shopee product fetch item id is not found error
  • Revise Lazada payment on fetching marketing fee from API
  • Fix: Shopee V2 account linking
  • Fix Shopee order wrong tracking no
  • Fix Shopee order status PROCESSED should be status READY TO SHIP
  • Revise Shopee order posting to include Product Discount Rebate from Shopee and Voucher
  • Revise Tiktok payment to post adjustment
  • Fix Tiktok order wrong shipping fee
  • Com objects BizApp’s FindKeyByRef support multiple References

SQL Account 5.2022.938.819

Released on 22 Jun 2022
Release Notes
  • Database upgrade to version 187
  • Support Online Payment link for Customer Statement & Invoice reports
  • Enable support Payment Link for Cust Statement 06 Mths 1 – with Orig Amt & Sales Invoice 8 (SST 2)-Aging format
  • Add SQLAcc.Lib.bpl for report script to access external function
  • Revise Auto Bank Recon messages when compiling
  • Feature #6234: Outstanding Document Listing add Remark 1 & remark 2
  • Feature #6233: Sales PnL By Document & Sales Serial Number PnL add DocRef1, 2, 3, 4 & DocNoEx
  • Add E-Commerce EasyStore
  • Fix: eCommerce payment should set project and payment project
  • Revise eCommerce order
  • Fix: eCommerce incorrect item UOM when post to quotation
  • Fix: Lazada payment able to load in multiple payment cycle
  • Fix: Lazada payment post date will be the last day of payment cycle
  • Fix: Lazada payment when posting reversal items
  • Fix: Shopee order multiple bundles with same item will not grouped
  • Fix: Shopee post payment wrong shipping fee charged
  • Fix: Auto Bank Recon MBB statement balance not showing
  • Feature #6223: Add To Cart – Export Stock Add columns for filtering
  • Feature #6209: Request to add fromDocNo in Job Order report
  • Feature #6185: Allow Batch Inactive Item Code for Maintain Stock Item
  • #6221: Fix item document flow is showing not related items
  • #6212: Auto Bank Recon out of memory when the loading large pdf
  • #6193: Fix GL Maintain Stock Value’s Box Alignment
  • #6178: Print audit trail find text with single quote with cause dynamic SQL error
  • #6138: Account Inquiry Description shows special symbol & as _
  • #6180 Bank Recon – Add Debit Net column for Load Statement View when Merge Bank Charges
  • Fixed Purchase Order 3 (Simple) Description Not correctly shown when merge same item code enable
  • Fixed Customer Statement with Orig Amt Shown 0.00 amount
  • Add Purchase Invoice 8 SST format
  • Fixed preview error & Rename Maintain Tax Listing
  • Fixed Preview Error on Product Activation Code
  • Add Stock Qty Balance (with Multi-UOM) – Level 1 report
  • Add Depreciation & Net Book Value Report Format
  • Fixed GL OR & PV for RTM error when Amount is Zero
  • Sales Local & Multi – Invoice Listing add ItemCode Summary
  • Sales Local – Invoice Listing (Tax 1) add ItemCode Summary
  • Fix Sales Quotation 8 (SST 2) shown GST label instead of Tax
  • Feature #6214: All AR/AP Browse & Detail Forms KnockOff Grid add Agent and Area fields
  • #6203: Rich Text Editor pre-select a font type shouldn’t change to another type after user start typing text
  • #6220: Customer/Supplier auto running code unable to increase when next number > 10k
  • #6216: AR/AP Payment Posted from Cash Sales/Cash Purchase – Payment Method Field should disable
  • #6210: Stock Document Listing remove the Detail columns from main grid
  • #6205: GL Bank Reconciliation edit hang when huge records
  • #6157: Close Grid Properties window prompt error access violation
  • #6161: Past AR/AP Deposit Entry if users edit and change amount shouldn’t affect GL Opening Balance
  • #6183: When tick more filter conditions in any Reports main grid then preview report will prompt Midas.dll access violation error
  • #6198: Stock Aging & Stock Analysis by Document reports hide cost columns when user has no “Show Cost in Stock Item Maintenance” right
  • Feature #6186: Stock Month End Balance report add Unit Cost column
  • Add E-Commerce Tiktok
  • Fix shopee return order posting to CN prompt total amount error
  • Feature: Lazada payment transactions will fetch directly from Lazada
  • Feature #6001: AR/AP Deposit Refund allow edit Agent, Area & Description
  • #6228: Stock Available Balance | Back Order Detail prompt error when drill down Job Order document
  • #6231: Customer Payment when save raise error access violation in module MIDAS.DLL (Knockoff has more than 400 records)

SQL Account 5.2022.934.818

Released on 01 Jun 2022
Release Notes
  • Fix eCommerce will not delete item if contain FOC in description
  • #6162 Fix E-Commerce Lazada payment statement missing payment ref id
  • Fix: Shopee payment posting for Lost Compensation
  • Adjust: Lazada voucher fill into discount
  • Adjust Lazada payment fees will update payment date to delivery date
  • Adjust: Shopee payment to be able to parse Chinese and Malay file
  • Revise eCommerce payment to post marketing fee and normal transactions in one payment
  • Fix bug: Lazada payment verify order wrongly
  • #6171 Auto Bank Recon – Request Add Indicator
  • Fix Alliance Bank Auto Bank Recon not a valid date error
  • #6144: Fix Auto Bank Recon RHB statement with different format
  • #6114: Auto execute apply after loading statement in bank reconciliation
  • Fix: Auto.BankRecon.HLBBMY last transaction’s description is parsed wrongly
  • Fixed GL BS – Comparison – 7C1P No line for Total Project Column
  • Add EMail & Checking for Phone1 only shown when not empty for Ecommerce Invoice reports
  • Remove the lines gap in Stock Assembly-JO vs AS Variance report
  • #6149 Fix Foreign Bank Adjustment incorrect currency rate format casting
  • #6163: Stock Card Prompt Error when double click on Deemed Supply document
  • #6175: Payment method records “Cloud Banking” not set to “None” after create new database
  • #6165: Delivery Order new appended record not position at last row after deleted some transferred document items from Sales Order
  • Feature #6166: GainLoss Posting Date dialog display alert message when user change GainLoss posting date
  • #6168: AR/AP Bill & Collection/Payment Report missing Currency column when group by Currency
  • Feature #2953: GL P&L & Balance Sheet Print Project Comparison’s Project panel add IsActive column
  • #6151: Audit Trail Summary form Field Name is empty if Update Permit number
  • #6159: Add DtlKey, Seq fields to Outstanding Job Order report BOMComponent dataset
  • Revise UI alignment
  • GL P&L and Balance Sheet report enlarge report format grid to prevent report name display in 2 lines
  • Fix Open GST Audit File prompt Invalid Date error
  • #6145: Sales and Purchase entry forms Transferable checkbox not position properly
  • #6143: Document Entry Form click “Edit As New” prompt Abstract Error when using Form Mode

SQL Account 5.2022.932.817

Released on 23 Apr 2022
Release Notes
  • Fix: Shopee order cancelled IV did not post CN
  • Fix: Shopee payment file format updated not able to load
  • #6117: Fix UI alignment issue in Bank Deposit
  • Fix Auto.BankRecon.RHBBMY invalid numeric input error
  • Fix Cust Local – Due Document Listing – Level 1 (Tax) unable group by Doc Project
  • Fixed SST SST-02A-2019 preview error
  • Fixed SST-02(2019) preview Error
  • Revise WhatsApp implementation
  • [GST-SG] Revise GST F5 Report Header from “GOODS AND SERVICES TAX ACT (CAP 117A)” to “GOODS AND SERVICES TAX ACT 1993”
  • #6117: Fix UI misaligned issue
  • #6126: Open SST Deemend Supply window prompt error “Invalid stream format”
  • #6122: All Reports’ Group By check list box by default should focus first item
  • Fix: Woocommerce to include fees when posting invoice
  • Fix: Shopee order incorrect amount when order over charged
  • Fix: Shopee payment unable to detect past order
  • Fix Ecommerce report 3 display all item from different invoices
  • Fix Shopee fetch order access violation error
  • Fix Lazada payment CN over knockoff IV and CF
  • Adjust eCommerce order to default sorting by account, date and id
  • Fix: Auto.BankReconAISLMY incorrect parsing of debit and credit
  • Fix RHBBMY incorrect closing balance amount
  • Add Sales P&L By Document(for eCommerce Customer Only) & summary format
  • Add Stock Assembly-JO vs AS Variance format
  • Fix Gain Loss Date > Aging, ledger vs aging will not tally for report Check Different Between Ledger vs Aging
  • Reduce Column Usage on FR3 Export to excel for Sales Local – Cash Sales Listing – Z Report format
  • Remove Sales Local – Delivery Order Listing (GST 1) format
  • Reduce Column Usage on FR3 Export to excel for Purchase Local – Purchase Invoice Listing (Tax 1) format
  • Reduce Column Usage on FR3 Export to excel for Purchase Local – Purchase Return Listing (Tax 1) format
  • Reduce Column Usage on FR3 Export to excel for Purchase Local – Debit Note Listing (Tax 1) format
  • #5454: Audit Trail Event Type AAA change to Security

SQL Account 5.2022.931.816

Released on 29 Mar 2022
Release Notes
  • Database upgrade to version 186 – Add ObjectID column to SY_VIEW table
  • #6112: Stock Transfer prompt error “Ancestor for ‘Panel1’ not found” upon open form
  • Fix Process pending service tax prompt error “Division by zero”
  • #6113: Sales Profit Estimator “Use Last IN Cost When Qty <= 0" show incorrect unit cost when there is negative stock balance before Last IN qty transaction
  • #6068: Add Audit Trail for Override for “Save on Negative Quantity”. Audit Trail Report add “AAA” event type
  • #6103: GL Cash Book, AR/AP Payment & Refund Entry Forms Bank Balance label caption should retrieve from Payment Method Journal. Cash Flow Inquiry Bank column caption rename to Bank/Cash
  • #6106: AR/AP Refund Gain Loss show full Local Amount when edit with full KO
  • #6098: Unable transfer to CN/SC once the IV/PI has been transfered to Extra DO/EG. Add “Transfer to CN/EG” in Extra DO/EG
  • #6096: Tools | Options | Misc – Display Format grid should display fully
  • #6101: Tools | Options | Customer, standalone unable to untick the Options “Perform Tax/Local Amount Rounding”
  • #6092: Cash Sales before prompt payment change dialog should prompt message if customer code is empty
  • #6087: Sales Invoice’s Item Template unable to show all item if access right Override Sales Min/Max Price with 0 ref price
  • #5446: SL/PH Document Entries when click “Edit as New”, detail record sequence will sort incorrectly if the records been moved seq before

SQL Account 5.2022.929.815

Released on 28 Feb 2022
Release Notes
  • Reduce Column Usage on FR3 Export to excel for Sales Points format
  • Reduce Column Usage on FR3 Export to excel for Purchase Local – Cash Purchase Listing (Tax 1) format
  • Fix #6081 Preview SST-02 (2020) format error
  • Fixed Sales Invoice 11 item Discount not shown
  • Fix Shopee order access violation if orders has no return
  • Fix eCommerce order post to QT status customer code not matched
  • Fix eCommerce post to QT ecommerce item description should be in description 2
  • Fix eCommerce print report error field item code not found
  • Fix Lazada payment detail replaced wrongly
  • #6091: Available Stock Balance form’s grid export to excel prompt Invalid file name error since the file name contain colon symbol
  • #5447: Open Any SL/PH Entry Forms will prompt Access Violation if enable Auto Logon and untick Command Navigator
  • #6088: DIY Advance Form Design’s Component Palette not display fully
  • #6089: Application shouldn’t open form when user click cancel in Form Mode selection dialog
  • #6086: Customer/Supplier Deposit Prompt Error when the deposit is transfer to Payment & with Refund
  • #6076: Unable to scroll Stock Value grid of Maintain Stock Value in browse mode
  • #6083: Sales & Purchase Price History Group/Sort by not fully showed as no scrollbar
  • #6082: GL Journal Entry prompt “Combination of account type “CL” and special account type “CH” is not supported error when choosing Cash account under Current Liabilities

SQL Account 5.2022.927.814

Released on 07 Feb 2022
Release Notes
  • #6055: [Automation]: Add Reconnect mechanism
  • #6054: Maintain Stock Item DIY Script – OnBeforeSave prompt error “Delta is empty”
  • #6056: Customer/Supplier Listing Group/Sort By UI control not display fully
  • Fix Flicker in report previewer shown in MDI form
  • Screen flicker when closing Available Stock Balance
  • Fix Prompt Install WebView2 due to windows update

SQL Account 5.2022.925.812

Released on 08 Jan 2022
Release Notes
  • Fixed Cust Statement 12 Mths 1 report Batch email error
  • Fixed Lazada payment not able to fetch order with modified order no
  • Fix eCommerce product mapping should return success when item code same as sku
  • #6033: GL Cash Book, AR/AP Payment & Refund show payment method balance should check on Account Inquiry – Inquire G/L Account access right
  • Change Job Order next number to 3 for sample database
  • Add Stock Month End Balance – Location in Column & Stock hysical Worksheet – Location in Column Reports
  • Fixed GL Local – Ledger – Level 1-SSTDeferred report – Error when have CN transactions
  • Feature: eCommerce able to replace as cancelled invoice
  • Fix Lazada account column should shows shop name instead of account email address
  • Adjust: eCommerce edit IV and CN to keep serial number in document note
  • Adjust: eCommerce will not delete detail if has batch no or serial number
  • Adjust: Lazada payment will update IV to untick cancelled
  • Fix Lazada payment has only payment fee and caused divide by zero error
  • Fix eCommerce order will replace remark 2 for non stock item
  • Fix eCommerce order append FOC in description for product with 0 item price
  • Fix Shopee payment should edit IV when release amount is 0
  • Fix Shopee order return refund only process order with status REFUND_PAID
  • Feature #6026: Stock Analysis by Document enable save grid layout
  • Feature #6024: Add support of item barcode lookup to Print Barcode (Windows Printer)
  • #6023: Credit note unable to auto knock-off if transfer from invoice and insert negative value record
  • #6018: Purchase Invoice edit and save prompt “Unable to rollback inactive transaction” error when using Region setting “Malay(Malaysia)”
  • #6020: AR/AP Fast Entry disable grid column sorting
  • Fix Auto bank recon Maybank not able to detect statement format and header
  • [GST-SG] Purchase Returned with TXRC tax code should post as negative value in GST Return
  • #5618: Stock Physical Worksheet should generate based on Location Lookup values
  • #5734: Stock Item Opening Balance Location Drop Down missing Qty
  • Feature #5933: User Access Right Assignment Request Add Option for Mark All and Clear All
  • #5926: Stock Item BOM raise error when Qty change to blank
  • #6013: All Documents Entries’ Note UI control unable to load image from rich text editor
  • #6012: Sales Invoice – Document_Company.”Outstanding” not set displayformat
  • #5620: Local Item Sales amount is incorrect, it is not in negative value
  • Feature #6016: Tools | Options | Barcode | Stock Take add Lock Qty Editing & Lock Re-Scanning S/N options

SQL Account 5.2021.922.811

Released on 13 Dec 2021
Release Notes
  • Fixed Stock Card – Location + SerialNo StockGroup total not correctly sum
  • Fixed Sales Invoice 8 (SST 2)-Aging should take DocDate
  • Add GL PnL – 13C13P-SinglePage format
  • Remove hardcode display format for Supplier IV, Supplier DN & Supplier CN format
  • Remove hardcode display format for Customer IV, Customer DN & Customer CN format
  • Change PnL-Comparison – Monthly (12 Months) report template to default print to GL PnL – 13C1P-SinglePage format
  • Reduce the GL PnL – 13C1P-SinglePage right margin
  • Reduce Column Usage on FR3 Export to excel for Customer due Listing report
  • Reduce Column Usage on FR3 Export to excel for Customer Aging 12 Months & GainLoss report
  • Reduce Column Usage on FR3 Export to excel for Stock Transfer
  • Reduce Column Usage on FR3 Export to excel for SST Listing
  • #6010: Customer Pricing Inquiry raise error : List index out of bounds (0)
  • #6015: Maintain Customer new Customer code incorrect add additional 1 in middle
  • Feature #4218: GL Cash Book, AR/AP Payment & Refund Entry Forms Show Bank Balance
  • #5796: Perform editing and save an deleted DO record deduct stock quantity.
  • #6011: Customer Pricing Inquiry unable to retrieve correct price if set by company
  • Fix GL Balance Sheet & P&L consolidate error if using firebird server with port no
  • Fix View item flow is not DPI-aware
  • #6009: General tax purchase invoice not allow save on closed SST return period
  • Move NextCloud Stock Take UI to Tools | Options | Barcode
  • Reduce Column on export to Excel for Supplier reports
  • #6004 – New Customer raise error: Unable to commit inactive transaction
  • Fix Shopee payment did not replace shipping fee
  • Fix: Lazada payment does not have post date on customer refund
  • Fix: eCommerce payment sub item is not deleted
  • Fix: Lazada payment didn’t post to customer IV / CN for past marketing fee
  • Fix bug: eCommerce posting IV should set discount field to empty
  • Fix bug: Lazada order not appending shop id to order id for 3rd duplicated order
  • Fix eCommerce order footer alignment
  • Fix eCommerce order item name and variation does not shows in QT
  • Fix eCommerce item been replaced if same item code
  • Fix Woocommerce order not able to fetch
  • Extract name, ref1, ref2 from PDF for auto bank recon
  • Add Stock BOM Wastage with Amount report
  • Fix GL/AR/AP/SL/PH Entries Form labels that show Currency Symbol missing
  • #5994: Apply job order listing report takes long time to show result when there are more than 150000 batch records
  • Blob Edit prompt “Invalid Typecast” error for non-DB aware grid
  • #6005: GL Balance Sheet & P&L Report Condolidate Grid show empty record
  • Fixed Sales Outstanding Sales Order Listing – Level 1 (DocFlow) not including Cash Sales

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info