eStream MSC Sdn Bhd

10. #4941: Service tax invoice paid the double entry become not balance after edit the Account code 11. Fix customer name is empty after read from MyK...

0 downloads 87 Views 757KB Size
eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 Release Build 861.775 - 22 Feb 2019 01. 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 02. Upgrade Database to Version 171 ⦁ Tunning SST_PROCESS, SST_TR & SST_TR_DRAFT table 03. Add SST registered option on start SST wizard form and make IMSV active only for non-SST Registered user 04. Feature #4946: Add "Use Invoice Ext. No as Invoice Number for Payment Detail" option on GIRO param form 05. Feature #5016: Company Profile UI update 06. Feature #5027: Allow Special Account Type for under the Normal Account (reverted changes of Bug #4916) 07. Feature #5017: Company Profile Set Report Header include SST No 08. #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 09. #5013: GL Cash Book add Local Amount & Local SubTotal (Tax) in grid 10. #5018: Maintain GL Account once created new account under non-current asset, it will auto scroll down to the new account code 11. #5028: Maintain Item Opening Stock Batch field is limited to 20 even is support 30 char 12. #4976: Stock & Purchase Documents Barcode entry (F8) if untick Show Cost access right, should hide unit price, discount & amount fields 13. SST Return add friendly message to "offset value exceeded balance value" error that stated PM and IV docno 14. #5003: GL Journal select Tax code prompt Abstract Error 15. Add Deemed Supply to Repost & Recalculate Costing 16. Feature #4993: Maintain Tax disable input tax & output tax and hide "Switch to Easy Mode" button

Release Build 860.774 - 24 Jan 2019 01. 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 02. Upgrade Database to Version 170 ⦁ Tunning GL_TRANS, AR_CUSTOMER, AP_SUPPLIER, SST_TR, SST_TR_DRAFT, SST_TR, SST_PROCESS & SY_PROFILE table 03. 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. 04. Add Non-SST Registered option on new SST return window 05. 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. 06. Feature #4973: Company Profile add PostCode, City & State fields. 07. Feature #4931: Add SST Taxable entry for Opening service tax invoices outstanding 08. Feature #4957: Add Sales Tax and Service Tax number fields in Maintain Customer & Supplier 09. [SST-MY] Feature #4956: Add new tax code "SVE" for service tax exemption 10. #4941: Service tax invoice paid the double entry become not balance after edit the Account code 11. Fix customer name is empty after read from MyKad

Release Build 859.773 - 15 Jan 2019 01. 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 02. Add support of preview customer CTOS lite report 03. #4922: Unable to edit sales invoice document detail (remark1) if the tax is SV and without payment knockoff after process SST return 04. #4966: Customer Deposit should not allow to add deposit refund/forfeit if Unapplied Amt = 0 05. #4917: Rename GL Account Code "SST-Kastam" didn't update the account code reference in Tools | Options | GL 06. Feature #4892: Rename KnockOff GST Date to KnockOff Tax Date 07. Feature #4950: Maintain Customer & Supplier browse screen add Mobile field in field chooser

Release Build 858.772 - 29 Dec 2018 01. Enhance, Retuning & Fixed Report

Page 1 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ 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

02. 03. 04. 05. 06. 07. 08. 09.

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 #4921: OnGridColumnValueChanged script bypass if move to other row Fix unable to identify which account code if application prompt error "Invalid account code ()" Feature #4596: CIMB Bulk Payment with Email Notification file format - Add other knock-off detail to payment detail record

Release Build 854.771 - 05 Dec 2018 01. Enhance, Retuning & Fixed Report ⦁ Add SST Listing 3 report 02. #4916: Prevent user to change child account's Special Account Type that different with its Parent Account upon Edit Account 03. #4913: Help | SQL Account Home Page direct to wrong URL 04. #4788: Unable to unchecked default if there is only one default tariff record 05. Fix access violation error when edit save doc in FastMM4.AlwaysClearFreedMemory_CheckHeapForCorruption_FullDebugMode mode. DevEx PropertiesEdit should put nil when create the instance 06. Fix Cash Purchase Address2 UI control misalign 07. #4918: Cash purchase windows re-open few times

Release Build 853.770 - 30 Nov 2018 01. Upgrade Database to Version 169 ⦁ Add Table: SST_TR_DRAFT & SST_TR_ADJ_DRAFT 02. 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 03. #4900: Save Customer Payment Prompt "cdsDocDetail dataset not in edit mode" Error 04. Feature #4838: Add the SST-02 draft features 05. #4788: Unable to unchecked default if there is only one default tariff record 06. Feature "Read MyKad" is available based on application OEM 07. #4846: Item tariff code will not update in PH document where default tax code is BLANK or not SST tax type in Maintain Supplier. 08. #4895: Unable to edit sales invoice document detail remark1 after process SST return

Page 2 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 09. 10. 11. 12.

Feature #4885: Sales Profit & Loss By Document add Discount #4799: Missing Country Field in the Browse Screen for Data Entry Form #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 13. Journal Entry: confirmation dialog not prompt when change account code 14. #4906: Cash Sales with payment prompt Access Violation 15. #4907: GL Cash Book - Item description is overridden by built in description in copy and paste operation

Release Build 850.769 - 12 Nov 2018 01. Upgrade Database to Version 168 ⦁ Tunning Table: PD_JO 02. 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 03. #4874: Prompt Error when create new Job Order 04. #4878: Unchecked bounced cash book prompt error "Table unknown TAX_PROCESS"

Release Build 849.768 - 02 Nov 2018 01. Upgrade Database to Version 167 ⦁ Tunning Table: SY_PROFILE ⦁ Add Table : AR_DP, AR_DPDTL 02. 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 03. Set document form size to to 1000 x 600 04. Feature #4866: Add link to get Google API key 05. #4868: Access Violation when using Form Mode with split browse & detail windows option 06. Feature #4865: Company Profile - Consolidate Alias change to friendly name 07. #4588: Customer Deposit 08. Insert Deposit Account into Maintain GL Account and Payment Method 09. GL Account add "Deposit" special account type (together with bank & cash special account type) 10. Tools | Options | GL | Default Journal, add "Deposit Journal" 11. Enable Cloud storage file sharing 12. Share billing or delivery address of sales or purchase document to whatsapp or windows 10 share charm 13. #4848: Process SST return prompt error license expired 14. #4859: DIY Script - OnGridColumnValueChange script not working

Page 3 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 15. 16. 17. 18. 19.

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

Release Build 847.767 - 25 Oct 2018 01. Upgrade Database to Version 166 ⦁ Tunning Table: GL_TRANS, GST_TR_DRAFT, GST_TR & SST_TR 02. Enhance, Retuning & Fixed Report ⦁ Update GL Journal of Transaction - Inbalance export script ⦁ #4832: Add GL | Print Bank Reconciliation Listing Template ⦁ #4815: SST-02 - Purchase Transactions should be excluded in Part B1 ⦁ Update SST SST-02 Highlight Red for Record without Tariff Code in B1 ⦁ Remove Word Wrap for Tariff Description 03. #4844: Partial Delivery Transfer slow if has many items (Tick/Untick all & selection and tick document record all are slow) 04. #4769: DIY Script - modal dialog stay behind 05. #4745: Gift output tax not calculated after 1 Jun 2018 even though tax rate is 6% and amount exceed RM500 06. #4834: Re-select the same item code the tax code will change and not follow the customer tariff tax code. Bug #4835: Tax code will not follow the customer tariff tax code if the tariff has set as default 07. Feature #4820: Add "Include Zero Qty" to Partial Delivery document transfer form 08. #4806: GL Payment Voucher save prompt assertion error if Bank Charges Account Code not specified in Maintain Payment Method 09. #4791: Transfer SO to PO should exclude Discount field 10. #4812: AR/SL missing Tax Date label 11. #4828: Published GL Bank Recon Report parameters for biz object 12. #4822: Prompt Access Violation when save Stock Item Template 13. Change Command Navigator group caption's Font Colors 14. Fix process final GST return prompt error "Easy GST (SL-BadDebt) input tax is not a valid tax type"

Release Build 844.766 - 10 Oct 2018 01. Enhance, Retuning & Fixed Report ⦁ Fixed GL Bank Reconciliation Report amount overlap ⦁ Fixed Cust Overdue Letter-(with other Info) address not shown if only OR ⦁ Add Cust 12 Months Aging LS - Outstanding Service Tax ⦁ #4805: SST-02 Report double click Drill Down should sensitive to Report Type (Sales Tax, Service Tax or Both) ⦁ Remove GST Tap function from SST SST-02 report ⦁ #4742: Balance Sheet Statement numeric format error in Indonesian environment 02. #4813: Missing tax code PST and PSV after start SST 03. #4808: LastModified not updated after save detail dataset changes. 04. Fix VarToDateTime cause variant conversion error for non English locale (e.g.: Indonesia) 05. Feature #4807: Allow set tax date for AR IV, AR DN, SL IV, Cash Sales & SL DN 06. #4809: System unable to capture correct Tariff Code preset in Maintain Stock Item 07. #4776: Press enter doesn't focus on next control in Maintain Account 08. #4798: Syntax error for numeric format in Indonesian environment

Release Build 842.765 - 08 Oct 2018 01. Upgrade Database to Version 165 ⦁ Add Table: SST_PROCESS, SST_TR 02. Enhance, Retuning & Fixed Report ⦁ AR, AP, SL & PH Document Listing report add Tax Exempt No field ⦁ Add Cust Local - Payment Listing - Collection Report-Service Tax ⦁ Add SST-02 format as at 29 Sept 2018 ⦁ Add SST Listing Report ⦁ Add GL Code for GL PnL 2C - 2C1P report ⦁ Fix GL BS - Comparison - 22C1P Column 13 not shown ⦁ Fix GL Local - OR & PV Listing (GST 1) detail line alignment ⦁ Fixed Customer DN(SST) half DocNo Field wrong mapping ⦁ Fix Cust Customer Listing 2 (Label) record will shown double if Record in Even

Page 4 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ Add Tax Exemption No for Purchase Order 8 ⦁ Add Tax Exemption No for Sales Invoice 8 ⦁ Fixed GL Ledger rtm Parameter Sort by too long ⦁ Add GL Official Receipt - Detail - Half (SST) - Listing report ⦁ Fixed Stock Issue & Receive Listing - Document Total Not correct if Amount more then 1000 ⦁ Fixed Sales Invoice 3 (Sales Tax) Tax Rate shown A instead of rate ⦁ Rename GST 1 to Tax 1 for Customer/Supplier Local Listing report ⦁ Fixed Sales Analysis By Document - Summary Line is not straight ⦁ Add Purchase Order 8 SST format ⦁ Add Purchase Multi - Purchase Cancel Note Listing report ⦁ Fixed Production Outstanding Sales Order Listing - Level 2 incorrect format ⦁ Add Deemed Supply Listing report

03. 04. 05. 06. 07. 08. 09. 10. 11. 12. 13. 14. 15. 16. 17. 18.

Feature #4789: Add exemption lookup field at AR/SL and AP/PH master Add Tax Exempt No field to AR/AP IV, DN, CN, SL & PH form and Tax Exempt No Lookup AR, AP, SL & PH Data Modules add TaxExemptNo field and by default retrieve Tax Exempt No from Maintain Customer/Supplier. Add TaxExemptNo field to AR/AP IV, DN, CN, SL & PH master tables Add SST return journal document number set Feature #4782: PST and PSV the tax type removed and replace by Purchase General Tax #4728: Incorrect LPA adjustment where there is a mixed supplies of 6% and 0% Feature #4800: Allow user to process bad debt relief and bad debt recover that will happen between 1 Sep 2018 and 29 Dec 2018 for final GST return Feature #4783: Allow Tax Date earlier than Doc Date for all documents Feature #4801: Allow LPA for Final GST Return (Aug 2018) to calculate LPA up to Aug 2018 in Aug 2018 Process (as we not allow LPA overlap with current process date range previously) Feature #4794: Enter asset value as DS in final GST return Add LastModified field to customer, supplier, stock group, stock item, stock price tag, item template and tax Fix payment knockoff invoice prompt access violation if SST effective date after 1 Sep 2018 and last processed GST return up to 31 Aug 2018 #4796: Tax code different between Sales Invoice and Customer Invoice if there is a change in Sales Invoice tax code and a tariff setting in Maintain Customer Feature #4778: Batch update tariff code in Maintain Stock Item #4780: Click Generate GAF Error if Accounting Start Date not same as System Conversion Date

Release Build 840.764 - 08 Sep 2018 01. Upgrade Database to Version 164 ⦁ Add Table: TAX_DM, TAX_DM_DTL 02. Enhance, Retuning & Fixed Report ⦁ Fixed Apply Report before 1 Sep 2018 error 03. Add SST: Deemed Supply

Release Build 839.763 - 06 Sep 2018 01. Upgrade Database to Version 163 ⦁ Tuning AR_Customer, AP_Supplier,Tax ST_Item table - Add Tariff field 02. Enhance, Retuning & Fixed Report ⦁ 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 03. Fix error in Maintain Tax: Could not convert variant of type (Null) into type (OleStr) 04. Feature #4768: All document transfer (from & to doc) allow to change Tax Inclusive. Transfer DO to Invoice/Cash Sales document allow to change the tax code (this commit also fix the issue itemcode & UOM suppose not allow to changed. Bug #3314 & #4663 changes has been reverted) 05. AR/AP/SL/PH Document Entries change tariff assigned default tax code should be trigger if user has set Tax Exempt No and check Tax Exp Date also 06. Revise Tax and Tariff UI in Maintain Customer and Supplier 07. SL/PH posting to AR/AP documents support Tariff 08. #4766: Document Entry default tax code not working on general tax type 09. #4765: Maintain Tax's Tax Type List is empty without Start SST or GST (it should contains general tax types)

Page 5 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 Release Build 837.762 - 28 Aug 2018 01. Upgrade Database to Version 162 ⦁ Tuning Tax table - Add IsDefault field 02. Enhance, Retuning & Fixed Report ⦁ Add GL JV, GL OR & GL PV format for SST ⦁ Remove AllowExpression option for GST Lampiran 4 03. Prevent user change SST effective date earlier than 1 Sep 2018 04. System will not assign GL CB & Journal default tax code (in Maintain GL Account) if different tax system 05. Fix Maintain Tax change Tax Type not refresh Tax Rate problem 06. Fix Maintain Tax New and Save tax code prompt "could not convert variant of type Null into type integer" 07. #4759: Remove Default Output & Input Tax from Tools | Options. Maintain Tax add Default Tax checkbox. Document Entries Default Tax Logic will retrieve default tax based on tax system 08. Feature #4760: Split SST tax codes to SL & PH 09. Fix incorrect closing stock value after recalculate GST return (MY) 10. Prompt user friendly message when GST return (MY) date to greater than 31 Aug 2018

Release Build 836.761 - 27 Aug 2018 01. Upgrade Database to Version 161 ⦁ Tuning SY_Profile table - Add sales tax number, service tax number & currency language field 02. Enhance, Retuning & Fixed Report ⦁ Add Sales Invoice 7 (GST 1) - SG report ⦁ Add New Sales Invoice format for SST & Non SST ⦁ Add New Sales Debit Note format for SST & Non SST ⦁ Add New Sales Credit Note format for SST & Non SST ⦁ Add New Cash Sales Format for SST & Non SST ⦁ Add Customer Invoice, Debit Note & Credit Note SST format ⦁ Convert all Customer Invoice, Debit Note & Credit Note to fr3 ⦁ SL/PH Outstanding Document Report cdsDocMaster should select distinct records ⦁ Fix Stock Issue & Received Listing preview error when DocAmt is 0 ⦁ Remove Shift option for Purchase Data Entry FR3 format for Title ⦁ Remove Shift option for Sales Data Entry FR3 format for Title ⦁ Fixed Cust Debit Note (GST) - Half DocNo Mapping wrong field 03. Singapore Customer Accounting - 2019-01-01 04. Malaysia Sales & Service Tax (SST) 2018-09-01 05. Feature #4755: Enter closing stock value as DS in final GST Return 06. Rename Maintain Tax Browse Category "Others" to "GST Others" 07. SST: Change menu GST to SST/GST 08. Feature #4757: GST-03 Return and payment due date should be 29 Dec 2018 if date to is 31 Aug 2018 detected 09. #4749: YED prompted "Insufficient memory" at Insert DO 21 Days OffSet into GST Taxable due to SL Outstanding DO report retrieve all records up to YED date

Release Build 834.760 - 28 Ju1 2018 01. Enhance, Retuning & Fixed Report ⦁ Fixed Supplier Invoice,DN, CN (GST) export pdf some field partly shown ⦁ Fixed Customer Invoice, DN, CN (GST) export pdf some field partly shown ⦁ Fixed GST Bad Debt Relief - Sales-Part C17 preview error when value is 0 ⦁ #4709: GL Ledger - Report selection is not filter by Grouping level ⦁ Fixed GL JV (GST) export pdf some field partly shown ⦁ Fixed GL OR & PV (GST) export pdf some field partly shown ⦁ Add Account code column for GL PnL - 13C1P format ⦁ Fixed GL BS - 13C2P Account Description on 2nd page not properly shown ⦁ Fixed Sales Credit Note 7 export pdf some field partly shown ⦁ Fixed Sales Debit Note 7 export to pdf some field partly shown ⦁ Fixed Sales Delivery Order 1 export to pdf some field partly shown ⦁ Fixed Sales Order 7 export to pdf some field partly shown ⦁ Fixed Sales Quotation 7 export to pdf some field partly shown

Page 6 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ Fixed GL PnL - 4C0P Export to Excel some field is hidden ⦁ Fixed Sales Cash Sales 7 export to pdf some field partly shown ⦁ Fixed Sales Cancel Note 7 export to pdf some field partly shown ⦁ Fixed Purchase Return 7 export to pdf some field partly shown ⦁ Fixed Purchase Request 7 export to pdf some field partly shown ⦁ Fixed Purchase Invoice 7 export to pdf some field partly shown ⦁ Fixed Purchase Debit Note 7 export to pdf some field partly shown ⦁ Fixed Purchase Cash Purchase 7 (GST 1) export to pdf some field partly shown ⦁ Fixed Purchase Cancel Note 7 export to pdf some field partly shown ⦁ Fixed Purchase Order 7 export to pdf some field partly shown ⦁ Fixed Sales Invoice 7 export to pdf some field partly shown ⦁ Fixed QT, SO, IV & CS Format 7 GST 1 item detail not fully shown if item more then 36 records ⦁ Fix Discount error if had tax inclusive for Sales Invoice 3 (Sales Disc) ⦁ Fix Sales Quotation 7 (GST 2) export to pdf some field partly shown

02. 03. 04. 05. 06. 07.

#4705: #4726: #4725: #4724: #4723: #4711:

GL Cash Book & JE - Change account code freeze the application TX-ES do not fulfilled the DMR 6a should be zero (this bug is happen where all transaction TX-ES tax rate is 0%) Incorrect result of GST-03 item 5a due to non-refundable deposit (Jun 2018) knockoff invoices (Jul 2018) Gift value not exceed RM500 after 1 June 2018 should not show in GST-03 5a Maintain Account Industry Code should only visible for GST Malaysia only Supplier Refund knockoff Payment will prompt gain loss even is local currency

Release Build 833.759 - 27 Jun 2018 01. Upgrade Database to Version 160 ⦁ Tuning Tax table 02. Enhance, Retuning & Fixed Report ⦁ Remove Record where LocalDR & LocalCR is 0 for GL Opening Balance report ⦁ Convert Stock Issue & Received Listing to FR3 ⦁ Fix GL BS - 3C1P & GL BS - 2C1P % for Fixed Asset is 0 if not Basic format ⦁ Convert GL Local - Ledger - Detail - Level 2 to FR3 ⦁ Fixed Sales Invoice 7 (GST 2) From Doc Date field column too short ⦁ Fixed GL Trial Balance - This Year should hide account when DR & CR is 0 ⦁ Fixed GL Balance sheet Export to pdf some info shown partly ⦁ Fixed GL PnL - 2C2P-Currency to pdf Account code shown partly ⦁ Convert 99% of GL Profit & Loss report to Fast Report ⦁ Fixed GST Summary Sheet - MY-20170106 double deduct for TX ⦁ Fixed GST Summary Sheet - MY-20170106 Taxable Amount Grand Total should including Bad Debts Amount 03. #4706: cdsTax missing in Report Object GL.CB.RO 04. #4702: Unable to start GST (Singapore) if GST effective date earlier than start of the current year 05. #4680: The Override Credit limit Counter not working on non english locale 06. #4652: IBizObject.XMLFieldDefs prompt error 07. Feature #4688: Add support of batch edit value for fast entry 08. #4696: Payment method of parent account not remove when drag a cash/bank account underneath 09. #4690: Prompt error when Logout and Login with automation 10. #4687: AR/AP Invoice Fast Entry delete all records after save error and re-append new record, it will show last deleted record value 11. #4685: AR/AP Invoice Fast Entry Main Description should set default value and memory last value 12. #4693: Supplier Invoice's Fast Entry default account should be Purchase Account 13. #4694: Rename AR/AP Invoice Fast Entry Form Title 14. #4695: Stock Assembly & Disassembly Copy Paste Prompt "the record has been changed by another user" (exclude UpdateCount field during copy paste) 15. #4692: Supplier Invoice's Fast Entry TaxAmt column should allow edit 16. #4675: TX-CG, RP & ZDA Rate is remain as 6% if upgrade db from Version 728 (Fix database upgrade script version 139) 17. #4678: AR/AP Invoice Fast Entry Error "Mismatch in datapacket" when save

Release Build 829.758 - 07 Jun 2018 01. Enhance, Retuning & Fixed Report ⦁ Update Purchase Invoice TaxRate label sensitive with TaxDate ⦁ Update Purchase Cash Purchase 7 Tax Rate label sensitive with Tax Date

Page 7 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ Update Purchase Debit Note 7 Tax Rate label sensitive with Tax Date ⦁ Update Purchase Return 7 Tax Rate label sensitive with Tax Date ⦁ Update Purchase Cancel Note 7 Tax Rate label sensitive with Tax Date ⦁ Update Sales Invoice 7 (GST 2) header alignment ⦁ Update GL PnL - 4C4P header alignment ⦁ Update Sales Invoice 7 (GST 1) Tax Code alignment ⦁ Update Sales Invoice 3 (GST 2) & (Sales Disc) fromat TaxAmt should shown 0 instead empty ⦁ Fixed Sales Invoice Tax Rate Label shown 0% when transfer from DO with 6% ⦁ Fixed Sales Cash Sales Tax Rate Label shown 0% when transfer from DO with 6% ⦁ Feature #4635: GL Balance Sheet Report Type Reposition & Set IFRS as Default ⦁ #4625 Stock Transfer unable to View if Qty is 0 ⦁ Fixed GL PnL - 2C2P Export to pdf Account code shown partly

02. 03. 04. 05. 06. 07. 08. 09.

#4655: Process LPA Prompt Error if Process date range falls after Jun 2018 but LPA DateTo is before Jun 2018 #4662: Win64 - MidasLib prompt Access Violation #4657 and #4659: Click street view on map prompt error access violation if coordinate is blank; click street view on map shows Paris #4660: AR/AP Invoice Fast Entry unable to edit some fields Feature #4663: Allow user change Tax Code for all transfer documents (except IV/CS that transfer from DO) #4667: The Save button still enable even after click cancel from Below Qty #4671: AR/AP IV Fast entry last entered past invoice amount will change to 0 after save Add integration for SQL-POS

Release Build 828.757 - 28 May 2018 01. Enhance, Retuning & Fixed Report ⦁ Add Sales Multi - Invoice Listing (GST 1) - Level 1 - TaxInclusive report ⦁ Update Purchase Order 7 Tax Rate label sensitive with TaxDate ⦁ Update Purchase Request 7 Tax Rate label sensitive with TaxDate ⦁ Fixed GST GST-03-2018 6a shown 0 even had Value 02. #4653: Error When transfer from DO to IV if the database never Start GST before 03. #4652: BizObject error in AR_Customer and AP_Supplier 04. Feature #4647: Maintain Tax add fixed tax rate 6% for certain tax codes (GST transition period purpose) 05. Fix Gift amount overflow bug, zero rated transaction (b4 June 2018) 06. Feature #4648: Tax rate column set as default appearance in documents detail grid

Release Build 827.757 - 24 May 2018 01. Upgrade Database to Version 159 ⦁ Tuning Tax table 02. Enhance, Retuning & Fixed Report ⦁ Update Sales Cancel Note 7 Tax Rate label sensitive with TaxDate ⦁ Update Sales Credit Note 7 Tax Rate label sensitive with TaxDate ⦁ Update Sales Debit Note 7 Tax Rate label sensitive with TaxDate ⦁ Update Sales Order Tax Rate label sensitive with TaxDate ⦁ Update Sales Quotation 7 Tax Rate Label sensitive with TaxDate 03. #4651: Incorrect GST-03 result 5b and 6b for Customer/Supplier CN and DN using tax type AJP-OA and AJS-OA treatment in GST-03 04. #4649: Access control fail in after upgrade to 756 05. Feature #4647: Maintain Tax add fixed tax rate 6% for certain tax codes (GST transition period purpose) 06. Fix Gift amount overflow bug, zero rated transaction (b4 June 2018) 07. Feature #4648: Tax rate column set as default appearance in documents detail grid

Release Build 826.756 - 23 May 2018 01. Upgrade Database to Version 158 ⦁ Tuning AP_SUPPLIERBRANCH, AR_CUSTOMERBRANCH and SY_PROFILE table 02. Enhance, Retuning & Fixed Report ⦁ Add Cust Local - Invoice Listing (GST 1) - Non Refund Deposit – 201806 ⦁ Fixed Input tax amount not correct when there is TX-ES for GST Summary Sheet - MY-20170106 report ⦁ Fixed Export to pdf ROC shown partly for GL Trial Balance report ⦁ Update Missing Agent & Area Parameter for GL Balance Sheet ⦁ Update Missing Agent & Area Parameter for GL Profit & Loss in Fast Report

Page 8 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ Fixed Output Tax over deduct if had RSA for GST Summary Sheet - MY-20170106 report ⦁ Fixed GST Summary Sheet - MY-20170106 should excluding NR for DN/CN & Fix Transactions NOt Included where Account Code is Empty ⦁ Update GL Journal of Transaction & GL Journal of Transaction - Inbalance Alignment for Export to Excel ⦁ Update Sales Invoice Tax Rate label sensitive with taxdate ⦁ Update Sales Cash Sales Tax Rate label sensitive with taxdate

03. 04. 05. 06. 07. 08.

Feature #4640 Add AR/AP Fast Entry for Invoice #4641 Update for GST Amendment from 6% to 0% (effectively 01 Jun 2018) Add Display customer or supplier location on the Google Maps Feature #4639 Reduce time for the Upgrade to Version 157 Feature #4597: Add invoice document date to GST and GL trans description for bad debt relief and bad debt recovered Fix Maintain Tax create new Tax Code prompt cannot convert null to integer error

Release Build 823.755 - 20 Apr 2018 01. Upgrade Database to Version 157 ⦁ Tuning All tables 02. Enhance, Retuning & Fixed Report ⦁ Add Sales Local - Sales Order Listing (GST 1)-SO2PO format ⦁ Add Sales Invoice 7 (GST 1) (SubTotal) report ⦁ GST Audit Report support datamap ⦁ GST Summary Sheet - MY-20170106 Output Tax for CN & DN Adjustment should excluding OS & OS-TXM ⦁ Fixed GST Summary Sheet - MY-20170106 TX should excluding TXCG ⦁ Fix GL PnL - 13C1P-SinglePage not follow font style & size set in XML ⦁ Add GST Audit-Footer F11 report ⦁ Fixed GST Detail 3 - GST-03 & GST Detail 3 - GST-03-2018 shown duplicate on item 16 when many Draft GST ⦁ Remove GL Trial Balance - This Year v GAF (Footer) report ⦁ Convert GL PnL - 13C1P-SinglePage to fast report ⦁ Update GL Ledger FR3 Alignment for export to excel ⦁ Update GL Profit & Loss FR3 Alignment for Export to Excel ⦁ GST Summary - Fix Input Tax double deduct when had CN ⦁ Update GST Summary Sheet - MY-20170106 Alignment for Export to Excel ⦁ Update Sales Invoice 7 Alignment for Export to Excel ⦁ Update GL Trial Balance Alignment for Export to Excel ⦁ Fix GL Local - Ledger - Detail - Level 1 should hide when zero ⦁ Fixed GST Summary Sheet - MY-20170106 Input Tax for CN/DN should excluding TX-NC ⦁ Feature #4602: GL Profit & Loss Always Hide Retained Earning if Print Sub Account Only is select ⦁ Increase column size for GL PnL - 6C4P report ⦁ Update Cust Overdue Letter-(with other Info) Alignment for Export to Excel ⦁ Update GL BS - 13C1P-SinglePage & 2C1P Alignment for Export to Excel ⦁ Update GL BS - 3C1P Alignment for Export to Excel ⦁ Fix GL Stock Value Project Description not shown & Footer Description not correctly shown ⦁ Update Sales Invoice 7 (GST 2) Alignment for Export to Excel 03. #4584: Unable to transfer empty item code from IV to CN 04. #4577: Incorrect display format for Overdue Limit in Maintain Customer 05. Feature #4576: Analyse Data Integrity add "Repost ST Documents" 06. #4595: Slow response using URL attachments 07. Feature #4597: Rename GST and GL trans description for bad debt relief and bad debt recovered 08. Feature #4349: Add record count indicator to bad debt relief and bad debt recover caption on GST bad debt form 09. Update RMCD GST TAP 10. Fix bug #4531: TClientDataSet.DisableStringTrim = False fail to work for ftWideString field

Release Build 822.754 - 14 Mar 2018 01. Upgrade Database to Version 156 ⦁ Tuning All tables 02. Enhance, Retuning & Fixed Report ⦁ Fix Cust Overdue Letter-(with other Info) Company header not shown if more then 1 page per customer ⦁ Fix #4572 Error prompted after preview the customer statement group where either total DR or CR are zero. ⦁ Add Company & CompanyBranch pipeline for EMail for Customer & Supplier Statement

Page 9 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ #4573: Balance Sheet Retain Earning Description set at Tools | Option not function ⦁ Remove Negative symbol for Stock Transfer Listing ⦁ Fixed GST Lampiran 2-with ZR notincluding IM-CG ⦁ Fixed GST Lampiran 2 not including IM-CG ⦁ #4500: Stock Physical Worksheet & Reorder Advice Reports have inconsistent stock result if group by location and batch (if item has

transaction in SO/PO but no transaction in ST_TR table) ⦁ Fixed GST Summary Sheet - MY-20170106 Input Tax should exclding BL & OP tax ⦁ Fixed GST Summary Sheet - MY-20170106 Bad Debts should excluding from DN/CN Section ⦁ Fixed GST Detail 3 - GST-03-2018 not including IM-CG

03. 04. 05. 06. 07. 08. 09.

Feature #4575: Allow NS tax code to select in Purchase side Feature #4561: Auto correction to ZP for EP, RP, GP transactions Convert to 0 if found any negative value in TAP text field 10, 11, 12, 13, 14, 15, 16 for GST GST-03-2018 #4556: BizObject - Post Stock Received without itemcode prompt Division by Zero Feature #4555: Add Bank Islam Third Party Transfer file format Feature #4547: RHB ePayment - Format update Feature #4325: Allow user to encrypt CIMB Bulk Payment text file

Release Build 821.753 - 14 Feb 2018 01. Upgrade Database to Version 155 ⦁ Tuning All tables to support New GST Guideline. 02. Enhance, Retuning & Fixed Report ⦁ Add GST Detail 3 - GST-03-2018 & GST Detail 4 - Mixed Supplies-2018. ⦁ Add New GST-03-2018 format. ⦁ GST-03 report total value of capital goods acquired include transaction with IM-CG tax type ⦁ Add GST.Gift 2 format ⦁ Fixed GL Multi - Ledger - Summary Balance C/F not correct in some situation. ⦁ #4513: GST Listing Summary Grid "Local Amount" Footer shown Empty ⦁ Feature #4452: Preview GL Maintain Stock Value Report Parameter form add From Year, From Month, To Year & To Month ⦁ Feature #4479: Stock Transfer Listing add Customer Lookup Filtering. ⦁ Remove Stretch Option for Company Header for Customer & Supplier Statement ⦁ Remove Display Format for TAP output 03. Add new tax types IM-CG, NTX, OS-TXM & SR-JWS. Mark inactive for EP, RP, GP, NP. Update tax description for NS, OP, ZP 04. #4541: Access right still can print even is untick with Preview Right. 05. #4540: Access Right - Maintain Item - Report section is not function. 06. #4539: Edit & Save Sales CN which transfer from IV (that transfer from Past DO) prompt assertion error 07. Feature #4514: Rename column caption from U/Cost to U/Price on gift entry form; GST_GIFT_DTL table UnitCost column stores item unit price . 08. #4503: Job Order browse screen, drag out BOM Template from field chooser prompt error. 09. Feature #4451: Add Police ID and Army ID to ID type of supplier bank account. 10. #4495: GL Cash Book Currency label not aligned properly when resize form. 11. #4455: AR/AP CN & Contra Not shown bad recover when Knock Off with IV which have bad debts. 12. #4483: Remove Maintain Style module Checking. 13. Fix unable to edit cancelled sales invoice after process GST return. 14. Fix Create Fresh Sample DB prompt error "You are not allow to bounce before system conversion date." 15. #4544: Capture incorrect GST 03 format for GST Cycle Nov 17 to Jan 18 (Should capture GST DateTo to capture GST03 Format) 16. #4550: GST-03 field 15 should cut-off start from 01 Jan 2018.

Release Build 818.752 - 27 Dec 2017 01. Internal Release 02. Upgrade Database to Version 154 ⦁ Tuning SY_PROFILE, AR_CUSTOMER, AP_SUPPLIER, GST_TR & GST_TR_DRAFT tables. 03. Enhance, Retuning & Fixed Report ⦁ Update EMail Setting for Supplier Statement. ⦁ Update EMail Setting for Stock Transfer Reports. ⦁ Update EMail Setting for Sales Invoice 7. ⦁ Update EMail Setting for Cust Overdue Letter-(with other Info). ⦁ Update EMail Setting for GL OR report. ⦁ Update EMail Setting for Customer Statement.

Page 10 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ Fix Sort Problem on Selection report for GL Journal of Transaction. ⦁ Add Indicator for Mix Tax Code for GST Bad Debt Relief - Sales-Part C17, C18, Purchase-Adj-OutputTax & Purchase-Adj-InputTax report ⦁ Fixed Supp Credit Note (GST) - Full Supplier name overlap with title. ⦁ Add GST Bad Debt Relief - Sales-Part C17 & GST Bad Debt Relief - Sales-Part C18 report. ⦁ Add Supp 06 Months Aging-GainLoss report ⦁ #4449: Apply Stock physical worksheet prompt integer overflow error. ⦁ Fix GST Bad Debt Relief - Purchase-Adj-InputTax & OutputTax report not sorting & shown duplicate.

04. 05. 06. 07. 08.

Create GST return journal document number set after setup GST parameters. #4468: Prompt Access Violation move form between monitor with different DPI Add missing fields for convert GST Process to Draft. Fix repost supplier payment prompt error "GST return already processed" if there is gain loss for knockoff invoice. Fix open attachment prompt "system cannot find the file specified" error if attachment is HTTP URL

Release Build 817.751 - 30 Nov 2017 01. Upgrade Database to Version 153 ⦁ Tuning ST_TR tables. 02. Enhance, Retuning & Fixed Report ⦁ Add GST Bad Debt Relief - Purchase-Adj-Input & Output Tax format ⦁ Feature #4442: List invoices where bad debt relief or bad debt recover already happened based on taxable period ⦁ Update GL Journal of Transaction - Inbalance.fr3 add Export list to text ⦁ Convert Customer Statement with Orig Amt to Fast Report ⦁ Convert Customer Statement - Group to fast report ⦁ Fixed Cust Statement 12 Mths 1-Fixed Month had extra unknown field & no decimal point for Open Credit Amount ⦁ Convert Customer & Supplier Listing to Fast Report ⦁ #4415: Report form data grid auto append a record if press "Down" arrow key on grid ⦁ #4426: GL Journal Listing Filter by Doc No prompt error ⦁ Add GST-Penyata Pembekalan Diberi Perlepasan CBP (RS) report 03. Feature #4438: Document batch lookup add qty column and option "View Qty" 04. #4441: GL Cash Book & Journal should allow to save if detail invoice date greater than document date within same month (Change to confirmation dialog) 05. Pascal Script support TcxCustomEditProperties.Alignment.Horz property 06. Bug #4433: Location lookup become slow when the items has huge stock transactions in same location. Location lookup add option "View Qty" for performance issue user can untick this option 07. #4431: Maintain Batch Unable to AutoRun Code 08. #4437: Access Right - File | Import no function 09. #4416: Stock Batch Lookup "New" should be disabled if no purchase batch modules 11. Feature #4423: Auto post the stock value when click apply on GL Trial Balance, Balance Sheet and P&L Reports 12. Fix application prompt override access right window twice even though ADMIN override the access right 13. #4434: GST taxable button is visible on document entry window if document default window is detail window 14. Feature #4060: Lookup New Entry supported for all master entry forms

Release Build 816.750 - 27 Oct 2017 01. Enhance, Retuning & Fixed Report ⦁ Reverse the Negative Symbol to Credit for GL Journal Voucher - (GST) reports ⦁ #4402: Stock Month End Error when Filter by Category ⦁ Remove redundancy code in Sales Picking List - Level 1-DocUOM ⦁ Fixed GST Detail 4 - Mixed Supplies label for calculation not correctly shown ⦁ Fix GST Summary Sheet - MY-20170106 Relief should not show GST Amount ⦁ Fixed GST Summary Sheet - MY - RSA should not include in DS category 02. Feature #4393: Localize and allow user specified GL Profit & Loss and Balance Sheet Report Grand Totals' Description in Tools | Options 03. Show Account Not Balance in GL Opening Balance when the LocalDR and LocalCR is not equal 04. Fix TcxDBImage unable to load jpeg image 05. Calculate bad debt invoice if invoice has outstanding (invoice DocAmt - payment KOAmt) 06. Update RMCD GST TAP 07. #4407: Customer Contra will Prompt Error if using Form Mode Split Browse & Detail Windows 08. #4410: Maintain Stock Batch rename code (1 space) to other value will cause incorrect update to all empty stock batch transactions 09. Update maybank2e-rc universal payment file format based on version 4.5 10. #4412: Incorrect Drill Down from GST Listing for PV with the Detail Inv No

Page 11 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 11. Feature #4391: GL Opening Balance allow batch edit save and display status to alert user if local DR and CR not balanced

Release Build 815.749 - 07 Oct 2017 01. Upgrade Database to Version 152 ⦁ Tuning SY_Registry tables. 02. Enhance, Retuning & Fixed Report ⦁ Fixed Stock Transfer Report Shown duplicate Serial Number ⦁ Add GST Summary Sheet - MY-20170106 ⦁ Add Sales Picking List - Level 1-DocUOM report ⦁ Fixed Sales Yearly Analysis unable to preview if group by Shipper 03. #4348: AR/AP Payment, CN, Refund & Contra upon save should prompt error if KnockOff documents have been deleted/updated 04. #4390: Stock Batch Lookup should list out Batch without Expiry Date 05. #4396: Font in Company name & Address in Sales Invoice do not follow application font setting 06. #4397: Empty Company Logo in sample database

Release Build 814.748 - 26 Sep 2017 01. Upgrade Database to Version 151 ⦁ Tuning ST_GROUP tables. 02. Enhance, Retuning & Fixed Report ⦁ #4388: Rename "GST | Generate GST Audit File (GAF) to Print GST Audit Ledger and remove "Name" column ⦁ Revise caption in GL Profit & Loss and Balance Sheet report ⦁ Fixed Cust 06 Months Aging-GainLoss Shown wrong Status ⦁ Add Cust Statement 12 Mths 1-Fixed Month report ⦁ Fixed GST Detail 4 - Mixed Supplies DMR Status shown Qualify even no ES 03. Feature #3512: Auto Posting Stock Month End value to Maintain Stock Value according to stock group's Balance Stock account. 04. Move Import "Save GL Account To File" command to SQL Payroll Import PV/JE form 05. Feature #4384: Add Stock Group Column in Grid for All ST/Production/SL/PH Data Entries.

Release Build 813.747 - 18 Sep 2017 01. Upgrade Database to Version 150 ⦁ Tuning GL_ACC tables. 02. Enhance, Retuning & Fixed Report ⦁ Fixed GL Trial Balance - This Year v GAF (Footer) not including Retained Earning ⦁ Fixed GST Detail 3 - GST-03 not Draft GST not shown Capital Goods Aquire Information ⦁ Fixed GST Detail 3 - GST F5-(SG) error on preview report ⦁ Enable Support New Format for GL Balance Sheet ⦁ Fully Convert GL Balance Sheet to Fast Report ⦁ Feature #4356 - GL Balance Sheet title to support Statement Of Financial Position ⦁ Feature #4356 - Change GL Profit & Loss title to Statement Of Comprehensive Income ⦁ GL Balance Sheet Report Title changed upon user change Report Type ⦁ Assigned parameter value "AccountTreeType" for other parts that use GL Balance Sheet Report ⦁ Feature #4341: GL Balance Sheet Report support GAAP format ⦁ Feature #4275: GL Balance Sheet Report support IFRS format. Report form added option "Report Type" ⦁ Auto set "TO" delivery date 14 days after "FROM" delivery date for Sales/Purchase Outstanding Document ⦁ #4376: Stock Month End Balance add UOM Dataset ⦁ Change Customer Aging xml title Cust-Local&Multi-L0-06 Mths-GainLoss to Cust-Local&Multi-L0-06 Mths-UnRealised Gain Loss ⦁ #4358: GL Balance Sheet and GL P&L Report add normal and budget columns by Project, the budget column should not be added the normal column amount ⦁ Set preview report zoom size to 100% by default ⦁ Position trackbar in preview form to vertical 03. Fix disappear GL account type icon 04. #4316: Allow all Sales Document to change Item Detail Tax Amount without key in item code & no perform one cents rounding 05. Maintain Tax's TaxRate Lookup drop down UI not aligned properly 06. Create New DB and existing db upgrade rename GL Account's Fixed Assets->Non-Current Assets and Long Term Liabilities->Non-Current Liabilities 07. Revise AR and AP credit Note UI 08. Feature #4374: GL Journal, AR/AP DN & CN (Journal) system not allow to save if duplicate doc no found in one of these data entries 09. Feature #4381: Add invoice document number to AR bad debt recover and AP bad debt relief description

Page 12 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 10. Show item code stock costing calculation 11. Feature #4373: Stock Location Lookup add Qty field for Data Entry 12. #4056: Edit Sales Invoice Detail's More description by changing all content to upper case to lower case, when close it system no prompt save changes ? and changes are not being saved 13. Feature #4377: Add form mode for GL bank reconciliation 14. Merge Data Import & Data Import (SQL Payroll) menu all under one "Import" menu 15. #4369: Error "No mapping for the Unicode character exists in the target multi-byte code page" 16. #4368: Auto running document number fail in non English language 17. #4370: Prompt Access Violation when Create sample database with invalid sample 18. Feature #4378: Memorize Lookup Search State (A-- / -A-) & Case Sensitive Setting in PC Registry 19. Lookup Grid Column support disable focusing when switch column will skip those focusing=false column (forward and backward) 20. #4361: Lookup prompt access violation error or hang when click grid view's customize filter 21. #4360: Hit ENTER key to focus on next field stop working after close Fast Report designer 22. #4351: Fresh installation with evaluation prompt error after create database

Release Build 812.746 - 10 Sep 2017 01. Upgrade Database to Version 149 ⦁ Tuning SY_Profile & AP_SUPPLIERBANKACC tables. 02. Enhance, Retuning & Fixed Report ⦁ #4357: GL Balance Sheet & PnL "Show Column Options", the Budget field should auto untick once select Variance ⦁ Enable Batch Email for Cust Overdue Letter-(with other Info) format ⦁ #4350: GL Cash Flow Statement - Profit Before taxation should including Prior Year Adjustment ⦁ Fix Sales Delivery Order 4 (Simple) Delivery Tel & Fax label not shown ⦁ Reposition "Apply" button on report param form ⦁ Fixed Supplier Statement still show P even is fully Knock off ⦁ Enable Batch Email for GL Official Receipt - Detail (GST) format ⦁ #4340: Profit and Loss Report doesn't filter Project Code defined in Unicode characters ⦁ GL Local - Ledger - Detail - Level 1 Date column wrongly map to DocDate ⦁ Convert GL Local & Multi - Ledger Summary to FR3 ⦁ Rename Stock Card - Location to Stock Card - Location + SerialNo ⦁ Convert Stock Transfer to FR3 ⦁ #4337: GL Receipt & Payment Report Parameter dataset's OpeningBalance & TotalAmount not set Display Format if preview second time ⦁ Add Report Footer & Change Title From RichText to Memo for GL Trial Balance, GL Profit & Loss Statement & GL Balance Sheet Report (Fast Report Only) ⦁ Convert GL BS - 4C0P to fr3 ⦁ #4331: Outstanding production for sales order document does not exclude non-BOM item ⦁ Fixed GST Summary Sheet - MY IES amount not match with GST-03 ⦁ Fixed RSA DS should not add in Deemed Supply column ⦁ Add GL PnL - 4C4P report ⦁ Remove Document_Document Pipeline for GL Journal Voucher & Bank Adjustment 03. Add support of telegraphic transfer payment mode of Maybank Universal Payment file format 04. Add Giro column, increase size of Bank and AccNo column for AR and AP Bank Account tables 05. Fix Memory leak occurred if click "Giro" button on supplier document listing window more than one time 06. #4334: Document Entries Batch Lookup add column "Exp (Days)" and grid option to filter unexpired batch item 07. Feature #3103: Add access right "Not allowed to delete GST return" and "Not allowed to unlock GST return" 08. #4354: GL OR/PV & Job Order Report Lookup DocAmt column shouldn't show $ symbol and Alignment should be on right 09. Fix process GST return prompt error "Total Local DR (Tax) and Total Local CR (Tax) is not balance" due to output tax, input tax and GST payable to equal zero 10. Feature #4353: Document Transfer (DO/GR->IV/CS/PI/CP) Delivery date should be assigned with DO/GR Doc Date 11. #4293: Unicode characters fail in most recently used dialog 12. Stock Analysis By Document disable Load/Save grid layout 13. Feature #4336: GST Listing detail drill down to original source document (eg. Sales IV instead of customer IV) 14. #4319: Negative access right allow to edit in Maintain Stock Item detail mode 15. Fix display format is missing for qty grid columns on outstanding job order data form 16. #4335: Incorrect transfer qty of outstanding job order listing due to item rate > 1 17. #4294: Purchase Documents' Tax Amount, Local Tax Amount & Taxable Amount should hide if "Show Cost" access right is unticked 18. #4327: SL/PH Documents add new detail record without Item Code shouldn't assign Default Tax Code if company has Tax Exemption Number 19. #4314: Grid in Account Inquiry is too close to form edge

Page 13 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 20. #4306: Gift record with item code can set UOM as blank 21. #4304: Copy & Paste Stock Item Assembly should exclude FromDocType & FromDocKey 22. #4334: SL/PH Credit Note, Stock Adjustment, Stock Issue, Stock Received & Stock Transfer's Batch Item Lookup should list all batch regardless of Expiry Date 23. Company Profile add Report Footer field 24. #4326: Unlock and delete PV or JE will cause incorrect output and input tax after recalculate 25. #4305: Maintain Stock Item UOM Code should limit user key in 10 characters only (currently can key in more than 10, it only truncated after press enter) 26. #4309: Incorrect output or input tax of draft GST return created after recalculate GST return if invoice deleted after unlock GST return 27. Allow user to configure firebird database properties such as forced writes and page buffers 28. Optimize lookup for better performance and reduce user objects (task manager) 29. Revise Command Navigator to draw icon caption

Release Build 810.745 - 03 Jul 2017 01. Upgrade Database to Version 148 ⦁ Tuning Tax tables 02. Enhance, Retuning & Fixed Report ⦁ Feature #4017: TX-NC transactions should list in GST Listing and GAF Feature #4237: TX-NC follows expense code if GL code is blank ⦁ Fixed GST Detail 1 preview error when using GL Bank Adjustment ⦁ #4296: Sales credit note detail with initial purchase cost not reported correctly in GST-03 report item 5a ⦁ Fix one cent different on tax amount when calculate AR bad debt recover and AP bad debt relief ⦁ Convert GL BS - 2C2P to Fast Report 03. #4303: All Document Entries Default Tax Code should show blank since De-register GST Date 04. #4285: AR/AP Credit Note should not allow to set Post Date & Tax Date if Document created from Sales / Purchase CN 05. #4298: Sales Invoice Edit Permit No prompt error when the document haven't processed GST 06. Fix open GST return window slow due to there are more than 100000 records of journal entry 07. #4300: Prompt Access violation on Generate GAF (DateFrom & DateTo < SystemConversionDate) 08. Remove NextDocNo popup bottom edge line from all document entry 09. #4297: Unable to knockoff invoice with past credit note contains GST taxable 10. #4295: Customer GST number is blank after apply GST bad debt relief report 11. Feature #4291: Select first item of supplier bank account based on selected supplier code 12. #3631: GL Journal Browse Grid display the local DR (Tax) as blank After Save Journal Entry 13. #4290: Bottom controls in Qty popup windows are missing 14. #4287: Incorrect unit cost of gift item if change item UOM 15. #4279: Show double entry is not balance for past document 16. Fit mdi child form to Main Form work area when maximize 17. Feature #4284: Standardize all sales & purchase entry screen title to full word and same font size 18. #4283: NextDocNo in all sales & purchase document entry screen not aligned with the label

Release Build 809.744 - 14 Jun 2017 01. Upgrade Database to Version 147 ⦁ Tuning GST_TR, GL_Trans & GST_Process tables 02. Enhance, Retuning & Fixed Report ⦁ Feature #4251: GL Profit Loss & Balance Sheet Report's option "Print Sub Account Only" able to display auto created account records (special subtotal) ⦁ #3810: GL Balance Sheet & Profit Loss Reports Apply Project Comparison Slow ⦁ GL Profit Loss Report support Batch Columns Query for project comparison (within same date range) to speed up performance ⦁ GL Balance Sheet Report Optimized S13_CalculateMain replaced with ClientDataSet looping instead of Local Query to speed up performance when user apply more columns at once ⦁ GL Balance Sheet Report support Batch Columns Query for project comparison (within same date range) to speed up performance ⦁ #4267: Stock Transfer Listing Fixed Cost Item's Actual Cost & Actual Amount incorrect if last item UTDQty < 0 ⦁ #4245: Stock Card with Fixed Costing Stock Transfer (In Qty Location) Unit Cost was zero (should follow item's RefCost) ⦁ Fixed GST Summary Sheet - MY Exampted Amount not correct when Dmr Fail ⦁ Fixed GST Lampiran 4 error preview when description had [ ] symbol ⦁ #4254: Stock Card Detail Cost Incorrect for Stock Transfer Item (FIFO) ⦁ #4250: GL Balance Sheet & Profit Loss Report should support Multi Select for "Print Sub Account Only" ⦁ Add Customer Cust 06 Months Aging-GainLoss report ⦁ Fix Purchase Analysis By Document - Level 2 preview unlimited page

Page 14 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ Increase Header Font size for Customer/Supplier Invoice, Debit Note & Credit Note Full page reports ⦁ Fix GST Listing Error if using Journal Voucher ⦁ Increase Font size for Customer/Supplier Invoice, Debit Note & Credit Note Full page reports ⦁ #4229: Stock Bom Wastage Report Qty will round up to 2 decimal point if value exceed 2 decimals ⦁ Add BOM Material Usage - JO vs SO Variance report ⦁ Remove Stock BOM Material Usage-Materials Required Plan (MRP) report ⦁ Fine tuning script for GL Local - Cash Book Listing (GST 1) report ⦁ #4281: Apply GL Ledger prompt Error C.ColumnNo Column unknown error 03. Feature #4272: Add currency symbol to NetTotal label for AR & AP document entry 04. Feature #4247: GL/SL/PH documents edit PermitNo will auto update GST table (Mark the particular GST Process to Invalid GST Audit File). Open GST Return form add option to Generate GAF 05. Show status on open GST return window if audit file is invalid 06. #4260: Open GST Return Slow when open form 07. #4258: Amend RSA Transaction will cause missing in Ledger 08. Feature #4269: Add gain/Loss ledger posting date column in KnockOff grid 09. Feature #4271: Add LocalNetTotal and NetTotal info at the footer of Cash Book Entry 10. #4268: Process GST Return DO 21 Days Rule didn't trigger for Negative Qty in DO 11. #4270: "Control " has no parent window" exception is raised when edit DateEdit 12. #4273: Edit GL Journal Prompt Access Violation Error when using Form Mode (split browse & detail screen) 13. #4256: Unable to find record. No key specified error message when try to exit SQL program 14. #4255: Edit Journal Entry raise error "Unable to find table name of this DocType "GP"" 15. Feature #4243: GST Audit File Ledger part should include Retained Earnings Balance B/F transactions 16. #4228: Job Order Print count not update even had print/exported 17. #4246: View | Show Chart missing tool buttons 18. #4225: Click cancel in multi form mode dialog does not abort in drill down operation 19. #4227: Changing company name doesn't update in DCF file 20. #4242: Drill down from View | Sales Price History prompt error if Sales Invoice Browse Screen don't have Company Code column 21. Fix Database upgrade script version 143 prompted error Arithmetic Overflow when LocalAmount/CurrencyRate (e.g 475734.84 / 0.000321) 22. Enable tab stop for company name, address, doc description & etc under sales, purchase & stock entry screen 23. Upkeep all stock entry screens for better viewability 24. Upkeep all sales entry screens for better viewability 25. Upkeep all purchase entry screens for better viewability 26. Show DISC column for all sales entry document 27. Upkeep detail screen grid columns for better viewability 28. Fix performance issue for Analyse Data Integrity "Resequence Table Fields"

Release Build 806.743 - 30 Apr 2017 01. Upgrade Database to Version 146 ⦁ Tuning GL_JEDTL, AR_CN, AR_DN, AP_SC & AP_SD tables 02. Enhance, Retuning & Fixed Report ⦁ Enable support new JE Structure for GST Detail 1, Lampiran 2 & Lampiran 2 with ZR report ⦁ Fix GST Detail 1 & 2 CompanyName & Description for OR & PV not correctly capture ⦁ Update GST F5 Return to map Field 13 ⦁ #4175: Stock Transfer Report Main Pipeline missing Company Name field ⦁ Fixed GST Detail 1 & 2 Gain & Loss Symbol incorrect set ⦁ Fixed Error when amount is 0 for Sales Cash Sales 6 - Receipt-TM-U220 (Tax Invoice – Simple) ⦁ Add Project Description for GL Profit & Loss Statement ⦁ Add Project Description for Balance Sheet Reports ⦁ Optimize performance of GST bad debt report; rename parameter date caption to docdate ⦁ Fixed Cust Local - Payment Listing - Collection Report not sort by IV ⦁ Add Detail For T, O1, E & O2 for GST Detail 4 - Mixed Supplies 03. Feature #4200: GL Journal Entry add new GST Fields (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country) 04. GL Cash Book & Journal Document Listing add new GST Fields (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country) to detail grid 05. GL Journal Entry added new GST Fields (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country) 06. GL_JEDTL table add new fields for GST Audit File (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country) 07. Feature #4180: AR & AP Journal (DN & CN) for non-GST adjustment 08. Add support for drill down to Journal document correctly if has duplicate doc no in GL Journal and AR/AP DN & CN

Page 15 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected].com.my Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 09. 10. 11. 12.

AR/AP Document Listing Report Grid add "DocType" column for AR/AP DN & CN GL Journal Listing Report's Detail Grid visible columns should same as GL Journal Entry GL Journal Listing Report and Journal Lookup support retrieve data from AR/AP DN & CN GL Journal browse grid click "Detail" button will drill down to AR/AP DN & CN if FromDocType is not empty. Support detail form able to click "Browse" back to browse grid if detail entry is empty record 13. GL Journal browse grid retrieve journal doc from AR/AP DN & CN 14. AR/AP DN & CN Entry Form label caption indicate "JE" if doctype is journal 15. AR/AP DN & CN support "New JE" journal document 16. AR/AP DN & CN tables add DocType field 17. Adjust GL Cash Book DocNo lookup coding to allow to set CacheData directly instead of define another ILookupProp class 18. #4037: Clone GST Malaysia database (Master Data only) and register as GST Singapore license 19. Revise get country name in Profile UI form 20. Localization for Motor business 21. #4212: Unable to save Maintain Customer/Supplier branch field changes using F3 key 22. Prompt user friendly exception message if a payment knock off same invoice more than once during calculate bad debt relief and recover 23. Update resourcestring for UBS Data Import 24. Feature #4181: GST F5 Report (SG) should retrieve value for Revenue (item 13) 25. #4204: GL Cash Book Detail "Inv Date" cannot greater than Master DocDate 26. #4183: All Documents not allow to save if currency rate is zero 27. #4199: Negative access right shouldn't allow to edit in Maintain Stock Item 28. Feature #4195: Maintain Stock Item Browse Grid add "Barcode" column 29. #4203: Spelling Error "Delivery Order" on SQL Power Search 30. #4198: Unable to clear supplier bank on supplier payment 31. #4194: Unable to bounce cash book even though bounced date fall on the taxable period already unlocked 32. Fix potential error in TDBDataSetBrowse.AddFields if SQL does not contain 'order by' clause 33. Feature #4179: AR/AP Payment & Refund Paid Amount & Unapplied Amt labers should indicate the currency symbol

Release Build 802.742 - 25 Mar 2017 01. Upgrade Database to Version 145 ⦁ Tunning GST_TR, TAX & GL_CBDTL tables 02. Enhance, Retuning & Fixed Report ⦁ #4073: Access violation when re-focus on 2nd level report grid with twice apply ⦁ #4076: Access Violation when activate filter on TClientDataSet due to field names "Seq" appear twice in IndexFieldNames (duplicate) ⦁ #4077: GST-03 Drill Down Form Filter Row by doc date not working ⦁ Fixed GST Lampiran 2-with ZR Output PermitNo not shown in some situation ⦁ #4088: GST Taxable Listing Report should show past documents taxable transactions ⦁ Change Report Title for Balance Sheet IFRS to "Statement of Financial Position As At" ⦁ Fixed GST Detail 3 - GST-03 Item 12 caption from (Gain)/ Loss to Gain/ (Loss) ⦁ Fix Cust Aging PDC Total Balance is empty ⦁ Fixed GST-Penyata Pembekalan Dikecualikan (ES & IES) JV Not included in report ⦁ Remove Allow Expression for Company Letterhead for Customer/Supplier IV, DN & CN & GL PV & OR ⦁ Convert GL PnL - 6C4P to fast report ⦁ Fix GL Local - Ledger - Detail - Level 1 export to Excel Grand total missing ⦁ Fix GL PnL - 6C4P % mapping error ⦁ Fixed GST Detail 2 not group by tax code 03. #3962: Unable to continue utilize COM object implemented by OPF 04. #4080: Gift document allow to change date even though the document already processed in GST return 05. #4087: GST Taxable button is missing after update in the Past Document 06. #4102: Giro - Incorrect payment amount for foreign supplier where payment method in local currency 07. #4104: GST Taxable Transaction didn't copy to GST_TR table if user never process GST 08. #4111: CN UnitCost not in smallest UOM if using UOM rate <> 1 09. #4074: AR/AP Payment should not allowed to delete the payment if posted from Cash Sales/Cash Purchase/Sales Order/Purchase Order 10. Enable single enter key press for stock item search 11. #4114: Incorrect output tax calculated if gift document contains record with OS tax code 12. #4056: Edit Sales Invoice Detail's More description by changing all content to upper case to lower case, when close it system no prompt "Save changes?" and changes are not being saved 13. #4085: Incorrect document number posting to transactions table (e.g GL_TRANS) after edit document for new document number 14. #4091: Unable to paste picture in RTF Editor 15. #4090: Access Violation When Delete Document Entries from Browse Screen if Split Browse & Detail Form Mode Applied

Page 16 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 16. Feature #4126: Tools | Option | Customer, Rename the checkbox caption "one cents different rounding (local currency fields) for all AR/SL Documents (Recommended)" to "Perform Tax / Local Amount Rounding". New database by default the option will be ticked 17. #4012: Disallow to Save Cash Sales & Cash Purchase when there is payment Amt and payment method is blank 18. #4132: User access right uncheck "Show Price in Delivery Order" should allow to access "Tax Code" field 19. #4122: Stock Item Search (F9) should auto focus on search item field after open the form 20. #4121: Prompt Access Violation when close Stock Item Search with Active Row Filter 21. Feature #4143: Tax code changes from the GST Guideline (02 March 2017) 22. Feature #4144: GST-03 Report changes from the GST Guideline (02 March 2017) 23. #4147: GST Taxable for AR/AP PM & CN should disable and only allow Past GST Taxable entry 24. #4045: Default filter operator for some string fields do not set to CONTAINS 25. #4165: Sales CN save with detail Qty=0 prompt error "Division by Zero" 26. #4162: Thousand separator in yearly amount of gift document does not fully display 27. Feature #4161: Stock Batch Lookup by Item should show only unexpired batch baesd on DocDate 28. GL Cash Book Detail table add GST_DocDate, GST_DocNo, CompanyName, RegisterNo, PermitNo & Country. Upgrade GSTNo field to 25 characters 29. Feature #4155: Cash Sales Payment Dialog should make currency edit box wider so can display more digits 30. Adjust GST listing drill down to document by document key 31. #4159: GL Cash Book Entry add new fields for GST Audit File (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country) 32. #3979: GL Cash Book Company Name Lookup (support add new value which not exists in the lookup). Upon change Company Name, system will retrieve GSTNo & RegNo that saved in table previously

Release Build 799.741 - 19 Jan 2017 01. Upgrade Database to Version 144 ⦁ Tunning GST_TR & GL_TRANS tables 02. Enhance, Retuning & Fixed Report ⦁ #4061: Apply GST gift listing report prompt "field seq not found" error ⦁ #4066: GL Ledger Prompt Error if group by Project when Financial Date <> Conversion Date ⦁ #4058: Apply Stock Card trigger costing exception not raised out (but there is a exception in debug mode) ⦁ Add KnockOff Info for Customer & Supplier CN (GST) ⦁ Fixed GST-Ledger-Vs-GST-03_6b & GST-Ledger-Vs-GST-03_5b report not shown for current process ⦁ Fix GST Detail Listing 1 & 2 preview error when there is bad debts ⦁ Fixed GST Listing Detail 1 & 2 Cash Book Info not fully shown ⦁ #4050: Amount column Stock Transfer Listing show currency symbol 03. #4063: Create DIY Field prompt error if login to non-English language 04. #4059: Improve performance in browse/detail form 05. #4065: GL Ledger Transaction posted by GST Process TaxDate is blank. Assigned description for unclaimable transaction in GST_TR (TX-RE and TX-ES) 06. #4064: GST Audit File Bad debt Transaction AJP should appear in Purchase part while AJS in Sales part and unclaimable ( from TX-IES and TX-RE) should add into GAF 07. #4067: GST_TR table contains records with name is blank for GL cash book, journal and foreign bank adjustment 08. #4062: GST Audit File GL part no records 09. #4057: Set GainLoss Posting Date Dialog not prompted when all GainLoss amount sum up equal to 0 10. #4054: Slow when operate the application by turn on Price History or Available Stock Balance 11. #4052: GST Listing double click Summary Grid Record prompt Access violation in cxGridRS24.bpl when Filter Row is not turn on. 12. #3952: Fix to dock all form DockPanels to DockSiteMain instead of dxDockPanel1.

Release Build 798.740 - 11 Jan 2017 01. Upgrade Database to Version 143 ⦁ Tunning SY_ALLOWDATE, GL_TRANS & GST_GIFT_DTL tables ⦁ Add GST_TR table 02. Enhance, Retuning & Fixed Report ⦁ Feature #4024: GST Listing Report add Summary Grid to show summary by tax code ⦁ Revise mouse double click event in GST Listing ⦁ Revise GST Listing UI ⦁ Enable support New Table name for GST Listing reports ⦁ Adjust GST.DP, GST Listing, GST-03 & GST F5 Report to support new columns in GST_TR ⦁ Adjust implementation of GST bad debt report ⦁ Adjust GST Taxable Listing Report to retrieve from GST_TR ⦁ GL Ledger Report add Tax Filter & Grouping

Page 17 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 ⦁ Increase Title size for Customer & Sales Invoice 3 (GST) ⦁ Split the Title Tax Invoice & No for Customer & Invoice ⦁ Stock Item List add barcode information ⦁ GL Local - Ledger - Detail - Level 1.fr3 add Grand Total for DR & CR ⦁ #4003: Sort Stock Group first by default in Stock Item Listing ⦁ Fixed GST Detail 3 - GST-03 Gain should be in positive & Loss is in negative symbol ⦁ Fixed GL Payment Voucher - Detail (GST) - Refund not shown Currency Word ⦁ #4046: Account Inquiry apply no data

03. 04. 05. 06. 07.

Fix incorrect local amount of bad debt relief and bad debt recovered if invoice tax amount calculated based on taxable amount Add support of re-sequence detail records for gift data entry Feature #4038: Change button caption from Giro (Beta) to Giro Feature #4022: Add color setting to Remark field in Company Profile Feature #4033: Change the report name from Customer Sales and Collection to Customer Bills and Collection in Menu and Access Control (same applied for AP) 08. Feature #4026: Hide tax inclusive column on detail grid of gift data entry 09. #4009: AR/AP Invoice & Credit Note's Detail remains if copy and paste from current to new create past document 10. Feature #4008: Analyse Data Integrity | SQL Control Center add countdown dialog to close form in 5 seconds 11. Fix missing up down button image 12. Feature #4014: Auto tick Split Browse & Detail Windows when create new form mode 13. #4013: Enable license checking for GIRO module 14. Feature #3945: Acceptable Transaction Date support Context & Feature #2274: GL Bank Reconciliation Lock by Acceptable Transaction Date 15. #4043: Access Violation when Activate license due to Remark_Markup 16. Fix Database upgrade script version 143 to convert SystemConversionDate dd/MM/YYYY to YYYY-MM-DD before CAST as Date in sql

Release Build 794.739 - 19 Dec 2016 01. Enhance, Retuning & Fixed Report ⦁ #3991: Apply Stock Card Prompt Error due to too big amount ⦁ #3961: Data will duplicate if select "Print Sub Account Only" for GL Balance Sheet & GL Profit & Loss ⦁ Fix GST Detail 4 - Mixed Supplies Status for 0% should not Qualify ⦁ #3950: Rename GL Ledger Report Form's CheckBox "Include Zero Transaction" to "Include Zero B/F with Transactions Before" ⦁ #3976: Stock Card Qty unable to shown opening balance if Project Module is Disable ⦁ Add GL PnL & Balance Sheet This Year vs Last Year Budget ⦁ Fixed GL Trial Balance - This Year v GAF (Footer) should exclude Stock Value ⦁ Fixed GST Summary Sheet - MY some amount not correct when AccType is Empty ⦁ Fixed Stock Adjustment & Received Listing DocAmt not follow filtered Detail ⦁ Fixed GST Listing Detail 1 SR & ZR mixed ⦁ Fixed GL Balance Sheet 2 Column Fixed is Amount is Net ⦁ Convert AR & AP Invoice, Debit Note & Credit Note (GST) to fast report ⦁ Fixed GST Detail 1 & 2 Other Category will shown Double for same Tax Type with Different Tax Code 02. Feature #3997: Change Customise Module 03. #3994: Sales Profit Estimator by default hide Tax, Tax Rate, Tax Amt & Tax Inclusive grid columns in Field Choser 04. Analyse Data Integrity add "SQL Control Center" allow user to do DIY field setting without logon db. DIY Fields Form Add "Reduce Size" button for string field only 05. #3999: Maintain GL Account Industry Code should be hidden if GST Module not activated 06. #3990: Slow in selection for Serial number when selection 5000 serial Numbers 07. #3992: Input tax relate to TX-ES cannot be claim if the ES = 0 (no ES) in the taxable period. Bug #3422: Deminus rules infinity should be FAILED where total supply is zero for the month 08. #3988: Duplicate company code displayed at Maintain Customer/Supplier list if there are more than 1 billing branches 09. #3975: Sales Invoice unable to save if enable 5 cent rounding & Prompt Stock Qty Control dialog 10. #4000: File | Open prompt error : Insufficient RTTI available to support this Operation 11. #3969: Show host name in Show Active Connection 12. #3987: Batch EMail - Statement aging will shown all same amount for different customer

Release Build 793.738 - 17 Nov 2016 01. Enhance, Retuning & Fixed Report ⦁ Add Balance Sheet - This Year - 3 Column-IFRS-Currency report ⦁ Add GL PnL This Month vs This Year-Currency & This Year - 2 Column-Currency Reports 02. #3958: Foreign bank adjustment allow to change post date to taxable period even though detail contains gain loss account

Page 18 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 03. 04. 05. 06.

#3959: Do not find inactive Stock Item in Barcode form (F8) #3956: Edit Customer Refund / Supplier Refund prompt error : Dynamic SQL Error : Count of Column List and variable List do not match #3906: Gift Entry add Stock Qty Control checking Fix decimal places of GST amount claimable not fully display even though open GST return window in maximize state

Release Build 792.737 - 12 Nov 2016 01. Upgrade Database to Version 142 ⦁ Upgrade to Unicode ⦁ Add LocalAmount_Output, LocalTaxAmt_Output, LocalAmount_Input and LocalTaxAmt_Input columns to GST_PROCESS table ⦁ Feature #3766: All Phone and Fax Fields upgrade from 20/30 to 200 characters ⦁ Feature #3767: Upgrade database numeric fields to support precision 18 so that can store more digit numbers 02. Enhance, Retuning & Fixed Report ⦁ Revise GST Summary Sheet - MY Code for Easy Maintain ⦁ #3932: Yearly Sales & Purchase Analysis TransDesc Field in Document_TransType no value ⦁ Fixed Sales Yearly Analysis report unable to view on Group by Transaction ⦁ Revise GST-Ledger-Vs-GST-03_5b & GST-Ledger-Vs-GST-03_6b Script for easy maintain ⦁ #3859: Unable to show tax amount of gift documents that already processed in GST return when preview gift listing report ⦁ Fix GL PnL - 2C2P & GL PnL 2C - 2C1P Alignment Problem for Long Description ⦁ Convert GL BS - 2C0P to Fast Report ⦁ Fix GL BS - 3C0P-IFRS & GL BS - 3C0P Alignment Problem for Description very long ⦁ Fix Cust Local - Credit Note Listing (GST 1) - GST Adjustment error when CN is Knock off by Refund ⦁ Fixed GL BS - 3C0P.fr3 total not correct if Level more then 2 ⦁ GST Summary Sheet - MY RS had wrongly added to input total ⦁ GST Lampiran 2 Should filter by FromDocType ⦁ #3920: Missing display format for MinQty and MaxQty fields in stock reorder advise report ⦁ Improve performance for GL Journal Of Transaction - Post and Tax Date Exception report ⦁ Fixed Currency Rate not shown for GL Official Receipt & Payment Voucher ⦁ GST Lampiran 2 - Add Permit No for Output Tax column K1 ⦁ Add GST-Lampiran B-0 PT GST Bil 2B (ATS) (IS), GST-Penyata Eksport (ZRE), GST-Penyata Pembekalan Dikecualikan (ES & IES) & GST-Penyata Pembekalan Tempatan Berkadar Sifar (ZRL) reports ⦁ Fixed GST Listing to support changes to Pivot Feature ⦁ Fixed Customer & Supplier Statement * Status not correctly shown in some situation ⦁ Fixed Sales Analysis By Document Grand total Amount empty if more then 3 page when export to Excel ⦁ #3954: Error when setting HideZero = True for string field binding to FastReport's MemoView control 03. #3936: Disable the Set Tax Date for GL Cash Book OR 04. Add additional company profile fields (RegisterNo, Phone1, Address1 & Address2) in Giro format. 05. #3935: System will not continue append for remaining Items in template if exception EAbort raised 06. #3888: Unable to transfer to Purchase Invoice if Stock Group & Purchase Account in Options is empty 07. #3933: Runtime created form in DIY script didn't scale properly in High DPI environment 08. Add Tax Year option on new GST return window 09. Feature #3919: Revise message of unlock GST return 10. #3931: Change the Open GST Grid Highlighted Background 11. #3875: Position of VCL Controls on TdxDockPanel changed after docking a new TdxDockPanel 12. Feature #3903: Job Order browse grid add Assembly Code, BOM Template, Qty, UOM, Location, Batch & Split To grid columns 13. Feature #3905: AR/AP Aging Report by default tick checkbox "Historial (by Post Date)" if "Document Date, Posting Date" module is activated 14. #3915: Outstanding Sales Document Listing checkbox description rename from "Calculate Outstanding SO & POO" to "Calculate Outstanding SO & PO Qty" 15. Feature #3922: Allow user to change account code in cash book and journal after process GST return except realised exchange gain loss and capital goods acquired cases 16. #3887: Bad debt occurs for an invoice even though no outstanding and payment tax date set to future 17. Feature #3872: Make GL Account Entry dialog stay after exception occur 18. Feature #3901: Add access control for File | Data Import 19. #3898 and #3917: Knockoff tax date set as invoice tax date if payment (before GST effective date) or payment (after unlock GST return) knockoff an invoice that already processed 20. Fix incorrect local amount of gift detail after process GST return if the detail contains small amount (example: 0.01) and non-zero tax rate 21. Feature #3904: Gain loss Post Date follow which ever is latest, Main Documents PostDate (PM/CN/CF) or Knockoff documents (IV, CN, PM, CN) PostDate 22. Tidy Maintain Budget to work correctly with Pivot Grid Transform

Page 19 of 92

eStream MSC Sdn Bhd (825433-U) 1, Jalan Setia Dagang AK U13/AK, Setia Alam, 40170 Shah Alam, Selangor DE, Malaysia. (CP No: B16-1809-32001103)

Tel.:- 03-7890 1300, Fax.:- 03-5886 9913 E-Mail : [email protected] [email protected] Web : www.estream.com.my

SQL Accounting History Date : 23/02/2019 08:51:03 23. Tax rate of bad debt relief and bad debt recover should based on invoice document date before post into GST_TRANS table 24. Fix RMCD GST TAP error if there is "Attention Needed" appears in portal during new return period 25. Unable to calculate past invoice bad debt relief due to tax date falls on or after system conversion date 26. #3892: GL Trans will post invalid table type S & T if 2 people edit same doc. Bug #3873: Double knock off if 2 users edit same CN & Save on same timing 27. #3885: Tools | Options | Customer | One Cent Different Rounding option enable only if current user didn't open any (AR/SL) forms and no other connected user except current user, otherwise the option will be disabled 28. #3891: Customer/Supplier IV, DN & CN detail is limited to 70 characters (should support 200 characters) 29. Support Firebird 3.0 30. Fix Unicode Diagnosis didn't replace with question mark if non-ascii character found 31. Fix transliterate error in Database Encoding Diagnosis when upgrade to Unicode 32. #3948: Win32 Action form not resize to specified number of action buttons 33. Feature #3897: Set 0.75 second delay in grid's row filter as default 34. #3918: Unicode text shows question mark (?) in using E-Mail Client & E-Mail Client (Batch) 35. Fix unable to restore raw firebird backup file via embedded connection 36. Feature #3946: Prompt message for outstanding delivery orders have been processed (total local amount and total local tax amount not equal to zero) after process GST return 37. Fix Unicode Diagnosis value not updated, if the field which need to be fixed is same as the Key Field (e.g Stock Group's Code). Add prefix for the param for the field which need to be fixed to avoid conflict with the param name in SQL WHERE clause 38. Revise splash implementation & product title font type in logon form

Release Build 789.736 - 10 Sep 2016 01. Enhance, Retuning & Fixed Report ⦁ Fixed Sales Invoice 3 (GST 2) Footer Disc not including itemcode DISC ⦁ Fixed Sales Quotation 3 (Sales Disc) batch print incorrectly shown Disc amount ⦁ Rename GST Detail 3 - GST F5 to GST Detail 3 - GST F5-(SG) ⦁ Fixed Sales Cash Sales 6 - Receipt Paid Amount shown zero if not using payment Dialog ⦁ Fix SL/PH Price History Report Group Header SubTotal & Base Qty Display Format (display wrongly when there are decimal values) ⦁ Fixed GST Summary Sheet - MY overdeduct for TX when using TX-CG ⦁ GL Local - Ledger - Detail - Level 1 Description 2 shown wrong info if had same Journal Begin with B or C ⦁ Add GL Acc Code for GL PnL - 2C2P format ⦁ Fixed GL PnL - 2C2P font format not follow the xml ⦁ Add Header for GST Amt for GL Journal Voucher - Full & Half (GST) ⦁ Add Project Parameter for Fast Report Balance Sheet & GL PnL Reports ⦁ Fixed GL PnL 2C - 2C1P line not properly drawn ⦁ Fixed Description overlap on DocNo for GL Journal of Transaction - Inbalance 02. Add GST Return matching with RMCD Customs TAP portal 03. #3878: Maintain Stock Value if untick project should show total figure for ALL project 04. #3870: Bank Account contain B/F Amount (but without current date range transaction) did not appeared in GST Audit File 05. [GST-MY] Feature #3867: Tax code GS (disregard supply) should not declare in GST-03 item 13. 06. Revise GST Guidelines menu item open with build-in PDF viewer 07. #3861: Change "Maintain Scripts" caption to "Maintain Commission Script" 08. #2991: Save a document with empty shipper field prompt Field Value Required 09. Feature #3698: Add RichTextToPlainText function to DIY Scripter 10. #3851: Payment Dialog not show when pressing F3 to save a cash sales 11. #3845: Revert Bug#3805 Stock Card Qty filter by Project 12. #3838: Maintain Chart of Account's Tax Code should be able to choose Non GST Tax Type 13. #3829: Save Negative Qty will by pass if user Enter 0 & Enter back the Qty 14. #3848: Addresses fields in Maintain Customer/Supplier has smaller font size 15. #3849: Prompt "At end of Table" error in Sales Invoice when change document date 16. #3850: Date, Agent & Terms in Delivery Order has smaller font size 17. #3833: Drop temporary tables in nested transactions 18. #3843: View | Price Tag form has smaller font size 19. #3842: Customer/Suppler Contra Listing Filter by Agent prompt Invalid Date error

Release Build 788.735 - 09 Aug 2016 01. Upgrade Database to Version 140 ⦁ Retuning Tax tables. ⦁ Add PermitNo to all Sales Document Detail Tables for Export Declaration Number Purpose

Page 20 of 92