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