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

SQL Accounting Latest Version (V773) Date : 19/01/2019

SQL Accounting Latest Version (V773)

Information

Last updated: 19/01/2019

Current version: 5.2018.859.773

Release notes

• Enhance, Retuning & Fixed Report
• #4961: Incorrect result of SST-02 item 19 if sales tax number and service tax number are empty
• Fixed Deemed Supply for SST Title out of alignment
• Add support of preview customer CTOS lite report
• #4922: Unable to edit sales invoice document detail (remark1) if the tax is SV and without payment knockoff after process SST return
• #4966: Customer Deposit should not allow to add deposit refund/forfeit if Unapplied Amt = 0
• #4917: Rename GL Account Code "SST-Kastam" didn't update the account code reference in Tools | Options | GL
• Feature #4892: Rename KnockOff GST Date to KnockOff Tax Date
• Feature #4950: Maintain Customer & Supplier browse screen add Mobile field in field chooser

SQL Accounting Latest Version (V772) Date : 13/12/2018

SQL Accounting Latest Version (V772)

Information

Last updated: 13/12/2018

Current version: 5.2018.855.772

Release notes

• Enhance, Retuning & Fixed Report
• Fixed Stock Issue & Receive Listing Summary not filter by document
• Fixed GST Detail 4 - Mixed Supplies Column 7 calculation not correct
• Fixed Customer/Supplier Statement Aging some with 0 not shown as -
• #4949: Preview deemed supply document in entry mode but the report contains all records
• Fixed TX-RE Should Exclude 0% - GST Detail 4 - Mixed Supplies reports
• #4909: Drill down from SST-02 report shows empty if process as draft
• #4929: Cash Flow Forecast Report GL Cash Book PD cheque not showed
• Fixed TX-RE not match with Screen for GST Detail 4 - Mixed Supplies reports
• Fixed GST Detail 4 - Mixed Supplies-2018 Column 7 calculation not correct
• Maintain Customer & Supplier Support SSM Registration Number Lookup
• #4713: Credit Limit control dialog freeze when save document in multi user environment
• #4928: Cash Flow Forecast grid misalign
• #4921: Fix at end of table error
• #4891: DataSet not in edit or insert mode error

SQL Accounting Latest Version (V770) Date : 30/11/2018

SQL Accounting Latest Version (V770)

Information

Last updated: 30/11/2018

Current version: 5.2018.853.770

• Upgrade Database to Version 169
• Add Table: SST_TR_DRAFT & SST_TR_ADJ_DRAFT
• Enhance, Retuning & Fixed Report
• #4897: SST-02 report show company name under sales tax and service tax columns even though the company has sales tax number or service tax number only
• Add Cust Local - Contra Listing - Collection Report-Service Tax report
• Add Batch EMail function to GL PV fr3 format
• Fixed GL PnL - 13C1P format export to excel some data is hidden
• Enable support CurrencyToLangWord function for Sales CN format
• Enable support CurrencyToLangWord function for Sales CS format
• Add Sales QT 8 SST format
• Enable support CurrencyToLangWord function for Sales QT format
• Fixed GL PnL - Project Summary (20 Rows) for invalid font type
• Enable support CurrencyToLangWord function for Customer Statement format
• Enable support CurrencyToLangWord function for Sales IV format
• Enable support CurrencyToLangWord function for GL PV format
• Enable support CurrencyToLangWord function for GL OR format
• Fixed GL Official Receipt - Detail - Full (SST) shown in half page
• Update Cust Local - Contra Listing - Collection Report-Service Tax for more detail info
• Update Cust Local - Payment Listing - Collection Report-Service Tax for more detail info
• Show Draft copy for SST SST-02 process as Draft
• #4900: Save Customer Payment Prompt "cdsDocDetail dataset not in edit mode" Error

Feature #4838: Add the SST-02 draft features

#4788: Unable to unchecked default if there is only one default tariff record

#4846: Item tariff code will not update in PH document where default tax code is BLANK or not SST tax type in Maintain Supplier.

#4895: Unable to edit sales invoice document detail remark1 after process SST return

#4804: Supplier Invoice Fast Entry, when Prompt duplicate & delete will not be able to save changes

#4879, #4880: "Share content" icon overlap with others button when preview report; switch MDI to tab docking mode prompt abstract error due to radial menu is visible on screen

Journal Entry: confirmation dialog not prompt when change account code

#4906: Cash Sales with payment prompt Access Violation

#4907: GL Cash Book - Item description is overridden by built in description in copy and paste operation

SQL Accounting Latest Version (V769) Date : 12/11/2018

SQL Accounting Latest Version (V769)

Information

Last updated:12/11/2018

Current version: 5.2018.850.769

Release notes

• Upgrade Database to Version 168
• Tunning Table: PD_JO
• Enhance, Retuning & Fixed Report
• Increase Column Header Hight for GL Balance Sheet & PnL Report to support 2 line caption
• Add GetShareText Function for Purchase Order Format
• Add GetShareText Function for Sales DO format
• Enable support Share Message for Customer Statement using QT
• Fixed Sales Quotation 7 format EMail Template not able get Default Template if report not in the list
• Fixed Sales Invoice 7 to 9 format EMail Template not able get Default Template if report not in the list
• Enable support Batch Email & using QT as Share Message Template for Sales Quotation 7 format
• Enable support using QT as Share Message template for Sales Invoice 7 to 9 format
• Feature #4873: GL P&L & Balance Sheet missing parameter field - Print Consolidate
• Enable support Deposit Module for GL OR & PV - Detail (SST) report
• Fixed GL Receipt & Payment report Overlap in total
• Fixed Sales Local - Invoice Listing (GST 1) - SLvsAR report name
• #4874: Prompt Error when create new Job Order
• #4878: Unchecked bounced cash book prompt error "Table unknown TAX_PROCESS"

SQL Accounting Latest Version (V768) Date : 02/11/2018

SQL Accounting Latest Version (V768)

Information

Last updated: 02/11/2018

Current version: 5.2018.849.768

Release notes

• Upgrade Database to Version 167
• Tunning Table: SY_PROFILE
• Add Table : AR_DP, AR_DPDTL
• Enhance, Retuning & Fixed Report
• Add GetShareText Function for Sales Quotation format
• Add GetShareText Function for Sales Invoice format
• #4863: Financial Consolidated Report
• GL Balance Sheet Report support Consolidation between databases
• GL Profit & Loss Report support Consolidation between databases
• Update label for Purchase PI, CP, SD & SC Listing GST to Tax
• Update label for Sales IV, CS, DN & CN Listing GST to Tax
• Update SST-02 - Limit tariff to 10 record for Page 2 & add Page 5 to list all Tariff records
• #4858 Stock Card Not match with Month End Balance
• #4857: SST-02 Report B1 should excluding Exempted transaction
• Feature #4851: GL Ledger Report "Merge GL Code for same document" option should apply to P&L Accounts only
• Fixed Sales Quotation 7 (GST 2) Description3 overlaping
• #4844: Partial Delivery Transfer slow if has many items (Tick/Untick all & selection and tick document record all are slow)
• Set document form size to to 1000 x 600
• Feature #4866: Add link to get Google API key
• #4868: Access Violation when using Form Mode with split browse & detail windows option
• Feature #4865: Company Profile - Consolidate Alias change to friendly name
• #4588: Customer Deposit
• Insert Deposit Account into Maintain GL Account and Payment Method
• GL Account add "Deposit" special account type (together with bank & cash special account type)
• Tools | Options | GL | Default Journal, add "Deposit Journal"
• Enable Cloud storage file sharing
• Share billing or delivery address of sales or purchase document to whatsapp or windows 10 share charm
• #4848: Process SST return prompt error license expired
• #4859: DIY Script - OnGridColumnValueChange script not working
• Feature #4751: Allow user to choose supplier invoices when process AP bad debt recover
• Feature #4855: Add new PST5 tax code under General Tax Purchase tax type
• #4854: Fix incorrect tax type for PST and PSV when Start SST
• #4849: Stock Assembly Transfer from JO will hang after enter Qty if contains much records
• #4842: Update GL/AR transaction tariff with default tariff if the transaction tariff is empty during process SST-02

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