SQL Account Releases | SQL Account Releases & History updates

SQL Account Releases

SQL Account 5.2023.965.836

Released on 24 Aug 2023
Release Notes
  • Allow posting Shopee canceled order
  • Fix Shopee incorrectly posted refund variance adjustment to sales credit note
  • Database upgrade to version 193
  • #6653: Add Description2, DocNoEx and Qty fields to Asset Item data entry window
  • #6632: Asset item allow to input useful life up to 4 decimals
  • Fixed Profit & Loss with Cash Flow (Amt Exclude Tax) report Unable to show Total Cost if do not have cost Adjustment.
  • #6659: Auto Bank Recon – Bank Islam current account cash line-i statement format
  • Fixed Sales Local – Cash Sales Collection Report not including Contra amount
  • Fix TikTok does not create sales credit note for returned item in partial returned order with status completed
  • Fix Lazada posting sales credit note without reversal item price for refund order
  • Fix Lazada does not include lost claims and adjustments item charge when editing sales invoices
  • Fix Woocommerce to use item ID instead of SKU to store alternative code
  • Avoid checking for Lazada payment file using empty cheque number
  • Delete Lazada sales invoice details while retaining stock record
  • Fix Lazada merged item incorrectly
  • Adjustment to Shopee return refund variance calculation
  • Adjustment to TikTok token refresh logic
  • Fix Lazada not adding returned stock items in sales credit note
  • Fix EasyStore does not include gift voucher in sales invoice
  • #6641: Calculate Costing post duplicate stock transfer or missing documents issue in multi user network environment
  • #6393: Asset item can be imported without verifying valid asset group
  • #6640: Customer Balance Report incorrect Local C/F when Payment’s GainLoss Posting Date > DateTo
  • #6656: Sales Price History report prompt out of memory error
  • #6651: Maintain Withholding Tax allow Tax Account (DR) leave blank to follow document accounts
  • #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 04 Aug 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
  • Fix TikTok posted refund seller discount incorrectly
  • #6634: All document entries upon save prompt message if Doc Date less then 01 Jan 2000
  • #6289: Stock Transfer View Price Tag should display Unit Price based on selected customer
  • #6626: GL Cash Book split form mode click New PV but show as OR entry. Same issue happen on AR/AP DN & CN
  • #6621: Stock Card Qty report tick Include Zero Balance Transaction show incorrect result
  • Fix Stock Card Qty report data form caption
  • #6628: GL Cash Book, AR/AP Payment & Refund Forms Bank Balance label change to grey color without bold
  • #6629: AR/AP Deposit Entry add Deposit Account column in browse grid
  • #6535: Auto Bank Recon – HSBC Bank Statement new format
  • #6577: Auto Bank Recon – RHB Bank New Cambodia Statement Format
  • #6591: GL Ledger Report group by Account & Project transactions not show if untick “Include zero B/F with Transaction” option
  • #6627: GL Cash Book, AR/AP Invoice, DN & CN forms 2nd side button position wrongly when using split browse & detail form mode
  • #6613: Sales Invoice save prompt conversion date error if Region format is Thai and Start GST with United Arab Emirates Country
  • #6620: Purchase Order transfer from Sales Order Document tab’s Amount, Local Amount, Currency Code & Project are blank
  • #6624: Cash Sales & Cash Purchase unable to select Payment Method if user manually enter Doc No
  • #6616: Location lookup add Description 2 field
  • #6617: Customer Payment unable to save if using Rich Text Editor

SQL Account 5.2023.962.834

Released on 20 Jul 2023
Release Notes
  • Database upgrade to version 192
  • Feature #6603: Document attachment support cloud SQL Drive
  • #6596: Calculate Costing post duplicate stock issue and missing documents issue in multi user network environment
  • Feature #6497: Serial Number field upgrade from 30 to 50 characters
  • Show Shopee Refresh Token expiry date instead of shop authorization expiry date
  • Include seller discounts in sales credit note for TikTok refund order
  • Lazada allow posting item quantity in sales invoice even item has been returned
  • Fix Lazada does not include Reversal Promotional Charges Flexi-Combo in sales credit note
  • Fix Lazada added additional Lazcoin discount
  • Exclude empty company item code in stock take items list
  • Prevent order fetching with date to earlier than date from
  • #6598: Auto running number for Asset Item doesn’t follow Acquire Date
  • Enable support up to 4 levels for GL BS – 6C1P – FA format
  • #6611: Maintain GL Account rename account “Sales” and “Sales Adjustment” to “Revenue” and “Revenue Adjustment”
  • #6614: Supplier Deposit Grid Caption not corect
  • #6605: Entry Forms browse mode unable to view images in Rich Text Editor fields
  • #6609: GL Cash Book, AR/AP DN & CN Forms new document access right not working
  • #6601: SL/PH Invoice, DN & Cash Purchase entry forms show Outstanding Amount
  • #6599: Fix Member Point raise error : BO Class (Sales.Point.BO.UI) Not found

SQL Account 5.2023.961.833

Released on 06 Jul 2023
Release Notes
  • Remove leading space on customer statement report name
  • Feature #5522: Entry forms support access right approvalfor New, Edit and Delete buttons
  • Fixed GL BS – 6C1P – FA start date should follow financial start date
  • Fixed Sales DN FromDocNo & FromDocDate not shown for RTM format
  • Fixed GL Balance Sheet & PnL Project Comparison Total Project no line
  • Enable support both show & unshow zero balance GL Trial Balance – This Year
  • Fix Lazada does not edit sales invoice correctly during payment posting
  • Verify Lazada endpoint stored in shop account is not empty
  • Fix Lazada fetch product’s SKU variation prompt error “SKU not exist”
  • 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 24 May 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 15 May 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
  • #6525: Maintain Stock Item search Stock Category prompt access violation error
  • #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 19 Apr 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 09 Mar 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

SQL Account 5.2023.951.828

Released on 30 Jan 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 31 Dec 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
  • #6398: Supplier Bills & Payment Analysis report grid enable multi select
  • #6396: Maintain Stock Value should remain when Clone DB for Master Data Only
  • #6391: Customer Analysis By Document report when filter grid column > 0 some zero value records still show
  • #6317: Show “New Taxable” button on past invoice

SQL Account 5.2022.948.826

Released on 10 Dec 2022
Release Notes
  • Account Inquiry adjust the aging grid height
  • Database upgrade to version 190
  • [GST-SG] Support seamless filing for SG GST Return F5 & F8 submission via API
  • Add GST F5 Return-2023 format
  • Maintain User add Phone field
  • Fixed PO unit price display format not follow tools | options
  • Fixed Stock Analysis By Document – Level 1 sometime hang due to summary hight
  • Remove Voucher from Item Discount for Sales P&L By Doc – eCommerce reports
  • Fixed #6275 OR not auto select when WhatsApp
  • Add Yearly Depreciation – Group By Level 1 format
  • Fixed Seq big number for Report format with (Tax 1)
  • Fixed Asset Analysis BF not correct
  • Fixed Stock Item List Query error
  • Add Asset Disposal Listing & Asset Card (with Schedule Depreciation) report
  • Add New report format for New feature 6326
  • Enable Batch email for Cash Sales Format
  • Add Summary total for Trade debtor & Creditor for GL Ledger Level 1
  • Fixed GL Payment Voucher – Detail – Full (with other SCnPV info) display format error
  • Post TikTok credit note from payment when escrow amount is 0 and no credit note is posted for order
  • Show Lazada order with status “confirmed” under status “delivered”
  • Support TikTok V2 authorization API
  • Fix EasyStore missing order item’s ID
  • Check EasyStore’s customer’s phone number is null or not
  • Remove empty spaces in EasyStore SKU and variant ID
  • Fix Shopee not including shipping variance in credit note
  • Fix Lazada payment added marketing fee as voucher
  • Fix TikTok UpdateDate displayed incorrectly
  • Fix Shopee return refund variance calculation
  • Shopee remove Shopee coin from refund amount calculation
  • Shopee try refresh token during get or post request when invalid access token error is received
  • Fix Lazada does not include items that’s free in print order
  • #6384: SL/PH Cancelled Document not allow Transfer To Others Document
  • #6381: Fix SL & PH Document Entries UI controls at top right position not align neatly
  • Stock Available Balance change IDockSiteView.SetOnDockClientClose
  • #6325: Auto Bank Recon – UOB New Statement Format
  • #6370: Auto Bank Recon – AMBANK New Statement Format
  • Feature #6380: AR/AP Deposit Refund Entry allow COM access to set Doc No
  • #6375: Maintain Stock Item delete first record in Customer Price (that contain 3 records) cause incorrect record sequence
  • #6298: Job Order Browse Grid add Remark, Line Supervisor and Production Info columns
  • #6352: Fix location DIY Field unable to view from Browsing Screen
  • #6377: Asset item allow project rate lower than 100%
  • Feature #6376: Add Asset code auto running
  • #6373: Unable to load default or last used layout for Supplier Payment KnockOff Grid
  • #6374: Production Outstanding JO & SO negative outstanding balance (over transfered) should treat as fulfilled item
  • #6299: Auto Bank Recon Alliance Bank – Unable to load complete bank statement
  • #6368: SL/PH Document Entry Currency Rate should follow periodic currency rate if using copy and paste document
  • Feature #6326: Add GL Project Profit & Loss with Cash Flow report
  • #6364: Unable to process depreciation without fill in fixed asset acquire date
  • #6360: Document Entry Detail first record Seq shouldn’t been changed when user delete second record

SQL Account 5.2022.947.825

Released on 11 Nov 2022
Release Notes
  • Add Asset Label 80mm X 45mm format
  • Reduce Lazada fetch order limit from 100 to 50
  • #6363: AR/AP Analysis by Document report’s Payment column should be no value if the payment and bounce date are fall in the same date range.
  • Lazada combine “Other Services-Marketing Fees” and “Wrong Weight Adjustment” record into single order’s payment
  • Fix Stock Take IsValid batch number check doesn’t check for batch number with no item code bind to it
  • Lazada change payment form voucher column value type to FMTBcd
  • Fix Shopee transfer sales invoice to credit note raised transferred quantity is greater than balance quantity
  • Fix transfer sales invoice using wrong IVDTLKey value when transferring item from sales invoice
  • Allow non stock item in Shopee sales order to be transferred to sales invoice
  • Fix AddToCart export stock JSON file prompt exception when description is empty.
  • Fixed Tax & TaxRate Grouping Summary not correctly group if have mixture empty & null data
  • #6351: AP/AR Fast Entry prompt invalid class typecast error
  • #6356: Incorrect decimal place on stock card grid
  • #6353: SL/PH document entries transfer from other document the SubTotal will be incorrect if user modify SubTotal in the source document
  • GL Account Entry should check if the deleted bank/cash account’s parent is not root account before add the parent account to payment method
  • #6347: Stock Item Assembly Detail UOM lookup’s Cost column should hide if user no right to View Cost
  • #6349: Audit Trail Summary open form slow when data is large
  • #6340: Customer Payment unable to back to Browse if using Tab docking & Form Mode with Split Browse & Detail Option

SQL Account 5.2022.946.824

Released on 28 Oct 2022
Release Notes
  • Add Asset Opening vs GL Maintain Opening Balance format
  • Add Remark1,Remark2, Description2 and StockGroup Fields for MergeItemCode pipeline for Sales & Purchase Data Entry format
  • Fixed GL Ledger – Detail Reports 2nd Description not correct shown
  • #6343: Asset analysis report depreciation summary doesn’t filter by trans date
  • Fix Shopee return refund variance and reverse shipping fee calculation for partial refund credit note
  • Accept Shopee return details with status ACCEPTED instead of just REFUND_PAID status is allowed
  • Add stock item’s remark 1 and 2 fields to Stock Take import JSON file
  • Remove Lazada transaction records that does not contain paid status
  • #6339: Unable to save after paste an asset item already disposed
  • #6337: Process Date does not follow Date To on Process Depreciation window
  • #6342: Accum depreciation account wrongly posted in JV if process depreciation group by project only
  • #6285: GL Cash Book, AR/AP Payment, Refund & Deposit Listing include bounced document and show as red color in report grid
  • Feature #6338: Add AcquireDate field to Yearly Depreciation, Asset Analysis reports
  • #6288: Journal Entry – Show label out of balance if not tally
  • #6329: GL Profit & Loss Statement allow to print opening balance 1 day before System Conversion Date
  • #5480: Stock Assembly’s Show in Tree Mode dialog OK & Cancel buttons misaligned when resize the form
  • #6332: Supplier payment unchecked knockoff invoice prompt “Dynamic SQL error”
  • #6330: AR/AP Deposit Refund & Forfeit’s Agent & Area should follow Maintain Customer/Supplier by default

SQL Account 5.2022.945.823

Released on 19 Oct 2022
Release Notes
  • #6328: Document Entries prompt invalid value for field “Seq” error when insert more than 32 detail records
  • Fixed Stock Assembly-JO vs AS Variance format the variance % value to returns as 100% if JO qty is zero
  • Add Security Deposit Amt for Supp Statement 06 & 12 Mths 1 format
  • #6296: SL/PH Doc Entries search From Doc No in detail grid’s filter row raise error
  • #6274: Stock Item Assembly disable the transfer from Job Order in browse mode
  • #6323: Stock Analysis By Document report’s grouping tick Stock Group prompt error “Field Item Code Not Found”
  • Lazada payment should exclude balance transactions amount into transaction details
  • #6308: User can cancel customer credit note knockoff invoice contains SV although knockoff tax date already processed
  • #6320: Incorrect value for SQty in print outstanding production job order listing report
  • Fix TikTok does not include shipping fee in credit note for full refund order.
  • Fix Lazada does not open credit note for marketing fee payment
  • Fix TikTok combine payment information doesn’t sum up fields value
  • Support Shopee payment file in Thai language
  • Fix TikTok shipping fee not included in adjusted credit note
  • Fix TikTok credit note does not include discounted shipping fee by platform
  • Add applied Shopee coin amount per order item for partial refund calculation
  • Fix Shopee not applying shipping fee to order and fix refund variance calculation for partial refund order
  • Fix fetch product show incorrect item code when similar SKU is used across multiple item code
  • Remove buyer ship from Shopee shipping calculation and fix Shopee partial refund posted incorrect invoice and credit note.
  • Prevent Shopee payment form from editing invoice and credit note
  • Fix Shopee refund order with negative escrow amount failed to post invoice and credit note
  • Fix TikTok sent empty array to API server
  • Fix TikTok doesn’t fetch all products
  • Database upgrade to version 189
  • Fixed Check Different Between Ledger vs Aging should exclude cancelled document
  • Fixed Shown unknown value when company Logo empy for GL Official Receipt – Detail – Full report
  • Update GL Multi – Ledger – Detail – Level 1 show Currency Data if have mix currency
  • Add Fixed Asset module
  • Add report templates
  • Add license module – Fixed Asset
  • Add Asset Disposal data entry
  • Add Open Depreciation window
  • Add Depreciation Listing report
  • Add Process Depreciation window
  • Add Depreciation Processor
  • Add Asset Analysis report
  • Add Yearly Depreciation report
  • Add Asset Item data entry
  • Add Asset Group data entry
  • Add Asset module tables
  • Fix Multiple audit trail records posted after create a new stock batch record with detail batch item
  • Feature #5927: Maintain Item’s BOM grid add move up & down buttons
  • Feature #6266: GL Cash Book, AR/AP Payment, Refund, Deposit, SL/PH Order, Cash Sales and Cash Purchase add BankChargeAccount fields
  • Add BankChargeAccount field to report form
  • Add change BankChargeAccount dialog to ui form
  • Add BankChargeAccount field to data module
  • GL_CB, AR/AP Payment, Refund, Deposit, SL/PH Order, Cash Sales and Cash Purchase add BankChargeAccount fields
  • #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

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info