SQL Account Releases

• #5950: Copy to excel prompt error “Could not convert variant of type unicodestring into type currency”
• #5955: Hong Leong bank Connect First file format detail record “Recipient Reference” and “Other Payment Details” values can only contains alphanumeric characters
• Fixed Sales Invoice & Cash Sales Format 8 Title Not correct
• Fixed Ecommerce Invoice 3 Not correctly sum
• Fixed Aging value does not tally with customer aging report
• Add Stock QRCode format
• #5945: Change customer DN filter date column to date format
• Fixed Sales Cash Sales 6 – Receipt-TM-U220 (SST) Layout alignment problem
• Convert Sales Cash Sales 6 – Receipt-TM-U220 to fr3
• Fixed GL Local – Ledger – Detail – Level 2 final balance by account not correct.
• #5944: Sales Entry – Stock Matrix unable to display full word in header
• #5943: Stock Card for Purchase Returned document unit cost should include TaxAmt for General Tax only
• Fixed Sales Invoice 3 (SubTotal) Seq show 0 when only 1 item code
• #5953: Missing supplier user defined fields in purchase module datamap
• #5954: Cannot auto create OR/PV document in bank recon
• Feature #5936: Dashboard – Profit & Loss request to add in Project
• #5949: Stock Take Export CSV not fully export out
• Fixed Stock Card total rounding error
• #5958: Stock Balance Inquiry drill down raise Access violation
• #5934: Stock Month End results will duplicate if stock category code do not check case sensitive
• #5939: Job Order transfer to Stock Assembly, items’ Unit Cost should follow Job Order
• #5930: Job Order – Outstanding not deduct when transfer from SO to existing JO
• Add Cust Local – Deposit Listing – Level 1 – Tally with Balance Sheet format
• #5940: SL/PH transfer documents modify destination Qty greater than source doc didn’t prompt error message
• Feature #5947: Document Transfer dialog by default filter recent 18 months instead of 7 months
• #5956: Invoice transfer to CN should exclude account code
• Feature #5938: Add Access Right: Show cost in Item Assembly
• #5942: Add Auto Bank Recon – Ambank Islamic format
• Fix: Lazada order status changes
• Fix: Lazada payment new fee type and discount could not be posted
• Adjust: Lazada payment able to handle orders split into multiple payment
• Fix: Shopee payment return refund amount calculation
• Fix: Shopee order should not include return refund amount when posting canceled orders
• Feature: Woocommerce order able to post as cancelled invoice, post to quotation
• Adjust: eCommerce product fetching optimization

• Database upgrade to version 184
• Feature #5820: ST_ITEM_ALT table upgrade AltCode from 30 to 35 characters (for E-Commerce Purpose)
• Add Email column to SY_USER table
• Add support of CTOS full report
• Add Daily Job Order Qty Listing (Group Sorted by Date) format
• #5876: PD document load remark1, remark2, description2 and description3 from item master if item BOM detail is empty
• Add Sales Invoice 8 (SST 2)-Aging format

• Add Shopee 3 format
• Fix bug: Lazada order couldn’t post when has voucher and all products are returned
• Fix bug: Lazada order is posted when has either invoice or credit note
• Fix bug: Lazada payment will not post order with 0 released amount
• Fix bug: Lazada payment unable to delete IV due to already knockoff by CN
• Fix bug: Shopee order print amount for coin and vouchers have no decimal
• Adjust: Shopee payment show message to sync all invoice before posting
• Fixed Stock Assembly Cost/Unit not same as on Screen
• #5925: DIY OnOpen Script failed when GL Ledger report form unable to trigger Apply button click and SL Invoice Detail unable to find UDF grid column

• Adjust: Lazada order post to IV detail, update original qty at S/U Qty
• Adjust: Lazada payment posting
• Adjust: Lazada Order to append seller id when have duplicate order id
• Adjust: Shopee order posting quotation and credit note to update unit price of stock item from invoice
• Adjust: Shopee order to display “Credit Note” on column Invoice if posted to credit note
• Adjust: Shopee payment allow post only when all orders are posted
• Fix bug: eCommerce chinese characters not properly display
• Fix bug: Lazada payment past order date
• Adjust: eCommerce post IV, Cancel is needed to show correct error message
• Adjust: Lazada product fetching limit to 5
• Adjust Lazada Account: store seller id
• Adjust eCommerce order must match customer code when verifying
• Fix bug: Lazada payment does not show error message after posting
• Adjust: Lazada order able to post as cancelled order
• Adjust Lazada payment only allow to post payment when all orders posted to IV/CN
• Adjust: eCommerce order posting to tick tax inclusive if has tax set
• Adjust: eCommerce order post order time in 24 hour to DocRef1, tracking no to DocRef2
• Fix bug: Lazada order only cancel partial item qty
• Adjust: eCommerce order posting to include shipping carrier name
• Fix bug: eCommerce credit note is not past order
• Fix bug: Shopee order same item should combine to 1
• #5921: AR/AP Deposit Refund – Add Company Name and Gain/Loss summary
• #5920: AR/AP Deposit Refund – the exchange rate should allow to edit if same foreign currency in both customer and payment method
• Fixed Preview error & Reduce Column Usage on FR3 Export to excel for GST Bad Debt Relief – Purchase-Adj-InputTax & OutputTax format
• Fixed Preview error & Reduce Column Usage on FR3 Export to excel for GST Bad Debt Relief – Sales-Part C17 & C18 format
• Bug #5916: SL/PH Documents detail when change itemcode to another, the tax code will be incorrect even both itemcode set to same Tariff
• Bug #5918: Fix incorrect label name in supplier deposit
• Bug #5915: Maintain GL Account should block to add sub account if parent account has transactions in GL Budget
• Bug #5898: Maintain Stock Item delete invalid Stock Category records upon save
• Bug #5902: Year End GL Opening Balance’s Retained Earning didn’t include GL Stock Value amount if the Project only has GL Stock Value but doesn’t have transaction in ledger
• Bug #5917: Unable to edit invoice detail record description when the detail record has SV tax code after process SST as draft
• Bug #5914: AR/AP Deposit Refund Loss/Gain calculation incorrect for last deposit refund with multiple refund
• Bug #5913: AR/AP Deposit Refund Loss/Gain calculation incorrect for last deposit refund with a payment knock off (foreign currency)
• Fixed Cust Local – Due Document Listing – Outstanding Service Tax Grand Total TaxDue amount not correct when more then 1 page
• Bug #5887: AR/AP Invoice Fast Entry if insert multiple invoices only the first invoice has audit trail posting, others invoices no audit trails
• Add Check Different Between Ledger vs Aging report
• Bug #5904: SST-02 Report tax code SVA from Sales Credit Note change back from item 13c to 13a (revert commit cac511a1)
• Fixed Sales Invoice 11 shown double detail information
• Reduce Column usage on FR3 Export to excel for Purchase Order format
• Reduce Column usage on FR3 Export to excel for Purchase Cancel Note format
• Reduce Column usage on FR3 Export to excel for Cash Purchase format
• Reduce Column usage on FR3 Export to excel for Purchase DN format
• Reduce Column usage on FR3 Export to excel for Purchase Request format
• Reduce Column usage on FR3 Export to excel for Purchase Return format
• Reduce Column usage on FR3 Export to excel for Sales Cancel Note format
• Bug #5906: Job Order & Stock Assembly if tick Cancelled should remove “transfer from” relation
• Bug #5891: Customer Balance Report apply with 1 year data show not responding
• Enable Batch Email for Sales DN Format
• Enable WhatsApp template for Sales CN Format
• Enable Batch Email for Customer Credit Note Format
• Enable Batch Email for Customer Debit Note Format
• Bug #5905: DIY Script – Ledger Unable to find the component for Account lookup
• Enable Batch Email for Customer Invoice Format
• Bug #5901: GL Opening Balance preview report prompt access violation error

• Adjust: eCommerce order posting should overwrite tax to empty
• Fix bug: Woocommerce product fetching not complete
• Fix bug: Lazada payment did not post seller balance adjustment
• Adjust: Shopee order able to post BOM item
• Adjust Shopee order able to post status cancelled
• Adjust eCommerce order posting for shipping fee
• Adjust Shopee product to show all products at form show
• Fix bug: Lazada payment able to post reversal marketing fee
• Fix bug: Lazada payment statement has trailing spaces
• Fix bug: eCommerce post invoice should overwrite the default value of disc
• Adjust eCommerce order selection
• Adjust Lazada order able to post “To Ship” to quotation
• Adjust eCommerce payment to not default select first account
• Adjust Lazada, Shopee order to show posting order count
• Bug #5896: SL/PH Order should prompt dialog if user key in deposit amount but payment method is blank
• Feature #5895: Maintain Stock Item – BOM should enable when have BOM or eCommerce Module
• Feature #5861: Maintain Stock Item BOM grid Location field should memorize last value
• Bug #5864: View | Stock Available Balance Stock Card section rename “Available Qty” to “Qty After SO” and “Future Qty” to “Available Qty”
• Feature #5872: Add feature auto calculate bank gain/loss
• Add SST Listing 3-DTR format
• Bug #5892: Advance Credit Control – Unable to Save Cash Sales if only Set Suspend in IV
• Fixed GST Detail 3 – GST F5-(SG) missing Box 8
• #5873: Point Listing add Customer Code filtering
• Feature #5874: Point Browse Screen should enable Filter Row by default
• #5886: Label missing after change label caption in DIY script
• Reduce Column Usage on FR3 Export to excel for GL Bank Reconciliation Report
• Fixed GST Detail 3 – GST F5-(SG) Total of Boxes (1) + (2) +(3) & (6) not correctly sum
• Bug #5888: GL Cash Flow Statement Report prompt temp table key violation error when click apply
• Adjust Lazada payment posting for marketing fee
• Adjust Lazada order change all status contain 3PL to “SHIPPED”
• Adjust Shopee payment showing incorrect error message
• Adjust Shopee order to include courier in shipping fee description
• Fix bug: Shopee product should show empty status when no action
• Fixed SST-02 (2020) F16 not included the DTR amount
• #5877: Apply Sales Picking List Prompt Index error
• Enable Batch email for FR3 Sales CN
• Feature #5843: SL/PH CN prompt dialog for auto knock-off transfered invoices/cash sales/cash purchase
• Adjust Lazada payment able to post reversal item
• Adjust eCommerce change “Expire Date” to “Session Expire”
• Adjust eCommerce order able to persist selection
• Feature eCommerce able to post past order to customer credit note
• Fix bug: Lazada payment did not post CN
• Fix bug: Woocommerce order incorrect item price when has discount
• Adjust eCommerce order to post credit note with FromDocKey, FromDtlKey and FromDocType
• Adjust Shopee payment posting to replace commission, service and transaction fee
• Adjust Shopee order posting to separate commission, service and transaction fee
• Adjust Lazada verify customer payment doc no with cheque no
• Adjust Lazada able to replace order
• Adjust eCommerce order will post item id to remark2
• Fix bug: Shopee did not match item id with stock item code
• Fix bug: Woocommerce order did not post voucher
• Adjust Shopee order to able to filter by date
• Fix bug: Shopee past invoice not found when knockoff payment
• Fix bug: eCommerce couldn’t replace order when IV knocked off with CN
• Fix bug: Shopee refund posting adjustment
• Adjust Shopee order will not post customer refund to knockoff credit note
• Fix bug: Shopee did not fetch all return orders
• Adjust Lazada payment transaction no from DocRef4 to description
• Adjust Lazada payment able to post presales order
• Adjust Lazada order and payment able handle lost or damaged orders
• Fix bug: eCommerce showing incorrect payment no
• Fix bug: Shopee return order fetching incomplete
• Fix bug: Woocommerce order shipping fee should be positive due to buyer pay
• Fix bug: Lazada payment statement commission not displayed
• Bug #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
• Bug #5870: AR/AP Debit Note incorrect document type when post audit trail
• Increase Calculation or O/s Amt decimal point to 8 for all Sales & Purchase Outstanding report with amt
• Fix bug #5836: Error when stock take share folder contain non JSON files
• Add Stock-Assembly Listing (Unit Cost) format
• Add Cost/Unit for Stock Assembly Report
• Add GL.Auto.BankRecon.HBMBMY
• Bug #5730: AR/AP Deposit Refund add Project & Payment Project fields
• Bug #5826: Supplier knock-off detail show duplicate invoice when perform undo data. AR/AP PM, CN, Refund & Contra should hide undo command from grid context menu
• Bug #5868: Stock Month End balance – Update GL Stock Value should not allow to update if user do not have access right to edit Maintain Stock Value
• Bug #5866: Year End if GL Budget has transaction, run Year End will prompt violation of Primary key error
• Fixed Customer Debit Note Export PDF Error
• Fixed Customer Credit Note Export PDF error
• Fixed Sales Order 3 (Sales Disc) batch print shown incorrectly
• #5853: Change current Shortcut CTRL+T to CTRL+Shift+T
• #5858: Memory Leaking When using ReportObject in DIY Script
• Fixed Sales Point Listing & Statement preview error
• Add GL Ledger-Forex Gain Loss Report
• Bug #5862: Account Inquiry Invoice full knock-off but still show outstanding in if select date range
• Fixed Shopee Report format – Spelling error
• Reduce Column Usage on FR3 Export to excel for Purchase Local – Goods Received Listing (Tax 1)
• Fixed Purchase Local – Goods Received Listing (Tax 1) should be in Listing
• Fixed Stock Transfer (With Cost) UnitCost not match with onscreen value
• Remove Sales invoice 2, Sales invoice 4, Sales Invoice 8 (SST) Subtotal & Sales Invoice 9 format
• Add Sales Invoice 10, 11 & 12 format

• #5847: Customer Balance Report’s Current Balance should show PM outstanding instead of 0 when Future Refund knockoff PM (within date range)
• Fixed GL Payment Voucher – RTM format Currency Rate 1 should hide
• Fixed GL Bank Reconciliation Report – Clear Transaction not include Opening Balance Information
• Fix Woocommerce did not fetch product’s variations
• Fix Shopee order couldn’t be posted when shipping fee charged more than item price
• Feature: Lazada setting add “Claims” item group
• Adjust: Lazada payment to use statement description as SQL description
• Feature: Lazada payment will create customer refund to knock off
• Feature: Lazada payment will amend invoice detail
• Feature: Shopee order able to replace sales invoice
• Feature: Shopee payment able to post past invoice
• Fix Shopee order did not include seller coin cash back as voucher
• Fix Shopee order post to Sales Quotation incorrect detail
• Fix Shopee order incorrect discount amount
• Fix Shopee, Lazada order refund should post only returned item
• Fix Shopee order couldn’t be posted when escrow amount is less than 0
• Fix Lazada order will prompt error when no orders within the selected period
• Fix eCommerce address filled up wrongly in invoice
• Fix AutoBankRecon matched to wrong record
• #5846: GL Bank Deposit Search Form missing Mark & Clear All, Mark & Clear Selected in grid context menu
• #5833: Sales Profit Estimator’s Total Sales Rounding issue

• Upgrade Database Version 183
• Add Shopee 2 format
• #5823: SST-02 Report Field 11a, 11b, 11c and B1 should include CN with SU, SU5 & SUV tax code
• Feature #3595: GL Balance Sheet Report when drill down Customer/Supplier account should apply Sales/Purchase Ledger report accordingly
• #5764: Job Order Listing Report master record show only when there is detail record
• Feature #5814: Stock Transfer Listing detail grid add more columns from detail dataset
• Feature #4701: Production Outstanding Sales Order add ItemType option to suit SO->PO case
• Feature #5736: Stock Item – BOM add Number, Description2, Description3, Remark1 & Remark2 fields
• Feature: Lazada payment able to post past invoice
• Fix Woocommerce product fetch time out
• Feature – Lazada auto refresh token when expires
• Fix Shopee order status “To Ship” will always post to QT
• Fix eCommerce post IV, CN, QT should overwrite the original address
• Fix Lazada will return error message from the response
• Feature: Lazada payment with same PaymentRefID with auto open bank deposit
• Fix Lazada order unable to manual map item code for certain orders
• Fix Lazada unable to post payment when all orders are posted to invoice
• Fix eCommerce grid flickering issue when posting IV
• Fix Shopee shipping fee not tally
• Add GL.Auto.BankRecon.CITIMY
• Fix auto bank recon error at RHB Bank Statement
• #5812: auto bank recon error at Alliance Bank statement
• Fix dashboard floating point error
• #5831: Process SST return prompt error “Account code cannot be empty” if an invoice contains detail with tax code SV (payment basis) and SVA
• #5809: Stock Matrix not working on document entries
• #5802: GL Official Receipt didn’t prompt bank reconciled warning message even already reconciled
• #5811: Maintain Stock Item’s BOM SubTotal column should hide when access right “Show Cost in Stock Item Maintenance” unticked
• #5808: Available Stock Balance and Stock Reports’ item JO Qtyshould show 0 if Stock Assembly’s detail Qty greater than Job Order’s detail Qty
• #5813: Customer Contra Entry prompt “Unable to commit inactive” error upon save
• Feature #5791: All entry forms support Edit -> Edit As New

• Upgrade Database to Version 182
• Reduce Column Usage on FR3 Export to excel for Sales Local – Cash Sales Collection Report when full expand
• Feature #5779: Purchase Price History add Master & Detail Landing Cost 1 & Landing Cost 2
• #5782: Sales Price History data sorting inconsistent, should sort by DtlKey
• Feature #5780: Stock Card by Qty Report enable Print Stock Control Item & Non Stock Control Item Options
• Fixed Sales Invoice 3 (Sales Disc) not include itemcode DISC
• Adjust AddToCart add column item sku
• Fix bug: Add supplier bank account without specify bank raise error “Could not convert variant of type Null into type OleStr
• #5799: Maintain GL Account should remove Parent account from Payment Method if other bank drag under it
• Fix eCommerce unable to show all products when more than 1 shops are link with SQL
• Adjust Lazada: Payment disable “Post” button if any order not posted to invoice
• Adjust Lazada: map sql item code with Shop SKU
• Fix bug: Woocommerce unable to fetch data
• Feature: eCommerce order able to post by project
• Feature: eCommerce order able to manual set item code and uom
• Fix eCommerce will not post item when price = 0
• Adjust Shopee shipping fee when posting to invoice
• Fix AutoBankRecon UOVBMY adjust data positioning
• Feature AutoBankRecon able to switch between classic and statement view
• Add AutoBankRecon PIBEMY keyword for matching PDF file
• Feature #5793: GL Bank Reconciliation Deposit records show any OR record’s Description and Cheque Number
• #5768: Browse grid not focus on first row if one of the column sort by descending in last saved grid layout
• #5778: F8 Barcode form cost related UI controls should be hidden if user no right to view cost
• #5391: Unable to update GL Maintain Opening Balance if project code with /
• Fix Close company profile window prompt message “You must re-logon for these changes to take effect”
• Fix Lazada payment split voucher from other fee
• Fix RHB Statement couldn’t load when balance is negative
• Fix Lazada product limit per fetch change from 100 to 50
• Fix Shopee not posting CN when returned order’s escrow amount > 0
• Fix Lazada Seller Voucher should post as negative
• #5771: Unable to open attachment file name with special character #

• #Fixed Sales Cash Sales 6 – Receipt-TM-U220 (SST) DocNo alignment problem
• #5757: Bank Recon word will overlay with others when too long
• Adjust eCommerce to post customer phone to DPhone1, customer id to DocRef4
• Fixed Bug eCommerce: Credit note did not knock off when posting payment
• AR/AP PM, CN, Refund & Contra add Knockoff DocNo info for error “Knock off amount must not exceed outstanding amount”
• Fix bug: Auto bank recon PDF last record not showing

• Upgrade Database Version 181
• #5742: Customer Refund listing preview prompt error “Document_CompanyBankAcc: Could not open DataSet”
• Feature #5754: AR/AP Contra auto open couple contra form upon save if couple company code is empty
• Add GL.Auto.BankRecon.UOVBMY
• Added column Recon At at auto bank recon
• #5036: GL Journal Entry form mode not working if FromDocType are CN & DN
• #5745: Different date format for PBB statement (CSV)
• #5743: Invalid numeric input error when load MAYBANK statement

• Fix GL Bank Reconciliation Report – Clear Transaction should exclude cancelled document
• Fixed Sales Local – Cash Sales Collection Report unable to shown detail information
• #5704: GL P&L Report Net Sales & Gross Profit/(Loss) have to show out even 0
• #5726: AR/AP Balance Report Local C/F not 0 due to incorrect local outstanding for CN
• Fixed Cust Contra Voucher – Full format had invalid character
• Feature #5727 : Auto Bank Recon – Add OCBC
• Add E-Commerce: AddToCart
• #5711: Auto Bank Recon – Support Maybank different statement format
• #5714: Auto Bank Recon – PBB statement has different format
• #5707: Auto Bank Recon – HLBB statement has different format

• Upgrade Database Version 180
• Fixed JV Description overlap when Description too long
• #5715: Unable to Save when Knockoff Invoice for some situation
• Add E-Commerce: Lazada, Shopee & Woocommerce

• Upgrade Database Version 179
• Add SST-02 (2020) format
• GL Receipt & Payment Report Prepayment Account should include transaction of Payment that transfer from AP Deposit
• Add Supplier Deposit Listing Report
• Enable Support Supplier Deposit for GL OR & GL PV format
• Feature #5679: Maintain Batch support DIY Views
• #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
• Feature #5701: GL Cash Book Detail & Tax ledger transaction “Description2” field should refer to CompanyName field value
• Feature #5553: Add Supplier Deposit Entry & Report
• Feature #5565: Stock Assembly, Disassembly & Job Order’s BOM Template become blank once the document has been saved
• GL Bank Reconciliation support Auto Bank Recon feature

• #5678: AR/AP Balance Report’s Current Balance & C/F incorrect when Refund knockoff CN falls in different month
• Fixed GL Bank Reconciliation Report – Clear Transaction not sorting
• Fixed GL Bank Reconciliation Report – Clear Transaction Transactions not only shown once when there is Same DocNo
• Update SST-02 (2019) Add Digital Tax Refund Calculation
• Fixed GL PnL – Comparison – 22C1P preview error when user use – when 0 as displayformat
• Auto Get Buying Rate from Maintain Currency when Currency Rate is 1 for GL PnL Currency report
• Auto Get Buying Rate from Maintain Currency Currency Rate is 1 for GL BS – 3C1P-IFRS-Currency report
• Fixed SST Listing 4-DST-02(2020) Preview Error when Tariff more the 15
• #5653: Maintain Stock Item if have multiple UOM with rate=1, should allow to change rate if IsBase is unticked
• #5690: Prompt access violation error when Customer/Supplier Code format is %.3s-%.0s%.4d
• Ignore tax return checking on document if GST/SST is not started
• #5673 User able to access Sales Analysis by document when user did not purchase S&P module
• Feature #5672: Stock Take sync stock item add new field – Shelf
• #5669: Supplier bank account lookup does not exclude inactive record