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
