SQL Account GST update history


Information

Last updated: 21/01/2017
Current version: 5.2017.801.741
Size: 50.7 MB
Username & Password: ADMIN

New in this version

  • Bug #4068: Job Order qty not correct in Stock Reorder Advice and Stock Physical WorkSheet if JO detail contains same item code
5.2017.800.741
  • Close assistant windows after logout
  • Fix bug #4028: Transactions (ZP, IS, GP and RP tax type) not reported for total value of capital goods acquired in GST-03 report
  • Year End assign TaxDate value when insert Opening Balance to GL_Trans. Remove unused variables
  • Bug #4068: Job Order qty not correct in Stock Reorder Advice and Stock Physical WorkSheet if JO detail contains same item code
5.2017.799.741
  • Database upgrade to version 144
  • Update App.XF font type
  • Bug #4063: Create DIY Field prompt error if login to non-English language
  • Bug #4059: Improve performance in browse/detail form
  • Bug #4066: GL Ledger Prompt Error if group by Project when Financial Date <> Conversion Date
  • Fix bug #4061: Apply GST gift listing report prompt "field seq not found" error
  • Bug #4065: GL Ledger Transaction posted by GST Process TaxDate is blank. Assigned description for unclaimable transaction in GST_TR (TX-RE and TX-ES)
  • Bug #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
  • Fix bug #4067: GST_TR table contains records with name is blank for GL cash book, journal and foreign bank adjustment
  • Bug #4062: GST Audit File GL part no records
  • Bug #4057: Set GainLoss Posting Date Dialog not prompted when all GainLoss amount sum up equal to 0
  • Refactor View Chart
  • Bug #4058: Apply Stock Card trigger costing exception not raised out (but there is a exception in debug mode)
  • Refactor Stock Item Picture
  • Refactor Price Tag
  • Refactor Stock Item Search
  • Refactor Sales / Purchase Price History
  • Bug #4054: Slow when operate the application by turn on Price History or Available Stock Balance
  • 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
  • Bug #4052: GST Listing double click Summary Grid Record prompt Access violation in cxGridRS24.bpl when Filter Row is not turn on
  • Bug #3952: Fix to dock all form DockPanels to DockSiteMain instead of dxDockPanel1.
  • Fix GST Detail Listing 1 & 2 preview error when there is bad debts
  • Revise IDBConnection.GetTableNames implementation
  • Remove DataRecoverManagerUnit
  • Fixed GST Listing Detail 1 & 2 Cash Book Info not fully shown
  • Remove old Stock Data Recover code and unit. Year End calculate costing refer to new data recover framework
  • Remove TDBManager.GetFieldDefs method
  • Bug #4050: Amount column Stock Transfer Listing show currency symbol
  • Revise Account menu xml
  • Revise TTransferStatusActions implementation
  • Remove TItemMatrixDataSource_old and TDocumentItemMatrixActions_old in SQLAccDocumentActionsUnit.pas
  • Relocate type library resource SQLAcc.TLB in .dpr file
  • Remove IntegralHeight property setting
  • Remove unused units

5.2017.798.740
  • Fix Database upgrade script version 143 to convert SystemConversionDate dd/MM/YYYY to YYYY-MM-DD before CAST as Date in sql
  • Bug #4046: Account Inquiry apply no data
  • Fixed GL Payment Voucher - Detail (GST) - Refund not shown Currency Word

5.2017.797.740
  • Remove unused units
  • Remove IntegralHeight property setting
  • Relocate type library resource SQLAcc.TLB in .dpr file
  • Remove TItemMatrixDataSource_old and TDocumentItemMatrixActions_old in SQLAccDocumentActionsUnit.pas
  • Revise TTransferStatusActions implementation
  • Revise Account menu xml
  • Fixed GL Payment Voucher - Detail (GST) - Refund not shown Currency Word
  • Bug #4043: Access Violation when Activate license due to Remark_Markup

5.2017.796.740
  • Database upgrade to version 143
  • Replace GST Malaysia Testcases hard code Year to CurrentYear function
  • [Merge]: Revise GST Listing implementation
  • 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
  • [Merge] - Add GST support for Year End
  • Feature #3981: Year End Auto Copy GL P&L & GL Balance Sheet Amount to Budget
  • Year End Outstanding DO checking should based on GST Start Date instead of the very beginning of date
  • Year End add confirmation message to prompt if latest GST process Date vs Year End Date is less than 9 months (this is to make sure bad debt calculation correct)
  • Fix past taxable process not auto processed if recalculate GST return after run year end
  • Adjust Year End Insert Past Document Details as GST Taxable to new GST_TR
  • Adjust Year End Insert DO 21 days GST OffSet post as GST Taxable to new GST_TR (into date range not process GST yet)
  • GL Cash Book & Journal documents details (PostDate<=YED, TaxDate>YED (not yet process GST only)) which has GST tax code will be inserted as GST Taxable in GST_TR (AutoPost=False)
  • Year End Remove Post Date (Before YED) & Tax Date (After YED) checking for AR/AP IV, DN, GL CB & Journal
  • Year End replace table GST_TAXABLE to GST_TR. No need to purge GST_TR (AutoPost=0) records even though source doc have been purged
  • [Merge]: Revise GST implementation
  • 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
  • GST Audit Forms (View by single process) add Description grid column in GL Ledger section
  • Adjust GST Audit File report coding to query from GST_TR. GST Audit File able to query from a range of GST Process instead of one only
  • Adjust implementation of GST bad debt report
  • Adjust GST Taxable Listing Report to retrieve from GST_TR
  • Fix GST taxable test cases fail
  • Fix incorrect local amount of bad debt relief and bad debt recovered if invoice tax amount calculated based on taxable amount
  • Adjust implementation of GST data loader, GST return calculation and posting
  • GST return transactions posting to GST_TR and GST_TR_ADJ table
  • GST Taxable Entry not longer post to GST_Taxable but is posted to GST_TR and add new PermitNo & SIC Fields
  • Add New Tables "GST_TR", "GST_TR_DRAFT", "GST_TR_ADJ" & "GST_TR_ADJ_DRAFT"
  • Add support of re-sequence detail records for gift data entry
  • Add Seq column to GST_GIFT_DTL table
  • GL Ledger Report add Tax Filter & Grouping
  • [Merge]: Add TaxDate to GL_Trans
  • GL Ledger Report add new parameter able to filter by PostDate or TaxDate and add TaxDate grid column
  • All GL Trans Posting support TaxDate
  • GL_Trans Table add "TaxDate" field
  • Year End GST Date Lookup by default hide "Status" grid column and only list out GST Process which DateFrom >= System Conversion Date
  • Increase Title size for Customer & Sales Invoice 3 (GST)
  • Feature #4038: Change button caption from Giro (Beta) to Giro
  • Feature #4022: Add color setting to Remark field in Company Profile
  • Split the Title Tax Invoice & No for Customer & Invoice
  • 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)
  • Stock Item List add barcode information
  • Fix bug #4027: Customer credit note allow to delete even though the credit note contains bad debt recover records
  • Feature #4026: Hide tax inclusive column on detail grid of gift data entry
  • Bug #4009: AR/AP Invoice & Credit Note's Detail remains if copy and paste from current to new create past document
  • GL Local - Ledger - Detail - Level 1.fr3 add Grand Total for DR & CR
  • Feature #4008: Analyse Data Integrity | SQL Control Center add countdown dialog to close form in 5 seconds
  • Fix missing up down button image
  • Hide ForceFilter option in Maintain Form Mode that don't serve any purposes
  • Feature #4014: Auto tick Split Browse & Detail Windows when create new form mode
  • Bug #4003: Sort Stock Group first by default in Stock Item Listing
  • Bug #4013: Enable license checking for GIRO module
  • Feature #3945: Acceptable Transaction Date support Context & Feature #2274: GL Bank Reconciliation Lock by Acceptable Transaction Date
  • Fixed GST Detail 3 - GST-03 Gain should be in positive & Loss is in negative symbol

5.2016.795.739
  • Add Box for footer for Purchase Invoice, Cash Sales & Invoice 3 (GST 2) format
  • [Firebird 3.0]: Add suffix '-V4' to database name after success upgrade in embedded connection
  • Remove kuRAFMerge and replace with native solution for merged ReportBuilder reports
  • Bug #4006: Access Violation when direct upgrade to unicode using Traditional/Simplified encoding

5.2016.794.739
  • Feature #3997: Change Customise Module
  • Bug #3994: Sales Profit Estimator by default hide Tax, Tax Rate, Tax Amt & Tax Inclusive grid columns in Field Choser
  • 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
  • DIY Fields Form Add "Reduce Size" button for string field only
  • Analyse Data Integrity add "SQL Control Center" allow user to do DIY field setting without logon db
  • SQL Control Center form's constructor accept IDBConnection instead of use DBManagerUnit
  • Bug #3999: Maintain GL Account Industry Code should be hidden if GST Module not activated
  • Bug #3990: Slow in selection for Serial number when selection 5000 serial Numbers
  • Bug #3991: Apply Stock Card Prompt Error due to too big amount
  • Bug #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
  • Bug #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
  • Bug #3950: Rename GL Ledger Report Form's CheckBox "Include Zero Transaction" to "Include Zero B/F with Transactions Before"
  • Bug #3976: Stock Card Qty unable to shown opening balance if Project Module is Disable
  • Bug #3988: Duplicate company code displayed at Maintain Customer/Supplier list if there are more than 1 billing branches
  • Bug #3975: Sales Invoice unable to save if enable 5 cent rounding & Prompt Stock Qty Control dialog
  • 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
  • Add resource string for Stock & Misc form caption
  • Fixed GL Balance Sheet 2 Column Fixed is Amount is Net
  • Convert AR & AP Invoice, Debit Note & Credit Note (GST) to fast report
  • Resource string spelling check
  • Fixed GST Detail 1 & 2 Other Category will shown Double for same Tax Type with Different Tax Code
  • Delphi 10.1 Berlin update 2
  • Bug #4000: File | Open prompt error : Insufficient RTTI available to support this Operation
  • Bug #3969: Show host name in Show Active Connection
  • Bug #3987: Batch EMail - Statement aging will shown all same amount for different customer

5.2016.793.738
  • Fix bug #3958: Foreign bank adjustment allow to change post date to taxable period even though detail contains gain loss account
  • Bug #3959: Do not find inactive Stock Item in Barcode form (F8)
  • Add GL PnL This Month vs This Year-Currency & This Year - 2 Column-Currency Reports
  • Add Balance Sheet - This Year - 3 Column-IFRS-Currency report
  • Bug #3956: Edit Customer Refund / Supplier Refund prompt error : Dynamic SQL Error : Count of Column List and variable List do not match
  • Bug #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

5.2016.792.737
  • 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
  • Revise splash implementation
  • product title font type in logon form

5.2016.791.737
  • 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
  • Revise logon form and background image
  • Fix Unicode Diagnosis didn't replace with question mark if non-ascii character found
  • Incorrect usage of {$IFDEF} construct in TfrxDBDataSetHelper.GetDisplayTextPatch
  • Bug #3954: Error when setting HideZero = True for string field binding to FastReport's MemoView control
  • Fix transliterate error in Database Encoding Diagnosis when upgrade to Unicode
  • Bug #3948: Win32 Action form not resize to specified number of action buttons
  • Remove ppDB.AnsiStringSort patch
  • Feature #3897: Set 0.75 second delay in grid's row filter as default
  • Revise Bug #3918: Unicode text shows question mark (?) in using E-Mail Client & E-Mail Client (Batch)
  • Fix unable to restore raw firebird backup file via embedded connection

5.2016.790.737
  • Unicode
  • Database upgrade to version 142 (unicode)
  • Accept unicode text encoding in DIY script
  • DBManagerUnit FillParam Variants string support unicode (remove AnsiString casting)
  • DIY Field change from TStringField to TWideStringField for boolean and string type. Create Table Field / Alter Field support UTF8 charset
  • Adjust all coding include reports to support unicode
  • Replace TStringField to TwideStringField
  • Update (VAR)CHAR fields to support unicode character sets
  • Database upgrade to version 141
  • Persist total payable output tax and total claimable input tax in GST_PROCESS table after process GST return
  • Remove ITaxProvider.ExcludeTaxType_Purchase method
  • Persist total payable output tax and total claimable input tax in GST_PROCESS table after process GST return
  • Add LocalAmount_Output, LocalTaxAmt_Output, LocalAmount_Input and LocalTaxAmt_Input columns to GST_PROCESS table
  • Bug #3936: Disable the Set Tax Date for GL Cash Book OR
  • Revise PascalScript sleep function to cdStdCall
  • Add additional company profile fields (RegisterNo, Phone1, Address1 & Address2) in Giro format.
  • Bug #3935: System will not continue append for remaining Items in template if exception EAbort raised
  • Revise GST Summary Sheet - MY Code for Easy Maintain
  • Bug #3888: Unable to transfer to Purchase Invoice if Stock Group & Purchase Account in Options is empty
  • Bug #3933: Runtime created form in DIY script didn't scale properly in High DPI environment
  • Bug #3932: Yearly Sales & Purchase Analysis TransDesc Field in Document_TransType no value
  • Add Tax Year option on new GST return window
  • Feature #3919: Revise message of unlock GST return
  • Bug #3931: Change the Open GST Grid Highlighted Background
  • Bug #3875: Position of VCL Controls on TdxDockPanel changed after docking a new TdxDockPanel
  • Fixed Sales Yearly Analysis report unable to view on Group by Transaction
  • Feature #3903: Job Order browse grid add Assembly Code, BOM Template, Qty, UOM, Location, Batch & Split To grid columns
  • Feature #3905: AR/AP Aging Report by default tick checkbox "Historial (by Post Date)" if "Document Date, Posting Date" module is activated
  • Bug #3915: Outstanding Sales Document Listing checkbox description rename from "Calculate Outstanding SO & POO" to "Calculate Outstanding SO & PO Qty"
  • Add 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
  • Fix bug #3887: Bad debt occurs for an invoice even though no outstanding and payment tax date set to future
  • Revise GST-Ledger-Vs-GST-03_5b & GST-Ledger-Vs-GST-03_6b Script for easy maintain
  • Feature #3872: Make GL Account Entry dialog stay after exception occur
  • Feature #3901: Add access control for File | Data Import
  • Fix bug #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
  • Year End Date Selection (for GST) prompt Invalid Argument error when there is NullDate
  • 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
  • Copy audit file to draft return after recalculate GST return
  • GST Summary Sheet - MY RS had wrongly added to input total
  • GST Lampiran 2 Should filter by FromDocType
  • Fix bug #3920: Missing display format for MinQty and MaxQty fields in stock reorder advise report
  • Fix bug #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
  • 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
  • Fix index name formatted error when create index on temporary table
  • Improve performance for GL Journal Of Transaction - Post and Tax Date Exception report
  • Fixed Currency Rate not shown for GL Official Receipt & Payment Voucher
  • 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
  • Revise IHTTPClient.Post to support custom headers
  • GST Lampiran 2 - Add Permit No for Output Tax column K1
  • Temporary allow user to edit gain/loss posting from knock-off document after process GST, this break the fixed of bug #3533
  • 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
  • Change all dma and coding to upgrade decimal precision=18 and CurrencyRate downgrade to size=8. DIY currency field change to precision=18 as well
  • Adjust columns decimal precision to 18
  • GST Listing Report Flatten all records into MainDataSet (instead of master & detail dataset) to allow pivot grid support. Report template change accordingly to new dataset structure
  • 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
  • Tidy Maintain Budget to work correctly with Pivot Grid Transform
  • Remove GST.Listing.Pivot.fm and remove master grid from GST Listing Report and reorganize the detail grid to allow framework pivot grid to be able function properly. Gain Loss summary custom coding has been removed (to allow normal grid sum)
  • Convert realised exchange gain/loss sign (gain +ve, loss -ve)
  • Tax rate of bad debt relief and bad debt recover should based on invoice document date before post into GST_TRANS table
  • Fixed Customer & Supplier Statement * Status not correctly shown in some situation
  • Fix RMCD GST TAP error if there is "Attention Needed" appears in portal during new return period
  • Unable to calculate past invoice bad debt relief due to tax date falls on or after system conversion date
  • Bug #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
  • Fixed Sales Analysis By Document Grand total Amount empty if more then 3 page when export to Excel
  • Bug #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
  • Bug #3891: Customer/Supplier IV, DN & CN detail is limited to 70 characters (should support 200 characters)
  • Support Firebird 3.0

4.2016.789.736
  • Add GST Return matching with RMCD Customs TAP portal
  • Add support of view return from RMCD GST TAP
  • Add RMCD GST TAP Account access
  • Add GST MY TAP GST Lookup Status test case
  • Rename GST.TAP.Lookup.pas to GST.MY.TAP.Lookup.pas
  • Rename GST.Portal.MY.pas to GST.MY.TAP.pas
  • Refactor TGST_MY_TAP
  • GST Process Lookup support List Field by description. Report should retrieve lookup value by ILookupController.EditKeyValue instead of TcxPopupEdit.EditValue
  • Fixed Sales Invoice 3 (GST 2) Footer Disc not including itemcode DISC
  • Rename GST Detail 3 - GST F5 to GST Detail 3 - GST F5-(SG)
  • Bug #3878: Maintain Stock Value if untick project should show total figure for ALL project
  • 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)
  • Bug #3870: Bank Account contain B/F Amount (but without current date range transaction) did not appeared in GST Audit File
  • [GST-MY] Feature #3867: Tax code GS (disregard supply) should not declare in GST-03 item 13. Revert commit of b97ab0cbde825404eb8790889df6bbc144d79abe and f4ca30bb9dcf92dbc05067bd6c25dd7bc3e40e35
  • Fixed Sales Quotation 3 (Sales Disc) batch print incorrectly shown Disc amount
  • Revise GST Guidelines menu item open with build-in PDF viewer
  • Replace TcxPageControl with TPageControl on GST bad debt form
  • Bug #3861: Change "Maintain Scripts" caption to "Maintain Commission Script"
  • Update GST Detail 3 & Lampiran 2 for TX-CG & ZDA
  • Fixed GST Summary Sheet - MY overdeduct for TX when using TX-CG
  • Fixed GL Local - Ledger - Detail - Level 1 Description 2 shown wrong info if had same Journal Begin with B or C
  • Bug #2991: Save a document with empty shipper field prompt Field Value Required
  • Feature #3698: Add RichTextToPlainText function to DIY Scripter
  • Add GL Acc Code for GL PnL - 2C2P format
  • Bug #3851: Payment Dialog not show when pressing F3 to save a cash sales
  • Bug #3845: Revert Bug#3805 Stock Card Qty filter by Project
  • Fixed GL PnL - 2C2P font format not follow the xml
  • Bug #3838: Maintain Chart of Account's Tax Code should be able to choose Non GST Tax Type
  • Bug #3829: Save Negative Qty will by pass if user Enter 0 & Enter back the Qty
  • Bug #3848: Addresses fields in Maintain Customer/Supplier has smaller font size
  • Bug #3849: Prompt "At end of Table" error in Sales Invoice when change document date
  • Bug #3850: Date, Agent & Terms in Delivery Order has smaller font size
  • Bug #3833: Drop temporary tables in nested transactions
  • Bug #3843: View | Price Tag form has smaller font size
  • Align drop down menu based on left and bottom position of button edit at open GST return window
  • Bug #3842: Customer/Suppler Contra Listing Filter by Agent prompt Invalid Date error
  • 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
  • Bug #3827: Year End GST Date Selection should exclude Unlock and Dirty (recalculate) GST Process
  • Fixed Description overlap on DocNo for GL Journal of Transaction - Inbalance

4.2016.788.735
  • Database upgrade to version 140
  • Maintain Tax Browse Grid paint inactive tax codes to grey text. "Show Changes" function will ignore inactive tax codes
  • [GST-MY] Add 11 new additional tax codes based on 1/8/2016 Accounting Software Guideline
  • [GST-MY] Remove IM-0 from Tax Provider MY and New DB will auto create IM-0
  • Revise TTaxPortal_MY implementation
  • Implement QueryString function for TNetHeaders to return & delimited string
  • Feature #3814: GL Opening Bank Reconciliation Payment Method Lookup Should Show Bank & Cash Type (Revert Bug #3739, commit: 908e644680de31b3151d9401f09823b5a4c54a2d)
  • Feature #3817: Maintain Journal Entry Add Tax Date at Browse Screen
  • Fixed GL Journal Voucher - Full & Half (GST) preview error if using GST Reversal
  • Convert Sales P&L By Document report to Fast Report
  • Fix GL PnL - 2C2P error if using #,0.00;-#,0.00;- displayformat

4.2016.787.735
  • Fix Database upgrade script version 139 (for db which don't have Tax Generator will failed)

4.2016.786.735
  • Database upgrade to version 139
  • Maintain Tax add "Show Changes" under Browse Grid "More" Button
  • Maintain Tax Browse Grid sort by TaxType column by default and add custom sorting to sort records by popularity of tax code (follow Customs guideline sequence)
  • Maintain Tax Browse Grid add "Category" column
  • ITaxProvider.GetTaxList change from TList to Tarray
  • RMCD GST Update 01 Aug 2016
  • GST Audit File all related class and UI form split by year (2015, 2016). IGSTAuditFormat class split by year & country also. Added TGSTAuditManagerFactory to be able to call out classes that splited by year and country
  • GST.Audit.DP add fields to support Malaysia GAF 2016 new format
  • GL Ledger Add AccType for Main DataSet
  • Add PermitNo to all Sales Document Detail Tables for Export Declaration Number Purpose
  • [GST-MY] GST Basic & Advance TestCase Field 13 include Tax Code "GS"
  • [GST-MY] GST-03 Report Field 13 include "GS" Tax Code
  • [GST-MY] Replace tax codes in GST Malaysia test cases with new tax codes
  • [GST-MY] Revise Tax Description for Output Tax "RS"
  • [GST-MY] Revise Tax Description for Output Tax "ES"
  • [GST-MY] Revise Tax Description for Output Tax "OS"
  • [GST-MY] Revise Tax Description for Output Tax "DS"
  • [GST-MY] Revise Tax Description for Output Tax "AJS_BD"
  • [GST-MY] Revise Tax Description for Output Tax "GS"
  • [GST-MY] Revise Tax Description for Output Tax "IES"
  • [GST-MY] Revise Tax Description for Output Tax "ZRE"
  • [GST-MY] Revise Tax Description for Input Tax "AJP_BD"
  • [GST-MY] Revise Tax Description for Input Tax "GP"
  • [GST-MY] Revise Tax Description for Input Tax "OP"
  • [GST-MY] Revise Tax Description for Input Tax "EP"
  • [GST-MY] Revise Tax Description for Input Tax "BL"
  • [GST-MY] Revise Tax Description for Input Tax "IS"
  • [GST-MY] Revise Tax Description for Input Tax "IM"
  • [GST-MY] Revise Tax Description for Input Tax "TX-RE"
  • [GST-MY] Revise Tax Description for Input Tax "TX-IES"
  • [GST-MY] Revise Tax Description for Input Tax "TX-ES"
  • [GST-MY] Add new output tax code "ZDA"
  • [GST-MY] IES replace ES43
  • [GST-MY] Add new input tax code "TX-CG"
  • [GST-MY] Add new input tax code "RP"
  • [GST-MY] TX-IES replace TX-E43
  • [GST-MY] TX-ES replace TX-N43
  • Tax DB Table Description Field upgrade from 80 to 200 characters
  • Fix bug #3679: Drill down is not supported yet message for document type (_A, _B, _C and _D) or trans type (_X) will be misleading
  • Maintain Tax Browse Grid, Tax Rate & Tax Account column value align to center
  • Bug #3816: Incremental search is not working on Debit & Credit column of Bank reconciliation report
  • Fixed Cust Local - Payment Listing - Collection Report.rtm on Print/Export prompt Error List index out of bounds
  • Simplify TArray for CheckFields parameter; adjust document locking implementation
  • Enhance speed when operate sub-account tree controls in GL Profit & Loss and Balance Sheet
  • RMCD TAP Update
  • Fixed GL Journal Voucher - Half & Full (GST) Total Taxamt not correctly shown
  • Allow user to change knock-off tax date, as long as the date does not fall in any GST return processed
  • Bug #3813: Unable to show parent account that has zero amount when use print Sub Account Only for PnL and Balance Sheet report
  • Fixed GST-Ledger-Vs-GST-03_5b & GST-Ledger-Vs-GST-03_6b not including Bounced transaction checking
  • Maintain Tax Entry Form's Description change to Memo type for easy reading and Adjust UI Control anchors
  • Tax Rate & Tax Code should retrieve based on DocDate instead of TaxDate
  • Fix calculate bad debt invoice prompt division by zero error
  • Bug #3812: Error when update company code
  • Bug #3811: Set default Qty to 1 when add item in Gift document
  • Fix Prompt Error due to Total Qty formula for GST.Gift 1 & Sales Delivery Order 1 report

4.2016.784.733
  • Database upgrade to version 138
  • Bug #3763: View GST Audit File prompt error "List Index out of bounds"
  • Add From Doc No Information for Sales/Purchase Invoice/Cash Sales 3 report
  • Adjust grid properties on bad debt form
  • Fix memory leak due to access violation in thread exit when unload SQLAcc.GST.UI.bpl package
  • Add Balance Sheet - This Year - 3 Column - IFRS format
  • Fix bug #3745: Unable to knockoff invoices with payment in foreign currency if the payment contains gain loss and zero gain loss from knockoffs
  • Bug #3747: YED should insert past AR & AP CN documents details into GST Taxable (PostDate <= YED and TaxDate > YED only)
  • Bug #3746: YED should prompt error if GL CB & GL Journal PostDate<=YED but TaxDate > YED
  • Bug #3738: Inquiry | Cash Flow Forecast Balance b/d should have value if account got B/F transaction only (no within date range transaction)
  • Bug #3736: DMR formula should include "Excluded Supply (O)"
  • Bug #3739: GL Opening Bank Reconciliation Payment Method Lookup should only show Bank Type
  • Add GST Detail 3 - GST F5.fr3 For Singapore GST
  • Fixed GST Detail 4 - Mixed Supplies shown incorrect DmR Status
  • Add GL Journal Of Transaction - Post and Tax Date Exception Report
  • Add FromDocDate & FromDocNo for Sales DN for Report Builder Format
  • Bug #3743: Error on calling report COM object
  • Bug #3740: All Sales & Purchase Entries Forms set Net Total UI Control to Read-Only
  • Bug #3735: GL Bank Reconcilliation Entry Form Slow on Open & Click Detail
  • [RAD10.1]: Revise IDBProviderSupport
  • [RAD10.1]: Upgrade packages
  • Year End Validation will list out AR/AP documents that PostDate <= YED & TaxDate > YED
  • Fix draft GST return not deleted if fail to recalculate GST return
  • Fix Temp Tables not free when Report calling others Reports due to same DB transaction for GST Audit File & GL Cash Flow Statement Report (should move to BeforeProcess instead of Process section in DP)
  • Revise TAnonymousMethod implementation
  • Fixed GST Detail 4 - Mixed Supplies LPA formula error
  • Fixed 3 column balance sheet error if TOTAL EQUITY AND LIABILITIES is 0
  • Fix bug #3731: GST return journal posted to incorrect taxable period after recalculate
  • Fix GST trans for each bad debt invoice posted many times in draft process after recalculate
  • Bug #3733: Sales Invoice unable to save if enable 5 cent rounding & Prompt Negative Stock Qty dialog
  • Bug #3732: Unable to Delete GL Account if BL Tax Account previously point to this account code, after GST process & BL Tax Account change to empty then Edit Save old documents with BL (Rename DB Metadata resource to actual table name)
  • Remove the Allow Expression for Account Code for Maintain Account Listing
  • Remove OnGetDisplayText event from LPA DateFrom and LPA DateTo columns
  • Bug #3726: GL PnL & Balance Sheet the option Show column Options unable to add new column on click the Thunder button
  • Fix GL OR & PV Error if detail record more then 1 page

4.2016.782.732
  • Database upgrade to version 137
  • Bug #3456: GL Receipt and Payment Report GL Journal Amount should include LocalTaxAmt
  • Fixed Customer & Supplier Statement PDCheq Amount unable to shown decimal point
  • Fix incorrect FromKey in GL Trans table for document detail contains RSA tax type after process GST return
  • Bug #3719: Stock Item Master Base UOM shouldn't change when user change UOM in Customer/Supplier Price Tab
  • [Localize] Localize Year End & GST Audit units
  • Rename constants prefix from rc_ to c_ to avoid clash with ResourceString declaration
  • Remove QC#38476 patch
  • Fixed GL OR & PV preview error when DocAmt is 0
  • Bug #3721: Prompt error when access Maintain Batch by COM that has more than one record
  • Fixed GST Detail 3 - GST-03 Itemd 13 TaxAmt should be 0 & Item 14 & 15 TaxAmt should had Value

4.2016.782.732
  • Database upgrade to version 136
  • Bug #3717: AR/AP Payment, Refund & Contra New Entry has Duplicate knock-off document number when tick and untick same document before save
  • Bug #3710: AR/AP Payment, Credit Note, Refund & Contra should not allow negative value to knock-off
  • Fix bug #3718: Filter record on report data form prompt access violation error when there are filters from more than one grid columns
  • Feature #1622: Add COM support to new business objects
  • Revise TFields implementation
  • Revise TActions implementation
  • Revise TParamsEx implementation
  • Remove redundant namespace: Estream_TLB
  • Revise TDataSets implementation
  • Replace LoadTypeLibEx with LoadRegTypeLibEx
  • Remove obsolete IRptObject implementation
  • Remove IVisitor_TFieldDefs and Ielement_TFieldDefs
  • Remove Ivisitor_TDataSet
  • Revise uses unit namespace in BizAppUnit.pas
  • Remove obsolete BizObject: Tax
  • Revise IBOPF.Params to TOPFParams. Remember to Rename .Add_9999 to .Add when release.
  • Localization
  • [Localize] Revise form resource
  • [Localize] Change special characters and symbols in .rc file
  • [Localize] Localize for New Database code, remove sqlacc.init.sql file and move the init sql to Account.DB.Init.pas
  • [Localize] Move previous ResourceString from other units into Acc.ResStr. localize for core1.bpl, core1.decorator.bpl, common.bpl, Misc.bpl, Stock.bpl, Sales2.bpl, GST.App.bpl, Costing2.bpl, Misc.DSM.bpl, Stock.DSM.bpl, GST.Command.bpl, Stock.DP.bpl, Misc.UI.bpl, GL.UI.bpl, Production.UI.bpl, GST.UI.bpl, DB.Sample.bpl, License.bpl, datarecover.bpl, dataimport.bpl, SQLAcc.dpr
  • [Localize] Revise form resource
  • [Localize] Move sisulizer projects to GitHub
  • Feature #3580: Year End for GST, optimized YED Speed & Persist Audit File for each GST Process
  • Year End locking change to Nov 2016
  • Remove Validate GST checking to prompt for GST Audit File might incorrect after YED
    YED Date UI for GST added a modal form to let user choose which process to YED. Add checking to validate GST Year End Date as well
  • YED AR/AP IV & DN all details (with GST tax code only) will be inserted into GST_Taxable (as past documents details will be purged). This is for bad debt calculation purpose
    YED auto insert DO Offset Transactions in GST_Taxable for Final IV/CS that transfered from DO
  • Add YED validation to prompt user to fully transfered Outstanding DO before run YED and list out Outstanding DO doc no
  • YED add validation to check if YED falls between PostDate & TaxDate for AR/AP IV & DN, system will prompt error not allow to proceed as both of these documents details will be purged and reinsert into GST_Taxable for bad debt calculation (bad debt calculation only able to capture opening in GST_Taxable but not the GST_Taxable that appeared after YED)
  • Revert changes of Feature #3315 (commit a487c17f3bc3dafac01adfd9a29a0a5d3cf892c2) and GST Taxable TaxDate checking as YED purging logic has been added so no need those date checking
  • YED AR/AP IV, DN, PN, CN & SL IV, add new checking (GST Taxable TaxDate <= YED) in "CanPurge" condition
  • YED AR/AP Payment, CN, Refund & Contra, add new checking (KOTaxDate <= YED) in "CanPurge" condition
  • YED all documents that has TaxDate, add new checking (TaxDate<=YED) in "CanPurge" condition
  • Replace Relation Hash List by using only one TDictionary instead of Both TDictionary & TList together. Replace TCollection to TList and TCollectionItem to TObject to speed up performance (As TCollectionItem.Index cause much slower performance)
  • YED Change Graph DataType from TList to Tlist
  • YED Create Index for T_GL_CB when Purge GL_CB to speed up performance when deleting GL_CB & GL_CBDTL
  • Optimize YED purge GL_TRANS for GL_CBDTL performance by using temp table & Exists SQL
  • Remove GST-03 (MY) and GST F5 (SG) report from Main Menu (Since Open GST Return has the menu already)
  • Open GST Return -> Generate Audit File, there is a grid load from CSV zip file that persist in each GST_Process. Previous GST Audit File (which read from db) has been removed in main menu
  • Persist GST audit file in GST_PROCESS table after process GST return
  • Add AuditFile column to GST_PROCESS table
  • GST Audit File convert from DS to CSV files, Zip all CSV files and convert Zip to Text/XML format
  • Fix Insuffiecient Memory error for large db to save GST Audit File. Free Ledger report objects immediately after called and Replace String Builder with TStreamWriter when writing text format.
  • Remove Spring4d package and adjust coding
  • Remove Spring4d package
  • Adjust GST classes implementation
  • Add support of show double entry on document entry window
  • Split "Tax" GL trans table type into "Detail Tax" and "Master Tax"; split "Pending Tax" GL trans table type into "Detail Pending Tax" and "Master Pending Tax"
  • Add feature #3633: Prompt message for total delivery order documents have been processed after process GST return
  • Add support of recalculate GST return
  • Rename TGST_Trans_Adj to TGST_Trans_Adj_Item
  • Add checking on GST Process & Tax Account before preview for GST-Ledger vs GST-03 5b & 6b
  • Fix bug #3694: New, Edit or Delete button on DBForm keep blinking if user does not have access rights
  • Bug #3712: SL/PH Documents Entries should refer to default account in Tools | Options when the particular account is not null in Stock Group
  • Fix bug #3701: Unable to drill down to gift document from GST gift listing
  • Adjust GST gift listing implementation
  • Bug #3666: When system Prompt Replace Unit Price Dialog on UOM Change & Click NO the Base Qty will not update
  • Add Total Amount Excluding GST & GST Amt for GL OR & PV
  • Bug #3695: Access AR/AP Contra through COM will cause no posting in Ledger
  • Bug #3705: AR/AP Document Listing reapply different document reports in same form and filter by agent will raise error : Invalid value for field 'DocDate'
  • Bug #3680: Purchase Invoice, Cash Purchase & Purchase Returned Tax Date will only shown partly if using the Themes
  • Feature #3360: GST listing Report support Pivot Table and Detail add GL Account & GL Account Description Fields
  • Prompt informative message if user edit gain/loss posting (from knockoff document) where GST return already processed
  • Fixed GL Journal of Transaction - Inbalance not group by Doc double entry
  • Feature #3692: Calculate RSA based on cash book (PV), invoice (PI), debit note (SD) and credit note (SC)
  • Adjust supplier invoice data loader and simplify classes implementation
  • Feature #3637: Rewrite Stock Quantity Control module to share one logic between SL, PH & Stock. Remove temporary tables from logic
  • Rewrite Stock Qty Control logic and UI to avoid using temp tables and share only one logic between SL, PH & Stock
  • Remove Stock, SL & PH old Stock Qty Control Logics and forms from project
  • Fix bug #3688: Bad debt supplier invoice calculated after expiry of 6 months even though input tax not claimed
  • Bug #2745: SL/PH/AR/AP Document Entries Add Company Code Validation
  • Remove Allow Expression for Cust/Supplier 12 months Aging reports
  • Add knockoff tax date column to knockoff invoice grid for payment, credit note and contra document entry form
  • Fix bug #3696: Document detail contains GST tax type allow to delete even though GST return already processed
  • Add no. of Month & more detail on TX-N43 for LPA
  • RSP-14691: A nested TClientDataSet instance always resulted to empty Childdefs in FieldDefs structure
  • Bug #3693: GL Bank Reconcilation Entry and Bank Reconcilation Listing Report Payment Method Lookup should only show Bank Type
  • Fix Customer/Supplier Statement Error if only 1 Company Code selected
  • Bug #3653: System will hang if select Mark All in Bank Reconciliation even the untick records is less then 3000
  • Bug #3675: Bank Reconcilliation will shown double duplicate ticked records if Click Apply and untick "Show Unticked Transactions"
  • Bug #3651: Barcode (F8) Form update Disc field did not trigger the OnGridColumnValueChanged DIY Script
  • Bug #3652: Stock Card Qty Report Batch & Project parameter should disable according to license module
  • Add Direct Post Checking for GST-Ledger-Vs-GST-03_5b & GST-Ledger-Vs-GST-03_6b
  • Bug #3655: Tick Grid's FilterRow causing some conversion error in certain form grid that has GetDisplayText, CustomDrawCell & FooterSummaryItemGetText event
  • Bug #3674: Customer/Supplier Aging & Statement xml Editor Header Scripts Editor should be Memo instead of Rich Text Editor
  • Bug #3691: Matrix profile Dimension 1 and 2 MaxValue set to 30
  • Fixed GST-Ledger-Vs-GST-03_5b & GST-Ledger-Vs-GST-03_6b not including Bad Debts & Excluding Tax code is Empty
  • Bug #3464: GL Journal Entry allow to select Non-GST Tax code
  • Revise IBOPF.New declaration
  • Fix bug #3685: Remove message prompt for bad debt invoices contains invoices issued to non-GST registered customer
  • Bug #3686: Supplier Invoice & Payment TaxDate & BadDebt label overlap
  • Bug #3683: Supplier IV with Tax Code IM-0, TaxRate should be empty string instead of 0%
  • Maintain Tax TaxRate Drop Down Grid Navigator Replace Insert Button to Append Button
  • Replace bookmark variable type from TBytes to TBookmark
  • Fix incorrect email separator in OCBC Bank Easi-Giro file format
  • Update Maybank Universal Payment file format to v4.4; combine multiple knockoff documents into one payment advise for each payment record (feature #3704)

4.2016.781.731
  • Database upgrade to version 135
  • Allow user to specify LPA date range on new GST return window
  • Add GST Detail 4 - Mixed Supplies
  • Bug #3673: IRR should calculated to nearest 2 decimals rounding
  • Convert All Supplier Statment fo Fast Report
  • Convert Cust Statement 6 & 12 Mths 1 & 2 to Fast Report
  • Fix GST Gift Listing Access Right Setting
  • Fix Bug #3676: LPA will be wrongly calculate for first tax year if DMR <= 5% and Monthly ES > 5k
  • Fix bug #3665: Incorrect sub total of gift detail after paste gift document from clipboard
  • Add E-Mail Script for Sales Invoice 7
  • Adjust sales and purchase entry form UI spacing
  • Fix Bug #3656: View | Sales [Purchase] Price History not follow DPI setting
  • Fixed GL Local - Ledger - Detail - Level 1 Description 2 shown unknow information if Sales or Purchase Ledger selected
  • Convert SY.AccessRight.User to fr3
  • Fixed Batch Printing not sort by DocDate & Number For Sales & Purchase Invoice & Cash Sales 3 (GST 2)
  • Add GST Lampiran 2 with ZR report

4.2016.780.730
  • Customer Aging if fully KO on current month will now shown in Fast Report
  • Allow change tax code for PO transfer from SO
  • Description is now shown when using Split Browse & Detail Windows of Form Mode
  • GL Payment Voucher - Detail - (GST) label now show as "Payment by"
  • Tools | Option images now display correctly for non English locale
  • GL OR & PV - Detail (GST) - Currency Rate is now hidden if under local currency bank
  • RCMD GST Lookup should now be able to function
  • Remove allow express for Ref, Description & Description 2 for GL Local - Ledger - Detail - Level 1
  • GL Bank Reconciliation Report 2nd page header font size now same with 1st page
  • Remove all Prompt Dialog to Show Detail for Fast Report & use Build in Show Detail button on Preview Screen
  • GL PnL - 13C1P should now show all record on next page
  • Other performance & stability improvements

4.2016.779.730
  • SL Document Entries should now reset to Min Price if user click "No" in Replace Unit Price Dialog
  • The system now won't double up the payment amount in payment change dialog when edit and change Cash Sales Document Number
  • Fixed error where GST Summary Sheet - MY just have SR
  • Convert Supp 12 Months Aging to Fast Report
  • Fixed Cust 12 Month Aging by limit Company Name to 70 character
  • Fixed GST-Ledger-Vs-GST-03_5b & GST-Ledger-Vs-GST-03_6b display format issue
  • Other performance & stability improvements

4.2016.778.730
  • Convert GL Local - Ledger - Detail - Level 1 to Fast Report & Format
  • Adjust DO-IV loader to exclude documents fall before system conversion date; adjust RSA loader to load past taxable records for past supplier invoice
  • Increase footer height for GL PnL – 6C4P
  • Convert Cust 12 Months Aging LS & Cust 12 Months Aging to fr3
  • Add Sales & Purchase Cancel Note 7 (GST) & Listing (GST 1)
  • Add Out of Balance Status for GL Bank Reconciliation report
  • Convert GL BS-3C0P to fast report
  • Adjust implementation of document locking and knockoff tax date
  • Convert GL OR & PV (GST) to Fast Report
  • Add GST Gift Lising report
  • Add GST | Gift / Deemed Supply Listing
  • Other performance & stability improvements

4.2016.777.729
  • Enable GST Lookup when creating sample database
  • Add GST No. Lookup from RMCD TAP portal
  • Add GST No Lookup module
  • Maintain Customer & Supplier support GST Tap Multi & Single Companies update
  • Add classes to access GST Lookup Status in Malaysia RMCD Portal
  • GL Bank Reconciliation display period's DateTo now follows bank statement date. Apply button only enable when Bank Statement Date & Payment Method has been selected
  • Add checking for invalid posting under GL Journal of Transaction - Inbalance report
  • Improve High DPI screen support
  • Add grouping by Shipper parameter for Sales & Purchase Listing
  • Revise Apply icon in report form
  • Prevent user from select non-GST tax type for gift data entry
  • Move GST Lampiran 4 to GST Listing
  • Add "Sub Total (Tax)" column into GST Taxable Entry
  • Maintain Stock Batch "Paste Stock Batch" now includes "Code"
  • Add support of Citibank (Singapore) CitiDirect file format
  • Add GL Cash Book Listing - GST Review
  • Add Customer & Supplier GST Review reports
  • New GL Cash Book by default set to Payment Voucher
  • GST Audit File Purchase & Sales section now matches GST Return Transactions
  • Stock Item Search (F9) Advance Search now includes Barcode field
  • Add Stock BOM Material Usage-Materials Required Plan (MRP) report
  • GST Main Menu now has sub menu to link to government guidelines for MY & SG
  • Other performance & stability improvements

4.2016.773.728
  • Enable Windows TaskBar thumbnail button by default
  • Add Sales/Purchase Price History (GST 1) - Review Reports
  • Add Document Type column for GL Journal of Transaction - Inbalance report
  • Hide Itemcode begin with DISC for Sales & Purchase 7 (GST 2) & (GST 3)
  • Add Continue Next Page... at Footer for Sales Cash Sales 7 (GST 3) report
  • Add GST Debtor Debit Note & Credit Note Listing (GST 1) - GST Adjustment
  • Add support for Public Bank Electronic Credit Payment Excel File Format
  • Add support for Standard Chartered Bank iPayment-CSV format
  • Other minor improvements