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