SQL Accounting Latest Version (v785) Date : 01 February 2020

SQL Account 5.2020.879.785

Released on February 1, 2020

Release Notes

• #5391: Sales Profit Estimator should convert to customer currency when click "Update Unit Price" button
• #5467: SL Invoice unable to posting via BizObject If Exceed Credit Limit with overridden permission
• #5048: Should not prompt dialog if user set Overdue or Credit Limit to 0 and the user allow to override
• #5468: Add calculator editor numeric column in GL Cash Book and Journal Entry
• Feature #5440: Document Transfer Dialog by default filter 7 Months from target document DocDate
• Feature #5453: AR/AP Documents browse grid add 2nd company name column
• Feature #5437: All GL Account Lookup add 2nd Description column
• #5457: COM client cannot capture invalid logon credential

SQL Accounting Latest Version (v784) Date : 10 December 2019

SQL Account 5.2019.878.784

Released on December 10, 2019

Release Notes

• #5417: GL Profit Loss & Balance Sheet - Fixed Date params show as number
• Stock Purchase Planning (Current & Next 3 months) report file has fixed Get SQty instead of Qty for PO and SO in each months.
• Fixed Customer CN full page formate Company Header overlaping the Company Logo
• Fixed Discount Amount not shown when using Disc Column for Sales Invoice 3 (Sales Disc)
• Feature #5412: Stock Transfer Listing Report add "SubTotal (Tax)" column in detail grid
• #5413: Stock Transfer Listing "Actual Amount" should sum up for IN qty amount only
• #5419: GL Ledger untick "Include Zero B/F with Transactions Before" should determine by LocalBalance instead of Balance field as some account has Local value but foreign value is zero
• #5418: Supplier Analysis by Document grouping 1 level but show level 2 report on screen
• #5421: GST-SG the box 13 should refer to net sales because box 4 has including CN in F5 return
• #5433: AR/AP Statement's Balance not sum correctly
• Rename SST-02 file name
• Add Sales Local - Sales Order Listing (Tax 1)-SO2PO Report
• Add Sales Local - Cash Sales Listing - Z Report
• Add Sales Local - Cash Sales Collection Report
• Add Stock Purchase Planning (Current & Next 3 months) report
• Feature #5410: SL/PH Invoice & Cash Sales add "Transfer To Credit Note" option
• Feature #3660: Document Entries that has payment info and has been reconciled with bank upon user click edit/delete will prompt confirmation message

SQL Accounting Latest Version (V783) Date: 12/11/2019

SQL Account 5.2019.877.783

Released on November 12, 2019

Release Notes

• #5359: List index out of bound error when double click GL PnL or Balance Sheet Format
• Add GL Bank Reconciliation Report - Clear Transaction Report
• #5395: Enable sync via USB cable using Stock Take App
• #5403: Customer Payment Deposit Drop down unable to show Description
• #5394: Customer Statement Report same date if got two Payment Transactions (OR) should sort by docno instead of amount
• #5381: GL Account delete Prepayment Account raise Access Violation error

SQL Accounting Latest Version (V782) Date: 21/10/2019

SQL Account 5.2019.876.782

Released on October 21, 2019

Release Notes

• Upgrade Database to Version 175 - Tunning Table SY_PROFILE, AR_CUSTOMER, AP_SUPPLIER, GL_CBDTL, GL_JEDTL, GST_TR_DRAFT, GST_TR & AR_CUSTOMERBANKACC table
• Add Sales Points-Summary report
• Fix Sales Points-Statement Error when no Balance c/f is zero
• FR3 Report - Reduce Column Usage on FR3 Export to excel for Sales Quotation 8
• Add Sales Points Listing Report
• Fixed Sales Yearly Analysis Export pdf line become not straight
• Feature #5352: Enlarge the Height for Group/Sort By
• Sales Points should exclude Point where less then 0
• Update Sales Points-Statement Footer Notes
• Convert Stock Transfer Listing to FR3
• #4919: Click "Read MyKad" button does nothing

SQL Accounting Latest Version (V781) Date: 25/09/2019

SQL Account 5.2019.874.781

Released on September 25, 2019

Release Notes

• Upgrade Database to Version 174 - Add SL_PT & ST_Take table
• Fixed SST Listing Summary Tariff not shown
• Reduce Column Usage on FR3 Export to excel for Sales Local - Cash Sales Listing (Tax 1)
• Add Cust Local - Due Document Listing - Outstanding Service Tax report
• Fixed Cust Local - Invoice Listing - Level 1 preview error
• Feature #5351: GL P&L, Balance Sheet, AR/AP Aging & Statement Report forms' report template add Load & Save buttons
• Feature #5320: IV/PI Fast Entry add CompanyName
• Feature #5344: Enlarge the Document Number Display till max

SQL Accounting Latest Version (V780) Date: 29/08/2019

SQL Account 5.2019.872.780

Released on August 29, 2019

Release Notes

• Upgrade Database to Version 173 - Tunning SY_USER table
• Change title to GL Opening Balance for GL Opening Balance report
• Fixed Sales P&L By Document - Level 2 export pdf line become not straight
• Feature #5273: Support advance password policy
• Feature #4959: Process SST return prompt list of outstanding service invoices over 12 months
• Bug #5285: BizObject - System will Prompt Catastrophic error or hang
• Feature #5251: View Sales/Purchase Price History Add Fields (Doc Description, Branch Name, DocRef 1-4, DocNoEx, CC & Country)
• Feature #5274: Sales/Purchase Price History Grid add Detail Seq column
• #5281: Search Reg No prompt error

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

SQL Accounting Latest Version (V777) Date : 08/05/2019

SQL Accounting Latest Version (V777)

Information

Last updated: 08/05/2019

Current version: 5.2019.866.777

Release notes

• Enhance, Retuning & Fixed Report
• Add Customer Invoice Listing - Outstanding Service Tax
• Enable support Customer Deposit Refund for GL PV
• Fixed Item 18a Not Printout even preview had shown
• #5157: System shouldn't assign default SST tax code for document entries which is before SST Effective Date
• #5151: DIY Script - Cash Sales - Prompt Insufficient Privilleges If the user don't had access right to Override Credit Limit
• Feature #5117: Find & Open Documents in Detail Entry
• Feature #5118: Main Menu support right click Browse/Entry mode options for all entry forms (like Maintain User)
• Feature #5132: Bank Reconciliation add past 6 statements graph for Bank Closing Amount
• Feature #5119: SL/PH QT, SO & DO add right click "Transfer To" other documents option in detail form

SQL Accounting Latest Version (V776) Date : 18/04/2019

SQL Accounting Latest Version (V776)

Information

Last updated: 18/04/2019

Current version: 5.2019.865.776

Release notes

• Enhance, Retuning & Fixed Report
• Feature #5052: All SL & PH reports add Tariff grid column, filtering and Group/Sorting
• #5061: Stock Card & Stock Month End Balance shouldn't show non stock control item even tick include zero balance
• #5065: AR/AP/SL/PH Reports Company branch pipeline not display properly on certain customer/supplier
• Feature #4926: GL P&L & Balance Sheet Consolidation support Total and Total Percentage columns
• Update 01. SST SST-02-2019 to shown the item 18A
• Feature #5109: GL/AR/AP/SL/PH Document Listing, SL/PH Price History & Sales Picking List report add all document master fields in grid
• Fixed GL OR - Fast Report - Amount not correct shown in Customer Deposit when in multi currency
• Add Option for Hide/UnHide Account Code for GL Profit & Loss
• Add Option for Hide/UnHide Account Code for GL Balance Sheet
• Fixed 01. SST SST-02-2019 Tariff count not including null
• Update GST F5 Return with Due date & GST No
• Add bank JomPAY file format
• #4971: Allow posting via BizObject If Exceed Credit Limit with overridden permission
• #5068: SST-02 Drill Down Form unable to drill down to source document
• Feature #4967: Customer Deposit Refund/Forfeit grid, Forfeit record DocNo should be display as Customer Deposit DocNo. Added support for edit Forfeit document entry.
• Feature #5037: GL/AR/AP/SL/PH document Entries forms by default open entry as NEW (if user has right), otherwise default to browse form. (without Form Mode condition)
• Fix error of Maybank Universal Payment file format (telegraphic transfer payment mode)
• Feature #5107: AR/AP Company & GL Account lookup by default search by Description field
• Feature #4784: AR/AP Fast Entry add Tariff Code field
• AR/AP Invoice Fast Entry add highlight for error records

SQL Accounting Latest Version (V775) Date : 26/02/2019

SQL Accounting Latest Version (V775)

Information

Last updated: 26/02/2019

Current version: 5.2018.862.775

Release notes

• Enhance, Retuning & Fixed Report
• #5035: Fix SST Listing SQty field display format
• #4998: SST listing report contain record with SR if the invoice contains detail with SV and SR
• #4990: Stock BOM Planner On Hand Qty double up when BOM list have selected 2 same components
• #5021: Sales Price History report "Document_CompanyBranch" pipeline not link properly to main pipeline
• #5024: Fast Report - Stock Card will show Dataset Category does not exist
• Convert GL OR & GL PV Detail (with other CNnOR info) to FR3
• Fixed Sales Quotation 8 (SST 2) still show total exclude gst / total include gst
• #5038: IMSV did not post the imported service tax 6% in SST-02 listing if the company is service tax registered
• Upgrade Database to Version 171 - Tunning SST_PROCESS, SST_TR & SST_TR_DRAFT table
• Add SST registered option on start SST wizard form and make IMSV active only for non-SST Registered user
• Feature #4946: Add "Use Invoice Ext. No as Invoice Number for Payment Detail" option on GIRO param form
• Feature #5016: Company Profile UI update
• Feature #5027: Allow Special Account Type for under the Normal Account (reverted changes of Bug #4916)
• Feature #5017: Company Profile Set Report Header include SST No
• #5007: GL OR contain "SV" payment basis tax code should include in SST Process logic that debit Deferred SST account and credit Service Tax Account
• #5013: GL Cash Book add Local Amount & Local SubTotal (Tax) in grid
• #5018: Maintain GL Account once created new account under non-current asset, it will auto scroll down to the new account code
• #5028: Maintain Item Opening Stock Batch field is limited to 20 even is support 30 char
• #4976: Stock & Purchase Documents Barcode entry (F8) if untick Show Cost access right, should hide unit price, discount & amount fields
• SST Return add friendly message to "offset value exceeded balance value" error that stated PM and IV docno
• #5003: GL Journal select Tax code prompt Abstract Error
• Add Deemed Supply to Repost & Recalculate Costing
• Feature #4993: Maintain Tax disable input tax & output tax and hide "Switch to Easy Mode" button

SQL Accounting Latest Version (V774) Date : 24/01/2019

SQL Accounting Latest Version (V774)

Information

Last updated: 24/01/2019

Current version: 5.2018.860.774

Release notes

• Enhance, Retuning & Fixed Report
• Add SST SST-02A-2019 format
• Add SST-02A report
• Feature #4905: Add Permit No, Item Code and SQty to SST listing for future Customs requirement
• Feature #4964: New tax code for imported service SVA, PSVE, IMSV & IMSVE (supplier/purchase entry) which should declare and paid the service tax in SST-02. Non-SST register users able to use SST tax code and SST-02A report.
• Add Non-SST Registered option on new SST return window
• Add New Tax Code: SVA, PSVE, IMSV, IMSVE. Maintain Tax Browse form add "Easy Tax" category and Easy Tax's Output & Input Tax Lookup include inactive & General tax code.
• Feature #4973: Company Profile add PostCode, City & State fields.
• Feature #4931: Add SST Taxable entry for Opening service tax invoices outstanding
• Feature #4957: Add Sales Tax and Service Tax number fields in Maintain Customer & Supplier
• [SST-MY] Feature #4956: Add new tax code "SVE" for service tax exemption
• #4941: Service tax invoice paid the double entry become not balance after edit the Account code
• Fix customer name is empty after read from MyKad