SQL Account Releases
SQL Account 5.2020.895.794
Released on 17 Dec 2020
Release Notes
- #5678: AR/AP Balance Report’s Current Balance & C/F incorrect when Refund knockoff CN falls in different month
- Fixed GL Bank Reconciliation Report – Clear Transaction not sorting
- Fixed GL Bank Reconciliation Report – Clear Transaction Transactions not only shown once when there is Same DocNo
- Update SST-02 (2019) Add Digital Tax Refund Calculation
- Fixed GL PnL – Comparison – 22C1P preview error when user use – when 0 as displayformat
- Auto Get Buying Rate from Maintain Currency when Currency Rate is 1 for GL PnL Currency report
- Auto Get Buying Rate from Maintain Currency Currency Rate is 1 for GL BS – 3C1P-IFRS-Currency report
- Fixed SST Listing 4-DST-02(2020) Preview Error when Tariff more the 15
- #5653: Maintain Stock Item if have multiple UOM with rate=1, should allow to change rate if IsBase is unticked
- #5690: Prompt access violation error when Customer/Supplier Code format is %.3s-%.0s%.4d
- Ignore tax return checking on document if GST/SST is not started
- #5673 User able to access Sales Analysis by document when user did not purchase S&P module
- Feature #5672: Stock Take sync stock item add new field – Shelf
- #5669: Supplier bank account lookup does not exclude inactive record
SQL Account 5.2020.885.789
Released on 06 Jun 2020
Release Notes
- Upgrade Database to Version 178
- Add Dashboard
- #5529: Process SST SV with Past IV Project Code is empty
- #5521: Points Entry Grid Caption for Code incorrect
- #5512: Grid cell always align to right on display dpi other than 100%
SQL Account 5.2020.880.786
Released on 06 Mar 2020
Release Notes
- Upgrade Database to Version 176
- Fixed Sales & Price History Group by DocNo, Tax & Tariff shown incorrect grouping information
- #5486: Import Serial Number with Prompt Replace Unit Price Dialog prompt error control has no parent window
- #5494: AR Payment edit and change “From Deposit” to another deposit not update the Deposit Amount in AR Deposit
- #5492: GL Maintain Opening Balance 2nd Description is empty
- #5489: Customer Refund slow after choose customer code if knockoff has over 1k records
- Feature #5427: Maintain Item Template add Location & Project fields
- #5475: GL Cash Book – Save Prompt Error if user empty the Amount Column
SQL Account 5.2020.879.785
Released on 01 Feb 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 Account 5.2019.878.784
Released on 10 Dec 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 Account 5.2019.877.783
Released on 12 Nov 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 Account 5.2019.876.782
Released on 21 Oct 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 Account 5.2019.874.781
Released on 25 Sep 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 Account 5.2019.872.780
Released on 29 Aug 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 Account 5.2019.869.779
Released on 24 Jul 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 Account 5.2019.868.779
Released on 22 Jul 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 Account 5.2019.867.778
Released on 04 Jul 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 Account 5.2019.866.777
Released on 08 May 2019
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 Account 5.2019.865.776
Released on 18 Apr 2019
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