Fix GL P&L & Balance Sheet report condolidate display empty database in SQL Connect, which window registry Connection.Pool is blank for normal users
#6708: SL Invoice edit save prompt error "2149900253" is not a valid integer value
#6700: Maintain Stock delete a BOM item cause invalid sequence for other BOM items
#6699: Stock Costing not calculated for old item code if edit document change to another item code
#6696: CN Transfer from Sales Invoice show "Insufficient memory for this operation" error when Invoice has 400k+ records
SQL Account 5.2023.967.837Released on September 30, 2023 Release Notes
Add QR Payment for Sales Invoice 8 (SST 2)-Aging format
Fixed Cust Local - Payment Listing - Collection Report Amount not reset when record not found
Fixed Sales DN rtm format FromDocDate show 30/12/1899
Update Job Order 1 format Remove the Unit Cost, Overhead Cost and Subtotal, Group by detail location & Add batch and signatory ie. Prepared by, Processed by
Fixed GL Local - Ledger - Detail - Level 2 Total balance by group not correct
Fixed Sales Local Invoice & Cash Sales Collection Report Grand Total not correctly map
Update Sales Invoice 8 (SST 2)-Aging for Pay only shown outstanding amt instead of docamt
Add new Asset Analysis (12 Months) - Group By Level 2
Remove net book value column and replace with gain/loss from disposal of assets in Asset Analysis
Adding Shopee order's note to document's note
Show country for Lazada, Shopee, and TikTok shops
Support linking with Lazada cross border account
Support linking with Shopee main account
Support new TikTok payment file format
Include note property for sales order and quotation
Fix Lazada payment posted refund with wrong amount
Increase number of records fetched from 250 to 500 for Lazada transaction details
Remove duplication check for Lazada transaction details
Do not post sales credit note for order that posted with canceled sales invoices
Fix TikTok HTTP request retries bug
Fix post cancelled order using option "Post As Cancelled Sales Invoice" does not tick "Cancelled" in sales invoice
Allow user to ignore Lazada payment for unposted order
Allow user to ignore Shopee payment for unposted order
Fix Shopee incorrectly posted "Product discount rebate from Shopee" in sales credit note
Fix TikTok assigned document number even document failed to post
Retry HTTP request if error code 500 Internal Server Error received
Check cell value is not empty before assigning Shopee payment header index
Allow user to select specific account(s) before fetch products
Allow user to select specific account(s) before fetch orders
Auto Bank Recon - Revise Bank Islam current account cash line-i statement format
#6575: Auto Bank Recon - Maybank Bank Statement Bank Closing not match ending balance
#6647: Auto Bank Recon - Maybank invalid numeric input for bank statement that contain gst type column
#6574: Auto Bank Recon - CIMB Bank did not auto fill Bank Statement Bank Closing balance
#6685: Stock Assembly unable to save if users no right for Allow Non-existent/Duplicate Serial Number even the Serial Number is valid
#6694: Sales Profit Loss By Document & Sales S/N Profit Loss By Document tick Cash Sales by default
View | SL/PH Price History form should focus on first record by default if user last saved grid layout sort by date descending
#6692: Rich Text Editor unable to change font type, size or color when selection text have mix Font settings (if user change to same current value of combo box)
#6686: SQL Connect unable to do Consolidation when DCF file saved in SQL Drive folder
#6642: RHB Reflex cloud banking "remark2" field is filled in as payment advice
#6681: Missing asset group, agent and area lookup on asset item batch edit window
#6683: Entry form "Edit as New" button click should prompt access denied if users don't have "New" access right
#6584: SL/PH CN right click add "Show KnockOff" option to open AR/AP CN entry form
#5738: Stock Physical Worksheet drill down open different forms based on Qty, SO Qty, PO Qty and JO Qty column's click
#6671: Add Journal No. on Asset Disposal entry window
#6674: Sales Price History report prompt Assertion failure error when tick Latest n records option
#6670: Sales Picking list report add DtlKey field
#6666: SL/PH Document Entries shouldn't allow to save if Discount contains comma
#6667: Stock Transfer unable to save if don't have the right for Allow Non-existent/Duplicate Serial Number
SQL Account 5.2023.965.836 Released on August 24, 2023 Release Notes
#6643: GL Ledger incorrect BF balance if group by Project alone. Account code should be compulsory to tick for grouping
#6645: Calculate Costing prompt "Out of Memory" error even item using Fixed Cost method
#6610: Two Good Received created at the same with same Serial Number for same item code shouldn't allow to save if access right "Allow Non-existent/Duplicate Serial Number" is unticked
#6639: Prompt error "cannot focus a disabled or invisible window" when double click on item flow document in tabbed docking mode
SQL Account 5.2023.963.835 Released on August 4, 2023 Release Notes
#6635: All SL/PH Browse grid add Billing Attention, Phone, Mobile & Fax columns
Update on HomeScreen debit credit icon
Ignore adjustment to quantity and discount when editing Lazada sales invoice
Ignore item ID when constructing Lazada post order details
Fix Lazada get transaction details with incorrect limit number
Include additional characters to be encode in Lazada API HTTP request call
Fix TikTok incorrect posting of shipping fee adjustment in sales credit note, and remove platform discount from sales credit note
Fix TikTok posted platform discount and platform promotion incorrectly
Fix Lazada fetch product's variation failed due to improper encode of seller SKU
#6560: AR/AP Payment edit & save prompt "MainDataSet: Dataset not in edit or insert mode" error
#6593: All document entries upon save prompt message if Doc Date is more than 13 months from Working Date
#6592: Stock & Production documents preview show blank after user changed posting date
#6571: GL Balance Sheet - Unable to show full for Consolidation
#6583: Document Entry remove Prompt for Cheque Number for bank if cheque no is empty
#6595: GL Profit & Loss and Balance Sheet open column properties prompt error
#6581: Sales Profit & Loss by Document & Item Margin should show in negative for CN document
#6540: Auto Bank Recon - Add RAK Bank Statement Format (CSV)
#6387: Auto Bank Recon - Add Bank Islam Statement Format (PDF)
#6582: Print BOM Listing click apply prompt access violation error when choose Chinese language
#6586: GL Ledger report make Project & Tax grid columns visible by default
#6585: Job Order with more then 600 items transfer to Stock Assembly very slow
SQL Account 5.2023.958.832 Released on May 24, 2023 Release Notes
Change new HomeScreen
#6534: Calculate Stock Costing issues in multi user environment. Stock Item has qty balance in Stock Physical Worksheet but no data in Stock Card report. Error "Cannot update erased record" occurred when perform same item costing calculation simultaneously
Improve TikTok load payment file performance
Fix TikTok failed to post partial refund order
Fix Shopee failed to post partial refund order
Fix Lazada post credit note with missing partial refund info, and Reversal Promotional Charges Vouchers not included in posted credit note
Add confirmed status to Lazada order view
Fixed GL Ledger-FOREX Gain Loss error arithmetic exception, numeric overflow. Floating point divide by zero....
[GST-SG] Open GST Return Form disable "Submit GST Return to IRAS" option for draft records
SQL Account 5.2023.957.831 Released on May 15, 2023 Release Notes
Disable invoice editing when loading TikTok payment file
Fix TikTok not posting shipping fee adjustment correctly
Fix TikTok not showing actual exception message while posting payment
Fix TikTok credit note does not apply shipping fee charges by TikTok for canceled order
Fix Woocommerce not excluding auto-draft order
Fix Lazada credit note does not knock off invoice
Fix Shopee order to include original platform discount into estimated escrow amount and invoice amount calculation
Fix TikTok not posting order with just shipping fee charge
Add Comparison - Monthly (18 Months) format for GL Profit & Loss report
Fixed PV & OR displayformat not follow option
Fixed Export to excel Account Description empty for GL BS - 4C0P format
#6531: Rename Asset Disposal to Asset Disposal/Write Off
Fix PopupControl.TaxRate inaccurate buttons position
#6526: Customer Statement with incorrect Aging info if date from is blank
#6529: Stock Card report's Merge Same Cost option by default untick
#6527: Auto Bank Recon - Auto match first same amount but different date transaction with bank statement record
Fix Bank Account Number is missing for some Supplier Payment when preview Supplier Payment Listing
#6523: Improper function on Access Right Setting for "Hide Dashboard" under View menu
#6522: Unable to process subsequent month depreciation if asset cost is negative
Feature #6385: Allow stock item to batch edit stock group
#6521: Edit & Save Invoice (Note field has value), prompt error "Could not convert variant of type (Array Byte) into type (Integer)"
#6518: Preview AR/AP Payment, payment method description is empty if the payment transfer from Deposit
#6519: View Price History - Record should always Go to first
SQL Account 5.2023.955.830 Released on April 19, 2023 Release Notes
#6512: Hide Dashboard access right should move to View instead of Inquiry
#6327: Auto Bank Recon - Match button not showing for DR amount match with Net DR when merge bank charges is checked
Remove Entry Forms "Close" button
#6088: DIY Advance Form Design's Component Palette not display fully
Change Page 2 Title to Year To Date
Fixed rounding error for Asset Opening vs GL Maintain Opening Balance report
Fixed Journal Voucher Spelling Error
Add SST-02 (2023) format
Fixed Profit & Loss with Cash Flow (Amt Exclude Tax) label not correctly shown
Support batch product map for E-Commerce product page
Fix TikTok not showing exception message when attempt to store duplicate order number
Fix AddToCart export JSON file prompt exception when product name is empty
Fix AddToCart not showing mapped item code in Order page. Removed AddToCart SKU code.
Fix TikTok not include SFP Service Fee in sales invoice, and prevent duplicate records added when editing sales invoice and credit note
Fix TikTok not including customer paid shipping fee in credit note for cancelled order
#6510: GL Ledger Purchase Invoice with same document number, but different supplier when double click will show first document
#6509: SL/PH Price History default show latest price by document type instead of oldest
#6508: Sales P&L by Document UnitPrice not follow the decimal point set at option
#6505: Sales P&L By Doc report add DocUnitPrice (original document unit price)
Feature #3882: GL Bank Deposit support Payment Voucher
#6500: Profit Estimator unit price amount different with unit price in Invoice
#6489: Add Auto Bank Recon - Standard Charted Bank Format
#6501: Year End auto post Stock Received for Serial No. Opening, set the document Description as "Opening Stock (Serial Number Items)"
SL/PH document posting to AR/AP should include Note field
#6492: Data entry form supports OnBeforeSave DIY event
Feature #6440: Stock Aging add Aging Type "Monthly (60 Months)" and quarterly support up to 5 years
#6336: Show Chart unable to close line chart after focused records
#6487: Supplier Deposit Entry New Refund & Forfeit options are missing. (Fixed commit 0948fd9c)
#6466: Purchase Invoice copy foreign doc & paste to another DB which currency code not exists. The Local Net Total field remain unchanged even after change supplier code
#6476: Customer Payment transfer from Deposit prompt "Payment Amount Cannot More Than Deposit's Unapplied Amount" error even is same amount
SQL Account 5.2023.953.829 Released on March 9, 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
#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
SQL Account 5.2023.951.828 Released on January 30, 2023 Release Notes
Fix Shopee failed to create sales credit note for refund order
Include store ID in generated Lazada payment reference ID
Fix EasyStore does not include shipping fee, item discount, and transaction fee in sales invoice
#6429: Supplier payment with invalid bank account allowed to save
#6431: Customer payment unable to unchecked knockoff service tax invoice after process draft SST return
#6423: GL Ledger report grid do not save last used layout
#6428: GL Ledger Group by Project - Balance incorrect if untick Include zero closing balance
#6413: Maintain Customer Credit Control unable to tick multiple document types when choose Chinese language
#6414: Form Mode Filter By Agent cannot work if use "Transfer To"
SQL Account 5.2022.949.827 Released on December 31, 2022 Release Notes
Add GL Trial Balance - This Month vs This Year with Opening format
Fixed Report Seq field show big figure
[GST-SG] #6410: SL/PH Document Entry Tax amount not calculated after transfered from other document between GST Transition Period 7% & 8% different tax rate
#6400: Not allow delete past depreciation if asset item is disposed on future date
Feature #6390: GL Trial Balance add Opening Balance & Period to Date column
#6404: Tools | Option | GL | Conversion Date prompt Access Violation when exit application if error occurred when save option
#6405: License Module "Special Aging" replaced by "Project Profit & Loss with Cash Flow"
#6394: Maintain Price Tag enable DIY Fields
#6402 Auto Bank Recon - OCBC Bank unable to load amount when balance overdraft
Feature #6403: GL P&L and Balance Sheet report Project Comparison tree list add header built-in menu, columns filtering and Find Panel
#6399: Alert user when try to save asset disposal record if asset depreciation is not processed up to dispose date
Change asset disposal date doesn't refresh accum depreciation
#6397: GL Trial Balance - Year To Date Retained Earning B/F incorrect when Start Date is not 1st day of month
#6315: All report grids enable Filter Row except Stock Card
#5951: Cannot focus a disabled or invisible window if split browse & detail window have ticked in form mode
#6006: SL/PH Doc Entries should clear Discount last memorized value when user edit any existing doc entry
#6318: Auto Bank Recon CIMB Bank empty result
#5142: Add Landing Cost with Currency Symbol
#6319: Exclude Deposit Account in Cash Sales Payment method
Feature #6292: Document Entry grids add Insert Row Above & Insert Row After options in context menu
Maintain Item - Adjust buttons position
#6314: Sales PnL S/N by Document report & Sales Profit Estimator S/N Cost are incorrect if a serial number has more In/Out transactions (e.g stock transfer or CN)
#6307: Apply P&L Statement with ledger information raise Error : conversion error from string "C1"
Feature #6206: Barcode (F8) Form add search item by serial number for stock qty out documents
Fix AR/AP Deposit Refund form label font height to default settings
SQL Account 5.2022.942.822 Released on September 22, 2022 Release Notes
Fix Lazada combined different date marketing fees.
Verify transaction by matching released amount to avoid mixing transaction from different account
Fix Lazada failed delivery order not canceled after shipped back to seller.
Fix Shopee failed to knockoff order's credit note without invoice.
Fix Shopee not posting credit note when escrow amount is negative and order is not canceled or returned.
Fix Shopee showing incorrect discount value.
Fix Lazada not showing expired token message.
Fix Shopee fetch cancelled order by buyer show logistic.error_param exception
Add Customer Listing - Credit Control format
Fixed GL OR & PV Amount not Including TaxAmt
Fixed OR & PV batch print for RTM format not correct shown Amount
Add Supp Local - Deposit Listing - Level 1 - Tally with Balance Sheet format