The AccountMate 7.2 for SQL CD contains the following components:
AccountMate 7.2 for SQL Program Files
Microsoft Visual FoxPro 9.0 (Service Pack 1) Runtime Files
Seagate Crystal Reports XI (Service Pack 1) Runtime Files
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.
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
Print Company Logo
Print Company Name and Address
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:
Gather data from the current tables only when processing current statement. Customer Statement
is considered current if the Last Statement Date is no earlier than the current period's Begin
Date and the Cut-off Date is on or before the current period's End Date.
Show a " ( Balance Forwarded ) " detail in the Invoice section of the Customer Statement if the
customer has an outstanding invoices as of the Last Statement Date and if Statement settings in the
Customer Maintenance function is set to Print Balance Forward instead of Print Open Item.
Display the applied discounts, adjustments and write-offs in the Payment section of the report.
For consolidated statement, the total balance should reflect the balance for both parent account
and subsidiary account(s).
Generate the consolidated statement regardless if transaction does not exist for the parent
account as long as transactions are recorded for the subsidiary account.
"Each Subsidiary on New Page" setting should apply to consolidated statements only and only if
the same section (i.e., Invoice, Payments, and Refunds) consists of transactions that belong to two
or more customer records.
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
Before installing a demo
or live copy of AccountMate 7 for SQL, 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.
Live Installation
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:
CPU:
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 Standard Edition (SP1) or
Microsoft SQL Server 2005 Enterprise Edition (SP1) or
Microsoft SQL Server 2005 Workgroup Edition (SP1) or
Microsoft SQL Server 2005 Express Edition (SP1) or
Microsoft SQL Server 2000 Standard Edition (SP4) or
Microsoft SQL Server 2000 Enterprise Edition (SP4)
*For Microsoft SQL Server 2005 Express Edition users only: 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 SQL 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 SQL 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:
CPU:
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:
CPU:
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
Note:
Please consult your AccountMate Reseller or System Administrator to
confirm the optimal configuration to suit your specific needs.
*For XP SP2 users only: If you have enabled Windows Firewall, contact your IT administrator for proper configuration to enable incoming network connections.
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 SQL:
Verify compliance with the System Requirements.
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.
Verify that you have administrative rights to the computer where you are installing a live copy of AccountMate 7; otherwise, the VFP run-time libraries and Crystal Report drivers in the Windows folder will not be properly registered.
Exit all Windows programs before starting the installation.
Quick Install Guide
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.
Click Next to display the License Agreement window. Read and accept the License Agreement; then, click Next to proceed.
View the AccountMate 7 for SQL ReadMe in the Information window; then, click Next to proceed.
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.
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
If you chose Custom Setup, the installer will display the Product Key window; otherwise, proceed to step 10.
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.
Click Next to proceed to the Select Components window.
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.
Click Next to proceed to the Select Program Folder window. Accept the default or define your own program folder name.
Click Next to start installation. When the installation is complete, click Finish to exit the AccountMate Setup.
To create the sample company database, launch the AccountMate Administrator program 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.
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.
Launch the AccountMate application and log in with the user name and password that you set up through the AccountMate Administrator program.