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