SQL Accounting Latest Version (V765) Date : 08/10/2018

SQL Accounting Latest Version (V765)

Information

Last updated: 08/10/2018

Current version: 5.2018.841.765

Release notes

• Database upgrade to version 165
• SST-02 returns and listing process ready.
• Service tax based on payment basis ready.
• Transitional rules for Bad debt Relief and LPA (after 1 Sept - 29 Dec 2018).
• Asset value field added for final GST return
• Batch update value to Tariff code in Maintain Stock Item
• Tax date can set earlier than doc date.
• Added the exemption lookup field memorized by company at Customer/Sales and Supplier/Purchase document.

SQL Accounting Latest Version (V764) Date : 12/09/2018

SQL Accounting Latest Version (V764)

Information

Last updated: 12/09/2018

Current version: 5.2018.840.764

Release notes

• Database upgrade to version 164
• Add SST: Deemed Supply
• Change SEC1, SEC2, SEC3, PEC1, PEC2 & PEC3 tax description. Add tax code SEC4, SEC5, PEC4, PEC5
• Fixed Apply Report before 1 Sep 2018 error

SQL Accounting Latest Version (V763) Date : 06/09/2018

SQL Accounting Latest Version (V763)

Information

Last updated: 06/09/2018

Current version: 5.2018.839.763

Release notes

• Upgrade Database to Version 163
• Customer & Supplier Report add Tariff pipeline
• Company Profile datamap add SalesTaxNo & ServiceTaxNo
• Remove Tax Code & Add Tax Rate for GL Data Entry SST Format
• Remove Tax Code & Add Tax Rate for Customer Data Entry SST Format
• Remove Tax Code & Add Tax Rate for Sales Data Entry SST Format
• Remove Sales Invoice & Cash Sales Entry GST format
• Fix error in Maintain Tax: Could not convert variant of type (Null) into type (OleStr)
• SL/PH posting to AR/AP documents support Tariff

SQL Accounting Latest Version (V762) Date : 28/08/2018

SQL Accounting Latest Version (V762)

Information

Last updated: 28/08/2018

Current version: 5.2018.837.762

Release notes

• Upgrade Database to Version 162
• Add GL JV, GL OR & GL PV format for SST
• Remove AllowExpression option for GST Lampiran 4
• Prevent user change SST effective date earlier than 1 Sep 2018
• System will not assign GL CB & Journal default tax code (in Maintain GL Account) if different tax system
• Fix Maintain Tax change Tax Type not refresh Tax Rate problem
• Fix Maintain Tax New and Save tax code prompt "could not convert variant of type Null into type integer"
• #4759: Remove Default Output & Input Tax from Tools | Options. Maintain Tax add Default Tax checkbox. Document Entries Default Tax Logic will retrieve default tax based on tax system
• Feature #4760: Split SST tax codes to SL & PH
• Prompt user friendly message when GST return (MY) date to greater than 31 Aug 201

SQL Accounting Latest Version (V760) Date : 28/07/2018

SQL Accounting Latest Version (V760)

Information

Last updated: 28/07/2018

Current version: 5.2018.834.760

• Fixed Supplier Invoice,DN, CN (GST) export pdf some field partly shown
• Fixed Customer Invoice, DN, CN (GST) export pdf some field partly shown
• Fixed GST Bad Debt Relief - Sales-Part C17 preview error when value is 0
• #4709: GL Ledger - Report selection is not filter by Grouping level
• Fixed GL JV (GST) export pdf some field partly shown
• Fixed GL OR & PV (GST) export pdf some field partly shown
• Add Account code column for GL PnL - 13C1P format
• Fixed GL BS - 13C2P Account Description on 2nd page not properly shown
• Fixed Sales Credit Note 7 export pdf some field partly shown
• Fixed Sales Debit Note 7 export to pdf some field partly shown
• Fixed Sales Delivery Order 1 export to pdf some field partly shown
• Fixed Sales Order 7 export to pdf some field partly shown
• Fixed Sales Quotation 7 export to pdf some field partly shown
• Fixed GL PnL - 4C0P Export to Excel some field is hidden
• Fixed Sales Cash Sales 7 export to pdf some field partly shown
• Fixed Sales Cancel Note 7 export to pdf some field partly shown
• Fixed Purchase Return 7 export to pdf some field partly shown
• Fixed Purchase Request 7 export to pdf some field partly shown
• Fixed Purchase Invoice 7 export to pdf some field partly shown
• Fixed Purchase Debit Note 7 export to pdf some field partly shown
• Fixed Purchase Cash Purchase 7 (GST 1) export to pdf some field partly shown
• Fixed Purchase Cancel Note 7 export to pdf some field partly shown
• Fixed Purchase Order 7 export to pdf some field partly shown
• Fixed Sales Invoice 7 export to pdf some field partly shown
• Fixed QT, SO, IV & CS Format 7 GST 1 item detail not fully shown if item more then 36 records
• Fix Discount error if had tax inclusive for Sales Invoice 3 (Sales Disc)
• Fix Sales Quotation 7 (GST 2) export to pdf some field partly shown
• #4705: GL Cash Book & JE - Change account code freeze the application
• #4723: Maintain Account Industry Code should only visible for GST Malaysia only
• #4711: Supplier Refund knockoff Payment will prompt gain loss even is local currency

SQL Accounting Latest Version (V759) Date : 27/06/2018

SQL Accounting Latest Version (V759)

Information

Last updated: 27/06/2018

Current version: 5.2018.833.759

• Remove Record where LocalDR & LocalCR is 0 for GL Opening Balance
• Convert Stock Issue & Received Listing to FR3
• Fix GL BS - 3C1P & GL BS - 2C1P % for Fixed Asset is 0 if not Basic format
• Feature #4688: Add support of batch edit value for fast entry
• Convert GL Local - Ledger - Detail - Level 2 to FR3
• Fixed Sales Invoice 7 (GST 2) From Doc Date field column too short
• Fixed GL Trial Balance - This Year should hide account when DR & CR is 0
• Fixed GL Balance sheet Export to pdf some info shown partly
• Fixed GL PnL - 2C2P-Currency to pdf Account code shown partly
• Convert 99% of GL Profit & Loss report to Fast Report
• Fixed GST Summary Sheet - MY-20170106 double deduct for TX
• Fixed GST Summary Sheet - MY-20170106 Taxable Amount Grand Total should including Bad Debts Amount

SQL Accounting Latest Version (V758) Date : 08/06/2018

SQL Accounting Latest Version (V758)

Information

Last updated: 08/06/2018

Current version: 5.2018.829.758

• Add integration for SQL-POS
• Fixed GL PnL - 2C2P Export to pdf Account code shown partly
• Feature #4635: GL Balance Sheet Report Type Reposition & Set IFRS as Default
• Feature #4663: Allow user change Tax Code for all transfer documents (except IV/CS that transfer from DO)
• Update Sales Invoice 3 (GST 2) & (Sales Disc) fromat TaxAmt should shown 0 instead empty
• Update Sales Invoice 7 (GST 1) Tax Code alignment
• Update GL PnL - 4C4P header alignment
• Update Sales Invoice 7 (GST 2) header alignment
• Update Purchase Cancel Note 7 Tax Rate label sensitive with Tax Date
• Update Purchase Return 7 Tax Rate label sensitive with Tax Date
• Update Purchase Debit Note 7 Tax Rate label sensitive with Tax Date
• Update Purchase Cash Purchase 7 Tax Rate label sensitive with Tax Date
• Update Purchase Invoice TaxRate label sensitive with TaxDate

SQL Accounting Latest Version (V757) Date : 25/05/2018

SQL Accounting Latest Version (V757)
Information
Last updated: 25/05/2018
Current version: 5.2018.828.757

• Upgrade Database to Version 159 - Tuning TAX table
• Update Sales Cancel Note 7 Tax Rate label sensitive with TaxDate
• Update Sales Credit Note 7 Tax Rate label sensitive with TaxDate
• Update Sales Debit Note 7 Tax Rate label sensitive with TaxDate
• Update Sales Order Tax Rate label sensitive with TaxDate
• Update Sales Quotation 7 Tax Rate Label sensitive with TaxDate
• #4649: Access control fail in after upgrade to 756
• Feature #4647: Maintain Tax add fixed tax rate 6% for certain tax codes (GST transition period purpose)

SQL Accounting Latest Version (V756) Date : 23/05/2018

SQL Accounting Latest Version (V756)
Information
Last updated: 23/05/2018
Current version: 5.2018.826.756

• Upgrade Database to Version 158 - Tuning AP_SUPPLIERBRANCH, AR_CUSTOMERBRANCH and SY_PROFILE table
• Add Cust Local - Invoice Listing (GST 1) - Non Refund Deposit – 201806
• Fixed Input tax amount not correct when there is TX-ES for GST Summary Sheet - MY-20170106 report
• Fixed Export to pdf ROC shown partly for GL Trial Balance report
• Update Missing Agent & Area Parameter for GL Balance Sheet
• Update Missing Agent & Area Parameter for GL Profit & Loss in Fast Report
• Fixed Output Tax over deduct if had RSA for GST Summary Sheet - MY-20170106 report
• Fixed GST Summary Sheet - MY-20170106 should excluding NR for DN/CN & Fix Transactions NOt Included where Account Code is Empty
• Update GL Journal of Transaction & GL Journal of Transaction - Inbalance Alignment for Export to Excel
• Update Sales Invoice Tax Rate label sensitive with taxdate
• Update Sales Cash Sales Tax Rate label sensitive with taxdate
• Feature #4640 Add AR/AP Fast Entry for Invoice
• #4641 Update for GST Amendment from 6% to 0% (effectively 01 Jun 2018)
• Add Display customer or supplier location on the Google Maps
• Feature #4639 Reduce time for the Upgrade to Version 157
• Feature #4597: Add invoice document date to GST and GL trans description for bad debt relief and bad debt recovered

SQL Accounting Latest Version (V755) Date : 20/04/2018

SQL Accounting Latest Version (V755)
Information
Last updated: 20/04/2018
Current version: 5.2018.823.755

• Add Sales Local - Sales Order Listing (GST 1)-SO2PO format

• Add Sales Invoice 7 (GST 1) (SubTotal) report

• GST Audit Report support datamap

• GST Summary Sheet - MY-20170106 Output Tax for CN & DN Adjustment should excluding OS & OS-TXM

• Fixed GST Summary Sheet - MY-20170106 TX should excluding TXCG

• Fix GL PnL - 13C1P-SinglePage not follow font style & size set in XML

• Add GST Audit-Footer F11 report

• Fixed GST Detail 3 - GST-03 & GST Detail 3 - GST-03-2018 shown duplicate on item 16 when many Draft GST

• Remove GL Trial Balance - This Year v GAF (Footer) report

• Convert GL PnL - 13C1P-SinglePage to fast report

• Update GL Ledger FR3 Alignment for export to excel

• Update GL Profit & Loss FR3 Alignment for Export to Excel

• GST Summary - Fix Input Tax double deduct when had CN

• Update GST Summary Sheet - MY-20170106 Alignment for Export to Excel

• Update Sales Invoice 7 Alignment for Export to Excel

• Update GL Trial Balance Alignment for Export to Excel

• Fix GL Local - Ledger - Detail - Level 1 should hide when zero

• Fixed GST Summary Sheet - MY-20170106 Input Tax for CN/DN should excluding TX-NC

• Feature #4602: GL Profit & Loss Always Hide Retained Earning if Print Sub Account Only is select

• Increase column size for GL PnL - 6C4P report

• Update Cust Overdue Letter-(with other Info) Alignment for Export to Excel

• Update GL BS - 13C1P-SinglePage & 2C1P Alignment for Export to Excel

• Update GL BS - 3C1P Alignment for Export to Excel

• Fix GL Stock Value Project Description not shown & Footer Description not correctly shown

• Update Sales Invoice 7 (GST 2) Alignment for Export to Excel

• #4584: Unable to transfer empty item code from IV to CN

• #4577: Incorrect display format for Overdue Limit in Maintain Customer

• Feature #4576: Analyse Data Integrity add "Repost ST Documents"

• #4595: Slow response using URL attachments

• Feature #4597: Rename GST and GL trans description for bad debt relief and bad debt recovered

• Feature #4349: Add record count indicator to bad debt relief and bad debt recover caption on GST bad debt form

• Update RMCD GST TAP

SQL Accounting Latest Version (V754) Date : 14/03/2018

SQL Accounting Latest Version (V754)
Information
Last updated: 14/03/2018
Current version: 5.2017.822.754

• Fix Cust Overdue Letter-(with other Info) Company header not shown if more then 1 page per customer

• Fix #4572 Error prompted after preview the customer statement group where either total DR or CR are zero.

• Add Company & CompanyBranch pipeline for EMail for Customer & Supplier Statement

• #4573: Balance Sheet Retain Earning Description set at Tools | Option not function

• Remove Negative symbol for Stock Transfer Listing

• Fixed GST Lampiran 2-with ZR not including IM-CG

• Fixed GST Lampiran 2 not including IM-CG

• #4500: Stock Physical Worksheet & Reorder Advice Reports have inconsistent stock result if group by location and batch (if item has transaction in SO/PO but no transaction in ST_TR table)

• Fixed GST Summary Sheet - MY-20170106 Input Tax should exclding BL & OP tax

• Fixed GST Summary Sheet - MY-20170106 Bad Debts should excluding from DN/CN Section

• Fixed GST Detail 3 - GST-03-2018 not including IM-CG

• Feature #4575: Allow NS tax code to select in Purchase side

• Feature #4561: Auto correction to ZP for EP, RP, GP transactions

• Convert to 0 if found any negative value in TAP text field 10, 11, 12, 13, 14, 15, 16 for GST GST-03-2018

• #4556: BizObject - Post Stock Received without itemcode prompt Division by Zero

• Feature #4555: Add Bank Islam Third Party Transfer file format

• Feature #4547: RHB ePayment - Format update

• Feature #4325: Allow user to encrypt CIMB Bulk Payment text file

SQL Accounting Latest Version (V753) Date : (09/02/2018)

Warm Reminder: Always make sure your SQL Account version are UP-TO LATEST VERSION 753. To ensure the submission correctly for GST Return taxable。

温馨提醒：记得确保您的SQL帐户版本是最新的版本753，以便提交正确的消费税给关税局。

SQL Accounting Latest Version (V753)
Information
Last updated: 9/2/2018
Current version: 5.2018.819.753

New in this version
Compliance to the latest GST Accounting Software guide (05 Feb 2018).

1. New Tax Code : IM-CG
2. Existing Tax Code (EP, RP, GP, NP) will be marked as INACTIVE.
3. Revised the tax code description for OP, NS,and ZP.
4. New GST-03 format*.
5. New TAP upload text format*.

SQL Accounting Latest Version (V751) Date : 30/11/2017

SQL Accounting Latest Version (V751)
Information
Last updated: 30/11/2017
Current version: 5.2017.817.751

New in this version
• Database upgrade to version 153
• Feature #4438: Document batch lookup add qty column and option "View Qty"
• Create index for ST_TR (Batch) to speed up performance for Batch Qty Lookup
• Feature #4438: Document batch lookup add qty column and option "View Qty"
• Add GST Bad Debt Relief - Purchase-Adj-Input & Output Tax format
• Add feature #4442: List invoices where bad debt relief or bad debt recover already happened based on taxable period
• Bug #4441: GL Cash Book & Journal should allow to save if detail invoice date greater than document date within same month (Change to confirmation dialog)
• Pascal Script support TcxCustomEditProperties.Alignment.Horz property
• Update GL Journal of Transaction - Inbalance.fr3 add Export list to text
• Bug #4433: Location lookup become slow when the items has huge stock transactions in same location. Location lookup add option "View Qty" for performance issue user can untick this option
• [Win64] - TClientDataSet.XMLData prompt Access Violation
• Convert Customer Statement with Orig Amt to Fast Report
• Convert Customer Statement - Group to fast report
• Bug #4431: Maintain Batch Unable to AutoRun Code
• Bug #4437: Access Right - File | Import no function
• Bug #4416: Stock Batch Lookup "New" should be disabled if no purchase batch modules
• Feature #4423: Auto post the stock value when click apply on GL Trial Balance, Balance Sheet and P&L Reports
• Fixed Cust Statement 12 Mths 1-Fixed Month had extra unknown field & no decimal point for Open Credit Amount
• Fix application prompt override access right window twice even though ADMIN override the access right
• Fix bug #4434: GST taxable button is visible on document entry window if document default window is detail window
• Feature #4060: Lookup New Entry supported for all master entry forms
• Convert Customer & Supplier Listing to Fast Report
• Fix bug #4415: Report form data grid auto append a record if press "Down" arrow key on grid
• Bug #4426: GL Journal Listing Filter by Doc No prompt error
• Add GST-Penyata Pembekalan Diberi Perlepasan CBP (RS) report
• Check tax type of input and output tax of easy GST bad debt before process GST return