SQL Accounting Latest Version (v829) Date : 09 March 2023

 

SQL Account 5.2022.953.829

Released on March 09, 2023

Release Notes

• #6469: Asset reports prompt dynamic SQL error when filtered by asset group, agent, area
• Fix Sample db load profile logo error
• Database upgrade to version 191
• #6455: Add Ref field to Customer and Supplier Bank Account datasets
• Add Ref column to AP_SUPPLIERBANKACC, AR_CUSTOMERBANKACC tables
• Add Online Approval for access right
• Add Online Approval message to access rights
• SY_User add Mobile & OpenID_Google fields
• Feature #6401: Points entry add Agent, Area and Project fields
• Points Listing add Group/Sort By, Area, Agent, Project, Company Category fields and filtering
• Sales Points entry add Area, Agent & Project fields
• SL_PT add Area, Agent & Project fields
• [GST-SG] Set SROVR tax code inactive and add DEPRECATED word to Description
• Feature #6270: Sales & Purchase DN able to transfer from QT, SO & DO and transfer to CN & Extra DO
• SL/PH document entries form (related to DN) add Debit Note document transfer actions
• SL/PH DN Entry form support document transfer and rename existing master table FromDocNo to FromDoc
• SL/PH DN tables add fields to support document transfer, add DeliveryDate field and rename existing master table FromDocNo to FromDoc
• Feature #6467: SL/PH entries browse grid add 2nd Company Name column
• Add Profit & Loss with Cash Flow (Amt Exclude Tax) format
• Fixed GL Official Receipt - Detail - Full (with other CNnOR info) Label not correct
• Update GL Ledger Level 1 - Only shown Summary total for Trade debtor & Creditor when not filter
• Change Balance Sheet Comparison - Monthly (12 Months) to print as Single Page format
• Increase width for Month & Year column for GL PnL - 13C1P-SinglePage
• Add Sales Invoice & Cash Sales Collection Report
• Fixed Customer & Supplier Listing ROC not correctly shown
• Fixed Sales Invoice 7 (GST 1) - SG Currency & TaxRate not correctly shown
• Fixed Stock Assembly-JO vs AS Variance Seq show big value
• Support TikTok new payment file format
• Fix Shopee failed to post credit note
• Fix lPaymentAmt compares failed to work properly
• Fix #6468: Auto Bank Recon - RHB Bank invalid numeric input
• #6464: Document Transfer didn't prompt error message in target doc when transfer Qty is more than source doc with zero Qty
• #6461: Cash Sales & Cash Purchase browse grid add Payment Project column
• Add sum footer to Lazada and Shopee payment's grid columns footer
• Add Delete Posted SKU option
• Document Entries add Audit Trail log for Override Credit Control
• #6458: AR/AP Payment, CN & Contra entry form upon save will check to make sure update AR/AP IV & DN Payment Amount is not negative
• Feature #6459: Add Analysis Data Integrity - Update AR/AP Invoice/Debit Note Outstanding Amount
• #6457: GL Trial Balance Period To Date column incorrect when Opening in CR & YTD in DR
• #6456: Cash Flow Forcast form UI adjustment
• #6453: Stock Analysis By Doc apply prompt integer overflow error
• #6451: Profit Estimator - Change Label Use Actual Cost to Use Actual On-Hand Cost
• #6446: Sales PnL by Doc - UnitPrice should divide by Base Qty
• #6449: Supplier CN & DN entry forms button rename caption to New CN & New DN
• #6424: Stock Card main grid add Qty column
• #6443: Maintain Stock Item become not responding when save after Copy from Item A and Paste into existing Item Code (which Customer Price has 192 records)
• #6430: Enable web-style row selection for grid view on "Bad Debt Relief" form
• #6435: Sales Order unable to change document date by pressing ENTER to the next field