SQL Accounting Latest Version (v801) Date : 28 Apr 2021

SQL Account 5.2021.907.801

Released on April 28, 2021

Release Notes

• Upgrade Database to Version 183
• Add Shopee 2 format
• #5823: SST-02 Report Field 11a, 11b, 11c and B1 should include CN with SU, SU5 & SUV tax code
• Feature #3595: GL Balance Sheet Report when drill down Customer/Supplier account should apply Sales/Purchase Ledger report accordingly
• #5764: Job Order Listing Report master record show only when there is detail record
• Feature #5814: Stock Transfer Listing detail grid add more columns from detail dataset
• Feature #4701: Production Outstanding Sales Order add ItemType option to suit SO->PO case
• Feature #5736: Stock Item - BOM add Number, Description2, Description3, Remark1 & Remark2 fields
• Production JO, AS & DS load additional details from Stock Item - BOM
• Feature #5805: Stock Take module will sync data with share drive, app tethering is removed
• Feature: Lazada payment able to post past invoice
• Adjust Woocommerce order
• Feature - Lazada auto refresh token when expires
• Feature: Lazada payment with same PaymentRefID with auto open bank deposit
• Add GL.Auto.BankRecon.CITIMY
• #5812: auto bank recon error at Alliance Bank statement
• Adjust Dashboard UI
• #4834: Document Entries SST Tax code allow to change/leave blank where tariff code setting has set in Maintain Supplier (reverted commit 6f6aec46)
• #5831: Process SST return prompt error "Account code cannot be empty" if an invoice contains detail with tax code SV (payment basis) and SVA
• Feature #5791: All entry forms support Edit -> Edit As New

SQL Accounting Latest Version (v800) Date : 06 Apr 2021

SQL Account 5.2021.906.800

Released on April 6, 2021

Release Notes

• Upgrade Database to Version 182
• Reduce Column Usage on FR3 Export to excel for Sales Local - Cash Sales Collection Report when full expand
• Feature #5779: Purchase Price History add Master & Detail Landing Cost 1 & Landing Cost 2
• #5782: Sales Price History data sorting inconsistent, should sort by DtlKey
• Feature #5780: Stock Card by Qty Report enable Print Stock Control Item & Non Stock Control Item Options
• Fixed Sales Invoice 3 (Sales Disc) not include itemcode DISC
• Adjust AddToCart add column item sku
• Adjust eCommerce Payment post cheque no
• Adjust Lazada Payment posting detail
• #5799: Maintain GL Account should remove Parent account from Payment Method if other bank drag under it
• Adjust Lazada: Payment disable "Post" button if any order not posted to invoice
• Adjust Lazada: map sql item code with Shop SKU
• Adjust eCommerce get account function

SQL Accounting Latest Version (v799) Date : 05 Mar 2021

 

SQL Account 5.2021.903.799

Released on March 5, 2021

Release Notes

• #Fixed Sales Cash Sales 6 - Receipt-TM-U220 (SST) DocNo alignment problem
• #5757: Bank Recon word will overlay with others when too long
• Adjust eCommerce to post customer phone to DPhone1, customer id to DocRef4
• Fixed Bug eCommerce: Credit note did not knock off when posting payment
• AR/AP PM, CN, Refund & Contra add Knockoff DocNo info for error "Knock off amount must not exceed outstanding amount"
• Fix bug: Auto bank recon PDF last record not showing

SQL Accounting Latest Version (v798) Date : 25 Feb 2021

 

SQL Account 5.2021.901.798

Released on February 25, 2021

Release Notes

• Upgrade Database Version 181
• #5742: Customer Refund listing preview prompt error "Document_CompanyBankAcc: Could not open DataSet"
• Feature #5754: AR/AP Contra auto open couple contra form upon save if couple company code is empty
• Add GL.Auto.BankRecon.UOVBMY
• Added column Recon At at auto bank recon
• #5036: GL Journal Entry form mode not working if FromDocType are CN & DN
• #5745: Different date format for PBB statement (CSV)
• #5743: Invalid numeric input error when load MAYBANK statement

SQL Accounting Latest Version (v797) Date : 30 Jan 2021

SQL Account 5.2021.898.797

Released on January 30, 2021

Release Notes

• Fix GL Bank Reconciliation Report - Clear Transaction should exclude cancelled document
• Fixed Sales Local - Cash Sales Collection Report unable to shown detail information
• #5704: GL P&L Report Net Sales & Gross Profit/(Loss) have to show out even 0
• #5726: AR/AP Balance Report Local C/F not 0 due to incorrect local outstanding for CN
• Fixed Cust Contra Voucher - Full format had invalid character
• Feature #5727 : Auto Bank Recon - Add OCBC
• Fixed Shopee payment excel new format and remove Shopee payment summary
• #5702: Purchase Order bind OnGridColumnValueChanged DIY event when append detail select itemcode lookup value, focus control will jump to save button instead of next grid column
• Add E-Commerce: AddToCart
• #5732: Open GST Return generate 2016 GAF file prompt error
• #5712: SL/PH Documents click "Transfer to document" should perform access right checking
• #5711: Auto Bank Recon - Support Maybank different statement format
• #5714: Auto Bank Recon - PBB statement has different format
• #5707: Auto Bank Recon - HLBB statement has different format
• Fix: eCommerce flickering issue when resize forms
• #5683 Stock Balance Inquiry will halt on switching grid view when window screen resolution scaling is more than 100%

SQL Accounting Latest Version (v796) Date : 08 Jan 2021

SQL Account 5.2021.897.796

Released on January 8, 2021

Release Notes

• Upgrade Database to Version 180
• Fixed JV Description overlap when Description too long
• #5706: GIRO button is disabled after select Supplier Payment on Supplier Document Listing when Customer/Supplier Deposit module is enabled
• #5715: Unable to Save when Knockoff Invoice for some situation
• Add E-Commerce: Lazada, Shopee & Woocommerce 

SQL Accounting Latest Version (v795) Date : 29 Dec 2020

SQL Account 5.2020.896.795

Released on December 29, 2020

Release Notes

• Upgrade Database to Version 179
• Add SST-02 (2020) format
• Fixed GL Bank Reconciliation Report - Clear Transaction Record not shown when there is Posting from JE with foreign Bank
• Remove Box 10 for GST F5 Return format
• GL Receipt & Payment Report Prepayment Account should include transaction of Payment that transfer from AP Deposit
• Add Supplier Deposit Listing Report
• Enable Support Supplier Deposit for GL OR & GL PV format
• Feature #5679: Maintain Batch support DIY Views
• #5685: User doesn't know that scan WhatsApp QR code is required when share report via WhatsApp
• #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
• Feature #5701: GL Cash Book Detail & Tax ledger transaction "Description2" field should refer to CompanyName field value
• Feature #5553: Add Supplier Deposit Entry & Report
• Feature #5565: Stock Assembly, Disassembly & Job Order's BOM Template become blank once the document has been saved
• GL Bank Reconciliation support Auto Bank Recon feature

SQL Accounting Latest Version (v794) Date : 17 Dec 2020

 

SQL Account 5.2020.895.794

Released on December 17, 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 Accounting Latest Version (v793) Date : 19 Nov 2020

SQL Account 5.2020.894.793

Released on Nov 19, 2020

Release Notes

• 01. Enhance, Retuning & Fixed Report 
• Fixed GL Ledger Detail & Summary GrandTotal for Balance should filter by PostDate
• Add Cancelled Label for Point Canceled transaction
• Fixed Sales Point Statement & Summary not excluding Canceled Transactions
• Convert GL Multi - Ledger - Detail - Level 1 to FR3 format
• Fixed GL Multi - Ledger Currency Symbol not correctly shown
• Fix Sales Local - Cash Sales Listing - Z Report Payment amount should take P_Amount
• Reduce file size for Stock Card & Stock Card Qty export pdf
• #5664: AR Deposit foreign Gain posting incorrect
• #5663: AR Deposit's Gain Lossshould post to PREPAYMENT account instead of bank account
• #5665: AR Customer Deposit copy paste should exclude refund/forfeit detail
• #5662: Customer payment cdsKnockOff return empty dataset when called using BizObject
• Tools | Inquiry add Stock Balance Inquiry

SQL Accounting Latest Version (v792) Date : 02 Nov 2020

SQL Account 5.2020.893.792

Released on Nov 02, 2020

Release Notes

• 01. Enhance, Retuning & Fixed Report 
• SL/PH Outstanding Document Report remove DocKey from cdsMain.IndexFieldNames to prevent error "Invalid Parameter"
• Add New New field Mapping for 13c for SST-02 (2019)
• Fixed error when total Amount is 0 for GST Detail 3 - GST F5-(SG)
• Fixed Customer Invoice Listing - Outstanding Service Tax incorrect Service Tax amount paid where the partial knock off
• Feature #5617: Customer Deposit's Browse List show 2nd Company Name
• Feature #5621: Maintain Item double click on Qty column will open Stock Card
• Feature #5633: Maintain Batch support Audit Trail
• Feature #5623: SO to PO - Allow to transfer From SO without Supplier Code & Change Supplier Code after transfer
• Fix open form slow if has hyperlink attachments. Prevent to load icon for hyperlink record

SQL Accounting Latest Version (v791) Date : 16 Sep 2020

SQL Account 5.2020.890.791

Released on Sep 16, 2020

Release Notes

• 01. Enhance, Retuning & Fixed Report 
• Fixed Customer Deposit Listing Unapplied Amount no Decimal Point 
• AR Deposit Listing sort incorrectly if has two documents same post date but different doc no prefix 
• #5600: GL Cash Flow Statement should not have "THIS YEAR PROFIT/(LOSS)". Retained Earning should exclude _RB_, _RD_, _PL_, _AP_ 
• #5602: Unicode character not support in GL PnL & Balance Sheet script 
• #5603: GL PnL - Prompt access violation for Sub Account selection 
• Fixed GST Detail 3 - GST-03 error preview in some cases.. 
• Fixed GL Official Receipt DocAmt not Correctly shown when there is partial transfer 
• Fixed Stock Transfer More Description Overlap 
• 02. #5572: Stock Assembly & Disassembly when load BOM raw material items auto exclude invalid item code 
• 03. #5585: Run Analyse Data Integrity at DCF database will prompt "Tax TX is not exists in the cached list" 
• 04. #5601: AR Payment not allow to save if customer payment amount more than the customer deposit unapplied amount 
• 05. #5614: Stock Take - Stock adjustment doesn't show correct balance quantity (book quantity) 
• 06. #5609: Dashboard Gearing Ratio Rounding Issue 
• 07. #5610 Dashboard Ratio Analysis: Operating Profit should change to Net Profit 
• 08. #5552: DIY Script - customise lookup control for Customer Payment freeze when select a row 
• 09. Feature #2843: Maintain GL Opening Balance support Audit Trail 
• 10. #5592: Purchase Return should allow partial document transfer even no Partial Delivery module license 
• 11. #5594: Stock Transfer Barcode screen (F8) select batch lookup prompt error 
• 12. #5595: Duplicate supplier purchase and payment analysis in SQL Control Center 
• 13. #5605: Customer Deposit forfeit should allow to select Project 
• 14. #5588 Dashboard: Ratio Analysis title is not refresh correctly after changing working date 
• 15. #5547: Prompt Error when posting using via COM 

SQL Accounting Latest Version (v790) Date : 22 July 2020

SQL Account 5.2020.886.790

Released on July 22, 2020

Release Notes

• #4983: Preview report raise error in locale other than English
• Feature #5564: Stock Card Report enable Print Stock Control Item & Non Stock Control Item Options
• Fixed GL BS - 13C2P Company ROC mystery shown at page 3
• Fixed Sales Local - Delivery Order Listing (Tax 1) data mapping & title not correct
• Feature #5571: Dashboard: Cash Flow Bank Balance add Currency Code column and local bank should display local amount
• #5569: AR/AP Refund Entry KnockOff's CurrencyRate not follow CurrencyRate display format setting
• #5570: AR/AP Fast Entry prompt error "cdsDocDetail field WHTAX not found" where supplier fast entry has pending records upgrade from version 785 and below
• #5567: DIY Script - System will remain at Edit Status if using F3 with OnGridColumnValueChanged Script
• #5540: Print Audit Trail show no result in non English locale
• #5562: Document Transfer shouldn't list out documents greater than target document's DocDate when user change target document's DocDate to earlier
• #5560: AR/AP Payment & Refund Unapplied Amount label will missing when using Tab Docking
• #5559: AR/AP Payment & CN unapplied amount has value after save even fully knockoff
• #5557: Stock Assembly after Insert BOM with serial number unable to delete detail record
• #5530: Tools | Options | Barcode | Stock Take prompt index out of bounds(1) if tick ItemCode only
• #5535: AR/AP Entry Forms adjust DocNo UI control's color issue
• #5528: Stock BOM Listing unable to drill down to source Document
• Feature #5544: Maintain GL Account should allow to create and drag drop the cash type under Current Liabilities
• #5550: Error ocurred if key-in date in 2nd row onward in Set Gain Loss Ledger Posting Date
• Feature #5546 Dashboard with Drill Down
• #5548 Dashboard - Ratio Analysis calculation incorrect
• #5545: Remove Dashboard SQL logo
• #5531: SQL Dashboard Unable to view full screen
• #5549: Stock Take - Calc Stock Take Screen UTD Qty should up to Working Date
• #5542: Unable to Paste Copied Stock Item in Windows 10 version 2004
• #5534: Show full error message when failed to import payment voucher or journal entry from SQL Payroll

SQL Accounting Latest Version (v789) Date : 06 June 2020

SQL Account 5.2020.885.789

Released on June 6, 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%