Bug Fixes

Refer to the MS607a / MD607a Maintenance Release Summary under the Technical Support section of the AccountMate Business Partner Home Page.

·     Sort by Control Number

http://www.accountmate.com/download/bugnotes/Fix_Summary_MS607a_byControl.htm

·     Sort by Module

http://www.accountmate.com/download/bugnotes/Fix_Summary_MS607a_byModule.htm

Important Changes

Read New Product Key From Build Update Installation Into the Application

For every build release, AccountMate requires a unique product key. Product key can be entered during installation or through the Activate Module function under File > Licensing Menu of the AccountMate 6.5 for SQL Administrator program.

In previous builds, when AccountMate is launched, the program will verify if the product key has been entered in the system. If product key has not been entered, the system will try to detect if it was keyed in during installation. If so, the system will be updated with that value and the user does not need to go through the Activate Module to key in the product key.

Installing a build update requires a new product key. Product key entered, during installation, for build updates will not refresh the product key in AccountMate. User needs to go through the Activate Module to input the new product key.

In this build release, the system is enhanced to read the new product key entered during installation. User will not need to re-key in the product key in AccountMate when updating the system to a new build.

Resolve Conflict With Microsoft Windows Security Update (KB896358).

After installing Microsoft Windows Security Update (KB896358), pressing the <F1> key will bring up the AccountMate Online Help but the topic page displays the following message:

Action canceled

Internet Explorer was unable to link to the Web page you requested. The page might be temporarily unavailable.

This issue is encountered when the AccountMate program is accessed from the File Server across the network. The following OS versions are affected: Windows 98, ME, 2000, 2003 and XP. Refer to http://support.microsoft.com/kb/896358 on the Microsoft website for more details.

To correct this behavior, the AccountMate Online Help file (AMW.CHM) will now be installed on the local workstation. AccountMate will open the local copy of the Online Help when a user presses the <F1> key.

Expand Information Into Item # + Warehouse + Specification Level

Show Average Cost, Profit Margin and other information by Item # + Warehouse + Specification Level

In previous builds, the information that shows in the Inventory Maintenance for Last Received Cost, Last Received Date, Average Cost, Profit Margin and Profit % for a item with specification belongs to only one(1) Specification Item. User will need to generate the Inventory Cost Listing to get the information per individual Specification Item.

It this build release, the system is enhanced to allow user to view the above information for all Specification Items. The Spec Detail command button is added in the Settings Tab to bring up the Specification Detail for Item # [XXX] in Warehouse [YYY] window. The information are shown in a grid and may be exported to Excel or other file formats.

Allow Setup of Revenue Code and GL Accounts by Warehouse + Item + Specification Level

In previous builds, setup of Revenue Code, Inventory Account and In-transit Account is only on the Item # + Warehouse level. If certain Specification Items have to be posted to different GL accounts, user needs to change the revenue code when posting transactions.

In this build, the system is enhanced to allow user to set up Revenue Code, Inventory Account and In-transit Account per Item # + Warehouse + Specification level. Changes can be entered through the grid on the Item Spec tab.

The GL Accounts tab reflects the values defined for the last Specification Item record of the Item # + Warehouse combo. Changes on the GL Accounts tab will only affect records with empty values (i.e., records with blank Revenue Code will be populated with the Revenue Code entered in the GL Accounts tab).

In cases wherein new Specification Items are added, the new records will get the default values from the last Specification Item record in the Item # + Warehouse combo.

The Item Specs tab is accessible only after the user goes through the Inventory Specification Maintenance to pick the specification codes to set up the Specification Items.

Image Path Limit for Inventory Record Increased to 100 Characters

In previous builds, user can attach an image to the inventory record but the image path is limited to 30 characters only.

In this build release, the system is enhanced to accept 100 characters for the image path. This will allow users to store the images in a shared folder over the network with more ease.

Optimization on AR Apply Payment

Processing of payment against a large volume of invoices in the AR Apply Payment function has been optimized on this build release.

Use the Last Transaction Cost To Calculate Cost of Goods Sold for FIFO/LIFO Items When On-hand Quantity Is Zero or Negative

In previous builds, inventory item are sold out based on the average cost if the on-hand quantity is zero or negative. This is regardless of the item’s costing method.

In this build release, the system is enhanced to compute Cost of Goods Sold for FIFO/LIFO items with zero or negative on-hand as follows:

System will compute for cost variance adjustment when transaction recorded is a positive adjustment against the on-hand quantity.

Use Arrow Keys to Add Journal Entry Lines

In previous builds, user can add new journal entry line in the Journal Entry function through the Add Line command button only.

In this build release, the system is enhanced to allow adding of a new journal entry line using the arrow key. This behavior is consistent with transactions in other modules (e.g., adding new line item in AR, SO, etc.)

Make Non-AccountMate Tables Available for Custom Reports

In previous builds, only AccountMate tables are available for selection in the Custom Reports function.

In this build release, the system is enhanced to make the non-AccountMate tables available for Custom Reports. Following are the requirements to use this feature:

1. The table must belong to an add-on module.

2. The table is among the list of tables in the AccountMate Create Table Script Table (AMTBL.DBF).

3. The table has a corresponding remote view in the company database container. This is necessary to show table and field caption.

NOTE: The Refresh Tables command button will re-generate the tables and fields list in the Custom Reports function. User needs to click on the button after implementing changes on the table structure (e.g., new table, new field).

Generate Inventory Transaction Log in Details or Subtotal

In previous builds, Inventory Transaction Log shows all detail information for the inventory item.

In this build release, the system is enhanced such that user can choose to generate the Inventory Transaction Log in Detail or Subtotal. Generate the report in Detail if you want to see the activity of the inventory per specified Transaction Date. Generate the report in Subtotal if you want to see the on-hand quantity as of the specified Last Transaction Date. The Subtotal option is available only when the sort option selected is by Item #.

Allow Inactive GL Account ID’s to be Consolidated to Parent Company

In previous builds, the system ignores inactive GL Account IDs in the subsidiary company. This generates out-of-balance error when performing consolidation.

In this build release, the system is enhanced such that the consolidation procedure will ignore the active status of the subsidiary company’s GL Account IDs. The inactive status of the GL Account ID will only prevent future use in posting transactions.

Refresh Freight Amount Only When Freight Code or Weight is Changed

In previous builds, various transactions re-computes freight amount when user exits the Overwrite Freight window even without changing any field value. User needs to verify the freight amount before saving otherwise the transaction may reflect an amount different than what is intended.

In this build release, the system is enhanced so that the freight amount is retained regardless of actions in the Overwrite Freight window. Changing any of the following field values will reset the freight amount to the system default: Freight Code, and/or Weight.

Add Warehouse Information in Inventory Type Listing

Inventory Type Maintenance allows setup of multiple warehouse, GL accounts, and/or revenue code. However, only one set of information is shown in the Inventory Type Listing.

In this build release, the report is enhanced to show the different warehouse, GL accounts and revenue codes as set up in the Inventory Type Maintenance function.