SQL Accounting Latest Version (v826) Date : 10 Dec 2022

 

SQL Account 5.2022.948.826

Released on December 10, 2022

Release Notes

• Account Inquiry adjust the aging grid height
• Database upgrade to version 190
• [GST-SG] Support seamless filing for SG GST Return F5 & F8 submission via API
• Add GST F5 Return-2023 format
• Maintain User add Phone field
• Fixed PO unit price display format not follow tools | options
• Fixed Stock Analysis By Document - Level 1 sometime hang due to summary hight
• Remove Voucher from Item Discount for Sales P&L By Doc - eCommerce reports
• Fixed #6275 OR not auto select when WhatsApp
• Add Yearly Depreciation - Group By Level 1 format
• Fixed Seq big number for Report format with (Tax 1)
• Fixed Asset Analysis BF not correct
• Fixed Stock Item List Query error
• Add Asset Disposal Listing & Asset Card (with Schedule Depreciation) report
• Add New report format for New feature 6326
• Enable Batch email for Cash Sales Format
• Add Summary total for Trade debtor & Creditor for GL Ledger Level 1
• Fixed GL Payment Voucher - Detail - Full (with other SCnPV info) display format error
• Post TikTok credit note from payment when escrow amount is 0 and no credit note is posted for order
• Show Lazada order with status "confirmed" under status "delivered"
• Support TikTok V2 authorization API
• Fix EasyStore missing order item's ID
• Check EasyStore's customer's phone number is null or not
• Remove empty spaces in EasyStore SKU and variant ID
• Fix Shopee not including shipping variance in credit note
• Fix Lazada payment added marketing fee as voucher
• Fix TikTok UpdateDate displayed incorrectly
• Fix Shopee return refund variance calculation
• Shopee remove Shopee coin from refund amount calculation
• Shopee try refresh token during get or post request when invalid access token error is received
• Fix Lazada does not include items that's free in print order
• #6384: SL/PH Cancelled Document not allow Transfer To Others Document
• #6381: Fix SL & PH Document Entries UI controls at top right position not align neatly
• Stock Available Balance change IDockSiteView.SetOnDockClientClose
• #6325: Auto Bank Recon - UOB New Statement Format
• #6370: Auto Bank Recon - AMBANK New Statement Format
• Feature #6380: AR/AP Deposit Refund Entry allow COM access to set Doc No
• #6375: Maintain Stock Item delete first record in Customer Price (that contain 3 records) cause incorrect record sequence
• #6298: Job Order Browse Grid add Remark, Line Supervisor and Production Info columns
• #6352: Fix location DIY Field unable to view from Browsing Screen
• #6377: Asset item allow project rate lower than 100%
• Feature #6376: Add Asset code auto running
• #6373: Unable to load default or last used layout for Supplier Payment KnockOff Grid
• #6374: Production Outstanding JO & SO negative outstanding balance (over transfered) should treat as fulfilled item
• #6299: Auto Bank Recon Alliance Bank - Unable to load complete bank statement
• #6368: SL/PH Document Entry Currency Rate should follow periodic currency rate if using copy and paste document
• Feature #6326: Add GL Project Profit & Loss with Cash Flow report
• #6364: Unable to process depreciation without fill in fixed asset acquire date
• #6360: Document Entry Detail first record Seq shouldn't been changed when user delete second record

SQL Accounting Latest Version (v825) Date : 11/11/2022

 

SQL Account 5.2022.947.825

Released on November 11, 2022

Release Notes

• Add Asset Label 80mm X 45mm format
• Reduce Lazada fetch order limit from 100 to 50
• #6363: AR/AP Analysis by Document report's Payment column should be no value if the payment and bounce date are fall in the same date range.
• Lazada combine "Other Services-Marketing Fees" and "Wrong Weight Adjustment" record into single order's payment
• Fix Stock Take IsValid batch number check doesn't check for batch number with no item code bind to it
• Lazada change payment form voucher column value type to FMTBcd
• Fix Shopee transfer sales invoice to credit note raised transferred quantity is greater than balance quantity
• Fix transfer sales invoice using wrong IVDTLKey value when transferring item from sales invoice
• Allow non stock item in Shopee sales order to be transferred to sales invoice
• Fix AddToCart export stock JSON file prompt exception when description is empty.
• Fixed Tax & TaxRate Grouping Summary not correctly group if have mixture empty & null data
• #6351: AP/AR Fast Entry prompt invalid class typecast error
• #6356: Incorrect decimal place on stock card grid
• #6353: SL/PH document entries transfer from other document the SubTotal will be incorrect if user modify SubTotal in the source document
• GL Account Entry should check if the deleted bank/cash account's parent is not root account before add the parent account to payment method
• #6347: Stock Item Assembly Detail UOM lookup's Cost column should hide if user no right to View Cost
• #6349: Audit Trail Summary open form slow when data is large
• #6340: Customer Payment unable to back to Browse if using Tab docking & Form Mode with Split Browse & Detail Option

SQL Accounting Latest Version (v824) Date : 28/10/2022

 

SQL Account 5.2022.946.824

Released on October 28, 2022

Release Notes

• Add Asset Opening vs GL Maintain Opening Balance format
• Add Remark1,Remark2, Description2 and StockGroup Fields for MergeItemCode pipeline for Sales & Purchase Data Entry format
• Fixed GL Ledger - Detail Reports 2nd Description not correct shown
• #6343: Asset analysis report depreciation summary doesn't filter by trans date
• Fix Shopee return refund variance and reverse shipping fee calculation for partial refund credit note
• Accept Shopee return details with status ACCEPTED instead of just REFUND_PAID status is allowed
• Add stock item's remark 1 and 2 fields to Stock Take import JSON file
• Remove Lazada transaction records that does not contain paid status
• #6339: Unable to save after paste an asset item already disposed
• #6337: Process Date does not follow Date To on Process Depreciation window
• #6342: Accum depreciation account wrongly posted in JV if process depreciation group by project only
• #6285: GL Cash Book, AR/AP Payment, Refund & Deposit Listing include bounced document and show as red color in report grid
• Feature #6338: Add AcquireDate field to Yearly Depreciation, Asset Analysis reports
• #6288: Journal Entry - Show label out of balance if not tally
• #6329: GL Profit & Loss Statement allow to print opening balance 1 day before System Conversion Date
• #5480: Stock Assembly's Show in Tree Mode dialog OK & Cancel buttons misaligned when resize the form
• #6332: Supplier payment unchecked knockoff invoice prompt "Dynamic SQL error"
• #6330: AR/AP Deposit Refund & Forfeit's Agent & Area should follow Maintain Customer/Supplier by default

SQL Accounting Latest Version (v823) Date : 19/10/2022

 

SQL Account 5.2022.945.823

Released on October 19, 2022

Release Notes

• #6328: Document Entries prompt invalid value for field "Seq" error when insert more than 32 detail records
• Fixed Stock Assembly-JO vs AS Variance format the variance % value to returns as 100% if JO qty is zero
• Add Security Deposit Amt for Supp Statement 06 & 12 Mths 1 format
• #6296: SL/PH Doc Entries search From Doc No in detail grid's filter row raise error
• #6274: Stock Item Assembly disable the transfer from Job Order in browse mode
• #6323: Stock Analysis By Document report's grouping tick Stock Group prompt error "Field Item Code Not Found"
• Lazada payment should exclude balance transactions amount into transaction details
• #6308: User can cancel customer credit note knockoff invoice contains SV although knockoff tax date already processed
• #6320: Incorrect value for SQty in print outstanding production job order listing report
• Fix TikTok does not include shipping fee in credit note for full refund order.
• Fix Lazada does not open credit note for marketing fee payment
• Fix TikTok combine payment information doesn't sum up fields value
• Support Shopee payment file in Thai language
• Fix TikTok shipping fee not included in adjusted credit note
• Fix TikTok credit note does not include discounted shipping fee by platform
• Add applied Shopee coin amount per order item for partial refund calculation
• Fix Shopee not applying shipping fee to order and fix refund variance calculation for partial refund order
• Fix fetch product show incorrect item code when similar SKU is used across multiple item code
• Remove buyer ship from Shopee shipping calculation and fix Shopee partial refund posted incorrect invoice and credit note.
• Prevent Shopee payment form from editing invoice and credit note
• Fix Shopee refund order with negative escrow amount failed to post invoice and credit note
• Fix TikTok sent empty array to API server
• Fix TikTok doesn't fetch all products
• Database upgrade to version 189
• Fixed Check Different Between Ledger vs Aging should exclude cancelled document
• Fixed Shown unknown value when company Logo empy for GL Official Receipt - Detail - Full report
• Update GL Multi - Ledger - Detail - Level 1 show Currency Data if have mix currency
• Add Fixed Asset module
• Add report templates
• Add license module - Fixed Asset
• Add Asset Disposal data entry
• Add Open Depreciation window
• Add Depreciation Listing report
• Add Process Depreciation window
• Add Depreciation Processor
• Add Asset Analysis report
• Add Yearly Depreciation report
• Add Asset Item data entry
• Add Asset Group data entry
• Add Asset module tables
• Fix Multiple audit trail records posted after create a new stock batch record with detail batch item
• Feature #5927: Maintain Item's BOM grid add move up & down buttons
• Feature #6266: GL Cash Book, AR/AP Payment, Refund, Deposit, SL/PH Order, Cash Sales and Cash Purchase add BankChargeAccount fields
• Add BankChargeAccount field to report form
• Add change BankChargeAccount dialog to ui form
• Add BankChargeAccount field to data module
• GL_CB, AR/AP Payment, Refund, Deposit, SL/PH Order, Cash Sales and Cash Purchase add BankChargeAccount fields
• #6315: All report grids enable Filter Row except Stock Card
• #5951: Cannot focus a disabled or invisible window if split browse & detail window have ticked in form mode
• #6006: SL/PH Doc Entries should clear Discount last memorized value when user edit any existing doc entry
• #6318: Auto Bank Recon CIMB Bank empty result
• #5142: Add Landing Cost with Currency Symbol
• #6319: Exclude Deposit Account in Cash Sales Payment method
• Feature #6292: Document Entry grids add Insert Row Above & Insert Row After options in context menu
• Maintain Item - Adjust buttons position
• #6314: Sales PnL S/N by Document report & Sales Profit Estimator S/N Cost are incorrect if a serial number has more In/Out transactions (e.g stock transfer or CN)
• #6307: Apply P&L Statement with ledger information raise Error : conversion error from string "C1"
• Feature #6206: Barcode (F8) Form add search item by serial number for stock qty out documents
• Fix AR/AP Deposit Refund form label font height to default settings

SQL Accounting Latest Version (v822) Date : 22/09/2022

 

SQL Account 5.2022.942.822

Released on September 22, 2022

Release Notes

• Fix Lazada combined different date marketing fees.
• Verify transaction by matching released amount to avoid mixing transaction from different account
• Fix Lazada failed delivery order not canceled after shipped back to seller.
• Fix Shopee failed to knockoff order's credit note without invoice.
• Fix Shopee not posting credit note when escrow amount is negative and order is not canceled or returned.
• Fix Shopee showing incorrect discount value.
• Fix Lazada not showing expired token message.
• Fix Shopee fetch cancelled order by buyer show logistic.error_param exception
• Add Customer Listing - Credit Control format
• Fixed GL OR & PV Amount not Including TaxAmt
• Fixed OR & PV batch print for RTM format not correct shown Amount
• Add Supp Local - Deposit Listing - Level 1 - Tally with Balance Sheet format
• #6297: Stock Analysis By Document add RefPrice & RefCost grid columns
• Feature #6291: ComObject add PlainTextToRichText & RichTextToPlainText function
• #6262: GL Bank Reconciliation should use Debit(Net) column for auto bank recon if Merge Bank Charges is ticked
• #6287: GL P&L Statement prompt access violation when filter by project with Ledger Information
• #6284: Sales Invoice Tax "SR" ledger posting is missing when user edit document date that fall in year 2022 which is not GST era
• [GST-SG] #6280: Open Sales Invoice raise Access violation error after start Singapore GST. Revise Company Profile Peppol APIKey & Secret editing issue
• #6283: GL Profit & Loss Print Project comparison prompt error "List index out of ranged" if Project parent nodes have repeated same value
• #6276: Run Repost Stock Transactions prompt arithmetic numeric overflow exception error
• #6300: Fix Maintain Project Range Editor btnMoveUp & btnMoveDown icon and on click error

SQL Accounting Latest Version (v821) Date : 30/08/2022

 

SQL Account 5.2022.940.821

Released on August 30, 2022

Release Notes

• Database upgrade to version 188
• Fixed SST-02 (2020) 13(3)(i) Description not fully shown
• Fixed SST Listing 4-DST-02 (2020) preview error
• Fixed GL PnL - Comparison format Column 1 header not consistent & add Custom_Header & Use_Year_Info functions
• Fixed GL BS - Comparison format Column 1 header not consistent & add Custom_Header & Use_Year_Info functions
• Add SerialNumber List for Merge Same Itemcode for Purchase Invoice, DN, CN, GRN & Cash Purchase
• Add SerialNumber List for Merge Same Itemcode for Sales Invoice, DN, CN, DO & Cash Sales
• Fixed GL PV Report Amount Incorrect Shown if Company is Foreign Currency
• Fixed GL OR Report Amount Incorrect Shown if Company is Foreign Currency
• Add Peppol SG export and import
• User can set or change company profile country except GST or SST is started
• Feature #3366: Increase DocNo, Ref & DocRef fields length to 40 characters
• Data modules increase Ref/DocRef fields length from 25 to 40 characters
• Data modules and logic increase DocNo field length from 20 to 40 characters
• Increase D_DocRef field length from 25 to 40 characters
• Increase D_DocNo field length from 20 to 40 characters
• Feature #6265: Stock BOM Listing report add Detail Batch lookup
• #6271: Maintain Location support DIY Field
• Fix Shopee escrow amount negative unable post as cancelled invoice
• Fix Shopee customer refund shouldn't have unapplied amount
• Fix Shopee incorrect shipping Fee, should be bundle discount
• Fix Lazada fetch product raise access violation
• Shopee load payment error total amount is less than payment amount
• Fix Shopee order did not show cancel reasons
• Fix Auto Bank Recon Maybank empty result
• Fix Shopee load payment error missing dataset property
• Fix item code and leading description not shown in credit note.
• Fix Lazada payment amount cannot less than or equal to zero.
• Fix Woocommerce order mapping item will prompt access violation
• Fix tiktok payment new excel file format
• Fix Shopee payment did not amend IV and CN if release amount < 0
• Revise Shopee order refund variance description from Shipping Fee to Return Refund Variance
• Revise Shopee retry fetching to show appropriate error message
• Feature: Shopee able to batch enable and disable accounts
• eCommerce order should show "Posted" when user post posted orders again
• Feature #6245: Journal entry prompt error message to show amount not balance
• Feature #6097: Show Last Doc Information by Company
• #6242: GL Bank Reconciliation - Mark All and Highlighted not update Balance Figure
• #6257: Unable to shown Full in Category Code in Maintain Item
• #6255: Fix Customer & Supplier Deposit some UI not fully shown
• #6247: Maintain Opening Balance - change message Account Not Balance to Out of Balance
• #6176 Auto Bank Recon - Add CIMB BizChannel format
• #6150 Auto Bank Recon - AMBANK New Statement Format
• #6268: Maintain Customer running code format if contain fixed numeric char will cause the code keep increasing digits
• #6269: Tools | Options | Misc | Show Document Project by default ticked for new database
• Feature #2421: BOM Planner report add JO Qty & Avail Qty columns
• #6172: AR/AP Bill & Collection/Payment report add Option Show in Foreign Currency
• #6264: GL Bank Recon prompt confirmation message when user click Clear All
• #6225: AR & AP Aging Report - Move the position of the Apply button
• Feature #6256: AR/AP Deposit master data support DIY Field
• Stock Take json file add customer/supplier items
• #6118: Maintain Stock Item BOM's Batch column will be truncated if length exceed 20
• Feature #6219: Analyst Data Integrity - Unticked SQL Control Center
• Feature #6248: GL Account Lookup enable New label
• #6252: AR/AP Invoice Fast Entry button enabled state should follow New Button
• #6258: Customer & Supplier Currency Code should not allow to change if any tables have transactions reference to it
• #6263: Customer Due Listing - TaxAmt for CN should be in negative value
• #6261: Maintain GL Account should remove new parent deposit account in Maintain Payment Method when drag child account under it
• #5770: Unable to perform transfer from document using region format (Indonesia)
• #6260: Stock Month End Balance report Unit Cost Display format not correct
• Feature #6240: Customer/Supplier Balance Report - Add Sort & Filter by Control Account
• #6250: GL PnL & Balance Sheet reports add missing options in parameter dataset
• #6254: Maintain GL Opening Balance remove Open Deposit entry button

SQL Accounting Latest Version (v820) Date : 03/08/2022

 

SQL Account 5.2022.939.820

Released on August 3, 2022

Release Notes

• Fixed GL Local - Ledger - Level 1-SSTDeferred error when DocType is JE & OR
• Fixed GL Opening Balance not fully shown amount
• Fixed Cust Local - Due Document Listing - Outstanding Service Tax Linking detail not correct
• Fix Shopee product fetch item id is not found error
• Revise Lazada payment on fetching marketing fee from API
• Fix: Shopee V2 account linking
• Fix Shopee order wrong tracking no
• Fix Shopee order status PROCESSED should be status READY TO SHIP
• Revise Shopee order posting to include Product Discount Rebate from Shopee and Voucher
• Revise Tiktok payment to post adjustment
• Fix Tiktok order wrong shipping fee
• Com objects BizApp's FindKeyByRef support multiple References

SQL Accounting Latest Version (v819) Date : 22/06/2022

 

SQL Account 5.2022.938.819

Released on June 22, 2022

Release Notes

• Database upgrade to version 187
• Support Online Payment link for Customer Statement & Invoice reports
• Enable support Payment Link for Cust Statement 06 Mths 1 - with Orig Amt & Sales Invoice 8 (SST 2)-Aging format
• Add SQLAcc.Lib.bpl for report script to access external function
• Revise Auto Bank Recon messages when compiling
• Feature #6234: Outstanding Document Listing add Remark 1 & remark 2
• Feature #6233: Sales PnL By Document & Sales Serial Number PnL add DocRef1, 2, 3, 4 & DocNoEx
• Add E-Commerce EasyStore
• Fix: eCommerce payment should set project and payment project
• Revise eCommerce order
• Fix: eCommerce incorrect item UOM when post to quotation
• Fix: Lazada payment able to load in multiple payment cycle
• Fix: Lazada payment post date will be the last day of payment cycle
• Fix: Lazada payment when posting reversal items
• Fix: Shopee order multiple bundles with same item will not grouped
• Fix: Shopee post payment wrong shipping fee charged
• Fix: Auto Bank Recon MBB statement balance not showing
• Feature #6223: Add To Cart - Export Stock Add columns for filtering
• Feature #6209: Request to add fromDocNo in Job Order report
• Feature #6185: Allow Batch Inactive Item Code for Maintain Stock Item
• #6221: Fix item document flow is showing not related items
• #6212: Auto Bank Recon out of memory when the loading large pdf
• #6193: Fix GL Maintain Stock Value's Box Alignment
• #6178: Print audit trail find text with single quote with cause dynamic SQL error
• #6138: Account Inquiry Description shows special symbol & as _
• #6180 Bank Recon - Add Debit Net column for Load Statement View when Merge Bank Charges
• Fixed Purchase Order 3 (Simple) Description Not correctly shown when merge same item code enable
• Fixed Customer Statement with Orig Amt Shown 0.00 amount
• Add Purchase Invoice 8 SST format
• Fixed preview error & Rename Maintain Tax Listing
• Fixed Preview Error on Product Activation Code
• Add Stock Qty Balance (with Multi-UOM) - Level 1 report
• Add Depreciation & Net Book Value Report Format
• Fixed GL OR & PV for RTM error when Amount is Zero
• Sales Local & Multi - Invoice Listing add ItemCode Summary
• Sales Local - Invoice Listing (Tax 1) add ItemCode Summary
• Fix Sales Quotation 8 (SST 2) shown GST label instead of Tax
• Feature #6214: All AR/AP Browse & Detail Forms KnockOff Grid add Agent and Area fields
• #6203: Rich Text Editor pre-select a font type shouldn't change to another type after user start typing text
• #6220: Customer/Supplier auto running code unable to increase when next number > 10k
• #6216: AR/AP Payment Posted from Cash Sales/Cash Purchase - Payment Method Field should disable
• #6210: Stock Document Listing remove the Detail columns from main grid
• #6205: GL Bank Reconciliation edit hang when huge records
• #6157: Close Grid Properties window prompt error access violation
• #6161: Past AR/AP Deposit Entry if users edit and change amount shouldn't affect GL Opening Balance
• #6183: When tick more filter conditions in any Reports main grid then preview report will prompt Midas.dll access violation error
• #6198: Stock Aging & Stock Analysis by Document reports hide cost columns when user has no "Show Cost in Stock Item Maintenance" right
• Feature #6186: Stock Month End Balance report add Unit Cost column
• Add E-Commerce Tiktok
• Fix shopee return order posting to CN prompt total amount error
• Feature: Lazada payment transactions will fetch directly from Lazada
• Feature #6001: AR/AP Deposit Refund allow edit Agent, Area & Description
• #6228: Stock Available Balance | Back Order Detail prompt error when drill down Job Order document
• #6231: Customer Payment when save raise error access violation in module MIDAS.DLL (Knockoff has more than 400 records)

SQL Accounting Latest Version (v818) Date : 01/06/2022

 

SQL Account 5.2022.934.818

Released on June 01, 2022

Release Notes

• Fix eCommerce will not delete item if contain FOC in description
• #6162 Fix E-Commerce Lazada payment statement missing payment ref id
• Fix: Shopee payment posting for Lost Compensation
• Adjust: Lazada voucher fill into discount
• Adjust Lazada payment fees will update payment date to delivery date
• Adjust: Shopee payment to be able to parse Chinese and Malay file
• Revise eCommerce payment to post marketing fee and normal transactions in one payment
• Fix bug: Lazada payment verify order wrongly
• #6171 Auto Bank Recon - Request Add Indicator
• Fix Alliance Bank Auto Bank Recon not a valid date error
• #6144: Fix Auto Bank Recon RHB statement with different format
• #6114: Auto execute apply after loading statement in bank reconciliation
• Fix: Auto.BankRecon.HLBBMY last transaction's description is parsed wrongly
• Fixed GL BS - Comparison - 7C1P No line for Total Project Column
• Add EMail & Checking for Phone1 only shown when not empty for Ecommerce Invoice reports
• Remove the lines gap in Stock Assembly-JO vs AS Variance report
• #6149 Fix Foreign Bank Adjustment incorrect currency rate format casting
• #6163: Stock Card Prompt Error when double click on Deemed Supply document
• #6175: Payment method records "Cloud Banking" not set to "None" after create new database
• #6165: Delivery Order new appended record not position at last row after deleted some transferred document items from Sales Order
• Feature #6166: GainLoss Posting Date dialog display alert message when user change GainLoss posting date
• #6168: AR/AP Bill & Collection/Payment Report missing Currency column when group by Currency
• Feature #2953: GL P&L & Balance Sheet Print Project Comparison's Project panel add IsActive column
• #6151: Audit Trail Summary form Field Name is empty if Update Permit number
• #6159: Add DtlKey, Seq fields to Outstanding Job Order report BOMComponent dataset
• Revise UI alignment
• GL P&L and Balance Sheet report enlarge report format grid to prevent report name display in 2 lines
• Fix Open GST Audit File prompt Invalid Date error
• #6145: Sales and Purchase entry forms Transferable checkbox not position properly
• #6143: Document Entry Form click "Edit As New" prompt Abstract Error when using Form Mode