CONCEPT SOFTWARE SDN BHD

Wednesday, May 3, 2017

SQL Accounting Latest Version (743) Date : 30th April 2017

Information

Last updated: 30/04/2017
Current version: 5.2017.806.743

New in this version

  • Database upgrade to version 146
  • Feature #4200: GL Journal Entry add new GST Fields (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country)
  • Enable support new JE Structure for GST Detail 1, Lampiran 2 & Lampiran 2 with ZR report
  • GL Cash Book & Journal Document Listing add new GST Fields (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country) to detail grid
  • GL Journal Entry added new GST Fields (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country)
  • GL_JEDTL table add new fields for GST Audit File (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country)
  • Feature #4180: AR & AP Journal (DN & CN) for non-GST adjustment
  • Add support for drill down to Journal document correctly if has duplicate doc no in GL Journal and AR/AP DN & CN
  • AR/AP Document Listing Report Grid add "DocType" column for AR/AP DN & CN
  • GL Journal Listing Report's Detail Grid visible columns should same as GL Journal Entry
  • GL Journal Listing Report and Journal Lookup support retrieve data from AR/AP DN & CN
  • GL Journal browse grid click "Detail" button will drill down to AR/AP DN & CN if FromDocType is not empty. Support detail form able to click "Browse" back to browse grid if detail entry is empty record
  • GL Journal browse grid retrieve journal doc from AR/AP DN & CN
  • AR/AP DN & CN Entry Form label caption indicate "JE" if doctype is journal
  • AR/AP DN & CN support "New JE" journal document
  • AR/AP DN & CN tables add DocType field
  • Adjust GL Cash Book DocNo lookup coding to allow to set CacheData directly instead of define another ILookupProp class
  • Bug #4037: Clone GST Malaysia database (Master Data only) and register as GST Singapore license
  • Revise get country name in Profile UI form
  • Maintain Customer support Read MyKad function
  • Add View | Smart Card Reader
  • Localization for Motor business
  • Bug #4208: Running Year End Item Code with Serial Number will double up the Balance Qty & Balance Cost. YED added new option "Perform Stock Posting, Calculate Costing & YED Stock Checking (Recommended)"
  • Bug #4212: Unable to save Maintain Customer/Supplier branch field changes using F3 key
  • Prompt user friendly exception message if a payment knock off same invoice more than once during calculate bad debt relief and recover
  • Update resourcestring for UBS Data Import
  • Fix GST Detail 1 & 2 CompanyName & Description for OR & PV not correctly capture
  • Update GST F5 Return to map Field 13
  • Feature #4181: GST F5 Report (SG) should retrieve value for Revenue (item 13)
  • Bug #4204: GL Cash Book Detail "Inv Date" cannot greater than Master DocDate
  • Bug #4183: All Documents not allow to save if currency rate is zero
  • Bug #4199: Negative access right shouldn't allow to edit in Maintain Stock Item
  • Bug #4175: Stock Transfer Report Main Pipeline missing Company Name field
  • Feature #4195: Maintain Stock Item Browse Grid add "Barcode" column
  • Add new reousrce string: rc_DocProject and rc_ItemProject
  • Bug #4203: Spelling Error "Delivery Order" on SQL Power Search
  • Fixed GST Detail 1 & 2 Gain & Loss Symbol incorrect set
  • Add package: i18n.my
  • Fix bug #4198: Unable to clear supplier bank on supplier payment
  • Fix bug #4194: Unable to bounce cash book even though bounced date fall on the taxable period already unlocked
  • RAD Studio 10.2 Tokyo
  • Fix potential error in TDBDataSetBrowse.AddFields if SQL does not contain 'order by clause;
  • Fixed Error when amount is 0 for Sales Cash Sales 6 - Receipt-TM-U220 (Tax Invoice – Simple)
  • Add Project Description for GL Profit & Loss Statement
  • Add Project Description for Balance Sheet Reports
  • Optimize performance of GST bad debt report; rename parameter date caption to docdate
  • Fixed Cust Local - Payment Listing - Collection Report not sort by IV
  • Feature #4179: AR/AP Payment & Refund Paid Amount & Unapplied Amt labers should indicate the currency symbol
  • Add Detail For T, O1, E & O2 for GST Detail 4 - Mixed Supplies

Sunday, April 30, 2017

SQL Accounting Latest GST Version (V742) Date: 25 March 2017


INFORMATION

Last updated: 25/03/2017
Current version: 5.2017.802.742


NEW IN THIS VERSION

  • Database upgrade to version 145
  • Feature #3979: GL Cash Book Company Name Lookup (support add new value which not exists in the lookup). Upon change Company Name, system will retrieve GSTNo & RegNo that saved in table previously
  • Feature #4159: GL Cash Book Entry add new fields for GST Audit File (CompanyName, RegNo, Invoice Date, Invoice No, PermitNo & Country)
  • Adjust GST listing drill down to document by document key
  • Adjust implementation of GL cash book detail posting to GST_TR table
  • Feature #4155: Cash Sales Payment Dialog should make currency edit box wider so can display more digits
  • GL Cash Book Detail table add GST_DocDate, GST_DocNo, CompanyName, RegisterNo, PermitNo & Country. Upgrade GSTNo field to 25 characters
  • Feature #4161: Stock Batch Lookup by Item should show only unexpired batch baesd on DocDate
  • Fix bug #4162: Thousand separator in yearly amount of gift document does not fully display
  • Bug #4165: Sales CN save with detail Qty=0 prompt error "Division by Zero"
  • Rename TIterator_cxGridDataBinder_FindColumn to Tenumerator_cxGridDataBinder_FindColumn
  • Fixed GST Detail 2 not group by tax code
  • Remove TIterator_FindFile and replace with Tfile.GetFiles
  • Revise TIterator_FindControl to generic Tenumerator_FindControl
  • Bug #4045: Default filter operator for some string fields do not set to CONTAINS
  • Revise TIterator_FindComponent to generic Tenumerator_FindComponent
  • Fix GL PnL - 6C4P % mapping error
  • Rename TStore to TObjectStore
  • Fix GL Local - Ledger - Detail - Level 1 export to Excel Grand total missing
  • Convert GL PnL - 6C4P to fast report
  • Bug #4147: GST Taxable for AR/AP PM & CN should disable and only allow Past GST Taxable entry
  • Feature #4144: GST-03 Report changes from the GST Guideline (02 March 2017)
  • Feature #4143: Tax code changes from the GST Guideline (02 March 2017)
  • Enable single enter key press for stock item search
  • Bug #4121: Prompt Access Violation when close Stock Item Search with Active Row Filter
  • Bug #4122: Stock Item Search (F9) should auto focus on search item field after open the form
  • Bug #4132: User access right uncheck "Show Price in Delivery Order" should allow to access "Tax Code" field
  • Bug #4012: Disallow to Save Cash Sales & Cash Purchase when there is payment Amt and payment method is blank
  • Feature #4126: Tools | Option | Customer, Rename the checkbox caption "one cents different rounding (local currency fields) for all AR/SL Documents (Recommended)" to "Perform Tax / Local Amount Rounding". New database by default the option will be ticked
  • Remove Allow Expression for Company Letterhead for Customer/Supplier IV, DN & CN & GL PV & OR
  • Bug #4090: Access Violation When Delete Document Entries from Browse Screen if Split Browse & Detail Form Mode Applied
  • Bug #4091: Unable to paste picture in RTF Editor
  • Fix bug #4085: Incorrect document number posting to transactions table (e.g GL_TRANS) after edit document for new document number
  • Bug #4056: Edit Sales Invoice Detail's More description by changing all content to upper case to lower case, when close it system no prompt "Save changes?" and changes are not being saved
  • Fix bug #4114: Incorrect output tax calculated if gift document contains record with OS tax code
  • Bug #4019: Customer Debit Note should have FromDocNo lookup from Customer Invoice
  • Bug #4074: AR/AP Payment should not allowed to delete the payment if posted from Cash Sales/Cash Purchase/Sales Order/Purchase Order
  • Bug #4111: CN UnitCost not in smallest UOM if using UOM rate <> 1
  • Bug #4108: Access violation error prompted in Year End while compare GL Bank Recon Opening Result
  • Bug #4104: GST Taxable Transaction didn't copy to GST_TR table if user never process GST
  • Fix bug #4102: Giro - Incorrect payment amount for foreign supplier where payment method in local currency
  • Fixed GST-Penyata Pembekalan Dikecualikan (ES & IES) JV Not included in report
  • Fix Cust Aging PDC Total Balance is empty
  • Fixed GST Detail 3 - GST-03 Item 12 caption from (Gain)/ Loss to Gain/ (Loss)
  • Change Report Title for Balance Sheet IFRS to "Statement of Financial Position As At"
  • Bug #4087: GST Taxable button is missing after update in the Past Document
  • Bug #4088: GST Taxable Listing Report should show past documents taxable transactions
  • Fix bug #4080: Gift document allow to change date even though the document already processed in GST return
  • Fixed GST Lampiran 2-with ZR Output PermitNo not shown in some situation
  • Bug #4077: GST-03 Drill Down Form Filter Row by doc date not working
  • Bug #4076: Access Violation when activate filter on TClientDataSet due to field names "Seq" appear twice in IndexFieldNames (duplicate)
  • Bug #4073: Access violation when re-focus on 2nd level report grid with twice apply
  • Bug #3962: Unable to continue utilize COM object implemented by OPF
  • Remove Shift option in JV