Thursday, November 29, 2018

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
  • Tuesday, November 13, 2018

    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"

    Friday, November 2, 2018

    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