AccountMate 7.2 for Express Release Notes

October 30, 2006

Installation File Contents

The AccountMate 7.2 for Express CD contains the following components:

Bug Fixes

Refer to the AccountMate 7.2 for SQL/Express Maintenance Release Summary under the Technical Support section of the AccountMate Business Partner Home Page.

Important Changes

New "Shipment On-Time Analysis Report" in the Sales Order Module

A new report is added to the Sales Order module which is accessed from the Sales Order Reports group in the Reports menu. The Shipment On-Time Analysis Report analyzes the shipment data by providing the Ship Date Variance which is the time elapsed (in days) from the day the order is placed (Request Date) until the order is shipped (Ship Date).

New Option to Print Company Logo and/or Name and Address on the AP and PR Check

In previous versions, the system will not print the company logo, company name and/or company address on the check. It is expected that the information are pre-printed on the check stock.

In this version release, the system is enhanced by adding the checkboxes in the AP and PR Module Setup. Users can now choose to order checks with or without the company logo, name and/or address pre-printed on it.

AP Check Compliance to the Canadian Check Requirements

AP Check is changed to comply with the latest Canadian check requirements based on the Canadian Payments Association Standard 006, which will take effect on July 1, 2007.

Print the Employee Information on Zero-Amount Checks

In previous versions, the system does not show any employee information in the printed check if the check amount is zero.

In this version release, the system is changed to show the employee information for the "Pay to the Order of" section of the check regardless of the check amount.

Customer Statement

There are a few changes in the AR Customer Statement in this version release. They are as follows:

Optimization for Recalculate Customer/Vendor Data

Recalculate Customer Data and the Recalculate Vendor Data functions have been further optimized in this version release.

Restrict Posting of AR Payments Earlier than the Original Transaction Date

In previous versions, the system accepts payments to invoices with dates earlier than the invoice date or payments from an open credit for which payment date is earlier than the open credit transaction date. Certain Accounts Receivable reports may generate balances that are difficult to understand.

In this version release, the Apply Payment function is enhanced to add validation to compare the apply date and transaction date. The system will not allow payments to be applied on a date earlier than the invoice date. The same validation applies to open credits. When open credits are applied, the apply date cannot be earlier than the invoice or open credit transactions.

Bank Reconciliation Report

There are a few discrepancies in the Bank Reconciliation Report which makes the report difficult to use for verification of data.

In this version release, the report is changed to correct the following information:
  • Record count and total amount for Deposits In-Transit and Outstanding Checks to reflect unverified bank transactions only.
  • Generate the Bank Reconciliation Report for the selected bank account regardless of the bank reconciliation status - finalized, completed, pending, or not reconciled.
Validate Bank Availability During Ship SO and Generate Invoice from Shipment

In previous versions, any bank # can be used when shipping sales orders and/or generating the AR invoices.

In this version release, the system is changed to confirm that the Available in Sales Order and Receivables settings for the bank # used in the Ship Sales Order and the Generate Invoice from Shipment is marked on the bank master record; otherwise the transaction will not be processed.

Prompt Overwrite Pay Code For Purchase Order with Multiple Line Items

In previous version releases, Create PO by Item function prompts the user to confirm if Pay Code change should affect the other line items in the Purchase Order regardless of the number of line items attached to the Purchase Order.

In this version release, the system is enhanced to suppress the message prompt if the Purchase Order has only one (1) line item. Changing the Pay Code for a Purchase Order with multiple line items will continue to bring up the message:

    Do you want to change the pay code of all line items with this vendor?
Clicking "Yes" confirms that the Pay Code change applies to all line items in the Purchase Order. Clicking "No" means that the Pay Code applies to the selected line item only.

Retain the Invoice Post Date When Amending an AP Invoice

In previous versions, accessing an AP Invoice through the Amend AP Invoice function shows the System Date as the Post Date if the invoice is paid in full through Apply Prepay.

In this version release, the system is changed so that the Post Date of the AP Invoice is retained in the Amend AP Invoice function. User will need to change the Post Date if he/she needs the Post Date to follow the System Date.

Exclude Archived Parent Items in the Bill of Materials Report

In previous versions, Bill of Materials Report will include parent items that are already archived.

In this version release, the system is changed so that archived parent items are no longer included in the Bill of Materials Report.

Editable GL Accounts for Earning Codes in the Transactions

In the previous version, the system does not allow changes on the GL Account IDs assigned to each of the earning code(s) in the following functions: Time Card/Piece Work, Apply Payroll/Payment, Post After-The-Fact Payroll, and Amend Applied Payroll.

In this version release, the system is changed to allow users to edit the GL Account IDs assigned to the earning codes when processing payroll/payment transactions. The GL Account IDs are shown in the GL distribution grid. For the Time Card/Piece Work function, the GL distribution grid is located in the Time Card Entry Tab. For the Apply Payroll/Payment, Post After-The-Fact Payroll, and Amend Applied Payroll functions, the GL Distribution Tab is added. This change allows users to use a generic earning code for multiple departments.

Include Overtime Hours in the Computation of Deductions with Rate/Work Hour Type

In the previous version, the system computes the deduction amount exclusive of the overtime hours.

In this version release, the system is enhanced to allow user to indicate whether deduction amount shall be computed inclusive or exclusive of the overtime hours. Mark the Include Overtime Hours checkbox in the Deduction Maintenance function, available only if deduction type is Rate/Work Hour, if calculation of the deduction amount on the applied payroll/payment transaction must include the overtime hours.

Prompt for Default Holiday Earning Code for Non-zero Holiday Hours

In the previous version, the system will not accrue holiday hours for employees that are not assigned a Holiday type earning code.

In this version release, the system is changed to require input of a default Holiday Earning Code when processing payroll/payment with non-zero holiday hours. The functions affected are Time Card/Piece Work, Apply Payroll, and Post After-The-Fact. If Holiday Earning Code is set up in the PR Module Setup, the system will use this value as the default Holiday Earning Code for the transactions. Employees who are not assigned a holiday type earning code will use the default earning code for accrual of holiday hours.

Worker's Comp Wages (WC Wages) Calculation for Overtime Earning Code

In the previous version, the system does not read the Exclude O/T Premium settings when calculating WC Wages for Overtime type earning code.

In this version release, the system is changed such that computation for WC Wages will depend on the Exclude O/T Premium settings of the Worker's Comp Group attached to the earning code.
  • If Exclude O/T Premium checkbox is unmarked, WC Wages is computed as overtime hours multiplied by the overtime rate.
  • If Exclude O/T Premium checkbox is marked, WC Wages is computed as overtime hours multiplied by the overtime rate, divided by the overtime factor.

Journal Entries for Accrual of Earned Sick Leave

In the previous version, the journal entries for accrual of earned sick leave are:
    DB: PR Accrual - Sick Time Expense
    CR: Accrued Payroll
In this version release, we changed the GL Account IDs for the journal entries as follows:
    DB: PR Accrual - Sick Time Expense
    CR: PR Accrual - Sick Time Liab-General

Accrue Leave Hours Up to the Maximum Leave Hours Only

In the previous version, the system uses the YTD Accumulated Leave Hours to check for accrual of the leave hours. This will cause Leave Balance to exceed the Maximum Leave Hours when during the W-2/1099 Year-End Closing, Leave Balance carries an outstanding balance while YTD Accumulated Leave Hours is reset to zero.

In this version release, the system is changed to check the Leave Balance to determine if leave hours should accrue or not. Once Leave Balance reaches the Maximum Leave Hours, Leave Balance will no longer accrue. The YTD Accumulated Leave Hours does not play any role in the accrual of the leave hours.

Default Liability and Expense GL Account ID for Paid Leave Code

In previous version, a new Paid Leave Code record gets the default Liability Account from the Wages Expense Account of the PR Module Setup while the Expense Account is assigned the Employer's PR Tax Account.

In this version release, the system is changed to assign the Liability and Expense Account in the PR Module Setup as default values for the Liability and Expense Account of a new Paid Leave Code record.

Suppress Printing of W-4 Settings on Short Format of Payroll Check Stub

In the previous version, the system prints the W-4 settings (for both federal and state) below the list of deductions on all check stubs (short or long format). The W-4 settings adds 2 extra lines in the deduction details which cause the printing to span over 2 checks if the deduction detail exceeds fourteen (14) lines. This issue applies only to checks using the short stub format (i.e., 3 ˝ inch stub).

In this version release, “Fed W/H” and “State W/H” setting information will no longer be printed on the short format of check stubs (which is the same behavior as that of Version 6.5). Only one computer check will be used for any employee with sixteen (16) or less deduction details. With this change, only the recommended long stub check format (e.g., Check 341L for laser) will continue to print the W-4 setting information.

Support User-Defined "amlogin" Password

Some environment uses the "strong password" policy for either Windows user account, SQL Server user account or both. In such cases, the AccountMate default password for the SQL Server user "amlogin" may not meet the special requirement.

In this version release, the system is enhanced to accept user-defined password for "amlogin". Create the AccountMate Setup Configuration File (AMSETUP.ACF) in the AccountMate application folder (e.g., C:\AMSQL7) with the line:

    LOGINPWD=<password>
When the AccountMate Administrator Program is launched for the first time and the program detects that the "amlogin" user is not yet created, "amlogin" is added to the user list and assigned the password defined in the AccountMate Setup Configuration File instead of the AccountMate default password.

Support Add-On Modules and Functions in the Create AccountMate Shortcut

In the previous versions, functions that do not belong to an AccountMate module will not be available for selection in the Create AccountMate Shortcut dialog box. However, functions added to an AccountMate module are included in the function list.

In this version release, the system is enhanced to allow addition of function shortcuts for non-AccountMate modules. This means that shortcuts can be created for menu options in both AccountMate and non-AccountMate modules. Non-AccountMate modules must be added into the Module Selection Table (AMMOD). Transactions, Reports, Maintenance, and Housekeeping functions that belong to these modules must be added into the Menu Option Table (AMMENU.DBF).

New Method "AfterSaveRecord" In The Form Class

A new method AfterSaveRecord is added to the Efrm class which is to be executed after a successful execution of the SaveRecord method of the Efrmtbr class. This method is used as a "hook" to isolate modification code from the standard SaveRecord code. The visual class contains no code in this new method.

Hardware/Software Requirements

Live Installation

Before installing a demo or live copy of AccountMate 7 for Express, verify that the servers and workstations meet the hardware and software requirements for installing and running AccountMate.
Note: Actual requirements may vary based on the operating system and database used in each installation. Provisions must also be made for any additional applications and files installed with AccountMate.

Recommended Hardware Configurations
 
Database Server
File Server (optional)
Workstation
Processor
Pentium 4
Pentium 4
Pentium 4
Memory
1 Gb
1 Gb
512 Mb
Hard Drive
20 GB Free Space
2 GB Free Space
2 GB Free Space

Database Server Requirements:
The database server should meet the following minimum requirements: 
Processor:
Pentium III
Memory:
512 MB
Hard Drive:
5.0 GB Free Space 
Operating System:
Windows Server 2003 Standard Edition (SP1) or
Windows Server 2003 Enterprise Edition (SP1) or
Windows 2000 Server (SP4) or
Windows 2000 Advanced Server (SP4) or
Windows Small Business Server 2003 (SP1)
Database:
Microsoft SQL Server 2005 Express Edition (SP1)**
 

**Before you install SQL Server 2005 Express Edition, you must install the .NET Framework 2.0. To download .NET Framework 2.0 and view information on other system requirements for SQL Server 2005 Express Edition, visit http://msdn.microsoft.com/vstudio/express/sql/download/.
 
File Server Requirements (Optional): 
A File Server is optional but recommended to enhance performance. You can install the AccountMate 7 for Express application on a file server and map all workstations to it, freeing up resources on the database server to obtain optimum performance on its data processing duties.

Note: Under this setup, you do not need to install the AccountMate 7 for Express application on each workstation. You only need to install the run-time library on each workstation. To do this, select the "Compact" installation type when running the program installer (AccountMate CD).

Each application server must meet the following minimum requirements:

Processor:
Pentium III
Memory:
512 MB
Hard Drive:
1.0 GB Free Space
Operating System:
Windows Server 2003 Standard Edition (SP1) or
Windows Server 2003 Enterprise Edition (SP1) or
Windows 2000 Server (SP4) or
Windows 2000 Advanced Server (SP4) or
Windows Small Business Server 2003 (SP1)
Workstation Requirements:
Each workstation that will be connected to the database server must meet the following minimum requirements:
Processor:
Pentium III
Memory:
256 MB
Hard Drive:
1.0 GB Free Space
Operating System:
Windows XP Professional (SP2)* or
Windows 2000 Professional (SP4) or
Windows Vista
*For XP SP2 users only: If you have enabled Windows Firewall, contact your IT administrator for proper configuration to enable incoming network connections.
 
Note: Please consult your AccountMate Reseller or System Administrator to confirm the optimal configuration to suit your specific needs.

Additional Software Requirements for Modification (Optional)

  • Visual FoxPro 9.0 (SP1)
  • Crystal Reports XI (SP1)
  • Microsoft SQL Server 2005 or 2000 Utilities

Installation Guide

Pre-installation Checklist

Use the following checklist as a guide when installing a live copy of AccountMate 7 for Express:
  1. Verify compliance with the System Requirements.
  2. Install Microsoft SQL Server if you have not previously done so. Be sure to select the Mixed Mode setting in order to support both SQL and NT Authentication. After installing Microsoft SQL Server, be sure to reboot the database server to start the SQL Server Service.
  3. Verify that you have administrative rights to the computer where you are installing a live copy of AccountMate 7 for Express; otherwise, the VFP run-time libraries and Crystal Report drivers in the Windows folder will not be properly registered.
  4. Exit all Windows programs before starting the installation.
Quick Install Guide
  1. Insert the AccountMate CD into your CD-ROM drive to automatically start the installation. If the installer program does not start automatically, double-click Setup.exe in the AccountMate CD to display the AccountMate Setup window.
  2. Click Next to display the License Agreement window. Read and accept the License Agreement; then, click Next to proceed.
  3. View the AccountMate 7 for Express ReadMe in the Information window; then, click Next to proceed.
  4. In the Choose Destination Location window, perform either one of these steps:

    4.1.
     
    Accept the default destination folder; or
    4.2.
     
    Select a different destination folder by clicking the Browse button to open a Choose Folder window; then, select the folder where you want the AccountMate program to be installed.

  5. Click Next to proceed to the Setup Type window. Select from the following types of installation:

    5.1.
     
    Typical - installs AccountMate program files (application) on the destination folder and the run-time library on your local workstation; recommended for Client installations that run the AccountMate program locally on each computer
    5.2.
     
    Compact - installs run-time files on your local workstation; recommended for Workstation installations that run the AccountMate program from a mapped folder on a file server
    5.3.
     
    Custom - gives users the option to enter the AccountMate product key and select the components to be installed; recommended for File Server installations

  6. If you chose Custom Setup, the installer will display the Product Key window; otherwise, proceed to step 10.
  7. In the Product Key window, enter the 25-character AccountMate Product Key that was supplied to you upon purchase of the software. If the product key you enter is invalid, the software will not be installed. If you have problems with your Product Key, contact your AccountMate Business Partner or AccountMate Customer Service.
  8. Click Next to proceed to the Select Components window.
  9. In the Select Components window, choose among the following components to install:

    9.1.
     
    Program Files - includes all AccountMate executable files that allow you to run the AccountMate program and all its functions and reports
    9.2.
     
    Administrator Program - installs the Administrator program needed to activate the AccountMate modules, create companies in AccountMate, and manage group and user access rights, among other functions
    9.3.
     
    Run-time Files - installs the Visual FoxPro, Crystal Reports and other run-time libraries necessary to run AccountMate functions and reports
    9.4.
     
    Source Code - includes all source code module files purchased. The installer will list the modules for which you purchased source code; mark the checkbox beside each module listed to install the source code files into the defined destination folder. Access to this option and the selection of modules shown will depend on the AccountMate Product Key you entered.

    NOTE: The Source Code option will not be available if you did not enter a valid Product Key or if the Product Key you entered does not include source code.

  10. Click Next to proceed to the Select Program Folder window. Accept the default or define your own program folder name.
  11. Click Next to start installation. When the installation is complete, click Finish to exit the AccountMate Setup.
  12. To create the system and sample company databases you must first launch the AccountMate Administrator program either from your desktop or the AccountMate program folder.

    12.1.
     
    Specify the name of the SQL server instance to which AccountMate will connect.
    12.2.
     
    When prompted for the supervisor password, enter the default password “go.”
    12.3.
     
    In the Select Country Tax for Sample Company window select from the drop down list the desired country tax for the sample company.
    12.4.
     
    Specify the SQL Server data directory where you want to store the AccountMate databases. Accept the default or select a different SQL data directory.
    12.5.
     
    If the SQL server is installed in another computer, specify in the Mapped as Directory field the drive letter and the shared network folder to which you mapped the physical location on the database server where the AccountMate databases will be stored. If you are physically running AccountMate at the same computer where the SQL server data directory is located, the Mapped as directory should be the same as the SQL server data directory.
    12.6.
     
    Click the Install button; when you see a message asking you to confirm whether you are ready to proceed with the installation, click Yes to start the creation of the system and sample company databases.
    12.7.
     
    When shown a message stating that the installation of the system and sample company databases is complete, click OK.

  13. In the AccountMate Administrator program, perform the following:

    13.1.
     
    Verify or enter the AccountMate Product Key and activate the modules you want to use.
    13.2.
     
    Install the License File, input the Maintenance Key and, if applicable, the PR Tax Subscription Key.
    13.3.
     
    Create your live company database(s).
    13.4.
     
    Define password policy.
    13.5.
     
    Set up groups and users, and assign access rights.

  14. Launch the AccountMate application and log in with the user name and password that you set up through the AccountMate Administrator program.

 

© Copyright 2009 AccountMate Software Corporation. All rights reserved.
AccountMate® is a registered trademark of AccountMate Software Corporation.
Site MapLegal Notices and Terms of Use • Privacy Statement • Website Feedback