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
