Friday, September 22, 2017

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