Slideshow

March 28, 2016

SQL Accounting Latest GST Version (V730) Date: 28 March 2016

Information

Last updated: 28/03/2016
Current version: 4.2016.778.730

NEW IN THIS VERSION
  • 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

March 3, 2016

SQL Accounting Latest GST Version (729) Date: 29 Feb 2016


INFORMATION

Last updated: 29/02/2016
Current version: 4.2015.774.729

NEW IN THIS VERSION

01. Enhance, Retuning & Fixed Report
• GL Bank Reconciliation display period's DateTo should follow bank statement date. Apply button only enable when Bank Statement Date & Payment Method has been selected
• Add checking Invalid Posting for GL Journal of Transaction - Inbalance report
• Fixed GL Journal of Transaction - Inbalance not including Non GST Transaction checking
• Fix Grand total with Tax not filter by detail fitering for AR, AP, SL & PH Listing (GST 1)
• Add Grouping by Shipper parameter for Sales & Purchase Listing
• Move GST Lampiran 4 to GST Listing
• GL Cash Flow - Other Liabilites (Normal Account) should under "Operating profit/(loss) before working capital changes"
• Add GL Cash Book Listing - GST Review
• GST bad debt relief report does not exclude cancelled invoices
• Add Customer & Supplier GST Review reports
• Fixed Sales Cash Sales 3 (GST 3) Rounding Amount batch print not correct
• Preview GST bad debt report doesn't match with grid filter condition
• GST Listing - Yearly GST Analysis - Incorrectly ranged the date for each month
• Fixed GST Detail 3 - GST-03 data will gone if had same docno
• Stock Card should show Opening Stock Documents (Before System Conversion Date) when date is
untick or Date From is Clear
• Add Stock BOM Material Usage-Materials Plan (MRP) report
• Fix Sales Analysis By Document - Level 2 keep generating page
• Fix GST-Lampiran B-0 PT GST Bil 2B (ATS) prompt error due to invalid tax rate
• Stock Batch Expiry Report Qty Column Display Format is Incorrect
02. Add GST No. Lookup from RMCD TAP portal
03. Don't allow Tick Cancelled & Save if there is a Payment for Cash Sales
04. Cancelled Cash sales should not prompt for Payment Dialog
05. Sales Order Transfer to Purchase Order should exclude TaxRate
06. Fix various High DPI issues
07. Remove Bold attribute from TcxStyle resource to accomodate High-DPI monitor
08. Revise Apply Icon in report form
09. Cash Sales Shouldn't Prompt Payment Change Dialog when Outstanding=0. Payment Change dialog Total Paid Amount is Outstanding + Cash Sales PaymentAmt. Dialog added Deposit field
10. Prevent user from select non-GST tax type for gift data entry
11. GST Taxable Entry Add "Sub Total (Tax)" Column
12. User can change gain loss amount of document after process GST return
13. Unable to Transfer to Sales Credit Note if Invoice detail Transferable is False. Transferable field should allow to edit if user no purchase Extra DO module
14. Maintain Stock Batch "Paste Stock Batch" should include "Code"
15. Add support of Citibank (Singapore) CitiDirect file format
16. Incorrect display format of local tax amount on bank charges GST reversal form due to application prompt error couldn't find EditValue
17. New GL Cash Book by default set to Payment Voucher
18. Remove LPA text from status column at open GST return window and GST return lookup
19. Industry Code should be BLANK in GST-03 item 19 if 5b is 0.00 (Same to TAP file format)
20. GST Audit File Purchase & Sales section should match to GST Return Transactions
21. Stock Item Search (F9) Advance Search Should Include Barcode Field
22. Fix Javascript call COM object to assign date value to report parameter. Add additioner code to convert Javascript DateTime (unix time) to Delphi TdateTime
23. Unusual behavior on GST return wizard form due to application prompt could not find activepageindex error after component upgrade to Developer Express VCL v15.2.2
24.  Inconsistent status display between open GST return window and GST process lookup
25. GST Main Menu add sub menu to link to government guidelines for MY & SG

January 12, 2016

SQL Accounting Latest GST Version (728) Date: 09 Jan 2016



Information

Last updated: 09/01/2016
Current version: 4.2015.773.728

New in this version

  • 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
  • Other minor improvements

Previous Update Version 727
  • Add GL Journal of Transaction - Inbalance report
  • Add Note for Sales & Purchase Local Listing (GST 1) SLvsAR & PHvsAP reports
  • Add GST Lampiran 4
  • Add support of allow multiple windows for DBForm
  • Add GST-Ledger-GST-Output Tax Prepaid report
  • Add support of GST opening balance
  • Add bad debt test cases - Tax amount greater than amount
  • Add Sales & Purchase Local Listing (GST 1) SLvsAR & PHvsAP reports
  • Add TaxInclusive column to GST_GIFT_DTL table
  • Add GL Cash Flow Statement Reports
  • Add GSTNo column for sales bad debt report; show latest GST return date to as report title for bad debt report
  • Other minor improvements

December 24, 2015

SQL Accounting Latest GST Version (727) Date: 23 Dec 2015

Information

Last updated: 23/12/2015
Current version: 4.2015.771.727
Size: 44.7 MB
License: Demo (Username & Password: ADMIN) 

New in this version


  • Add GST Lampiran 4
  • Add support of allow multiple windows for DBForm
  • Add GST-Ledger-GST-Output Tax Prepaid report
  • Add support of GST opening balance
  • Add bad debt test cases - Tax amount greater than amount
  • Add Sales & Purchase Local Listing (GST 1) SLvsAR & PHvsAP reports
  • Add TaxInclusive column to GST_GIFT_DTL table
  • Add GL Cash Flow Statement Reports
  • Add GSTNo column for sales bad debt report; show latest GST return date to as report title for bad debt report
  • Other minor improvements
Previous Update Version 726
  • Split Detail Description for GL PV for CompanyName & Item Description for GST Lampiran 2
  • Add Code for Description with empty Code for GL Cash Flow Statement
  • Add FromDockey for pipeline Document_PaymentHistory for AR/AP IV & DN Listing
  • Add Sales & Purchase Quotation, Sales Order & DO Listing (GST 1) reports
  • Add TaxDate property to IBO_GL_CB interface
  • Revise AR/AP module improve performance
  • Show taxable amount column at gift tax estimator window
  • Add Project field for AR/AP Payment, CN, Contra & Refund Document Listing Knockoff grid & datamap
  • Revise local amount for bad debt relief and bad debt recover post to GST_TRANS table exclude local tax amount
  • Bad debt relief can only be claimed if the invoice issued to GST registered customer
  • Rename "Print GST Bad Debt" to "Print GST Bad Debt Relief"
  • Add options for GST bad debt report to allow user to filter bad debt relief claimed, not claim or not happen
  • Revise invoice age calculation in GST bad debt report
  • All document entries that contain TaxDate, once user change TaxDate system should retrieve new tax rate based on selected TaxDate instead of working date
  • Update GST Ledger vs GST-03 notes
  • Update GST Lampiran 2 Get TaxRef column for GL Cash Book & Journal Entry
  • Add "Tax Reference" field into Cash Book Entry Detail and Journal Entry
  • Remove RS calculation (item 3 Page 1) from GST Summary Sheet - MY
  • GST Taxable Entry Form Edit State should prompt error "Local Tax Amount must be zero" when user change ZRL to SR which LocalTaxAmt > 0
  • Increase field length to 100 for Remark field in SY_PROFILE table
  • Add Popup Option for Bad Debts Detail Filtering
  • Other minor improvements

November 27, 2015

SQL Accounting Latest GST Version (726) Date: 27 Nov 2015

Information

Last updated: 27/11/2015
Current version: 4.2015.768.726
Size: 44.7 MB


New in this version

  • Split Detail Description for GL PV for CompanyName & Item Description for GST Lampiran 2
  • Add Code for Description with empty Code for GL Cash Flow Statement
  • Add FromDockey for pipeline Document_PaymentHistory for AR/AP IV & DN Listing
  • Add Sales & Purchase Quotation, Sales Order & DO Listing (GST 1) reports
  • Add TaxDate property to IBO_GL_CB interface
  • Revise AR/AP module improve performance
  • Show taxable amount column at gift tax estimator window
  • Add Project field for AR/AP Payment, CN, Contra & Refund Document Listing Knockoff grid & datamap
  • Revise local amount for bad debt relief and bad debt recover post to GST_TRANS table exclude local tax amount
  • Bad debt relief can only be claimed if the invoice issued to GST registered customer
  • Rename "Print GST Bad Debt" to "Print GST Bad Debt Relief"
  • Add options for GST bad debt report to allow user to filter bad debt relief claimed, not claim or not happen
  • Revise invoice age calculation in GST bad debt report
  • All document entries that contain TaxDate, once user change TaxDate system should retrieve new tax rate based on selected TaxDate instead of working date
  • Update GST Ledger vs GST-03 notes
  • Update GST Lampiran 2 Get TaxRef column for GL Cash Book & Journal Entry
  • Add "Tax Reference" field into Cash Book Entry Detail and Journal Entry
  • Remove RS calculation (item 3 Page 1) from GST Summary Sheet - MY
  • GST Taxable Entry Form Edit State should prompt error "Local Tax Amount must be zero" when user change ZRL to SR which LocalTaxAmt > 0
  • Increase field length to 100 for Remark field in SY_PROFILE table
  • Add Popup Option for Bad Debts Detail Filtering
  • Other minor improvements

Previous Update Version 722
  • Clean up the Coding for GST Bad Debt Relief reports
  • Add GST Listing - Yearly GST Analysis
  • Other minor improvements

November 20, 2015

SQL Accounting Latest GST Version (724) Date: 18 Nov 2015

Information

Last updated: 18/11/2015
Current version: 4.2015.766.724
Size: 44.7 MB
License: Demo (Username & Password: ADMIN) 

New in this version

  • Add FromDockey for pipeline Document_PaymentHistory for AR/AP IV & DN Listing
  • Add Sales & Purchase Quotation, Sales Order & DO Listing (GST 1) reports
  • Add TaxDate property to IBO_GL_CB interface
  • Revise AR/AP module improve performance
  • Show taxable amount column at gift tax estimator window
  • Add Project field for AR/AP Payment, CN, Contra & Refund Document Listing Knockoff grid & datamap
  • Revise local amount for bad debt relief and bad debt recover post to GST_TRANS table exclude local tax amount
  • Bad debt relief can only be claimed if the invoice issued to GST registered customer
  • Rename "Print GST Bad Debt" to "Print GST Bad Debt Relief"
  • Add options for GST bad debt report to allow user to filter bad debt relief claimed, not claim or not happen
  • Revise invoice age calculation in GST bad debt report
  • All document entries that contain TaxDate, once user change TaxDate system should retrieve new tax rate based on selected TaxDate instead of working date
  • Update GST Ledger vs GST-03 notes
  • Update GST Lampiran 2 Get TaxRef column for GL Cash Book & Journal Entry
  • Add "Tax Reference" field into Cash Book Entry Detail and Journal Entry
  • Remove RS calculation (item 3 Page 1) from GST Summary Sheet - MY
  • GST Taxable Entry Form Edit State should prompt error "Local Tax Amount must be zero" when user change ZRL to SR which LocalTaxAmt > 0
  • Increase field length to 100 for Remark field in SY_PROFILE table
  • Add Popup Option for Bad Debts Detail Filtering
  • Other minor improvements

Previous Update Version 722
  • Clean up the Coding for GST Bad Debt Relief reports
  • Add GST Listing - Yearly GST Analysis
  • Other minor improvements

October 22, 2015

SQL Accounting Latest GST Version (722) Date: 21 Oct 2015

Information

Last updated: 21/10/2015
Current version: 4.2015.765.722
Size: 44.4 MB
License: Demo (Username & Password: ADMIN) 

New in this version

  • Clean up the Coding for GST Bad Debt Relief reports
  • Add GST Listing - Yearly GST Analysis
  • Other minor improvements

Previous Update Version 721
  • Indicate the latest tax rate for A & EA setting in Maintain Tax
  • Prompt message upon saving Stock Item when BOM got duplicate items
  • Add Draft GST return
  • TaxRate support multiple tax rate setting, auto tax rate & IRR excluded transaction.
  • All document details & GST_Trans add TaxRate field.
  • IRR formula support excluded transaction.
  • Auto tax rate will be sensitive with TaxDate
  • Add Stock Item without Category - Exception Report
  • Adjust gift entry form
  • Allow user to bounce customer and supplier payment but will cause incorrect GST return
  • Remove unused event actProfitEstimatorUpdate from Job Order Entry Form
  • Retune Print Count Coding for Fast Report
  • Revise document locking mechanism
  • Update Bad Debt Relief unclaimed Letter as at 6 mths expired
  • Show LPA date range if LPA option is checked at new GST return window
  • Add GL Trial Balance - This Year v GAF (Footer).fr3
  • Add 4 format GST- Sales Bad Debt Relief-Unclaimed Letter
  • Modify GST Bad Debt Relief - Sales - to show the tax amt claimed and unclaimed after AR bad debt relief
  • Update Fast Report with ShitRelative function
  • Add GST Detail 3 - GST-03
  • Update GST Bad Debt Forcast by just show 5 & 6 month record only
  • [BETA] Add options to import current transaction for AR & AP (IV, DN, CN, Payment & Refund)
  • Other minor improvements