SQL Accounting Latest Version (v812) Date : 08 Jan 2022

SQL Account 5.2022.925.812

Released on January 8, 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 Accounting Latest Version (v811) Date : 13 Dec 2021

SQL Account 5.2021.922.811

Released on December 13, 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

SQL Accounting Latest Version (v810) Date : 19 Nov 2021

SQL Account 5.2021.919.810

Released on November 19, 2021

Release Notes

• #5998: Ambank - Bank Recon - DR & CR Column in correct
• #5980: Ambank Islamic Bank Recon capture wrong year
• #5919 Incosistent auto match results in bank reconciliation
• Fixed Access violation when create supplier payment at auto bank recon
• #5986: Outstanding Sales/Purchase - Add all the Source Header in grid
• #6002: Maintain Stock Item browse grid Barcode code able to perform incremental search, sort, grouping and export to excel (filtering column is not supported)
• Feature #5218: Enable multi-select to all report forms
• #5670: Customer/Supplier Payment unable to Save if there is Refund Knock Off
• #6003: Tools | Options | Barcode format should prompt error when user enter "%" as delimiter
• #5999: Supplier Aging report Gain Loss not filter out by date
• Add Option To Change Code & Description font type for GL Trial Balance report
• Add Option To Change Code & Description font type for GL Balance Sheet Report
• Add Option To Change Code & Description font type for GL PnL Report
• Fixed SST Listing 3 preview error when using Deemed Supply & Data with []
• #5984: Stock Matrix grid columns become too small when captions are short
• Fixed Sales Invoice 8 (SST 2)-Listing-EMail mapping error
• #5988: Account Inquiry grid filter row default condition should be Contains instead of equal
• Feature #5983: Stock Item COM object set unicode to More Description become ???
• #5981: View | Purchase Price History add Landing Cost fields
• #5992: GL Bank Recon Listing date range set to 6 months
• #5996: Sales tax which had process SST can still change doc date
• Add Total for each company for Cust 12 Months Aging LS - Outstanding Service Tax report
• Convert Sales Customer Price History to FR3