SQL Account Released Note
Release Build 886.790 - 22 Jul 2020
01. Enhance, Retuning & Fixed Report
⦁ #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
02. Feature #5571: Dashboard: Cash Flow Bank Balance add Currency Code column and local bank should display local amount
03. #5569: AR/AP Refund Entry KnockOff's CurrencyRate not follow CurrencyRate display format setting
04. #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
05. #5567: DIY Script - System will remain at Edit Status if using F3 with OnGridColumnValueChanged Script
06. #5540: Print Audit Trail show no result in non English locale
07. #5562: Document Transfer shouldn't list out documents greater than target document's DocDate when user change target document's DocDate to
earlier
08. #5560: AR/AP Payment & Refund Unapplied Amount label will missing when using Tab Docking
09. #5559: AR/AP Payment & CN unapplied amount has value after save even fully knockoff
10. #5557: Stock Assembly after Insert BOM with serial number unable to delete detail record
11. #5530: Tools | Options | Barcode | Stock Take prompt index out of bounds(1) if tick ItemCode only
12. #5535: AR/AP Entry Forms adjust DocNo UI control's color issue
13. #5528: Stock BOM Listing unable to drill down to source Document
14. Feature #5544: Maintain GL Account should allow to create and drag drop the cash type under Current Liabilities
15. #5550: Error ocurred if key-in date in 2nd row onward in Set Gain Loss Ledger Posting Date
16. Feature #5546 Dashboard with Drill Down
17. #5548 Dashboard - Ratio Analysis calculation incorrect
18. #5545: Remove Dashboard SQL logo
19. #5531: SQL Dashboard Unable to view full screen
20. #5549: Stock Take - Calc Stock Take Screen UTD Qty should up to Working Date
21. #5542: Unable to Paste Copied Stock Item in Windows 10 version 2004
22. #5534: Show full error message when failed to import payment voucher or journal entry from SQL Payroll
Release Build 885.789 - 06 Jun 2020
01. Upgrade Database to Version 178
⦁ Tunning Table AR_DPDTL & GL_TRANS table
02. Enhance, Retuning & Fixed Report
⦁ Fixed GST Detail 4 - Mixed Supplies-2018 date format not correctly shown
⦁ Fixed Customer/Supplier Statement Format 1 Reference title out of alignment
⦁ Fix Customer Invoice Listing - Outstanding Service Tax show service tax unpaid for pass invoices
⦁ #5517: GL Balance Sheet Consolidation incorrect even using same database (Previous consolidation merging code only cater max 2 levels, this
commit will solve for more than 2 levels)
⦁ #5466: AR/AP Aging Report Local balance vs Ledger Balance not Match when Gain Loss Post Date not same as any DocDate
⦁ Fix GL Trial Balance & GL Transaction Summary Report apply prompt error
03. Add Dashboard
04. #5529: Process SST SV with Past IV Project Code is empty
05. #5516: Customer Deposit Refund Gain Loss should deduct Forfeit Amount
06. #5521: Points Entry Grid Caption for Code incorrect
07. #5512: Grid cell always align to right on display dpi other than 100%
===================================================+++++++++++++++++++++=============
Release Build 883.788 - 17 Apr 2020
01. Upgrade Database to Version 177
⦁ Add Table WHTAX table
02. Internal Release.
03. Add Access Right: Print Points Listing
04. Add variable CURRENTUSER to form form filter
05. Feature #5507: Add Maintain Withholding Tax and AP & PH Invoice, Cash Purchase, DN & CN documents add Withholding Tax function.
06. Add Access Rights: Stock Take & SQL Pos
====================================================================================
Release Build 882.787 - 06 Apr 2020
01. Enhance, Retuning & Fixed Report
⦁ Add Stock Transfer Listing-ActualAmount
⦁ #5505: GL Receipt & Payment Report Prepayment Account should include transaction of Payment that transfer from AR Deposit
02. #5503: Bank Reconciliation if user edit first record and tick "Show Current Recon Transactions" and cancel & edit second record, the detail still
display previous bank recon detail
03. Feature #5498: GL Bank Reconciliation move Mark & Clear grid record options from button panel to grid context menu
04. #5497: Stock Assembly Batch Update Unit Cost grid tick/untick all should based on grid filter result instead of all records if user filter grid records
05. #5449: All SST Report Forms access right missing "Execute" option
06. #5506: AR/AP Company Code incorrect if company name first char start from number
07. #5509: GL P&L & Balance Sheet Report format unable to add multiple Projects
08. #5508: Slow response if attachments contain unavailable network path
====================================================================================
Release Build 880.786 - 06 Mar 2020
01. Upgrade Database to Version 176
⦁ Tunning Table SY_PROFILE & ST_ITEM_TPLDTL table
02. Enhance, Retuning & Fixed Report
⦁ Fixed Sales Invoice 3 (SubTotal) Seq error when more then 1 page
⦁ Update GST F5 Return for 2020
⦁ Fix GL BS - 3C1P Total for Long Term Liabilities at wrong column
⦁ Fixed Sales Local - Cash Sales Listing - Z Report rounding error
⦁ Add Total Item & Doc Discount for Sales Local - Cash Sales Listing - Z Report
⦁ #5485: GL Profit & Loss Statement and Balance Sheet report prompt access violation error when report template is empty in report format
⦁ #5442: AR/AP Statement Report should exclude those company that has empty details if zero balance has ticked
⦁ Fixed Sales & Price History Group by DocNo, Tax & Tariff shown incorrect grouping information
03. Bug #5486: Import Serial Number with Prompt Replace Unit Price Dialog prompt error control has no parent window
04. Bug #5494: AR Payment edit and change "From Deposit" to another deposit not update the Deposit Amount in AR Deposit
05. Feature #5364: Add new locale: Traditional Chinese
06. #5492: GL Maintain Opening Balance 2nd Description is empty
07. Feature #4119: GST Gift/Deemed supply & SST Deemed Supply support Ctrl+F11 available stock balance function
08. [GST-SG] Feature: #5429: Add new tax code and GST F5 for year 2020
09. Bug #5489: Customer Refund slow after choose customer code if knockoff has over 1k records
10. Feature #5463: Stock Batch with Qty Lookup should Sum Qty according to the location selected
11. Feature #5482: SL/PH Documents upon save prompt "Transferred Qty cannot more than Balance Qty" error should indicate Item Code and Seq
12. Feature #5427: Maintain Item Template add Location & Project fields
13. #5475: GL Cash Book - Save Prompt Error if user empty the Amount Column
14. SY_Profile URL field change from length 80 to 200
====================================================================================
Release Build 879.785 - 01 Feb 2020
01. Enhance, Retuning & Fixed Report
⦁ Reduce Column Usage on FR3 Export to excel for GST F5 Return
⦁ Reduce Column Usage on FR3 Export to excel for Sales Local - Sales Cancel Note Listing (Tax 1)
⦁ Rename Sales Local - Sales Cancel Note Listing (GST 1) to Sales Local - Sales Cancel Note Listing (Tax 1)
⦁ Reduce Column Usage on FR3 Export to excel for Sales Local - Sales Order Listing (Tax 1)
⦁ Rename Sales Local - Sales Order Listing (GST 1) to Sales Local - Sales Order Listing (Tax 1)
⦁ Reduce Column Usage on FR3 Export to excel for Sales Local - Quotation Listing (Tax 1)
⦁ Rename Sales Local - Quotation Listing (GST 1) to Sales Local - Quotation Listing (Tax 1)
⦁ Reduce Column Usage on FR3 Export to excel for Purchase Local - Purchase Cancel Note Listing (Tax 1)
⦁ Rename Purchase Local - Purchase Cancel Note Listing (GST 1) to Purchase Local - Purchase Cancel Note Listing (Tax 1)
⦁ Reduce Column Usage on FR3 Export to excel for Purchase Local - Purchase Request Listing (Tax 1)
⦁ Rename Purchase Local - Purchase Request Listing (GST 1) to Purchase Local - Purchase Request Listing (Tax 1)
⦁ Reduce Column Usage on FR3 Export to excel for Purchase Local - Purchase Order Listing (Tax 1)
⦁ Rename Purchase Local - Purchase Order Listing (GST 1) to Purchase Local - Purchase Order Listing (Tax 1)
⦁ Reduce Column Usage on FR3 Export to excel for Sales Analysis By Document
⦁ Reduce Column Usage on FR3 Export to excel for Purchase Supplier Price History (GST 1) - Review
⦁ Reduce Column Usage on FR3 Export to excel for Sales Customer Price History (GST 1) - Review
⦁ Reduce Column Usage on FR3 Export to excel for Supp Local - Credit Note Listing (Tax 1)
⦁ Reduce Column Usage on FR3 Export to excel for Supp Local - Debit Note Listing (Tax 1)
⦁ Reduce Column Usage on FR3 Export to excel for Stock Transfer Report
⦁ Reduce Column Usage on FR3 Export to excel for Sales DO Listing
⦁ Add Sales Local - Delivery Order Listing (Tax 1) report
⦁ Reduce Column Usage on FR3 Export to excel for Sales DN Listing
⦁ Reduce Column Usage on FR3 Export to excel for Sales CN Listing
⦁ Reduce Column Usage on FR3 Export to excel for Purchase Return Listing
⦁ Reduce Column Usage on FR3 Export to excel for Purchase Invoice Listing
⦁ Reduce Column Usage on FR3 Export to excel for GRN Listing
⦁ Add Purchase Local - Goods Received Listing (Tax 1) report
⦁ Reduce Column Usage on FR3 Export to excel for Purchase DN Listing
⦁ Reduce Column Usage on FR3 Export to excel for Cash Purchase Listing
⦁ Add Post DNCN Adjustment Function for Customer & Supplier Aging-GainLoss report
⦁ Add Set_Profile_Font_Size for GL Profit & Loss Report
⦁ Add Set_Profile_Font_Size for GL Balance Sheet Report
⦁ Add Set_Profile_Font_Size for GL Trail Balance Report
⦁ Fix Customer Invoice Listing Labeling error
⦁ Fixed Cust 06 Months Aging-GainLoss summary not fully shown
⦁ Remove redundancy script for Sales Local - Cash Sales Listing - Z Report
⦁ Add SST Listing 4-DST-02 (2020)
⦁ Fixed Sales Local - Cash Sales Listing - Z Report Payment amount mapping not correct
⦁ Fix Stock Transfer Listing Header amount not follow filter amount
⦁ Fix Sales Invoice 3 (Sales Disc) batch print Disc amt incorrectly
⦁ Fixed Stock Purchase Planning (Current & Next 3 months) SO Qty should Exclude sales cancelled note transfer from SO case
⦁ Reduce Column Usage on FR3 Export to excel for GL Payment Voucher
⦁ Reduce Column Usage on FR3 Export to excel for GL Local - Payment Voucher Listing (GST 1)
⦁ Reduce Column Usage on FR3 Export to excel for GL Local - Official Receipt Listing (GST 1)
⦁ Reduce Column Usage on FR3 Export to excel for GL Local - Journal Voucher Listing (GST 1)
⦁ Reduce Column Usage on FR3 Export to excel for GL Journal Voucher
⦁ Reduce Column Usage on FR3 Export to excel for GL Foreign Bank Adjustment
⦁ Reduce Column Usage on FR3 Export to excel for GL Cash Book Listing
⦁ Reduce Column Usage on FR3 Export to excel for Customer Debit Note
⦁ Reduce Column Usage on FR3 Export to excel for Customer - GST Review
⦁ Reduce Column Usage on FR3 Export to excel for Customer Invoice
⦁ Add GL Local - Ledger - Detail - Level 1-V2
⦁ Fix SST-02 Item 13 spelling error
⦁ Fixed Payment & Contra Listing - Service Tax Knock off should take doc ammount
⦁ Fixed Stock Purchase Planning (Current & Next 3 months) should excluding Can celled Doc & follow Post Date Fix typo error
02. #5391: Sales Profit Estimator should convert to customer currency when click "Update Unit Price" button
03. #5467: SL Invoice unable to posting via BizObject If Exceed Credit Limit with overridden permission
04. #5048: Should not prompt dialog if user set Overdue or Credit Limit to 0 and the user allow to override
05. #5468: Add calculator editor numeric column in GL Cash Book and Journal Entry
06. #5469: Tariff code of invoice detail record remain empty after process SST return
07. Feature #5440: Document Transfer Dialog by default filter 7 Months from target document DocDate
08. rtm/core#5370 Regression: Revive exclusive backup
09. #5457: COM client cannot capture invalid logon credential
10. Feature #5453: AR/AP Documents browse grid add 2nd company name column
11. #5454: Batch Lookup by Item if search by Day will prompt "Interface not supported" error
12. #5441: DIY Script - GL_JE - OnBeforeSave Unable to Append detail
13. Feature #5437: All GL Account Lookup add 2nd Description column
14. Feature #5450: AR/AP CN & DN show label "Past Journal is not allowed" when user trying to create past Journal
15. #5452: Sales Cancelled Note raise error "Could not convert variant of type Null into type Double" when select itemcode
16. #5438: Copy AR/AP DN & CN and Paste as New JE the Doc Type should be JE
====================================================================================