Attendance - My Software Solutions

OOOOOOOOOOOPS! PAGE NOT FOUND

The Page You’re Looking For Does Not Exist
Let’s Get You

SQL Account Releases

SQL Account 5.2024.987.851

Released on June 18, 2024

Release Notes

Revise database upgrade script version 200 for db upgrade error in certain pc
Unknockoff TikTok credit note before editing TikTok sales invoice
Skip posting TikTok platform discount refund
Adjustment to Shopee voucher adjustment logic
Support linking with Shopee SIP account
#6896: Make TEncoding.UTF8 as default encoding using TStringList in DIY script
Database upgrade to version 201
Attachment support Database Blob storage & GL Cash Book support OCR
Add SY_BLOB table
Add OCR
Support Database Storage in External Attachment
GL_CBDTL add OCR field
Add WebApp
Add logon by QR authentication
Add customer aging format with 6 months local amount
AR and Sales modules support SQL Views
Fixed Customer/Supplier Multi Balance Listing report not error when preview
Adjustment to TikTok sales invoice editing logic
Adjustment to TikTok logic on checking platform shipping fee discount reduction
Add adjustment grid view for listing Shopee adjustment in payment file, and allow posting Shopee adjustment together with payment
Maintain Customer & Supplier support single company TIN update
#6891: Job Order transfer from Sales Order the Transfer Qty column unable to enter more than 2 decimal places
[EIV-MY] Batch TIN Update form revise MyInvois calling part to prevent memory leaks in thread
#6883: GL Receipt and Payment Report Balance B/F should based on by Project, Agent & Area filtering

SQL Account 5.2024.986.850

Released on May 28, 2024

Release Notes

Revise database upgrade script version 200 for db upgrade error in certain pc
Tin Batch Update form support user enter TIN
#6885: AR/AP Post Dated Cheque Listing Amount & LocalAmount footer summary values incorrect when filter grid
Maintain Customer & Supplier add TIN batch lookup
Company Profile, Maintain Customer & Supplier validate TIN shouldn’t raise exception if users unable to online (perform silently)
Company Profile, Maintain Customer & Supplier remove spaces for old/new BRN & TIN
Feature #5225: Production Job Order and Stock Disassembly add Show Cost access right
Remove bottom line border from TcxDBImage

SQL Account 5.2024.984.849

Released on May 17, 2024

Release Notes

Fix TikTok additional shipping fee checking logic
Remove redundant actual shipping fee entry in TikTok sales credit note
Re-enable sales invoices editing during load TikTok payment file to add in missing transaction fee and SFP service fee
Fix TikTok posted duplicated platform shipping fee discount adjustment
Fix Shopee voucher adjustment calculation for return refund
Fixed SST-02 (20240301) Draft no value
Fixed Ledger – Detail Description2 get wrong information when record is BA
Fix Database upgrade version 200 for certain db upgrade failed issue
#6877: Maintain Customer & Supplier open in Entry mode prompt access violation error
[EIV-MY] Prompt for Company Profile TIN dialog show only if is standalone startup mode
#6876: Stock Item Batch Edit form hide Classification label if company profile is not Malaysia

SQL Account 5.2024.983.848

Released on May 13, 2024

Release Notes

Database upgrade to version 200
Fix process hang when running automation server registration or unregistration
Switch rounded rectangle TShape to TSkPaintBox
Import TIN from Excel
Maintain Customer & Supplier remove GST No lookup function
[EIV-MY]: Maintain Customer & Supplier form add EIV fields
[EIV-MY]: Maintain Stock Item form add product Classification field
[EIV-MY]: Company Profile form add e-Invoice tab. Move GST & SST No fields to GST/SST tab accordingly
[SST-MY] #6861: SST Tax code “SVE” Description should include for Group J
Apply adjustment to TikTok platform shipping fee discount when actual shipping fee is lower than original shipping fee
Fix Shopee missing prorated seller voucher offset return in sales credit note
Fix TikTok calculated other fees incorrectly
Revise WooCommerce HTTP Authentication implementation
Trim returned products JSON list data by WooCommerce API
Fix TikTok posted shipping fee adjustment incorrectly
Fix TikTok incorrectly listed refund as additional shipping fee charge

SQL Account 5.2024.982.847

Released on May 8, 2024

Release Notes

Fix process hang when running automation server registration or unregistration
Add SST-02 (20240301) Format
Split Diff TaxRate for Same Tax Code for SST Listing Report
Fix Sales & Purchase 8 (SST 1) format tax rate field not correct position when have more description
Skip TikTok buyer paid shipping fee for other fees calculation
#6874: Auto Bank Recon – Fix always show bank statement have been fully matched after error raise on load statement
RHB Reflex – Fix payment method AccNo not update after link
Prompt error for Shopee escrow detail call after 10 failed attempts
Adjustment to Shopee access token refresh
Add TikTok Platform Discount Refund to sales credit note
Post separate credit note for TikTok additional actual shipping fee charge
Fix Shopee added shipping fee SST twice in printed order invoice
Added Shopee reverse shipping fee SST incorrectly in credit note
Revise TikTok orders fetch
#6869: Sales P&L by S/N report’s Cost will incorrect if same S/N IN & Out same day
Solve flicker when resize for controls hosted in TdxDockPanel and TPageControl in MDI child form.
#6870: AR Payment’s Currency Rate different with Cash Sales when user change the Currency Rate
#6868: AR/AP Balance Report’s Document_Currency pipeline is empty
SSM RegNo Lookup Form switch new and old RegNo columns position
Company Profile prompt re-login dialog when user change Country

SQL Account 5.2024.981.846

Released on April 1, 2024

Release Notes

Fixed Cust Multi – Invoice & Debit Note Listing – Level 1 (with other CNnOR Info) – Local OS Amount not shown when no Knock off Information
Add SST Listing 1-SVE6 & SVE8 reports
Fix Lazada editing sales invoice item’s UOM incorrectly
Add Shopee reverse shipping fee SST to sales credit note
Fix EasyStore posted discount incorrectly
Fix TikTok not posting non refund order with negative settlement amount incorrectly
Fix TikTok shipping fee adjustment calculation in sales credit note
#6857: SST-02A after apply prompt dynamic SQL error
[Peppol-SG] Fix Sales Invoice/CN send peppol failed prompt Access Violation error and refine error message
#6855: Asset disposal cost, accum depreciation, net book value are not updated after select an asset item
[SST-MY] #6853: Opening SST Taxable in Past Invoice on 31/12/2023 should show 6% instead of 8%
#6795: Maintain Customer & Supplier Listing report form should follow entry form’s access right setting

SQL Account 5.2024.980.845

Released on March 15, 2024

Release Notes

Database upgrade to version 199
#6832: Maintain Stock Item’s browse grid show no responding when search on Barcode column
Fix TikTok access token expiry check
Include Shopee shipping fee SST in sales order and print order invoice
Fix EasyStore calculated discount adjustment incorrectly
Fix Shopee not including shipping fee SST in sales invoice
TikTok fetch order date from payment file instead of calling API
#6848: Import payment voucher or journal entry from SQL Payroll prompt error “Access Violation”
#6826: Maintain GL Account and Opening Balance forms preview report prompt Access Violation error
#6833: Maintain Stock Value preview report raise error “RTTI objects cannot be manually destroyed by application code”
#6845: Sales Invoice Unit Price incorrect when Customer Price Tag Discount Field change from Null to empty
#6841: TCommDevice PrintFromString and PrintFromBytes does not work in script
#6839: SST IMSV Tax double entry not tally if change document date from Mar (8%) to Feb 2024 (6%)

SQL Account 5.2024.979.844

Released on March 7, 2024

Release Notes

Fix Invoke IBizApp.IsLogin prompt error “Catastrophic failure”
Add Maybank cloud banking
#6831: Document Entry forms click “Edit as New” button shouldn’t remain 6% Tax Amt on March 2024
#6834: Access violation in Show Chart
#6829: SST tax code with Tax Inclusive by default will cause Tax Amt incorrect when Sales Order Date before 01 Mar & transfer to IV for Date after 01 Mar 2024
Fix Incomplete captions of menu items under SST/GST menu
#6820: SQL Power Search prompt “Could not convert variant of type (Null) into type (OleStr)” when tick a table to search

SQL Account 5.2024.977.843

Released on February 29, 2024

Release Notes

Database upgrade to version 198
#3445: Job Order add Cancelled Date & Cancelled Qty
Auto Select Bank for Giro bank info when BankID is selected and Giro is null
#6806: Maintain Location default location should set default GL Stock Project for new database (db upgrade only)
Convert Stock Received to FR3 format
Recognize TikTok payment type “Deductions incurred by seller” as adjustment
#5558: Serial Number Qty lookup labels at the bottom not display properly
#6815: Create asset disposal prompt error “Problematic key value”

SQL Account 5.2024.976.842

Released on February 21, 2024

Release Notes

Database upgrade to version 197
[SST-MY] #6779: Update new SST Tax Rate for Malaysia SST tax codes started 2023-03-01 (SV, SVA, SU, PSV, DTR)
Disable AddToCart option
Fix TikTok not posting ARIV for past invoice
Fix Shopee return refund variance calculation
[SST-MY] Maintain Tax display new SST tax rates according to industries (effective from 1st March 2024)
Fixed Batch Print Sales Invoice 8 (SST 2) format tax rate not correctly shown
#6810: System Calculate Bank Closing not calculate after apply
#6812: Process SST Return raise access violation error when the IV (Tax: SV) have outstanding more than 1 year
#6801: Weighted Average costing for Stock Transfer IN Qty UTD Cost should be 0 when UTD Qty <=0
TikTok sales credit note doesn’t add shipping fee adjustment correctly
Use TikTok payment file “Related order ID” as order adjustment ID when payment type is “Order”
#6806: Maintain Location default location should set default GL Stock Project for new database

SQL Account 5.2024.974.841

Released on February 15, 2024

Release Notes

Database upgrade to version 196
Fix Shopee return refund variance calculation
Add TikTok shipping fee subsidy to platform shipping fee discount adjustment calculation
Add Shopee prorated coin value refund items to sales credit note and fix return refund variance calculation
Add Shopee seller protection fee claim for reverse shipping fee in sales credit note
Avoid posting TikTok platform shipping fee discount in credit note
Add TikTok SFP service fee and transaction fee to credit note if sales invoice is knocked off with credit note
Fix Shopee debug mode showing load file dialog instead of save file dialog when new debug file option is selected
Skip checking for TikTok payment’s order type when verifying post status
Fix TikTok posted shipping fee adjustment incorrectly
Add TikTok platform discount refund and actual return shipping fee to sales credit note for partial refund order
Revise posting cancelled order to sales invoice
Allow WooCommerce cancelled order to be posted as cancelled sales invoice
Fix EasyStore not including additional discount in sales invoice
Replace sales invoices in Shopee order section when verify status is “Replace”
Fix Lazada does not knockoff sales invoice with reversal item price credit note properly
Include UOM when looking for BOM sub item
Fix Lazada edited sales invoice without adjusting Lazada Bonus – LZD co-fund
Fix Lazada posted sales credit note incorrectly included Lazcoin discount
Fix Lazada posted sales credit note incorrectly for order with payment fee only
Fix TikTok posted sales credit note incorrectly for partial refund order
#6697: Asset disposal by qty
Add Qty column to FA_ITEM_PROJECT, FA_DI table; add FA_DI_PROJECT table; FA_DI table rename Project column to PaymentProject
Add Sales Picking List (Barcode) format
Add Sales Cash Sales 6 – Receipt-TM-U220 (SST)-With PM KO format
Add Customer & Supplier SBank Details Request Form (E-Payment) format
#6804: Continue pressing shortcut key on the a child form will trigger the action in other child form
#6803: Asset disposal prompt error upon save if payment method is non-payment method GL code
#6797: Maintain Stock Item, Customer & Supplier open Analysis code entry forms (e.g Stock Group, Agent, Area and etc) should check access right
#6768: Asset item status date does not change after edit the asset disposal post date
#6799: Show system conversion date value in the message “System conversion date in between depreciation date range”
Fix Audit Trail Summary form Apply button position and form enlarge to 70% of monitor screen
#6798: JV contains SV tax code is allowed to delete after process SST return
#6775: A document type can utilize document number set of other document type
#6794: Purchase Invoice, Cash Purchase & Returned Outstanding label incorrect when there are documents with same doc no
Fix Asset item detail datasets scroll to last record upon save
Fix Fixed asset test suite prompt duplicate GL account code 924-000
#6778: Application prompt error “Conversion error from string” if windows region format is Thai
[GST-SG] #6783: Singapore Maintain Tax display Tax Rate should be 9% instead of 8%
#6746: Default value for DIY field is not working

SQL Account 5.2023.973.840

Released on December 29, 2023

Release Notes

Cater damaged parcel for TikTok order
Fix Lazada edited sales invoice with unadjusted Lazada bonus amount
Fix for fetch specific shop’s products and orders
Create credit note for Lazada order with damaged item while shipping
Try to update alternative code if record inserted before
Add adjusted coin discount to Shopee order’s credit note
Fix for e-commerce account form updated settings to incorrect shop when main account is used
Fixed GL Cash Flow Statement 2 & 4 Columns format on export to excel title missing
Fixed Asset Analysis (12 Months) – Group By Level 2 mapping dataset not correct
Fixed error when description is using [] for SST Listing 3 report
Fixed Sales Local – Invoice Collection Report not including Contra Amount
#6764: Asset item depreciation schedule supports batch edit
#6680: Import asset item through batch entry window prompt “Schedule total depreciation must be equal” error
#6748: Asset analysis show zero disposal amount when filtered by asset group
#6732: Add journal entry document number to asset depreciation process
#6765: Open Depreciation Listing prompt “Access Violation” error

SQL Account 5.2023.972.839

Released on December 8, 2023

Release Notes

Database upgrade to version 195
Feature #6749: GL Bank Reconciliation add Attachment field
Feature #6752: Maintain Location add GL Stock Project field for auto post GL Stock value by project
#6760: Maintain GL Stock Value prompt “Invalid Transaction Object” error when save
#6757: AR/AP Deposit Entry once change the date from after conversion date to before conversion date the ledger transactions for detail records still exists
#6762: Rich Text Editor multi select different rows with different font size and click font size combo box prompt “” is not valid integer” error
Fixed Cust-Multi-F1-12 Mths Statement-Jun 2004, May 2004….xml error when Batch Email
Shopee fallback to individual order fetch when empty array is received from API endpoint
Fix TikTok fetch order item’s SKU info causes access violation on multi-thread execution
TikTok allow ignore cipher when get request query
Fix TikTok failed to post order with shipping fee only
#6761: Stock Transfer open barcode form (F8) search by serial number prompt access violation error
Feature #6738: SL/PH Yearly Sales Analysis add Item Desc 2, Remark 1 & Remark 2 grid columns
#6734: GL P&L report Taxation account should be positive for debit side value
#6759: Open GL Cash Book raise error “overflow error while converting a variant of type (Double) into Type (Currency)” due to a large value enter for bank charge
#6758: AR/AP Deposit Entry Deposit Acc lookup should include Other Liabilities & Other Assets deposit accounts accordingly
#6754: GL P&L Statement, Balance Sheet Statement and Trial Balance report should not auto update GL Stock Value if fall outside maintain acceptable trans date

SQL Account 5.2023.968.838

Released on October 27, 2023

Release Notes

Fix posted incorrect amount of EasyStore gift voucher to sales invoices
Enable Auto Post Reverse Unrealise GainLoss on 01 of Next Month for Customer & Supplier 06 Months Aging-GainLoss format
Reduce Level support to 3 for GL BS – 6C1P – FA format
Database upgrade to version 194
#6723: GL Balance Sheet & GL P&L reports Project Tab add Full Expand & Full Collapse options
#6707: AR/AP Deposit Entry Deposit Account lookup filter by current asset or current liabilities
Force TikTok confirmed order status to canceled for order canceled due to item not shipped out
Add prorated Shopee voucher offset return to Shopee order’s sales credit note
Fix replace as canceled sales invoices does not tick canceled checkbox
#6702: Auto Bank Recon – Ambank new deposits combined statement format
Auto Bank Recon – Fix Public Bank format capture Balance as Dr Amount
#6717: Auto Bank Recon – Add Affinmax Bank format
#6715: Purchase Invoice unable to save if cancel document with serial number and user has no right for “Allow Non-existent/Duplicate Serial Number”
#6704: Entry Form Note field should follow application default font type
#6720: Sales Entry forms open Profit Estimator form slow when costing detail table has big data
#6716: Stock Physical Worksheet & Stock Reorder Advice reports drag and drop to Stock Transfer should assign Location to From Location field
Add adjusted coin discount for Shopee sales invoice
Fix for Shopee displaying incorrect return quantity amount
Post TiktTok platform reimbursement and shipping fee compensation with the use of new TikTok payment file format
Bug fix for posting TikTok logistics reimbursement, and post TikTok sample shipping fee adjustment with the use of new TikTok payment file format
Fix TikTok posting sales invoice incorrectly
Support TikTok main account
Switch to new TikTok API (202309)
Fix Shopee posted incorrect discount amount in sales credit note
Fix Lazada post payment for order with missing item(s) and lost claim
Post TikTok logistics reimbursement adjustment with the use of new TikTok payment file format
Skip empty row in TikTok payment excel file
#6713: SL/PH CN add Access Rights for Prompt Knockoff for CN
#6672: E-Commerce forms support access rights
[GST-SG] GST SG tax rate increase to 9% start from 1/1/2024
#6714: Stock Assembly entry browse grid unable to show Asm Cost column from field chooser
#6709: Document Transfer dialog add Batch column for Sales Order ->Job Order & Job Order -> Stock Assembly
#6703: Stock Assembly & Disassembly reports add master batch, detail item & batch pipelines
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.837

Released 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