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

====================================================================================