SQL Accounting Latest GST Version (V732) Date: 08 June 2016

Information

Last updated: 08/06/2016
Current version: 4.2016.783.732

New in this version

• 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)