January 31, 2005
The AccountMate 6.5 for MSDE MD606a CD contains the following components:
· AccountMate 6.5 for MSDE Program Files
· MSDE installer (under the “MSDE_Installer” folder)
· Utility to set SQL Server Security (under the “MSDE Utilities” folder)
· Report Utility Files (For details, refer to the Readme file under the “Crystal Utilities” folder.)
· Stored Procedure and Trigger Update Program (For details, refer to amspmain.pdf file under the “Other Utilities” folder.)
· Microsoft Visual FoxPro 8.0 (Service Pack 1) Runtime Files
· Seagate Crystal Reports 8.5 Runtime Files
Refer to the MS606a / MD606a 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_MS606a_byControl.htm
· Sort by Module
http://www.accountmate.com/download/bugnotes/Fix_Summary_MS606a_byModule.htm
A new shortcut group called “My AccountMate Help” is added in the Shortcut Pane. This group contains the following shortcuts:
1. Online Help opens the AccountMate help file.
2. Electronic Manual opens the Table of Contents file of the AccountMate documentation.
3. AccountMate Homepage opens the Internet Explorer pointing to the AccountMate website www.accountmate.com.
In previous builds, user needs to click on the Exit icon or the “X” button on the upper right-hand corner of the AccountMate screen to get out of the AccountMate application.
In this build release, the system is enhanced to allow exit from AccountMate by pressing the <ALT> and <F4> keys simultaneously.
In addition to the change above, the message
Do you want to exit the application?
will no longer appear when trying to exit the AccountMate application.
The SAMPLE data are updated by moving the current fiscal year to 2005. Prior fiscal year is 2004 and Next fiscal year is 2006.
Payments may be voided for different reasons like insufficient funds or charges are denied. The original payment may have been recorded in a previous deposit. In previous builds, users cannot create a deposit with the voided payment because the voided payment entries were not included in the selection list for recording of deposits.
In this build release, the system is enhanced so that the scenario above is supported. The system will show both the regular and voided payment transactions. We also allow deposits to be zero or negative in both AR and BR modules.
In previous builds, AR Bank Deposits are recorded with a generic description of “AR Deposits”.
In this build release, the system is enhanced to allow user to input the description of each AR Bank Deposit. The deposits will be easily identified when performing Bank Reconciliation later on.
In previous builds, data in the different tabs of the Bank Reconciliation function appear in one specific order, mostly the data shown in the column after the checkboxes.
In this build release, the system is enhanced to allow user to change sorting order during reconciliation. The default sorting order is not changed. A blue-colored column-heading identifies sortable columns. A click on the column heading prompts the system to sort the values in the column. If a user clicks the column heading of a sorted column, the system will switch the sorting order from ascending to descending or vice versa.
In previous builds, AP invoices posted on a restricted period is only available for viewing. To void an AP invoice, the period where the AP invoice is posted would need to be flagged as unrestricted.
In this build release, the system is enhanced to allow viewing and voiding of AP Invoice posted in a restricted period. However, void date must still belong to an unrestricted period to successfully void a posted AP invoice.
In previous builds, the discount rate default for new Purchase Orders is always taken from the Discount % of the Information Tab of each function.
In this build release, the system is enhanced such that Vendor Discount % setup may also be used as default discount rate. The Use Vendor Discount % checkbox is added in the Create Purchase Order by Item / Sales Order / Reorder Quantity. Mark the checkbox to get default discount rate from the Vendor Setup. Unmark to follow the inputted Discount % in the Information Tab.
The Discount % field is available for input only when the Use Vendor Discount % is unmarked. To reflect a discount rate other than the default, access the Line Item Detail window and input the desired Discount % for the line item.
In previous builds, user can add new line item in the Create Purchase Order and Create Blanket Purchase Order functions through the Add command button only.
In this build release, the system is enhanced to allow adding of a new line item using the arrow key. This behavior is consistent with transactions in other modules (e.g., AR, SO, etc.)
In previous builds, our system allowed changes to the decimal settings for Cost and/or Price without validation. We found that decreasing the decimal settings causes an anomaly in the data.
To avoid such cases, we have restricted the decimal settings of the two amount fields. In this build, we only allow increase to the decimal settings. The following module setup functions are affected: AR, SO, PO, MI, IC, RA.
When a user attempts to increase the decimal settings, a message will appear saying:
WARNING: The cost and price decimal settings cannot be decreased once saved. Do you wish to proceed?
The message appears with a Yes/No button to allow the user to confirm or cancel the changes. Once the change is saved, there is no way to revert it.
In previous builds, unit price in the Create Purchase Order function is reset to system default when user moves from one field to another using the <TAB> key, even without changing the field value. User needs to verify the unit price before saving otherwise the order might reflect a price different than what is intended.
In this build release, the system is enhanced so that the unit price is retained regardless of cursor movement. Changing any of the following field values will reset the unit price to the system default: Unit of Measurement, Vendor #, and/or Vendor Part #.
In this release, the presentation of the data is enhanced in the AR and SO Line Item Reports.
|
Before Change |
After Change |
|
No subtotal to a specific warehouse when viewing Subtotal report for sorting option Item # + Warehouse. |
Sorting option Item # + Warehouse will generate group total based on Item # + Unit of Measurement and subtotal on each warehouse. Report shows subtotal and group total on Order Quantity. |
|
No subtotal on Order Quantity for sorting option Salesperson + Item #. |
Sorting option Salesperson + Item # will generate group total based on Salesperson and subtotal on Item # + Unit of Measurement. Report shows subtotal on Order Quantity. |
|
No subtotal on Item # when viewing subtotal report for sorting option Warehouse + Item #. |
Sorting option Warehouse + Item # will generate group total based on Warehouse and subtotal on Item # + Unit of Measurement. Report shows subtotal on Order Quantity. |
In previous builds, voided invoices always appear in AR Packing Slip report.
In this build release, the system is enhanced to allow preview or print of the AR Packing Slip including or excluding voided invoices. Mark the Include Voided Invoices checkbox to include voided invoices in the report, unmark to exclude.
In previous builds, a counted quantity of zero (0) does not affect item on-hand.
In this build release, the system is modified so that counted quantity will be evaluated if different from the frozen on-hand. Update Physical Count will generate adjustments and update on-hand accordingly.
In previous builds, the Recalculate Inventory Data function recalculates on-hand quantity (ICIWHS) for items based on details record (ICITRS). However, if records do not exist, the inventory on-hand does not get updated.
In this build release, the system is modified to use the inventory bin data (ICIBIN) in recalculation of the onhand quantity (ICIWHS). Data in other inventory tables will be populated accordingly.
In previous builds, there is no validation on the freight charges on Return for Credit items which may cause increase on the Accrued Received Liability account.
In this build release, the system is modified to detect anomaly on the Accrued Received Liability account due to freight charges on Return for Credit items. The following message is displayed when such case is detected:
Return for Credit will increase Accrued Received Goods by the freight charge amount. Cannot proceed with the transaction.
In previous builds, a user can use the contact filter record in the Contact Filter function even when access right is not granted to the user account.
In this build release, the system is modified to limit access to the contact filter record to authorized users only.
In previous builds, crop insurance proceeds do not have a corresponding AP 1099 Type.
In this build release, AP 1099 Type “Crop Insurance Proceeds” option is available for the crop insurance proceeds for 1099.
The AP Voucher # Report is enhanced in this build to include a sorting option on the Invoice # field. Voucher # is a system-generated value and users sometimes do not track the Voucher #. In which case, it is still easier to look up information by the AP Invoice #.
Below are some changes applied to the Budget Statement:
1. Budget PTD will show the PTD of the period as defined in the budget maintenance.
2. Budget YTD will show the YTD of the period as defined in the budget maintenance.
3. Available column is “Actual minus the Budget” “or Budget minus the Actual” depending on whether the “Actual vs Budgeted” or “Budgeted vs Actual” option has been selected. However, Available column will be zero if the Actual Amount is greater than the Budget Amount.
|
CPU1 |
Pentium III 733MHz |
|
Memory1 |
256MB |
|
Hard Drive1 |
1.0 GB Free Space |
|
Operating System |
Windows Server 2003 Standard Edition or Windows Server 2003 Enterprise Edition or Windows 2000 Server (SP3) or Windows 2000 Advanced Server (SP3) |
|
Database |
Microsoft MSDE 2000 |
|
CPU1 |
Pentium III 733MHz |
|
Memory1 |
256MB |
|
Hard Drive1 |
500 MB Free Space |
|
Operating System |
Windows Server 2003 Standard Edition or Windows Server 2003 Enterprise Edition or Windows XP Professional (SP2)* or Windows 2000 Server (SP3) or Windows 2000 Advanced Server (SP3) or Windows 2000 Professional (SP3) |
|
CPU1 |
Pentium II |
|
Memory1 |
128MB |
|
Hard Drive1 |
500MB Free Space |
|
Operating System |
Windows XP Professional (SP2)* or Windows 2000 Professional (SP3) or Windows 98 SE (not recommended) |
1 Denotes Minimum Hardware Requirements
*For XP SP2 users only: If you have enabled Windows Firewall, contact your IT administrator for proper configuration to enable incoming network connections.
Important: For an updated system requirements list, always visit our website at http://www.accountmate.com/am65/msde_systemreq.asp. Please consult your AccountMate Reseller to confirm the optimal configuration to suit your specific needs.
Visual FoxPro 8.0 (SP1)
Crystal Reports 8.5 (SP1)
Microsoft SQL Server 7.0 or 2000 Utilities
There is no installation interface for the Report Utility Files (Rptsetup.exe). When the files are needed, the users are required to copy them manually from the CD. The same applies for the Stored Procedure/Trigger Maintenance Utility (Amspmain.exe).
Microsoft SQL Server is not included in the CD. If SQL Server has not been installed on the database server, the user is required to install Microsoft SQL Server before installing AccountMate 6.5. Refer to the Hardware/Software Requirements above regarding the versions of SQL Server that AccountMate 6.5 supports.
Do not forget to install the Microsoft Data Access Component (MDAC), if it has not been installed on each workstation that will be running AccountMate 6.5.
The succeeding section outlines the steps to install AccountMate 6.5 from the CD:
1. Insert the AccountMate CD into your CD-ROM drive to automatically start the installation; otherwise, 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, and click Next to proceed to the Information window.
3. Click Next to proceed to the Choose Destination Location window. Perform either one of these steps:
a. Accept the default destination folder; or
b. Select a destination folder other than the default by clicking the Browse button to open a typical Choose Folder window where you can select a different folder.
4. Click Next to proceed to the Setup Type window. Select from the following types of installation:
a. Typical
This option will install AccountMate 6.5 Program Files, Visual FoxPro 8.0 Runtime Library and other drivers for Crystal Reports 8.5.
· Choose this option if you do not use a file server to load AccountMate 6.5 or you want to run the AccountMate 6.5 application from the workstation.
b. Compact
This option will install the Visual FoxPro 8.0 Runtime Library and other drivers for Crystal Reports 8.5.
· Choose this option if AccountMate 6.5 has been installed on a file server and you only want to install the minimum files required on the workstation in order to run AccountMate 6.5 from the file server.
c. Custom
This option will allow the user to choose from among three specific component(s) to be installed and it has all three component options checked by default in the Select Component window. Available components are AccountMate 6.5 Program Files, AccountMate 6.5 Administrator Program, and Runtime Files (i.e., Visual FoxPro 8.0 Runtime Library, and drivers for Crystal Reports 8.5).
· Choose this option to install any components that you forgot to install or choose specific components to fit your needs.
5. If you chose the Custom setup type, the installer will display the Product Key window otherwise, proceed to step 9.
6. In the Product Key window, enter the 25-digit 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. Should you encounter problems with your Product Key contact your AccountMate Reseller or AccountMate Customer Service.
NOTE: Leave this field blank to install the AccountMate Presentation Software.
7. Click Next to proceed to the Select Components window.
8. In the Select Components window choose from among the following components to install:
a. Program Files
This includes all AccountMate executable files that allow you to run the AccountMate 6.5 program and all its functions and reports.
b. Administrator Program
Installs the Administrator program which you need to activate the AccountMate 6.5 modules, create companies, and manage group and user access rights, among other functions.
c. Run-time Files
This installs the Visual FoxPro, Crystal Reports and other run-time libraries necessary to run AccountMate 6.5 functions and reports.
d. Source Code
This includes all the 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 supplied in the Product Key window.
NOTE: The Source Code option will not be available if you choose to install the Presentation Copy of AccountMate.
9. Click Next to proceed to the Select Program Folder window. Accept the default or define your own program folder name.
10. Click Next to start installation. When the installation is complete, click Finish to exit the AccountMate Setup window.
Use the following checklist as a guide when installing a live copy of AccountMate 6.5:
1. Verify compliance with the Minimum System Requirements.
2. Install Microsoft SQL Server on your database server.
3. Install AccountMate 6.5 in the database server, file server (if applicable), and/or all workstations where AccountMate will be used. Refer to the Installation Guide for instructions on the Installation Type to use for file server, client and/or workstation installations.
4. Connect all workstations to the Database Sever by performing the following:
a. Set up your Open Database Connectivity (ODBC) driver.
§ If the AccountMate 6.5 installation does not properly create a System DSN in the ODBC, perform the following:
o Access the ODBC Data Source program from the Administrative Tools folder of the Control Panel.
o Create a new Data Source that uses SQL Server driver and call it “MSSQL_VAM”.
b. Configure your ODBC to connect to the correct Microsoft SQL Server instance.
§ To establish connection, perform the following:
o Configure your ODBC Data Source (“MSSQL_VAM”) to point to the correct Microsoft SQL Server instance.
o Set the System DSN to use SQL Server Authentication to verify the authenticity of your login ID.
o Check the option to “Connect to SQL Server to obtain default settings for the additional configuration options.”
o Use ‘sa’ for the Login ID and enter a valid Password. Contact your database administrator if you do not know the password.
o Test the connection and verify that it is established successfully.
5. To create the sample company database, launch the AccountMate 6.5 Administrator program from your desktop or the AccountMate program folder. The application will prompt you for an AccountMate User Name and Password. Use the following defaults until you change them:
User Name: SUPERVISOR
Password : GO
6. In the AccountMate 6.5 Administrator program, perform the following:
a. Enter the AccountMate Product Key and activate the modules you want to use.
b. Install the License File
c. Create your live company database.>
d. Set up groups and users and define access rights.
7. Launch the AccountMate 6.5 application using the default AccountMate User Name and Password until you change them:
User Name: SUPERVISOR
Password : GO
Follow the instructions set forth under the Live Copy Setup excluding step 6.