SQL Accounting Latest Version (v806) Date : 23 Aug 2021

SQL Account 5.2021.914.806

Released on August 23, 2021

Release Notes

• Database upgrade to version 184
• Feature #5820: ST_ITEM_ALT table upgrade AltCode from 30 to 35 characters (for E-Commerce Purpose)
• Add Email column to SY_USER table
• Add support of CTOS full report
• Add Daily Job Order Qty Listing (Group Sorted by Date) format
• #5876: PD document load remark1, remark2, description2 and description3 from item master if item BOM detail is empty
• Add Sales Invoice 8 (SST 2)-Aging format

SQL Accounting Latest Version (v805) Date : 13 Aug 2021

SQL Account 5.2021.913.805

Released on August 13, 2021

Release Notes

• 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 Accounting Latest Version (v804) Date : 09 Aug 2021

SQL Account 5.2021.912.804

Released on August 09, 2021

Release Notes

• 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 Accounting Latest Version (v803) Date : 17 July 2021

SQL Account 5.2021.911.803

Released on July 17, 2021

Release Notes

• Adjust: eCommerce order posting should overwrite tax to empty
• Fix bug: Woocommerce product fetching not complete
• Fix bug: Lazada payment did not post seller balance adjustment
• Adjust: Shopee order able to post BOM item
• Adjust Shopee order able to post status cancelled
• Adjust eCommerce order posting for shipping fee
• Adjust Shopee product to show all products at form show
• Fix bug: Lazada payment able to post reversal marketing fee
• Fix bug: Lazada payment statement has trailing spaces
• Fix bug: eCommerce post invoice should overwrite the default value of disc
• Adjust eCommerce order selection
• Adjust Lazada order able to post "To Ship" to quotation
• Adjust eCommerce payment to not default select first account
• Adjust Lazada, Shopee order to show posting order count
• Bug #5896: SL/PH Order should prompt dialog if user key in deposit amount but payment method is blank
• Feature #5895: Maintain Stock Item - BOM should enable when have BOM or eCommerce Module
• Feature #5861: Maintain Stock Item BOM grid Location field should memorize last value
• Bug #5864: View | Stock Available Balance Stock Card section rename "Available Qty" to "Qty After SO" and "Future Qty" to "Available Qty"
• Feature #5872: Add feature auto calculate bank gain/loss
• Add SST Listing 3-DTR format
• Bug #5892: Advance Credit Control - Unable to Save Cash Sales if only Set Suspend in IV
• Fixed GST Detail 3 - GST F5-(SG) missing Box 8
• #5873: Point Listing add Customer Code filtering
• Feature #5874: Point Browse Screen should enable Filter Row by default
• #5886: Label missing after change label caption in DIY script
• Reduce Column Usage on FR3 Export to excel for GL Bank Reconciliation Report
• Fixed GST Detail 3 - GST F5-(SG) Total of Boxes (1) + (2) +(3) & (6) not correctly sum
• Bug #5888: GL Cash Flow Statement Report prompt temp table key violation error when click apply
• Adjust Lazada payment posting for marketing fee
• Adjust Lazada order change all status contain 3PL to "SHIPPED"
• Adjust Shopee payment showing incorrect error message
• Adjust Shopee order to include courier in shipping fee description
• Fix bug: Shopee product should show empty status when no action
• Fixed SST-02 (2020) F16 not included the DTR amount
• #5877: Apply Sales Picking List Prompt Index error
• Enable Batch email for FR3 Sales CN
• Feature #5843: SL/PH CN prompt dialog for auto knock-off transfered invoices/cash sales/cash purchase
• Adjust Lazada payment able to post reversal item
• Adjust eCommerce change "Expire Date" to "Session Expire"
• Adjust eCommerce order able to persist selection
• Feature eCommerce able to post past order to customer credit note
• Fix bug: Lazada payment did not post CN
• Fix bug: Woocommerce order incorrect item price when has discount
• Adjust eCommerce order to post credit note with FromDocKey, FromDtlKey and FromDocType
• Adjust Shopee payment posting to replace commission, service and transaction fee
• Adjust Shopee order posting to separate commission, service and transaction fee
• Adjust Lazada verify customer payment doc no with cheque no
• Adjust Lazada able to replace order
• Adjust eCommerce order will post item id to remark2
• Fix bug: Shopee did not match item id with stock item code
• Fix bug: Woocommerce order did not post voucher
• Adjust Shopee order to able to filter by date
• Fix bug: Shopee past invoice not found when knockoff payment
• Fix bug: eCommerce couldn't replace order when IV knocked off with CN
• Fix bug: Shopee refund posting adjustment
• Adjust Shopee order will not post customer refund to knockoff credit note
• Fix bug: Shopee did not fetch all return orders
• Adjust Lazada payment transaction no from DocRef4 to description
• Adjust Lazada payment able to post presales order
• Adjust Lazada order and payment able handle lost or damaged orders
• Fix bug: eCommerce showing incorrect payment no
• Fix bug: Shopee return order fetching incomplete
• Fix bug: Woocommerce order shipping fee should be positive due to buyer pay
• Fix bug: Lazada payment statement commission not displayed
• Bug #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
• Bug #5870: AR/AP Debit Note incorrect document type when post audit trail
• Increase Calculation or O/s Amt decimal point to 8 for all Sales & Purchase Outstanding report with amt
• Fix bug #5836: Error when stock take share folder contain non JSON files
• Add Stock-Assembly Listing (Unit Cost) format
• Add Cost/Unit for Stock Assembly Report
• Add GL.Auto.BankRecon.HBMBMY
• Bug #5730: AR/AP Deposit Refund add Project & Payment Project fields
• Bug #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
• Bug #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
• Bug #5866: Year End if GL Budget has transaction, run Year End will prompt violation of Primary key error
• Fixed Customer Debit Note Export PDF Error
• Fixed Customer Credit Note Export PDF error
• Fixed Sales Order 3 (Sales Disc) batch print shown incorrectly
• #5853: Change current Shortcut CTRL+T to CTRL+Shift+T
• #5858: Memory Leaking When using ReportObject in DIY Script
• Fixed Sales Point Listing & Statement preview error
• Add GL Ledger-Forex Gain Loss Report
• Bug #5862: Account Inquiry Invoice full knock-off but still show outstanding in if select date range
• Fixed Shopee Report format - Spelling error
• 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
• Fixed Stock Transfer (With Cost) UnitCost not match with onscreen value
• Remove Sales invoice 2, Sales invoice 4, Sales Invoice 8 (SST) Subtotal & Sales Invoice 9 format
• Add Sales Invoice 10, 11 & 12 format