This release brings a range of enhancements focused on transaction management, e-Invoice submission control, and auto bank reconciliation. Highlights include an improved knock-off details view, a new access right to control e-Invoice submission at the transaction level, Excel import support for past year price history, richer price history information, and a new function to rekey your Client ID and Client Secret after key renewal.
Important: This version of AutoCount Accounting will upgrade your Database Version to 2.2.98.
1. Improve Forms with Knock-Off Details to Show More Knock-Off Lines
For users with high-resolution display settings, the Knock-Off Details section may not be fully visible due to limited screen space. To improve the viewing experience, a Minimize/Expand Ribbon button has been added to the GL, AR, and AP modules. Users can minimize the ribbon to free up more screen space and display more Knock-Off lines.
- Click the Minimize button to minimize the ribbon and display more Knock-Off lines.
- Click the Expand button to restore the ribbon.
2. New Access Right to Check or Uncheck Submit e-Invoice at Transaction
A new Access Right has been added to control which users are allowed to check or uncheck the Submit e-Invoice option in e-Invoice transactions.
When a user without this access right creates or edits an e-Invoice transaction, the Submit e-Invoice option will be displayed in grey and cannot be edited. This prevents unauthorized users from changing the e-Invoice submission setting.
The new access right is available under Access Right Maintenance > e-Invoice > e-Invoice Setting > Allow to check or uncheck Submit e-Invoice.
3. Add Import Past Year Price History with Excel
A new Import from Excel function has been added to allow users to import Past Year Price History records directly from an Excel file. This enhancement allows users to import their historical price for reference after the recent change to Price History behaviour.
Example:
- Go to AutoCount Accounting Management Studio > Data Consistency > Past Year Price History Maintenance > Import Option > Import from Excel.
- Copy the past transaction from Excel and click Paste from Clipboard.
- After the import is completed successfully, the imported records will be available under Past Year Price History for further viewing and maintenance.
- These records will also be available in the Sales > Price History Report, Inquiry > Stock Item Inquiry, and the transaction’s Show Instant Info, allowing users to view their price history conveniently.
4. Enhance Show Instant Info Price History to Add “Document Company Name” Field
The Price History section in Show Instant Info has been enhanced with a new Document Company Name field. This field displays the company name stored directly in the transaction document.
This enhancement makes it easier for users to identify which company a particular item was previously sold to or purchased from. In some cases, the company name associated with the Account Number may differ from the company name entered in the transaction document, usually for Cash Sale. Previously, users needed to open the transaction document to verify the company name.
With the new Document Company Name field, users can view the company name directly from the Price History section, making it easier and faster to trace past selling or purchase prices.
5. Add Function to Rekey Client ID and Client Secret to Handle Key Renewal After Expiry
A new function has been added to allow users to rekey the Client ID and Client Secret when the existing Client Secret has expired or needs to be renewed. This allows users to update the e-Invoice credentials without having to reconfigure the e-Invoice settings from the beginning.
Example:
- Go to e-Invoice > e-Invoice License Setting > e-Invoice Status. Click Reactivate e-Invoice on AIP Server.
- Click the Reset button.
- A confirmation message will be displayed. Click Yes to proceed.
- Enter the ADMIN password when prompted.
- The success message will be displayed.
- After the reset is completed successfully, the existing Client ID and Client Secret fields will be cleared. Enter the latest Client ID and Client Secret generated under the MyInvois Portal.
6. Support to Save Different Accounting Basis Tax Type in Document
In the previous version, the system did not allow different accounting basis tax types to be saved in the same document due to tax calculation limitations. This has been enhanced to allow Accrual Basis and Payment Basis tax types to be saved in the same document.
Example: Accrual basis: S-10, Payment basis: SV-6
Create a sales invoice and select both tax codes. The system now allows the document to be saved successfully.
Under SST Instant Info, the sales tax amount will be shown after the sales invoice is created, as it is based on Accrual Basis.
After payment is made within 12 months, the service tax amount will be shown under SST Instant Info, as it is based on the Payment Basis.
This also applies to Purchase, where a supplier may bill both different tax types in one invoice — and now you can key exactly the same in AutoCount.
7. New Auto Bank Reconciliation Function (BETA)
An auto bank reconciliation feature has been added in this revision. Instead of manually ticking each transaction, users just need to load their bank statement (in PDF or CSV format) into GL > Bank Reconciliation, and the system will automatically match the transactions. This saves a significant amount of time when checking transactions against the bank statement.
This function is currently in BETA.
- Go to GL > Bank Reconciliation, create a new reconciliation for the 310-1000 Bank account.
- Click Load Statement. A download dialog will appear to download the required components for this function, followed by a notice that the feature is currently in BETA. Click Yes to proceed and select your bank statement.
- After the bank statement is loaded, the Actual Bank Statement Balance is filled in automatically. The system also automatically checks any bank transaction whose description, document date, and amount match the bank statement.
How the Matching Works
The system performs matching through a scoring system:
- Amount MUST match.
- Bank Statement Record Date must be equal to or later than the transaction date.
- Score to Match: 26 points.
- Date Score: 17–10 points for ≤ 7 days, 9–3 points for ≤ 14 days, 2 points for ≤ 30 days, 1 point for the rest.
- Cheque Number Score: 15 points if found in the cheque column, 10 points if found in the reference or description column, 0 points if the statement has one but the document doesn’t.
- Description Score: up to 10 points, depending on the percentage of words matched (common words, pure-numeric tokens, separators, and one/two-character words are excluded from scoring).
By default, Precise Matching requires the date score + cheque score + description score to reach 26 points or more to be considered a match. Unticking Precise Matching lowers the requirement to 13 points and removes the date rule.
Other Functions
1. Load Statement Option
Auto re-match statement: When enabled, any new transactions created through the Bank Reconciliation function at the bottom section after loading a statement will be reconciled automatically and reflected at the top section. Note that any manual reconciliation done at the top part will be refreshed and unticked, as it was not saved beforehand.
Use Precise Matching: Enabled by default. Unticking this option allows a more lenient matching — the requirement to match your statement and transactions becomes easier and lower, and removes the date rule requiring the statement date to be equal to or later than the transaction date.
2. Create Transaction via Bank Reconciliation (Bottom Section)
This section lists records that are found in your Bank Statement but unable to match any transactions in your AutoCount database. This could be because the transaction has not yet been created in AutoCount, or due to mistakes made when keying in transactions with wrong or missing information.
- If the transaction had not been created in AutoCount, users can create it directly from this screen. Clicking the available icons (Cash Book, Payment, Refund, Journal) automatically prompts the relevant document dialog, so there’s no need to leave the Bank Reconciliation screen.
The document description is filled in automatically by the system, based on the bank statement’s description. Users usually only need to select the correct Debtor, Creditor, or Acc No, then save.
Such selections are saved in the system (BankRule table), so if similar descriptions appear again in the future, the Debtor, Creditor, or Acc No will be automatically captured and displayed.
Once the document is created, it appears under the Bank Reconciliation’s knock-off section, and the matched entry is removed from the matching list.
3. Match
Under the Bank Reconciliation Matching section, there is a Match button.
Users can also match any transactions that already exist but that the system was unable to match for specific reasons. Clicking Match opens the Manual Matching dialog, letting the user choose the correct document.
Select the transaction and click Match — the system will complete the match and it will be reconciled in the Bank Reconciliation.
4. Combine Match
The Bank Reconciliation Matching section also includes a Combine Match button. This is useful when a single transaction recorded in the system (with the total amount) actually corresponds to two separate lines in the bank statement.
- For example, there is a Payment Voucher (PV) with the same document description as two lines in the bank statement. Select the two matching bank statement lines in the Matching section, then click Combine Match.
- The corresponding PV appears, letting the user select and match it.
Once matched, the entry appears under the Bank Reconciliation’s top section and is ready to be saved.
5. Batch Process
This function allows users to batch-create transactions based on unmatched bank records at the bottom section. To use this function, these bank records should have been created at least once, so the system knows which Debtor, Creditor, or Acc No to select (stored in the BankRule table).
With Batch Process, once a similar transaction is set up, users don’t need to recreate it again in the following month’s bank reconciliation. They simply select the relevant bank statement transactions and click the button.
Note: The Currency Code is displayed at the bottom of the form for reference, as some transactions may involve currency conversion, such as transferring from USD to MYR.
The system then generates the corresponding documents and auto-matches them.
6. Bank Rules
A Bank Rules mechanism is applied in this Auto Bank Reconciliation feature. The system remembers the following after saving a bank reconciliation:
- Any manual bank reconciliation matching.
- Any creation of documents and their details through the Auto Bank Reconciliation function.
These rules are applied the next time a similar bank statement is loaded, to achieve a better matching experience. Any documents created through this function will also have some fields, such as Acc No, filled in automatically based on past historical records, so you don’t have to select it again next time.
Limitations:
- Does not support image-type PDFs, such as a bank statement scanned into a PDF via scanner.
- Unable to recognize the source currency of a bank record. For example, if there is a transfer from another currency (USD) into an MYR bank, the statement will only show the MYR amount and details. If you use Create Transaction or Batch Process, it will only generate the payment as MYR.
8. New Function: e-Invoice Submission Summary
A new e-Invoice Submission Summary function has been added to the e-Invoice module. This summary provides users with a clear overview of the number of e-Invoice transactions that have been submitted, including the number of transactions with Valid and Invalid submission statuses.
This enhancement allows users to quickly review the e-Invoice submission status across different document types without having to check each transaction individually.
9. Enhance e-Invoice Submission Status to Add Supplier Name, Buyer Name, Subtotal, Tax, Total, and Currency
Several new columns have been added to the e-Invoice Submission Status screen, including Supplier Name, Buyer Name, Subtotal exclude Tax, Tax, Total, Currency Code, and Currency Rate.
This enhancement allows users to view this information directly on screen, without having to open each e-Invoice transaction individually.
10. Add Audit Trail Record for Triggering Company Profile Share Company Tax Information
A new Audit Trail record has been added to track when a user shares Company Tax Information via Share Company Tax Information (General Maintenance > Company Profile).
This enhancement allows users to identify who shared out the Company Tax Information, addressing this sensitive data.
11. Enhance Batch Mail to Support Email Message Template Function
The Batch Mail function in AR > Debtor Statement Report has been enhanced to support Email Message Templates. Users can create and save frequently used email messages as templates and select the required template when sending batch emails.
This reduces the need to manually enter the same email message each time and makes the batch mailing process more efficient.
Example:
- Go to AR > Debtor Statement Report, inquire the required records, and click Batch Mail. Select the required report format.
- Click the + icon to add a Statement Email Template.
- Enter the required email content. Click the Information icon to view the supported parameters for the email body, then save the template.
- In the Message section, select the saved email template to use for the batch mail.
- The saved message will appear automatically. Proceed to send the batch mail.
After the batch mail is sent successfully, the email records can be viewed in the Server Mailing List.
A Manage Template button is also available, allowing users to create, edit, and delete saved email message templates.
12. Enhance Debtor Statement When Previewing Only 1 Debtor to Capture Its Statement Email Address
The Debtor Statement function has been enhanced to automatically capture the Statement Email address maintained under Debtor Maintenance when previewing the statement for a single debtor.
When users select Send by Email (via SMTP Server) or Send by Email (MS Outlook Compatible), the system will automatically capture the debtor’s Statement Email address, rather than requiring it to be keyed in manually as in previous versions.
Example:
- Go to AR > Debtor Statement and inquire the required debtor.
- Click Preview and select the debtor statement to preview.
- Click Send by Email (via SMTP Server). The system will automatically retrieve the Statement Email address maintained under Debtor Maintenance.
- Enter the required email message and send the email. Ensure the required Email Settings have been configured beforehand.
13. Enhance Sales and Purchases Transaction Command Form to Show TIN and Identity No
The Sales and Purchase Transaction Command forms have been enhanced to support displaying TIN and Identity No (BRN/NRIC/Passport) as available columns.
Users can now add these fields to the Transaction Command form to view the debtor’s or creditor’s TIN and Identity No directly from the transaction listing. This enhancement applies to transactions in the Sales and Purchase modules, except for Purchase Request.
14. Enhance to Key ADMIN Password When Saving a Tax Entity Already Assigned in Company Profile
Tax Entity information may be accessible to users responsible for maintaining customers or suppliers. As a result, users may be able to view the company’s Tax Entity information and could accidentally modify the details.
To prevent unauthorized changes, the system now requires the ADMIN password when a user attempts to save changes to a Tax Entity that is already assigned in the Company Profile. When the user modifies the Tax Entity information and clicks Save, the system will prompt for the ADMIN password before allowing the changes to be saved.
15. Other Enhancements
Some other key highlights of this version that do not require further explanation:
- Enhance Reorder Advice Report to exclude discontinued items — prevents users from generating reorder recommendations for items the company plans to stop purchasing.
- Enhance Reorder Advice Report to consider Max Quantity when generating Purchase Order item quantity.
- Enhance Audit Trail to show Doc No when there is an override action, allowing users to easily identify the affected transaction.
- Enhance Copy as Spreadsheet to add a Classification column in Excel exports.
- Enhance Copy as Spreadsheet to add a TaxableAmt column in Excel exports.
- Enhance Transaction Range Set to support Tariff Code as a criterion.
- Optimize saving speed when multiple payments knock off a single invoice.
- Add Audit Trail record for Delete All Mails in Server Mailing List.
- Add Audit Trail record for the “New” event type when creating a Refund Deposit from AR/AP Deposit.
- Add Audit Trail record for editing Fiscal Year.
- Add Audit Trail records for Budget Maintenance.
- Add Audit Trail records for Multi-Dimensional Price Book.
- Support Withholding Tax Payment Basis in the AR/AP Payment Knock-Off function.
- Enhance e-Invoice Setting Activate e-Invoice dialog to support copying the AIP ID.
- Enhance Import Supplier e-Invoice from MyInvois Portal to retain the original transaction description.
- Enhance Import Supplier e-Invoice from MyInvois Portal so the form no longer locks when viewing a Supplier e-Invoice.
- Enhance Bonus Point Redemption Command Form to add Debtor Company Name and Member Name columns.
- Rename the access right “Can Cancel / Uncancel” to “Can Cancel”, as the Unvoid function is no longer supported.
- Enhance database size limit notification to determine the applicable limit based on the SQL Server version in use.
- Enhance Serial Number Transaction Inquiry to show Unit Price / Cost.
- Enhance Purchase Request command form right-click function to handle multiple creditors.
- Enhance Stock Assembly to show the originating Sales Order number when transferred.
- Enhance the user-defined data type size for Account Number to support up to 50 characters (previously 30).
- Enhance the message shown when generating a Consolidated e-Invoice with an empty detail line.
- Enhance Stock Item Maintenance command form to add the Main Supplier’s Company Name to the grid list.
- Enhance Credit Note to capture and update related fields when a Cash Sale Debtor and Tax Entity are selected.
- Support Purchase Request to transfer Price when converting a Purchase Request.
- Remove the Description column from Cash Sales Multi-Payment.
- Improve the Tax Entity warning message when a similar Tax Entity already exists.
- Optimize save speed for recurrence documents requiring manual processing.
- Optimize the manual recurrence saving algorithm for multiple transactions.
- Optimize Item Maintenance loading performance when many locations have a POS Price Plan set up.
- Add a Detail Discount column to the Debtor and Creditor Command Form and Listing.
- Add support for Netherlands and Timor Leste under More Countries.
- Support the Thai language at the user interface level.
- [SG] InvoiceNow Advanced Ordering — covers the full cycle of a sales and purchase process digitally.
- [SG] Enhance InvoiceNow transaction command form to default-show InvoiceNow IRAS submission status and Document UUID.
- [SG] Enhance InvoiceNow to show Business Unit at document entry when a Debtor with a Business Unit is selected.
- [SG] Enhance InvoiceNow validation for government transactions and include YourPONo when sending invoices.
- [SG] Enhance InvoiceNow transaction validation so DocDate cannot be backdated more than 7 days.
- [SG] Enhance InvoiceNow Logging to support Group Header.
- [SG] Enhance InvoiceNow Logging Reconciliation to use color-coding for easier identification of matched records.
- [PH] Increase description font size for BIR 2307 and 2306 reports for better readability.
- [PH] Add a checkbox on BIR Report 2307 and 2306 to show the issue date.
- [PH] Exclude Withholding Tax of VAT from the SAWT 1701/1702 reports where applicable.
- [PH] Support changing TIN and Tax Branch ID for Philippines tax settings.