SQL Accounting Latest Version (V779) Date : 24/07/2019

SQL Account 5.2019.869.779

Released on July 24, 2019

Release Notes

• Reduce Column Usage on FR3 Export to excel for Stock Item without Category - Exception Report
• Reduce Column Usage on FR3 Export to excel for Sales Picking List
• Reduce Column Usage on FR3 Export to excel for Sales Profit & Loss By Document
• Reduce Column Usage on FR3 Export to excel for Sales Yearly Analysis
• Reduce Column Usage on FR3 Export to excel for GL Cash Flow Statement
• Reduce Column Usage on FR3 Export to excel for Customer Aging
• Fixed Supp 12 Months Aging Title now correctly shown
• Reduce Column Usage on FR3 Export to excel for GL Journal of Transaction - Post and Tax Date Exception
• Reduce Column Usage on FR3 Export to excel for Customer Due Document Listing
• Fixed Sales Invoice 3 (Sales Disc) Total Discount is shown Double Amount
• #5226: SST Listing - Change the tax column filter type to Equal instead of Contains if double click on the Tax Code
• Fixed Stock Reorder Advice (with POnSO Info) report Item Description Overlap
• Reduce Column Usage on FR3 Export to excel for BOM Material Usage - JO vs SO Variance
• GL Balance Sheet, P&L, AR/AP Statement & Aging enable add and delete button for report format selector for release version (SQL Connect purpose). Remove "Change Content" button and use double click grid record instead
• #5240: ComObject - Unable to post customer refund if payment method without default document number set
• #5258: BizObject - Unable to change database
• Feature #5255: DIY Field add new datatype "URL"
• #5244: Create new customer prompt error "Invalid floating point operation" in Windows XP SP3
• #5230: AP Invoice Fast Entry prompt "Do not have access rights to override Supplier Invoice" even user has access right
• #5234: GL Bank Reconciliation prompt Access Violation error when set Entry Mode
• Feature #5229: GL Bank Reconcilation support real time graph

SQL Accounting Latest Version (V779) Date : 22/07/2019

SQL Account 5.2019.868.779

Released on July 22, 2019

Release Notes

• Reduce Column Usage on FR3 Export to excel for Stock Item without Category - Exception Report
• Reduce Column Usage on FR3 Export to excel for Sales Picking List
• Reduce Column Usage on FR3 Export to excel for Sales Profit & Loss By Document
• Reduce Column Usage on FR3 Export to excel for Sales Yearly Analysis
• Reduce Column Usage on FR3 Export to excel for GL Cash Flow Statement
• Reduce Column Usage on FR3 Export to excel for Customer Aging
• Fixed Supp 12 Months Aging Title now correctly shown
• Reduce Column Usage on FR3 Export to excel for GL Journal of Transaction - Post and Tax Date Exception
• Reduce Column Usage on FR3 Export to excel for Customer Due Document Listing
• Fixed Sales Invoice 3 (Sales Disc) Total Discount is shown Double Amount
• #5226: SST Listing - Change the tax column filter type to Equal instead of Contains if double click on the Tax Code
• Fixed Stock Reorder Advice (with POnSO Info) report Item Description Overlap
• Reduce Column Usage on FR3 Export to excel for BOM Material Usage - JO vs SO Variance
• GL Balance Sheet, P&L, AR/AP Statement & Aging enable add and delete button for report format selector for release version (SQL Connect purpose). Remove "Change Content" button and use double click grid record instead
• #5240: ComObject - Unable to post customer refund if payment method without default document number set
• #5258: BizObject - Unable to change database
• Feature #5255: DIY Field add new datatype "URL"
• #5244: Create new customer prompt error "Invalid floating point operation" in Windows XP SP3
• #5230: AP Invoice Fast Entry prompt "Do not have access rights to override Supplier Invoice" even user has access right
• #5234: GL Bank Reconciliation prompt Access Violation error when set Entry Mode
• Feature #5229: GL Bank Reconcilation support real time graph

SQL Accounting Latest Version (V778) Date : 04/07/2019

SQL Account 5.2019.867.778

Released on July 4, 2019

Release Notes

• Upgrade Database to 172
• Reduce Column Usage on FR3 Export to excel for Sales Invoice Listing
• Add Customer Deposit Listing Reports
• Reduce Column Usage on FR3 Export to excel for Cust Local Invoice Listing Report
• Reduce Column Usage on FR3 Export to excel for GST Maintain Tax report
• Reduce Column Usage on FR3 Export to excel for GL Transaction Summary Report
• Reduce Column Usage on FR3 Export to excel for GL Receipt & Payment Report
• Reduce Column Usage on FR3 Export to excel for GL Bank Reconciliation Report
• Reduce Column Usage on FR3 Export to excel for GL Account
• Fix GL Payment Voucher Detail RTM report shown incorrect information if in Foreign Currency
• Reduce Column Usage on FR3 Export to excel for Supplier Aging Reports
• Reduce Column Usage on FR3 Export to excel for Sales Invoice Reports
• Reduce Column Usage on FR3 Export to excel for Customer Statement Reports
• Reduce Column Usage on FR3 Export to excel for Supp Statement Report
• Reduce Column Usage on FR3 Export to excel for Maintain Supplier Listing Report
• Reduce Column Usage on FR3 Export to excel for Supplier Listing report
• Customer Statement Add Security Deposit Amount
• Reduce Column Usage on Export to excel for Tools Maintenance Reports
• Fixed Supp-Local&Multi-L1-04 Mths Aging-Current,1 Mth... report format mapping not correct
• #5214: GL Bank Reconciliation prompt Date Encode error
• Update Sales Analysis By Document to support group by DocDate
• Open GL Balance Sheet & Profit Loss prompt error could not convert null to string
• Fixed Cust Local Payment Listing Collection Report-Service Tax GrandTotal for DocAmount no Decimal Point
• Feature #5188: SL/PH Analysis by Document add DocDate for Group/Sort By
• Feature #5217: Change Access Right Description for Stock Batch to Maintain Batch
• #5159: GL/AR/AP/Stock Documents Copy Paste Prompt "the record has been changed by another user" (exclude UpdateCount field during copy paste)
• #5203: BizObject Unable to change user if using ComServer.Login function
• #5088: SSM Reg No or CTOS lookup prompt error for Windows 7