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