SQL Accounting Latest Version (V758) Date : 08/06/2018

SQL Accounting Latest Version (V758)

Information

Last updated: 08/06/2018

Current version: 5.2018.829.758

• Add integration for SQL-POS
• Fixed GL PnL - 2C2P Export to pdf Account code shown partly
• Feature #4635: GL Balance Sheet Report Type Reposition & Set IFRS as Default
• Feature #4663: Allow user change Tax Code for all transfer documents (except IV/CS that transfer from DO)
• Update Sales Invoice 3 (GST 2) & (Sales Disc) fromat TaxAmt should shown 0 instead empty
• Update Sales Invoice 7 (GST 1) Tax Code alignment
• Update GL PnL - 4C4P header alignment
• Update Sales Invoice 7 (GST 2) header alignment
• Update Purchase Cancel Note 7 Tax Rate label sensitive with Tax Date
• Update Purchase Return 7 Tax Rate label sensitive with Tax Date
• Update Purchase Debit Note 7 Tax Rate label sensitive with Tax Date
• Update Purchase Cash Purchase 7 Tax Rate label sensitive with Tax Date
• Update Purchase Invoice TaxRate label sensitive with TaxDate

SQL Accounting Latest Version (V757) Date : 25/05/2018

SQL Accounting Latest Version (V757)
Information
Last updated: 25/05/2018
Current version: 5.2018.828.757

• Upgrade Database to Version 159 - Tuning TAX table
• 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
• #4649: Access control fail in after upgrade to 756
• Feature #4647: Maintain Tax add fixed tax rate 6% for certain tax codes (GST transition period purpose)

SQL Accounting Latest Version (V756) Date : 23/05/2018

SQL Accounting Latest Version (V756)
Information
Last updated: 23/05/2018
Current version: 5.2018.826.756

• Upgrade Database to Version 158 - Tuning AP_SUPPLIERBRANCH, AR_CUSTOMERBRANCH and SY_PROFILE table
• 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
• 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
• 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

SQL Accounting Latest Version (V755) Date : 20/04/2018

SQL Accounting Latest Version (V755)
Information
Last updated: 20/04/2018
Current version: 5.2018.823.755

• 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

• #4584: Unable to transfer empty item code from IV to CN

• #4577: Incorrect display format for Overdue Limit in Maintain Customer

• Feature #4576: Analyse Data Integrity add "Repost ST Documents"

• #4595: Slow response using URL attachments

• Feature #4597: Rename GST and GL trans description for bad debt relief and bad debt recovered

• Feature #4349: Add record count indicator to bad debt relief and bad debt recover caption on GST bad debt form

• Update RMCD GST TAP

SQL Accounting Latest Version (V754) Date : 14/03/2018

SQL Accounting Latest Version (V754)
Information
Last updated: 14/03/2018
Current version: 5.2017.822.754

• 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

• #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 not including 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

• 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

SQL Accounting Latest Version (V753) Date : (09/02/2018)

Warm Reminder: Always make sure your SQL Account version are UP-TO LATEST VERSION 753. To ensure the submission correctly for GST Return taxable。

温馨提醒：记得确保您的SQL帐户版本是最新的版本753，以便提交正确的消费税给关税局。

SQL Accounting Latest Version (V753)
Information
Last updated: 9/2/2018
Current version: 5.2018.819.753

New in this version
Compliance to the latest GST Accounting Software guide (05 Feb 2018).

1. New Tax Code : IM-CG
2. Existing Tax Code (EP, RP, GP, NP) will be marked as INACTIVE.
3. Revised the tax code description for OP, NS,and ZP.
4. New GST-03 format*.
5. New TAP upload text format*.

SQL Accounting Latest Version (V751) Date : 30/11/2017

SQL Accounting Latest Version (V751)
Information
Last updated: 30/11/2017
Current version: 5.2017.817.751

New in this version
• Database upgrade to version 153
• Feature #4438: Document batch lookup add qty column and option "View Qty"
• Create index for ST_TR (Batch) to speed up performance for Batch Qty Lookup
• Feature #4438: Document batch lookup add qty column and option "View Qty"
• Add GST Bad Debt Relief - Purchase-Adj-Input & Output Tax format
• Add feature #4442: List invoices where bad debt relief or bad debt recover already happened based on taxable period
• Bug #4441: GL Cash Book & Journal should allow to save if detail invoice date greater than document date within same month (Change to confirmation dialog)
• Pascal Script support TcxCustomEditProperties.Alignment.Horz property
• Update GL Journal of Transaction - Inbalance.fr3 add Export list to text
• 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
• [Win64] - TClientDataSet.XMLData prompt Access Violation
• Convert Customer Statement with Orig Amt to Fast Report
• Convert Customer Statement - Group to fast report
• Bug #4431: Maintain Batch Unable to AutoRun Code
• Bug #4437: Access Right - File | Import no function
• Bug #4416: Stock Batch Lookup "New" should be disabled if no purchase batch modules
• Feature #4423: Auto post the stock value when click apply on GL Trial Balance, Balance Sheet and P&L Reports
• Fixed Cust Statement 12 Mths 1-Fixed Month had extra unknown field & no decimal point for Open Credit Amount
• Fix application prompt override access right window twice even though ADMIN override the access right
• Fix bug #4434: GST taxable button is visible on document entry window if document default window is detail window
• Feature #4060: Lookup New Entry supported for all master entry forms
• Convert Customer & Supplier Listing to Fast Report
• Fix bug #4415: Report form data grid auto append a record if press "Down" arrow key on grid
• Bug #4426: GL Journal Listing Filter by Doc No prompt error
• Add GST-Penyata Pembekalan Diberi Perlepasan CBP (RS) report
• Check tax type of input and output tax of easy GST bad debt before process GST return

SQL Accounting Latest Version (V750) Date : 08/11/2017

SQL Accounting Latest Version (V750) Date : 08/11/2017
Information
Last updated: 08/11/2017
Current version: 5.2017.816.750

• Feature #4391: GL Opening Balance allow batch edit save and display status to alert user if local DR and CR not balanced
• Remove old GL Opening Balance dma, dmb & form
• Add Editing drop down button for Customer & Supplier account to drill down to other entry forms
• Rewrite GL Opening Balance to support batch edit
• Bug #4412: Incorrect Drill Down from GST Listing for PV with the Detail Inv No
• Fixed GST Summary Sheet - MY - RSA should not include in DS category
• Update maybank2e-rc universal payment file format based on version 4.5
• Bug #4410: Maintain Stock Batch rename code (1 space) to other value will cause incorrect update to all empty stock batch transactions
• Fix GST Summary Sheet - MY-20170106 Relief should not show GST Amount
• Bug #4407: Customer Contra will Prompt Error if using Form Mode Split Browse & Detail Windows
• Fixed GST Detail 4 - Mixed Supplies label for calculation not correctly shown
• Update RMCD GST TAP
• Calculate bad debt invoice if invoice has outstanding (invoice DocAmt - payment KOAmt)
• [Localize] Add Khmer (Cambodian) language
• Remove redundancy code in Sales Picking List - Level 1-DocUOM
• Fix TcxDBImage unable to load jpeg image
• Show Account Not Balance in GL Opening Balance when the LocalDR and LocalCR is not equal
• Feature #4393: Localize and allow user specified GL Profit & Loss and Balance Sheet Report Grand Totals' Description in Tools | Options
• Bug #4402: Stock Month End Error when Filter by Category
• Reverse the Negative Symbol to Credit for GL Journal Voucher - (GST) reports

SQL Accounting Latest Version (V750) Date : 08/11/2017

SQL Accounting Latest Version (V750) Date : 08/11/2017

Information

Last updated: 08/11/2017

Current version: 5.2017.816.750

SQL Accounting Latest Version (V749) Date : 07/10/2017

SQL Accounting Latest Version (V749) Date : 07/10/2017

Information

Last updated: 07/10/2017

Current version: 5.2017.815.749

• Fixed Stock Transfer Report Shown duplicate Serial Number

• Bug #4348: AR/AP Payment, CN, Refund & Contra upon save should prompt error if KnockOff documents have been deleted/updated

• Bug #4390: Stock Batch Lookup should list out Batch without Expiry Date

• Bug #4396: Font in Company name & Address in Sales Invoice do not follow application font setting

• Bug #4397: Empty Company Logo in sample database

• Remove MiscBO.UI.Impl project

• 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

SQL Accounting Latest Version (V748) Date : 26/09/2017

SQL Accounting Latest Version (V748) Date : 26/09/2017

Information

Last updated: 26/09/2017

Current version: 5.2017.814.748

New in this version

• Feature #3512: Auto Posting Stock Month End value to Maintain Stock Value according to stock group's Balance Stock account

• Feature #3512: Auto Posting Stock Month End value to Maintain Stock Value according to stock group's Balance Stock account

• Stock Month End Balance Report add "Balance Stock" field

• Maintain Stock Group add "Balance Stock" field

• ST_Group table add "BalanceStock" field

• Bug #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

• Remove modules: SalesTax, PriceAssistant, StockStatusAssistant, AdvanceDrillDown, ProfitEstimator and AlternateItem

• 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

• Move Import "Save GL Account To File" command to SQL Payroll Import PV/JE form

• Feature #4384: Add Stock Group Column in Grid for All ST/Production/SL/PH Data Entries

SQL Accounting Latest Version (V747) Date : 19/09/2017

Available in SQL Account version 747 :

1. Added the Balance Sheet IFRS (UK) and GAAP (US) format.
2. Get to know the tax invoices from the GST Bad Debt Recover in GST Listing and drill down in GST-03 item 18.

SQL Accounting Latest Version (V746) Date : 10/09/2017

Information

Last updated: 10/09/2017
Current version: 5.2017.812.746

New in this version
• Fix build script to remove developer library from OEM release
• Database upgrade to version 149
• Merge m2e.universalpayment.TT
• Add support of telegraphic transfer payment mode of Maybank Universal Payment file format
• Add Giro column, increase size of Bank and AccNo column for AR and AP Bank Account tables
• Merge feature/DPI
• [DPI]: Revise DialogsEx
• [DPI]: Revise docking controls creation
• Exclude localize files based on OEM
• Bug #4357: GL Balance Sheet & PnL "Show Column Options", the Budget field should auto untick once select Variance
• Memory leak occurred if click "Giro" button on supplier document listing window more than one time
• Revise Tools | Options | Unit Price GUI design
• Revise methods in class THTTP_Methods to support default parameters
• Enable Batch Email for Cust Overdue Letter-(with other Info) format
• Bug #4350: GL Cash Flow Statement - Profit Before taxation should including Prior Year Adjustment
• Bug #4334: Document Entries Batch Lookup add column "Exp (Days)" and grid option to filter unexpired batch item (reverted commit 1fb2d5b601f963d80b671c7cf0f539aa46d03015)
• Add SSM service class
• Revise THTTP_Net_HTTPClient.Create
• Set default encoding to gzip and handle redirects for THTTP_Net_HTTPClient instance
• Add feature #3103: Add access right "Not allowed to delete GST return" and "Not allowed to unlock GST return"
• Add dxGaugeControlRS25 to project runtime packages
• Add sample database defined in OEM resource
• Merge feature/image
• Replace IGraphic with Tgraphic
• Remove graphic file name extension .bmp
• Replace all bmp image files to png image
• Merge feature/commandnavigator
• Revise Command Navigator XML file to class
• Remove command navigator icons caption
• Revise TAppFactoryVCL class
• Bug #4354: GL OR/PV & Job Order Report Lookup DocAmt column shouldn't show $ symbol and Alignment should be on right
• Optimize SetDisplayFormat
• Fix Sales Delivery Order 4 (Simple) Delivery Tel & Fax label not shown
• 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
• Feature #4353: Document Transfer (DO/GR->IV/CS/PI/CP) Delivery date should be assigned with DO/GR Doc Date
• 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
• Bug #4340: Profit and Loss Report doesn't filter Project Code defined in Unicode characters
• Bug #4293: Unicode characters fail in most recently used dialog
• GL Local - Ledger - Detail - Level 1 Date column wrongly map to DocDate
• Bug #4278: Save button icon is missing in TfrDatasetButtons
• Revise Balance Sheet UI: Removing unuse Panel1 control
• Revise Profit & Loss UI: Removing unuse Panel2 control
• Make Apply button in report form to transparent
• Convert GL Local & Multi - Ledger Summary to FR3
• Rename Stock Card - Location to Stock Card - Location + SerialNo
• Stock Analysis By Document disable Load/Save grid layout
• Add CheckModule function to scripter
• Feature #4336: GST Listing detail drill down to original source document (eg. Sales IV instead of customer IV)
• Bug #4319: Negative access right allow to edit in Maintain Stock Item detail mode
• Feature #4315: Stock module auto activate the Basic S&P module
• ert Stock Transfer to FR3
• Bug #4337: GL Receipt & Payment Report Parameter dataset's OpeningBalance & TotalAmount not set Display Format if preview second time
• Temporary solution to fix process GST return prompt "out of memory" error due to more than 150000 records of AR bad debt relief
• 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
• Fix display format is missing for qty grid columns on outstanding job order data form
• Fix bug #4335: Incorrect transfer qty of outstanding job order listing due to item rate > 1
• Bug #4294: Purchase Documents' Tax Amount, Local Tax Amount & Taxable Amount should hide if "Show Cost" access right is unticked
• Bug #4322: Year End should insert GL Journal in GL Opening Reconciliation (Bank transactions only)
• Bug #4327: SL/PH Documents add new detail record without Item Code shouldn't assign Default Tax Code if company has Tax Exemption Number
• Bug #4314: Grid in Account Inquiry is too close to form edge
• Fix bug #4331: Outstanding production for sales order document does not exclude non-BOM item
• Bug #4332: Revert back the commit - Enable tab stop for company name, address, doc description & etc under sales, purchase & stock entry screen
• Fix bug #4306: Gift record with item code can set UOM as blank
• Bug #4304: Copy & Paste Stock Item Assembly should exclude FromDocType & FromDocKey
• Bug #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
• Company Profile add Report Footer field
• Fixed GST Summary Sheet - MY IES amount not match with GST-03
• Fixed RSA DS should not add in Deemed Supply column
• Fix bug #4326: Unlock and delete PV or JE will cause incorrect output and input tax after recalculate
• Add GL PnL - 4C4P report
• Revise build script for chm file
• Bug #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)
• Fix bug #4309: Incorrect output or input tax of draft GST return created after recalculate GST return if invoice deleted after unlock GST return
• Remove Document_Document Pipeline for GL Journal Voucher & Bank Adjustment
• Bug #4307: GL Journal & Bank Adjustment Reports cdsDocument (Document_Document pipeline) been removed since Main pipeline already has same data
• Allow user to configure firebird database properties such as forced writes and page buffers
• Feature #4261: Sync preview actions of currently focused data form to standard toolbar
• DCF create Sample DB from json file
• Optimize lookup for better performance and reduce user objects (task manager)
• Revise Command Navigator to draw icon caption