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

SQL Accounting Latest Version (v817) Date: 23/04/2022

 

SQL Account 5.2022.932.817

Released on April 23, 2022

Release Notes

• Fix: Shopee order cancelled IV did not post CN
• Fix: Shopee payment file format updated not able to load
• #6117: Fix UI alignment issue in Bank Deposit
• Fix Auto.BankRecon.RHBBMY invalid numeric input error
• Fix Cust Local - Due Document Listing - Level 1 (Tax) unable group by Doc Project
• Fixed SST SST-02A-2019 preview error
• Fixed SST-02(2019) preview Error
• Revise WhatsApp implementation
• [GST-SG] Revise GST F5 Report Header from "GOODS AND SERVICES TAX ACT (CAP 117A)" to "GOODS AND SERVICES TAX ACT 1993"
• #6117: Fix UI misaligned issue
• #6126: Open SST Deemend Supply window prompt error "Invalid stream format"
• #6122: All Reports' Group By check list box by default should focus first item
• Fix: Woocommerce to include fees when posting invoice
• Fix: Shopee order incorrect amount when order over charged
• Fix: Shopee payment unable to detect past order
• Fix Ecommerce report 3 display all item from different invoices
• Fix Shopee fetch order access violation error
• Fix Lazada payment CN over knockoff IV and CF
• Adjust eCommerce order to default sorting by account, date and id
• Fix: Auto.BankReconAISLMY incorrect parsing of debit and credit
• Fix RHBBMY incorrect closing balance amount
• Add Sales P&L By Document(for eCommerce Customer Only) & summary format
• Add Stock Assembly-JO vs AS Variance format
• Fix Gain Loss Date > Aging, ledger vs aging will not tally for report Check Different Between Ledger vs Aging
• Reduce Column Usage on FR3 Export to excel for Sales Local - Cash Sales Listing - Z Report format
• Remove Sales Local - Delivery Order Listing (GST 1) format
• Reduce Column Usage on FR3 Export to excel for Purchase Local - Purchase Invoice Listing (Tax 1) format
• Reduce Column Usage on FR3 Export to excel for Purchase Local - Purchase Return Listing (Tax 1) format
• Reduce Column Usage on FR3 Export to excel for Purchase Local - Debit Note Listing (Tax 1) format
• #5454: Audit Trail Event Type AAA change to Security

SQL Accounting Latest Version (v816) Date: 29/03/2022

 

SQL Account 5.2022.931.816

Released on March 29, 2022

Release Notes

• Database upgrade to version 186 - Add ObjectID column to SY_VIEW table
• #6112: Stock Transfer prompt error "Ancestor for 'Panel1' not found" upon open form
• Fix Process pending service tax prompt error "Division by zero"
• #6113: Sales Profit Estimator "Use Last IN Cost When Qty <= 0" show incorrect unit cost when there is negative stock balance before Last IN qty transaction
• #6068: Add Audit Trail for Override for "Save on Negative Quantity". Audit Trail Report add "AAA" event type
• #6103: GL Cash Book, AR/AP Payment & Refund Entry Forms Bank Balance label caption should retrieve from Payment Method Journal. Cash Flow Inquiry Bank column caption rename to Bank/Cash
• #6106: AR/AP Refund Gain Loss show full Local Amount when edit with full KO
• #6098: Unable transfer to CN/SC once the IV/PI has been transfered to Extra DO/EG. Add "Transfer to CN/EG" in Extra DO/EG
• #6096: Tools | Options | Misc - Display Format grid should display fully
• #6101: Tools | Options | Customer, standalone unable to untick the Options "Perform Tax/Local Amount Rounding"
• #6092: Cash Sales before prompt payment change dialog should prompt message if customer code is empty
• #6087: Sales Invoice's Item Template unable to show all item if access right Override Sales Min/Max Price with 0 ref price
• #5446: SL/PH Document Entries when click "Edit as New", detail record sequence will sort incorrectly if the records been moved seq before

SQL Accounting Latest Version (v815) Date : 28 Feb 2022

SQL Account 5.2022.929.815

Released on February 28, 2022

Release Notes

• Reduce Column Usage on FR3 Export to excel for Sales Points format
• Reduce Column Usage on FR3 Export to excel for Purchase Local - Cash Purchase Listing (Tax 1) format
• Fix #6081 Preview SST-02 (2020) format error
• Fixed Sales Invoice 11 item Discount not shown
• Fix Shopee order access violation if orders has no return
• Fix eCommerce order post to QT status customer code not matched
• Fix eCommerce post to QT ecommerce item description should be in description 2
• Fix eCommerce print report error field item code not found
• Fix Lazada payment detail replaced wrongly
• #6091: Available Stock Balance form's grid export to excel prompt Invalid file name error since the file name contain colon symbol
• #5447: Open Any SL/PH Entry Forms will prompt Access Violation if enable Auto Logon and untick Command Navigator
• #6088: DIY Advance Form Design's Component Palette not display fully
• #6089: Application shouldn't open form when user click cancel in Form Mode selection dialog
• #6086: Customer/Supplier Deposit Prompt Error when the deposit is transfer to Payment & with Refund
• #6076: Unable to scroll Stock Value grid of Maintain Stock Value in browse mode
• #6083: Sales & Purchase Price History Group/Sort by not fully showed as no scrollbar
• #6082: GL Journal Entry prompt "Combination of account type "CL" and special account type "CH" is not supported error when choosing Cash account under Current Liabilities

SQL Accounting Latest Version (v814) Date : 07 Feb 2022

SQL Account 5.2022.927.814

Released on February 7, 2022

Release Notes

• #6055: [Automation]: Add Reconnect mechanism
• #6054: Maintain Stock Item DIY Script - OnBeforeSave prompt error "Delta is empty"
• #6056: Customer/Supplier Listing Group/Sort By UI control not display fully
• Fix Flicker in report previewer shown in MDI form
• Screen flicker when closing Available Stock Balance
• Fix Prompt Install WebView2 due to windows update

SQL Accounting Latest Version (v812) Date : 08 Jan 2022

SQL Account 5.2022.925.812

Released on January 8, 2022

Release Notes

• Fixed Cust Statement 12 Mths 1 report Batch email error
• Fixed Lazada payment not able to fetch order with modified order no
• Fix eCommerce product mapping should return success when item code same as sku
• #6033: GL Cash Book, AR/AP Payment & Refund show payment method balance should check on Account Inquiry - Inquire G/L Account access right
• Change Job Order next number to 3 for sample database
• Add Stock Month End Balance - Location in Column & Stock hysical Worksheet - Location in Column Reports
• Fixed GL Local - Ledger - Level 1-SSTDeferred report - Error when have CN transactions
• Feature: eCommerce able to replace as cancelled invoice
• Fix Lazada account column should shows shop name instead of account email address
• Adjust: eCommerce edit IV and CN to keep serial number in document note
• Adjust: eCommerce will not delete detail if has batch no or serial number
• Adjust: Lazada payment will update IV to untick cancelled
• Fix Lazada payment has only payment fee and caused divide by zero error
• Fix eCommerce order will replace remark 2 for non stock item
• Fix eCommerce order append FOC in description for product with 0 item price
• Fix Shopee payment should edit IV when release amount is 0
• Fix Shopee order return refund only process order with status REFUND_PAID
• Feature #6026: Stock Analysis by Document enable save grid layout
• Feature #6024: Add support of item barcode lookup to Print Barcode (Windows Printer)
• #6023: Credit note unable to auto knock-off if transfer from invoice and insert negative value record
• #6018: Purchase Invoice edit and save prompt "Unable to rollback inactive transaction" error when using Region setting "Malay(Malaysia)"
• #6020: AR/AP Fast Entry disable grid column sorting
• Fix Auto bank recon Maybank not able to detect statement format and header
• [GST-SG] Purchase Returned with TXRC tax code should post as negative value in GST Return
• #5618: Stock Physical Worksheet should generate based on Location Lookup values
• #5734: Stock Item Opening Balance Location Drop Down missing Qty
• Feature #5933: User Access Right Assignment Request Add Option for Mark All and Clear All
• #5926: Stock Item BOM raise error when Qty change to blank
• #6013: All Documents Entries' Note UI control unable to load image from rich text editor
• #6012: Sales Invoice - Document_Company."Outstanding" not set displayformat
• #5620: Local Item Sales amount is incorrect, it is not in negative value
• Feature #6016: Tools | Options | Barcode | Stock Take add Lock Qty Editing & Lock Re-Scanning S/N options

SQL Accounting Latest Version (v811) Date : 13 Dec 2021

SQL Account 5.2021.922.811

Released on December 13, 2021

Release Notes

• Fixed Stock Card - Location + SerialNo StockGroup total not correctly sum
• Fixed Sales Invoice 8 (SST 2)-Aging should take DocDate
• Add GL PnL - 13C13P-SinglePage format
• Remove hardcode display format for Supplier IV, Supplier DN & Supplier CN format
• Remove hardcode display format for Customer IV, Customer DN & Customer CN format
• Change PnL-Comparison - Monthly (12 Months) report template to default print to GL PnL - 13C1P-SinglePage format
• Reduce the GL PnL - 13C1P-SinglePage right margin
• Reduce Column Usage on FR3 Export to excel for Customer due Listing report
• Reduce Column Usage on FR3 Export to excel for Customer Aging 12 Months & GainLoss report
• Reduce Column Usage on FR3 Export to excel for Stock Transfer
• Reduce Column Usage on FR3 Export to excel for SST Listing
• #6010: Customer Pricing Inquiry raise error : List index out of bounds (0)
• #6015: Maintain Customer new Customer code incorrect add additional 1 in middle
• Feature #4218: GL Cash Book, AR/AP Payment & Refund Entry Forms Show Bank Balance
• #5796: Perform editing and save an deleted DO record deduct stock quantity.
• #6011: Customer Pricing Inquiry unable to retrieve correct price if set by company
• Fix GL Balance Sheet & P&L consolidate error if using firebird server with port no
• Fix View item flow is not DPI-aware
• #6009: General tax purchase invoice not allow save on closed SST return period
• Move NextCloud Stock Take UI to Tools | Options | Barcode
• Reduce Column on export to Excel for Supplier reports
• #6004 - New Customer raise error: Unable to commit inactive transaction
• Fix Shopee payment did not replace shipping fee
• Fix: Lazada payment does not have post date on customer refund
• Fix: eCommerce payment sub item is not deleted
• Fix: Lazada payment didn't post to customer IV / CN for past marketing fee
• Fix bug: eCommerce posting IV should set discount field to empty
• Fix bug: Lazada order not appending shop id to order id for 3rd duplicated order
• Fix eCommerce order footer alignment
• Fix eCommerce order item name and variation does not shows in QT
• Fix eCommerce item been replaced if same item code
• Fix Woocommerce order not able to fetch
• Extract name, ref1, ref2 from PDF for auto bank recon
• Add Stock BOM Wastage with Amount report
• Fix GL/AR/AP/SL/PH Entries Form labels that show Currency Symbol missing
• #5994: Apply job order listing report takes long time to show result when there are more than 150000 batch records
• Blob Edit prompt "Invalid Typecast" error for non-DB aware grid
• #6005: GL Balance Sheet & P&L Report Condolidate Grid show empty record
• Fixed Sales Outstanding Sales Order Listing - Level 1 (DocFlow) not including Cash Sales

SQL Accounting Latest Version (v810) Date : 19 Nov 2021

SQL Account 5.2021.919.810

Released on November 19, 2021

Release Notes

• #5998: Ambank - Bank Recon - DR & CR Column in correct
• #5980: Ambank Islamic Bank Recon capture wrong year
• #5919 Incosistent auto match results in bank reconciliation
• Fixed Access violation when create supplier payment at auto bank recon
• #5986: Outstanding Sales/Purchase - Add all the Source Header in grid
• #6002: Maintain Stock Item browse grid Barcode code able to perform incremental search, sort, grouping and export to excel (filtering column is not supported)
• Feature #5218: Enable multi-select to all report forms
• #5670: Customer/Supplier Payment unable to Save if there is Refund Knock Off
• #6003: Tools | Options | Barcode format should prompt error when user enter "%" as delimiter
• #5999: Supplier Aging report Gain Loss not filter out by date
• Add Option To Change Code & Description font type for GL Trial Balance report
• Add Option To Change Code & Description font type for GL Balance Sheet Report
• Add Option To Change Code & Description font type for GL PnL Report
• Fixed SST Listing 3 preview error when using Deemed Supply & Data with []
• #5984: Stock Matrix grid columns become too small when captions are short
• Fixed Sales Invoice 8 (SST 2)-Listing-EMail mapping error
• #5988: Account Inquiry grid filter row default condition should be Contains instead of equal
• Feature #5983: Stock Item COM object set unicode to More Description become ???
• #5981: View | Purchase Price History add Landing Cost fields
• #5992: GL Bank Recon Listing date range set to 6 months
• #5996: Sales tax which had process SST can still change doc date
• Add Total for each company for Cust 12 Months Aging LS - Outstanding Service Tax report
• Convert Sales Customer Price History to FR3