WHAT’S NEW IN ACCOUNTMATE 11.2 FOR SQL AND EXPRESS

Availability of Spanish and French Languages

Spanish and French languages are made available in AccountMate 11.2. This enhancement is handy for users who want to read and record transactions in Spanish or French languages; thereby giving the flexibility of having specific users or even the entire company use Spanish, French, or both languages.

Customizable Database Connection Password

AccountMate 11.2 provides the flexibility of customizing the AMLOGIN password. A new Database Connection function is added in the AccountMate Administrator program. Before you can change the current AMLOGIN password, you are required to enter the System Administrator login and password. When the default AMLOGIN password is presently used, the user may not enter the current AMLOGIN password but can proceed. When the user provides a new AMLOGIN password; the SQL Server, AMSETUP.AM file, and registry are updated to store the new password.

Ability to Assign User Access Rights rather than Require Supervisor Password in certain Functions

AccountMate 11.2 allows you to assign user access rights rather than require users to enter the Supervisor password like in the previous versions in order to access the following functions:

  • Error Log Viewer
  • Fiscal Period Table Setup
  • Data Manager
  • Company Access Lock

Not all users who need to view or send the error logs, set up the fiscal table, recalculate certain balances, release period-end closing and year-end closing lock, or lock access to certain companies have the Supervisor password; thus, this enhancement is implemented in AccountMate 11.2 to address this need. Though a Supervisor password is no longer required, data security is strengthened by restricting access to sensitive information only to authorized users. User access rights can be assigned in the AccountMate Administrator program > Setup menu > Security option > Group/User Setup function > Add User/Edit User screen. New checkboxes are added in the Add User/Edit User window, specifically the Update Fiscal Period Table checkbox under the General Ledger section as well as the Access Data Manager, Access Error Log, and Lock Company Access checkboxes under the System Manager section. Mark the checkbox(es) that correspond to the function(s) that the user is allowed to access.

New Hotkeys Facilitates More Efficient Performance of Daily Tasks

AccountMate function keys and hotkeys allow you to perform tasks more quickly than using a mouse or other input devices. This newest version has new hotkeys as follows:

  • Ctrl + P – Use this key combination to access the Change Company menu.
  • Ctrl + O – Use this key combination to access the Change Module menu.
  • Alt + F4 – Use this key combination to exit AccountMate.

Module Selection List Excludes Modules Without Menu Options

In the previous versions all AccountMate modules including those without menu options (e.g., System Manager, Customer Inventory Manager, Kitting, Lot Control, Inventory Specification, Pricing, Upsell Management, etc.) were available in the Module Selection list in the Main Menu Toolbar. In this newest version the modules that do not have menu options are available for selection only in the sample company, not in a live company.

Supports the latest SQL Server version

AccountMate 11.2 supports SQL Server 2019. For more information about the supported SQL Server versions and operating systems, refer to the Software Requirements section on the AccountMate website.

Payroll Enhancements

The Payroll module has been enhanced as follows:

Separately Track the Adjusted and Converted Paid Leave Hours from the YTD Accumulated and YTD Used Paid Leave Hours
In previous AccountMate versions the adjusted and converted paid leave hours recorded in the Convert/Adjust Unused Paid Leave function were added either to the YTD (i.e., Year-to-Date) Accumulated hours (if it is a positive adjustment) or YTD Used hours (if it is a negative adjustment or a conversion) in the employee record. YTD Accumulated hours is supposed to represent only the hours
accumulated using the normal paid leave accrual process. YTD Used hours is supposed to represent only the hours actually claimed as paid time off during payroll/payment application. Therefore, incorporating the adjusted and converted paid leave hours into the YTD Accumulated hours and YTD Used hours is misleading.

AccountMate 11.2 is enhanced to separately track from the YTD Accumulated and YTD Used hours the Adjusted and Converted paid leave hours. To do this, a read-only YTD Adj column is added in Employee Maintenance > Paid Leave tab to separately show the total paid leave hours that are adjusted or converted during the accrual year. A new column “Adjusted” is also added in Employee Paid Leave Listing.

Compliance to the National Payment Corporation’s Recent Requirements for Electronic Payment Files

In this version release the Process Transmission Files function is changed to comply with National Payment Corporation’s most recent requirement to manually upload to their website the electronic payment files.

Allows Import of Tips when Importing Timecard Data that contain Earning Hour Columns

Previous AccountMate versions allowed users to configure the import timecard data that contained the Earning Hour columns to include the employee number, transaction date, regular hours, overtime hours, holiday, leave, rate, and state; however, it excluded tips. Some companies (e.g., restaurant business) may need to import Tips that are presented as an amount, not hours, in the import data file. To address this need, this newest version release comes with an enhancement in the Import Time Card Setup that
allows users to include Tips in the time card data file for import when the import data contains the Earning Hour columns. This enhancement provides more flexibility when importing timecard data.

Option to Include Tips when validating Employee Minimum Wage

Federal law allows for tip credit towards its minimum wage obligation for tipped employees; however, some states may not allow it. Previous AccountMate versions always excluded tips when validating that the federal minimum wage requirement was met. AccountMate 11.2 adds a new checkbox “Include Tips when Validating Minimum Wage” in PR Module Setup. This enhancement addresses the companies’ need for flexibility of either including or excluding tips when validating whether the federal minimum
wage requirement is met.

Option to Filter Activity Entries shown in the Activity Detail Transaction # Search window

In AccountMate 11.2 we have taken the Activity tab feature one step further by providing the option to filter the customer or vendor activity entries that will be shown in the Activity Detail Transaction # Search window. A checkbox named Show Same Customer Records Only or Show Same Vendor Records Only, whichever is applicable, is added in the Activity Detail window. Marking the checkbox configures AccountMate to display in the Transaction # Search window only those customer or vendor activity entries that pertain to the specific customer or vendor for which the transaction or activity record is created. This enhancement makes the search
easier and faster.

Allow Copy and Paste from Excel into the AP Post Credit Card Billing Grids

AccountMate supports pasting of data copied from an Excel file into each of the two grids in the Post Credit Card Billing > Transactions tab in the Accounts Payable module. You can copy and paste from an Excel file the credit card billing transaction details for all columns in the upper grid. For the lower grid the paste action expects data for the GL Distribution Accounts and Amount columns. When preparing data in Excel, you must put the columns side-by-side in the same order as they are displayed in the grid. To copy data, open the Excel file and select the lines of data to be copied; then, right-click on the screen and select the Copy option.

In the AccountMate screen right-click anywhere on the credit card transactions grid (upper grid) or GL distribution grid
(lower grid); then, select “Paste from Excel” in the pop-up menu. When you are pasting data into the GL distribution grid, a message is displayed asking for your confirmation whether to overwrite the existing GL distribution entries; click “Yes” to replace the default distribution with the records copied from Excel. Choose “No” to keep the default distribution and add the records copied from Excel. This enhancement provides a quicker way to record credit card billing transactions and minimize data-entry mistakes.

Option to Require Bank # when Recording AP Invoice transactions

AccountMate 11.2 can now be configured to require a bank number for each AP invoice transaction being recorded. This is done by marking the new Require Bank # for AP Invoice checkbox in the Vendor Maintenance function. When this checkbox is marked, AccountMate will require a bank number upon recording AP invoices, AP prepayment invoices, deferred expense invoices, and credit card billing for the particular vendor.

When you attempt to import an AP invoice for a vendor but the import file does not contain a bank number, AccountMate will automatically use as default the bank number assigned in the vendor record. If no bank number is assigned in the vendor record, the import will fail. When you set up a template for recurring AP invoices but do not assign a bank number, you have the option to continue saving the template or not. This enhancement provides added internal control to ensure that each AP invoice recorded in AccountMate has an associated bank number.

Allows Copying of Line Items from Historical Work Orders

In versions earlier than AccountMate 11.2, users could not copy line items from work orders that had been moved to the historical tables. In this latest version release users can copy line items from any work orders regardless of whether these have been moved to history. This provides users more flexibility when creating work orders by copying information from existing ones.

Option to Print Kit Components in the Warehouse Inventory Transfer Slip

AccountMate 11.2 allows users to print on the Warehouse Inventory Transfer Slip any or all of the kit component numbers, kit component descriptions, kit component serial numbers, and/or kit component lot numbers. Marking the new option checkboxes in IC Module Setup > Printing tab and the Prt checkbox in the kit formula record configures AccountMate to print the kit components information on the Warehouse Inventory Transfer Slip. The report interface also has new options to show the transferred items serial numbers, lot numbers, and/or kit numbers on the report.

More Powerful Reporting Tools

AccountMate 11.2 introduces powerful new reports and some report enhancements as follows: Exporting and E-mailing Reports Support the XLSX (MS Excel) and DOCX (MS Word) Formats In addition to the currently supported standard file formats (i.e., XLS and .DOC) for Microsoft Excel and Word, AccountMate 11.2 supports the latest formats (i.e., XLSX and .DOCX) when exporting and emailing reports.

New Sales Transaction Report by State in the Accounts Receivable Module

The Sales Transaction Report by State provides information about the total sales amount and/or number of transactions for each state where the items are shipped. Users can elect to display on the report either all sales or only the taxable sales. Users also have the option to include on the report the sales returns. This report helps users determine whether they are required to start collecting sales tax for items shipped to a state where the company has no physical presence (i.e., out-of-state sales).

New Items Requiring Serial/Lot Numbers Report in the Inventory Control Module

The Items Requiring Serial/Lot Numbers report lists the serialized and/or lot-controlled items that do not have any serial and/or lot numbers assigned to some, if not all, of their units. This report facilitates the assignment of serial and/or lot numbers to serialized and/or lot-controlled items. There is no longer the need to waste time and resources in generating multiple reports to achieve the same purpose.

New Purchase Order Line Item Status Report in the Purchase Order Module

The Purchase Order Line Item Status Report provides information about the Purchase Order line items’ status. The report specifically shows the PO line items’ order quantities, received quantities, backorder quantities, and cancelled quantities. This report is useful in quickly analyzing the PO line items’ status thereby allowing users to efficiently make sound purchasing decisions.
Ability to Filter Paid Leave Transaction Report by Paid Leave Type The Paid Leave Transaction Report has been enhanced to give users the option to view transactions assigned with specific paid leave types (i.e., accumulated, used, adjusted, beginning balance, carry over adjustment, and/or converted paid leave types). To use this filter option, simply mark the checkbox(es) that corresponds to the paid leave type(s) assigned to the transactions that you want to view in the report. This enhancement facilitates the users’ verification of the employee leave balances and helps them focus their analysis on the specific type of paid leave transactions.

Show Pay Rate in the Applied Payroll/Payment Report and Check Register Report

Both the Applied Payroll/Payment Report and Check Register Report now show the pay rate that is used to calculate the particular earning code amount for the specified payroll transaction. This helps users verify the pay rate at quick glance.

Include Voided Transactions in the Bank Transaction Listing Report

We have added a new Include Voided Transactions checkbox to the Bank Transaction Listing Report interface. When marked, the report will include details about the voided bank transactions. This allows users to view and analyze the voided bank transactions.