SQL Account 5.2019.867.778
Released on July 4, 2019
- 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)
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)
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)
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)
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)
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)
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)
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)
Information
Last updated:12/11/2018
Current version: 5.2018.850.769
Release notes
- Upgrade Database to Version 168
- 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)
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)
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)
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)
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
