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