~ Get 50% or Up-to RM 5,000 SME Digitalization Grant Today ~
SQL Account Release Note

SQL Account 5.2021.913.805

Released on August 13, 2021

  • Add Shopee 3 format
  • Fix bug: Lazada order couldn't post when has voucher and all products are returned
  • Fix bug: Lazada order is posted when has either invoice or credit note
  • Fix bug: Lazada payment will not post order with 0 released amount
  • Fix bug: Lazada payment unable to delete IV due to already knockoff by CN
  • Fix bug: Shopee order print amount for coin and vouchers have no decimal
  • Adjust: Shopee payment show message to sync all invoice before posting
  • Fixed Stock Assembly Cost/Unit not same as on Screen
  • #5925: DIY OnOpen Script failed when GL Ledger report form unable to trigger Apply button click and SL Invoice Detail unable to find UDF grid column

SQL Account 5.2021.912.804

Released on August 09, 2021

  • Adjust: Lazada order post to IV detail, update original qty at S/U Qty
  • Adjust: Lazada payment posting
  • Adjust: Lazada Order to append seller id when have duplicate order id
  • Adjust: Shopee order posting quotation and credit note to update unit price of stock item from invoice
  • Adjust: Shopee order to display "Credit Note" on column Invoice if posted to credit note
  • Adjust: Shopee payment allow post only when all orders are posted
  • Fix bug: eCommerce chinese characters not properly display
  • Fix bug: Lazada payment past order date
  • Adjust: eCommerce post IV, Cancel is needed to show correct error message
  • Adjust: Lazada product fetching limit to 5
  • Adjust Lazada Account: store seller id
  • Adjust eCommerce order must match customer code when verifying
  • Fix bug: Lazada payment does not show error message after posting
  • Adjust: Lazada order able to post as cancelled order
  • Adjust Lazada payment only allow to post payment when all orders posted to IV/CN
  • Adjust: eCommerce order posting to tick tax inclusive if has tax set
  • Adjust: eCommerce order post order time in 24 hour to DocRef1, tracking no to DocRef2
  • Fix bug: Lazada order only cancel partial item qty
  • Adjust: eCommerce order posting to include shipping carrier name
  • Fix bug: eCommerce credit note is not past order
  • Fix bug: Shopee order same item should combine to 1
  • #5921: AR/AP Deposit Refund - Add Company Name and Gain/Loss summary
  • #5920: AR/AP Deposit Refund - the exchange rate should allow to edit if same foreign currency in both customer and payment method
  • Fixed Preview error & Reduce Column Usage on FR3 Export to excel for GST Bad Debt Relief - Purchase-Adj-InputTax & OutputTax format
  • Fixed Preview error & Reduce Column Usage on FR3 Export to excel for GST Bad Debt Relief - Sales-Part C17 & C18 format
  • Bug #5916: SL/PH Documents detail when change itemcode to another, the tax code will be incorrect even both itemcode set to same Tariff
  • Bug #5918: Fix incorrect label name in supplier deposit
  • Bug #5915: Maintain GL Account should block to add sub account if parent account has transactions in GL Budget
  • Bug #5898: Maintain Stock Item delete invalid Stock Category records upon save
  • Bug #5902: Year End GL Opening Balance's Retained Earning didn't include GL Stock Value amount if the Project only has GL Stock Value but doesn't have transaction in ledger
  • Bug #5917: Unable to edit invoice detail record description when the detail record has SV tax code after process SST as draft
  • Bug #5914: AR/AP Deposit Refund Loss/Gain calculation incorrect for last deposit refund with multiple refund
  • Bug #5913: AR/AP Deposit Refund Loss/Gain calculation incorrect for last deposit refund with a payment knock off (foreign currency)
  • Fixed Cust Local - Due Document Listing - Outstanding Service Tax Grand Total TaxDue amount not correct when more then 1 page
  • Bug #5887: AR/AP Invoice Fast Entry if insert multiple invoices only the first invoice has audit trail posting, others invoices no audit trails
  • Add Check Different Between Ledger vs Aging report
  • Bug #5904: SST-02 Report tax code SVA from Sales Credit Note change back from item 13c to 13a (revert commit cac511a1)
  • Fixed Sales Invoice 11 shown double detail information
  • Reduce Column usage on FR3 Export to excel for Purchase Order format
  • Reduce Column usage on FR3 Export to excel for Purchase Cancel Note format
  • Reduce Column usage on FR3 Export to excel for Cash Purchase format
  • Reduce Column usage on FR3 Export to excel for Purchase DN format
  • Reduce Column usage on FR3 Export to excel for Purchase Request format
  • Reduce Column usage on FR3 Export to excel for Purchase Return format
  • Reduce Column usage on FR3 Export to excel for Sales Cancel Note format
  • Bug #5906: Job Order & Stock Assembly if tick Cancelled should remove "transfer from" relation
  • Bug #5891: Customer Balance Report apply with 1 year data show not responding
  • Enable Batch Email for Sales DN Format
  • Enable WhatsApp template for Sales CN Format
  • Enable Batch Email for Customer Credit Note Format
  • Enable Batch Email for Customer Debit Note Format
  • Bug #5905: DIY Script - Ledger Unable to find the component for Account lookup
  • Enable Batch Email for Customer Invoice Format
  • Bug #5901: GL Opening Balance preview report prompt access violation error

SQL Account 5.2021.907.803

Released on June 28, 2021

  • 01. Enhance, Retuning & Fixed Report
    • Remove Sales invoice 2, Sales invoice 4, Sales Invoice 8 (SST) Subtotal & Sales Invoice 9 format
    • Add Sales Invoice 10, 11 & 12 format
    • Reduce Column Usage on FR3 Export to excel for Purchase Local - Goods Received Listing (Tax 1)
    • Fixed Purchase Local - Goods Received Listing (Tax 1) should be in Listing
    • Reduce Column Usage on FR3 Export to excel for Purchase Invoice
    • Reduce Column Usage on FR3 Export to excel for Cash Sales
    • Reduce Column Usage on FR3 Export to excel for Sales CN
    • Reduce Column Usage on FR3 Export to excel for Sales DN
    • Reduce Column Usage on FR3 Export to excel for Sales DO
    • Reduce Column Usage on FR3 Export to excel for Sales Invoice
    • Reduce Column Usage on FR3 Export to excel for Sales Order
    • Reduce Column Usage on FR3 Export to excel for Sales Quotation
    • Fixed Stock Transfer (With Cost) UnitCost not match with onscreen value
    • Fixed Shopee Report format - Spelling error
    • Fixed Sales Point Listing & Statement preview error ⦁ Add GL Ledger-Forex Gain Loss Report
    • Fixed Customer Debit Note Export PDF Error
    • Fixed Customer Credit Note Export PDF error
    • Fixed Sales Order 3 (Sales Disc) batch print shown incorrectly
    • Add Stock-Assembly Listing (Unit Cost) format
    • Add Cost/Unit for Stock Assembly Report
    • Increase Calculation or O/s Amt decimal point to 8 for all Sales & Purchase Outstanding report with amt
  • 02. #5862: Account Inquiry Invoice full knock-off but still show outstanding in if select date range
  • 03. #5853: Change current Shortcut CTRL+T to CTRL+Shift+T
  • 04. #5858: Memory Leaking When using ReportObject in DIY Script
  • 05. #5868: Stock Month End balance - Update GL Stock Value should not allow to update if user do not have access right to edit Maintain Stock Value
  • 06. #5826: Supplier knock-off detail show duplicate invoice when perform undo data. AR/AP PM, CN, Refund & Contra should hide undo command from grid context menu
  • 07. #5730: AR/AP Deposit Refund add Project & Payment Project fields
  • 08. #5836: Error when stock take share folder contain non JSON files
  • 09. #5870: AR/AP Debit Note incorrect document type when post audit trail
  • 10. #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
  • 11. Adjust Lazada payment able to post reversal item
  • 12. Adjust eCommerce change "Expire Date" to "Session Expire"
  • 13. Adjust eCommerce order able to persist selection
  • 14. Feature eCommerce able to post past order to customer credit note
  • 15. Fix bug: Lazada payment did not post CN
  • 16. Fix bug: Woocommerce order incorrect item price when has discount
  • 17. Adjust eCommerce order to post credit note with FromDocKey, FromDtlKey and FromDocType
  • 18. Adjust Shopee payment posting to replace commission, service and transaction fee
  • 19. Adjust Shopee order posting to separate commission, service and transaction fee
  • 20. Adjust Lazada verify customer payment doc no with cheque no
  • 21. Adjust Lazada able to replace order
  • 22. Adjust eCommerce order will post item id to remark2
  • 23. Fix bug: Shopee did not match item id with stock item code
  • 24. Fix bug: Woocommerce order did not post voucher
  • 25. Adjust Shopee order to able to filter by date
  • 26. Fix bug: Shopee past invoice not found when knockoff payment
  • 27. Fix bug: eCommerce couldn't replace order when IV knocked off with CN
  • 28. Fix bug: Shopee refund posting adjustment
  • 29. Adjust Shopee order will not post customer refund to knockoff credit note
  • 30. Fix bug: Shopee did not fetch all return orders
  • 31. Adjust Lazada payment transaction no from DocRef4 to description
  • 32. Adjust Lazada payment able to post presales order
  • 33. Adjust Lazada order and payment able handle lost or damaged orders
  • 34. Fix bug: eCommerce showing incorrect payment no

SQL Account 5.2021.907.802

Released on May 29, 2021

  • 01. Enhance, Retuning & Fixed Report
    • Bug #5847: Customer Balance Report's Current Balance should show PM outstanding instead of 0 when Future Refund knockoff PM (within date range)
    • Fixed GL Payment Voucher - RTM format Currency Rate 1 should hide
    • Fixed GL Bank Reconciliation Report - Clear Transaction not include Opening Balance Information
  • 02. Fix bug: Woocommerce did not fetch product's variations
  • 03. Fix bug: Shopee order couldn't be posted when shipping fee charged more than item price
  • 04. Feature: Lazada setting add "Claims" item group
  • 05. Adjust: Lazada payment to use statement description as SQL description
  • 06. Feature: Lazada payment will create customer refund to knock off
  • 07. Feature: Lazada payment will amend invoice detail
  • 08. Feature: Shopee order able to replace sales invoice
  • 09. Feature: Shopee payment able to post past invoice
  • 10. Fix bug: Shopee order did not include seller coin cash back as voucher
  • 11. Fix bug: Shopee order post to Sales Quotation incorrect detail
  • 12. Fix bug: Shopee order incorrect discount amount
  • 13. Fix bug: Shopee, Lazada order refund should post only returned item
  • 14. Fix bug: Shopee order couldn't be posted when escrow amount is less than 0
  • 15. Fix bug: Lazada order will prompt error when no orders within the selected period
  • 16. Fix bug: eCommerce address filled up wrongly in invoice
  • 17. Fix bug: AutoBankRecon matched to wrong record
  • 18. Bug #5852: Year End Prompt Error "There is No Active Transaction"
  • 19. Bug #5846: GL Bank Deposit Search Form missing Mark & Clear All, Mark & Clear Selected in grid context menu
  • 20. Bug #5844: Account Inquiry Customer's Age doesn't match with AR Due Document Report
  • 21. Revert commit "Bug #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff"
  • 22. #5795: Hide RefCost columns in stock reports
  • 23. Move Stock Access Right items to Stock.AccessRight
  • 24. Feature #5839: Maintain Stock Item Browse Grid add DEFUOM_ST, DEFUOM_SL, DEFUOM_PH columns
  • 25. Bug #5830: Should allow to change header description in SO after transfer from SO to PO
  • 26. Bug #5837: Fix report transaction issue to force new transaction when using same report class (different instance) more than once
  • 27. Bug #5833: Sales Profit Estimator's Total Sales Rounding issue
  • 28. Bug #5825: AP Payment "From Deposit" label stay behind the supplier bank

SQL Account 5.2021.907.801

Released on April 28, 2021

  • 01. Upgrade Database to Version 183
    • Tunning table SY_PROFILE, ST_ITEM_BOM, AR_DN, AR_CN, AP_SD & AP_SC tables
  • 02. Enhance, Retuning & Fixed Report
    • Add Shopee 2 format
    • #5823: SST-02 Report Field 11a, 11b, 11c and B1 should include CN with SU, SU5 & SUV tax code
    • Feature #3595: GL Balance Sheet Report when drill down Customer/Supplier account should apply Sales/Purchase Ledger report accordingly
    • #5764: Job Order Listing Report master record show only when there is detail record
    • Feature #5814: Stock Transfer Listing detail grid add more columns from detail dataset
    • Feature #4701: Production Outstanding Sales Order add ItemType option to suit SO->PO case
  • 03. Feature #5736: Stock Item - BOM add Number, Description2, Description3, Remark1 & Remark2 fields
  • 04. Production JO, AS & DS load additional details from Stock Item - BOM
  • 05. Feature #5805: Stock Take module will sync data with share drive, app tethering is removed
  • 06. Feature: Lazada payment able to post past invoice
  • 07. Adjust Woocommerce order
  • 08. Fix Woocommerce product fetch time out
  • 09. Feature - Lazada auto refresh token when expires
  • 10. Fix Shopee order status "To Ship" will always post to QT
  • 11. Fix eCommerce post IV, CN, QT should overwrite the original address
  • 12. Fix Lazada will return error message from the response
  • 13. Feature: Lazada payment with same PaymentRefID with auto open bank deposit
  • 14. Fix Lazada order unable to manual map item code for certain orders
  • 15. Fix Lazada unable to post payment when all orders are posted to invoice
  • 16. Fix eCommerce grid flickering issue when posting IV
  • 17. Fix Shopee shipping fee not tally
  • 18. Add GL.Auto.BankRecon.CITIMY
  • 19. Fix auto bank recon error at RHB Bank Statement
  • 20. #5812: auto bank recon error at Alliance Bank statement
  • 21. Fix dashboard floating point error
  • 22. Adjust Dashboard UI
  • 23. #4834: Document Entries SST Tax code allow to change/leave blank where tariff code setting has set in Maintain Supplier (reverted commit 6f6aec46)
  • 24. #5831: Process SST return prompt error "Account code cannot be empty" if an invoice contains detail with tax code SV (payment basis) and SVA
  • 25. #5809: Stock Matrix not working on document entries
  • 26. #5802: GL Official Receipt didn't prompt bank reconciled warning message even already reconciled
  • 27. #5811: Maintain Stock Item's BOM SubTotal column should hide when access right "Show Cost in Stock Item Maintenance" unticked
  • 28. #5808: Available Stock Balance and Stock Reports' item JO Qtyshould show 0 if Stock Assembly's detail Qty greater than Job Order's detail Qty
  • 29. #5813: Customer Contra Entry prompt "Unable to commit inactive" error upon save
  • 30. Feature #5791: All entry forms support Edit -> Edit As New

SQL Account 5.2021.906.800

  • 01. Upgrade Database to Version 182
    • Tunning table ST_XFDTL table
  • 02. Enhance, Retuning & Fixed Report
    • Reduce Column Usage on FR3 Export to excel for Sales Local - Cash Sales Collection Report when full expand
    • Feature #5779: Purchase Price History add Master & Detail Landing Cost 1 & Landing Cost 2
    • #5782: Sales Price History data sorting inconsistent, should sort by DtlKey
    • Feature #5780: Stock Card by Qty Report enable Print Stock Control Item & Non Stock Control Item Options
    • Fixed Sales Invoice 3 (Sales Disc) not include itemcode DISC
  • 03. Adjust AddToCart add column item sku
  • 04. Adjust eCommerce Payment post cheque no
  • 05. Adjust Lazada Payment posting detail
  • 06. Fix bug: Add supplier bank account without specify bank raise error "Could not convert variant of type Null into type OleStr
  • 07. #5799: Maintain GL Account should remove Parent account from Payment Method if other bank drag under it
  • 08. Fix bug: eCommerce unable to show all products when more than 1 shops are link with SQL
  • 09. Adjust Lazada: Payment disable "Post" button if any order not posted to invoice
  • 10. Adjust Lazada: map sql item code with Shop SKU
  • 11. Fix bug: Woocommerce unable to fetch data
  • 12. Adjust eCommerce get account function
  • 13. Feature: eCommerce order able to post by project
  • 14. Feature: eCommerce order able to manual set item code and uom
  • 15. Fix bug: eCommerce will not post item when price = 0
  • 16. Adjust Shopee shipping fee when posting to invoice
  • 17. Fix bug: AutoBankRecon UOVBMY adjust data positioning
  • 18. Feature AutoBankRecon able to switch between classic and statement view
  • 19. Add AutoBankRecon PIBEMY keyword for matching PDF file
  • 20. Feature #5793: GL Bank Reconciliation Deposit records show any OR record's Description and Cheque Number
  • 21. #5768: Browse grid not focus on first row if one of the column sort by descending in last saved grid layout
  • 22. #5787: Stock Transfer Detail Table change field position for UnitPrice
  • 23. #5778: F8 Barcode form cost related UI controls should be hidden if user no right to view cost
  • 24. #5391: Unable to update GL Maintain Opening Balance if project code with /
  • 25. Fix bug: Close company profile window prompt message "You must re-logon for these changes to take effect"
  • 26. Fix bug: Lazada payment split voucher from other fee
  • 27. Fix bug: RHB Statement couldn't load when balance is negative
  • 28. Fix bug: Lazada product limit per fetch change from 100 to 50
  • 29. Fix bug: Shopee not posting CN when returned order's escrow amount > 0
  • 30. Fix bug: Lazada Seller Voucher should post as negative
  • 31. #5771: Unable to open attachment file name with special character #

SQL Account 5.2021.903.799

  • 01. Enhance, Retuning & Fixed Report
    •  #Fixed Sales Cash Sales 6 - Receipt-TM-U220 (SST) DocNo alignment problem
    • Feature #5761: GL Receipt & Payment Report add Group By Box (Project, Agent & Area)
  • 02. #5757: Bank Recon word will overlay with others when too long
  • 03. #5755: F8 Barcode's UOM lookup price column values should hide when no Show Cost access right
  • 04. Fix Bug AddToCart Format string error
  • 05. Adjust eCommerce to post customer phone to DPhone1, customer id to DocRef4
  • 06. Fixed Bug eCommerce: Credit note did not knock off when posting payment
  • 07. AR/AP PM, CN, Refund & Contra add Knockoff DocNo info for error "Knock off amount must not exceed outstanding amount"
  • 08. Fix bug: Auto bank recon PDF last record not showing

SQL Account 5.2021.901.798

  • 01. Upgrade Database to Version 181
    • Tunning table ST_ITEM_ALT table
  • 02. Enhance, Retuning & Fixed Report
    • #5742: Customer Refund listing preview prompt error "Document_CompanyBankAcc: Could not open DataSet"
    • Fixed Stock Transfter Listing Doc Amount & GrandTotal not correct
    • Fixed GL PnL - Comparison - 22C1P Total sometime not shown...
    • Fixed Sales Points-Summary alignment problem
  • 03. Fixed AddToCart License Module
  • 04. Feature #5747: Stock Item - Alternate Item add UOM field
  • 05. [GST-SG] Feature #5729: Add Partial Exemptions Tax Codes: TXRC-ESS, TXRC-N33, TXRC-RE, IM-ESS, IM-N33, IM-RE
  • 06. [GST-SG] Rename Tax Description for TX-ESS and TX-N33
  • 07. [GST-SG] Maintain Tax Description replace hardcode tax rate to %TAXRATE
  • 08. [GST-SG] Feature #5729: Add Partial Exemptions Tax Codes: TXRC-ESS, TXRC-N33, TXRC-RE, IM-ESS, IM-N33, IM-RE
  • 09. Feature #5754: AR/AP Contra auto open couple contra form upon save if couple company code is empty
  • 10. Add GL.Auto.BankRecon.UOVBMY
  • 11. Added column Recon At at auto bank recon
  • 12. #5036: GL Journal Entry form mode not working if FromDocType are CN & DN
  • 13. #5745: Different date format for PBB statement (CSV)
  • 14. #5743: Invalid numeric input error when load MAYBANK statement
  • 15. #5691: Y axis value does not represent max value in Daily Stock Inquiry

SQL Account 5.2020.897.797

  • 01. Enhance, Retuning & Fixed Report
    • Fix GL Bank Reconciliation Report - Clear Transaction should exclude cancelled document
    • Fixed Sales Local - Cash Sales Collection Report unable to shown detail information
    • #5704: GL P&L Report Net Sales & Gross Profit/(Loss) have to show out even 0
    • #5726: AR/AP Balance Report Local C/F not 0 due to incorrect local outstanding for CN
    • Fixed Cust Contra Voucher - Full format had invalid character 0 08. #5711: Auto Bank Recon - Support Maybank different statement format
  • 02. Feature #5727 : Auto Bank Recon - Add OCBC
  • 03. Fixed Shopee payment excel new format and remove Shopee payment summary
  • 4. #5702: Purchase Order bind OnGridColumnValueChanged DIY event when append detail select itemcode lookup value, focus control will jump to save button instead of next grid column
  • 05. Add E-Commerce: AddToCart
  • 06. #5732: Open GST Return generate 2016 GAF file prompt error
  • 07. #5712: SL/PH Documents click "Transfer to document" should perform access right checking
  • 09. #5714: Auto Bank Recon - PBB statement has different format
  • 10. #5707: Auto Bank Recon - HLBB statement has different format
  • 11. Fix: eCommerce flickering issue when resize forms
  • 12. #5683 Stock Balance Inquiry will halt on switching grid view when window screen resolution scaling is more than 100%

SQL Account 5.2020.897.796

  • Upgrade Database to Version 180
    • Tunning table SY_PROFILE table
  • Enhance, Retuning & Fixed Report
    • Fixed JV Description overlap when Description too long
  • #5706: GIRO button is disabled after select Supplier Payment on Supplier Document Listing when Customer/Supplier Deposit module is enabled
  • #5715: Unable to Save when Knockoff Invoice for some situation
  • Add E-Commerce: Lazada, Shopee & Woocommerce

SQL Account 5.2020.896.795

Featuring a new function in SQL Accounting, the Auto Bank Reconciliation!
 Simply load your online bank E-Statement to our SQL Accounting Bank Reconciliation and it will automatically help to pick your invoices!

  • Upgrade Database to Version 179
    • Add table AP_SI and AP_SIDTL
  • Enchance, Returning & Fixed Report
    • Add SST-02 (2020) format
    • Fixed GL Bank Reconciliation Report - Clear Transaction Record not shown when there is Posting from JE with foreign Bank
    • Remove Box 10 for GST F5 Return format
    • GL Receipt & Payment Report Prepayment Account should include transaction of Payment that transfer from AP Deposit
    • Add Supplier Deposit Listing Report
    • Enable Support Supplier Deposit for GL OR & GL PV format
  • Feature #5679: Maintain Batch support DIY Views
  • #5685: User doesn't know that scan WhatsApp QR code is required when share report via WhatsApp
  • #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
  • Feature #5701: GL Cash Book Detail & Tax ledger transaction "Description2" field should refer to CompanyName field value
  • Feature #5553: Add Supplier Deposit Entry & Report
  • Feature #5565: Stock Assembly, Disassembly & Job Order's BOM Template become blank once the document has been saved
  • GL Bank Reconciliation support Auto Bank Recon feature

SQL Account 5.2020.895.794

  • Enhance, Retuning & Fixed Report
    •  #5678: AR/AP Balance Report's Current Balance & C/F incorrect when Refund knockoff CN falls in different month
    • Fixed GL Bank Reconciliation Report - Clear Transaction not sorting
    • Fixed GL Bank Reconciliation Report - Clear Transaction Transactions not only shown once when there is Same DocNo
    • Update SST-02 (2019) Add Digital Tax Refund Calculation
    • Fixed GL PnL - Comparison - 22C1P preview error when user use - when 0 as displayformat
    • Auto Get Buying Rate from Maintain Currency when Currency Rate is 1 for GL PnL Currency report
    • Auto Get Buying Rate from Maintain Currency Currency Rate is 1 for GL BS - 3C1P-IFRS-Currency report
    • Fixed SST Listing 4-DST-02(2020) Preview Error when Tariff more the 15
  • #5653: Maintain Stock Item if have multiple UOM with rate=1, should allow to change rate if IsBase is unticked
  • #5690: Prompt access violation error when Customer/Supplier Code format is %.3s-%.0s%.4d
  • Ignore tax return checking on document if GST/SST is not started
  •  #5673 User able to access Sales Analysis by document when user did not purchase S&P module
  • Feature #5672: Stock Take sync stock item add new field - Shelf
  •  #5669: Supplier bank account lookup does not exclude inactive record

SQL Account 5.2020.894.793

  • Enhance, Retuning & Fixed Report
    • Fixed GL Ledger Detail & Summary GrandTotal for Balance should filter by PostDate
    • Add Cancelled Label for Point Canceled transaction
    • Fixed Sales Point Statement & Summary not excluding Canceled Transactions
    • Convert GL Multi - Ledger - Detail - Level 1 to FR3 format
    • Fixed GL Multi - Ledger Currency Symbol not correctly shown
    • Fix Sales Local - Cash Sales Listing - Z Report Payment amount should take P_Amount
    • Reduce file size for Stock Card & Stock Card Qty export pdf
  • #5664: AR Deposit foreign Gain posting incorrect
  • #5663: AR Deposit's Gain Lossshould post to PREPAYMENT account instead of bank account
  • #5665: AR Customer Deposit copy paste should exclude refund/forfeit detail#5662: Customer payment cdsKnockOff return empty dataset when called using BizObject
  • Tools | Inquiry add Stock Balance Inquiry

SQL Account 5.2020.893.792

  • Enhance, Retuning & Fixed Report
    • SL/PH Outstanding Document Report remove DocKey from cdsMain.IndexFieldNames to prevent error "Invalid Parameter"
    • Bug #5643: GL P&L Report prompt error when print Manufacturing Account
    • Bug #5568: SST-02 Report's Field 13 tax code SVA from Sales Credit Note should show in 13c instead in 13a
    • Add New New field Mapping for 13c for SST-02 (2019)
    • Bug #5644: GL P&L Report missing summary account (e.g Net Sales, Gross Profit) in Grid Transform
    • Fixed error when total Amount is 0 for GST Detail 3 - GST F5-(SG)
    • Fixed Customer Invoice Listing - Outstanding Service Tax incorrect Service Tax amount paid where the partial knock off
  • Feature #5617: Customer Deposit's Browse List show 2nd Company Name
  • Feature #5621: Maintain Item double click on Qty column will open Stock Card
  • Bug #5619: Document Transfer Form "Load All" label not align properly when resize form
  • Bug #5632: Print Audit Trail tick Opening Balance only no record displayed
  • Bug #5634: Customer Refund's browse grid unable to display red color for bounced document if Bounced column is hidden
  • Feature #5633: Maintain Batch support Audit Trail
  • Feature #5623: SO to PO - Allow to transfer From SO without Supplier Code & Change Supplier Code after transfer
  • Bug #5198: GL Cash Book should prompt friendly error message when bank charge account is not defined in Option and Payment Methhod
  • Fix open form slow if has hyperlink attachments. Prevent to load icon for hyperlink record
  • Bug #5639: Maintain Customer/Supplier Next Company Code shouldn't include chinese word if company name in chinese
  • Bug #5651: Invoice amount over knockoff when user open two payments and knockoff same invoice at the same time

SQL Account 5.2020.890.791

  • Fixed Customer Deposit Listing Unapplied Amount no Decimal Point
  • AR Deposit Listing sort incorrectly if has two documents same post date but different docno prefix
  • #5600: GL Cash Flow Statement should not have "THIS YEAR PROFIT/(LOSS)". Retained Earning should exclude _RB_, _RD_, _PL_, _AP_
  • #5602: Unicode character not support in GL PnL & Balance Sheet script
  • #5603: GL PnL - Prompt access violation for Sub Account selection
  • Fixed GST Detail 3 - GST-03 error preview in some cases..
  • Fixed GL Official Receipt DocAmt not Correctly shown when there is partial transfer
  • Fixed Stock Transfer More Description Overlap
  • #5572: Stock Assembly & Disassembly when load BOM raw material items auto exclude invalid item code
  • #5585: Run Analyse Data Integrity at DCF database will prompt "Tax TX is not exists in the cached list"
  • #5601: AR Payment not allow to save if customer payment amount more than the customer deposit unapplied amount
  • #5614: Stock Take - Stock adjustment doesn't show correct balance quantity (book quantity) 06. #5609: Dashboard Gearing Ratio Rounding Issue
  • #5610 Dashboard Ratio Analysis: Operating Profit should change to Net Profit
  • #5552: DIY Script - customise lookup control for Customer Payment freeze when select a row
  • #2843: Maintain GL Opening Balance support Audit Trail
  • #5592: Purchase Return should allow partial document transfer even no Partial Delivery module license
  • #5594: Stock Transfer Barcode screen (F8) select batch lookup prompt error
  • #5595: Duplicate supplier purchase and payment analysis in SQL Control Center
  • #5605: Customer Deposit forfeit should allow to select Project
  • #5588 Dashboard: Ratio Analysis title is not refresh correctly after changing working date
  • #5547: Prompt Error when posting using via COM

SQL Account 5.2020.885.789

Released on June 6, 2020

Release Notes

  • Upgrade Database to Version 178
  • Add Dashboard
  • #5529: Process SST SV with Past IV Project Code is empty
  • #5521: Points Entry Grid Caption for Code incorrect
  • #5512: Grid cell always align to right on display dpi other than 100%

SQL Account 5.2020.880.786

Released on March 6, 2020

Release Notes

  • Upgrade Database to Version 176
  • Fixed Sales & Price History Group by DocNo, Tax & Tariff shown incorrect grouping information
  • #5486: Import Serial Number with Prompt Replace Unit Price Dialog prompt error control has no parent window
  • #5494: AR Payment edit and change "From Deposit" to another deposit not update the Deposit Amount in AR Deposit
  • #5492: GL Maintain Opening Balance 2nd Description is empty
  • #5489: Customer Refund slow after choose customer code if knockoff has over 1k records
  • Feature #5427: Maintain Item Template add Location & Project fields
  • #5475: GL Cash Book - Save Prompt Error if user empty the Amount Column

SQL Account 5.2020.879.785

Released on February 1, 2020

Release Notes

  • #5391: Sales Profit Estimator should convert to customer currency when click "Update Unit Price" button
  • #5467: SL Invoice unable to posting via BizObject If Exceed Credit Limit with overridden permission
  • #5048: Should not prompt dialog if user set Overdue or Credit Limit to 0 and the user allow to override
  • #5468: Add calculator editor numeric column in GL Cash Book and Journal Entry
  • Feature #5440: Document Transfer Dialog by default filter 7 Months from target document DocDate
  • Feature #5453: AR/AP Documents browse grid add 2nd company name column
  • Feature #5437: All GL Account Lookup add 2nd Description column
  • #5457: COM client cannot capture invalid logon credential

SQL Account 5.2019.878.784

Released on December 10, 2019

Release Notes

  • #5417: GL Profit Loss & Balance Sheet - Fixed Date params show as number
  • Stock Purchase Planning (Current & Next 3 months) report file has fixed Get SQty instead of Qty for PO and SO in each months.
  • Fixed Customer CN full page formate Company Header overlaping the Company Logo
  • Fixed Discount Amount not shown when using Disc Column for Sales Invoice 3 (Sales Disc)
  • Feature #5412: Stock Transfer Listing Report add "SubTotal (Tax)" column in detail grid
  • #5413: Stock Transfer Listing "Actual Amount" should sum up for IN qty amount only
  • #5419: GL Ledger untick "Include Zero B/F with Transactions Before" should determine by LocalBalance instead of Balance field as some account has Local value but foreign value is zero
  • #5418: Supplier Analysis by Document grouping 1 level but show level 2 report on screen
  • #5421: GST-SG the box 13 should refer to net sales because box 4 has including CN in F5 return
  • #5433: AR/AP Statement's Balance not sum correctly
  • Rename SST-02 file name
  • Add Sales Local - Sales Order Listing (Tax 1)-SO2PO Report
  • Add Sales Local - Cash Sales Listing - Z Report
  • Add Sales Local - Cash Sales Collection Report
  • Add Stock Purchase Planning (Current & Next 3 months) report
  • Feature #5410: SL/PH Invoice & Cash Sales add "Transfer To Credit Note" option
  • Feature #3660: Document Entries that has payment info and has been reconciled with bank upon user click edit/delete will prompt confirmation message

SQL Account 5.2019.877.783

Released on November 12, 2019

Release Notes

  • #5359: List index out of bound error when double click GL PnL or Balance Sheet Format
  • Add GL Bank Reconciliation Report - Clear Transaction Report
  • #5395: Enable sync via USB cable using Stock Take App
  • #5403: Customer Payment Deposit Drop down unable to show Description
  • #5394: Customer Statement Report same date if got two Payment Transactions (OR) should sort by docno instead of amount
  • #5381: GL Account delete Prepayment Account raise Access Violation error