Microsoft KB Archive/171408

{| = SBFM97: Contents of the Quickbooks 5.0 Filter Readme.txt =
 * width="100%"|

Article ID: Q171408

The information in this article applies to:
 * Microsoft Excel 97 for Windows
 * Microsoft Small Business Financial Manager 97 for Microsoft Excel 97

SUMMARY
The following is the contents of the Quickbooks version 5.0 filter for the Microsoft Small Business Financial Manager 97 Readme.txt. You can obtain this Readme.txt file by downloading Sbfmqb5.exe from the Microsoft Software Library and extracting its contents.

For more information about how to download files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q119591 TITLE    : How to Obtain Microsoft Support Files from Online Services

MORE INFORMATION
MICROSOFT SMALL BUSINESS FINANCIAL MANAGER 97 FOR MICROSOFT EXCEL

QUICKBOOKS AND QUICKBOOKS PRO 5.0 FILTERS README FILE (c) 1997 Microsoft Corporation. All rights reserved.

CONTENTS
1. Installation Instructions

2. Problems Importing Accounting Data from Intuit Quickbooks 5.0

3. Problems with Accounts Being Incorrectly Classified in Financial

Manager 4. Differences in Account Numbers Between Intuit Quickbooks 5.0 and Financial Manager 5. Differences in Quantity Sold Between Intuit Quickbooks 5.0 and Financial Manager 6. Support and Licensing Information NOTE: To use these filters, Microsoft Excel 97 and Microsoft Small Business Financial Manager 97 must be installed on your computer.

1. INSTALLATION INSTRUCTIONS

A. Quit Microsoft Excel 97, if it is running.

B. Copy the Aapqbw50.dll file to the SBFM folder on your computer's      hard disk. By default, this is C:\Program Files\Microsoft Office\Office\Sbfm. 2. PROBLEMS IMPORTING ACCOUNTING DATA FROM INTUIT QUICKBOOKS 5.0 Before you import accounting data from QuickBooks 5.0 for Windows, you must register QuickBooks and disable all password protections on  the data. In addition, if you have Quickbooks set to automatically enter memorized transactions, this should be disabled while running the Financial Manager filter. If you don't, you may receive a series of error messages, which you should clear by pressing ENTER in  response to each.

If you encounter problems importing accounting data from QuickBooks 5.0 for Windows, you should run the QuickBooks utility to rebuild your accounting data, and then try importing again. To run the QuickBooks repair utility, choose Rebuild Data on the QuickBooks File:Utilities menu. 3. PROBLEMS WITH ACCOUNTS BEING INCORRECTLY CLASSIFIED IN FINANCIAL MANAGER Occasionally, when importing Quickbooks 5.0 data, accounts end up in the wrong category. This causes Financial Manager reports to be incorrect.

If this occurs, use the Remap menu item on the Accounting Menu within Microsoft Excel to correctly map your data to the proper account categories. 4. DIFFERENCES IN ACCOUNT NUMBERS BETWEEN INTUIT QUICKBOOKS 5.0 AND FINANCIAL MANAGER

If you use account numbers when setting up accounts in Quickbooks, these account numbers will not appear on Financial Manager reports. Financial Manager will create its own account numbers to ensure that reports are sorted correctly. 5. DIFFERENCES IN QUANTITY SOLD BETWEEN INTUIT QUICKBOOKS 5.0 AND FINANCIAL MANAGER

When entering an invoice in Quickbooks 5.0, if you do not enter a sales price and quantity, it will default to a quantity of 1 when creating reports. This quantity is not an accurate reflection of the transaction.

Financial Manager will use a quantity sold of 0 for these transactions, which properly reflects what was entered in the invoice. This will cause some differences between the quantity sold reported in Financial Manager and that reported in Quickbooks 5.0. 6. SUPPORT AND LICENSING INFORMATION Assistance with these filters is provided to you through your Microsoft Small Business Financial Manager 97 for Microsoft Excel warranty support policy. Installing these filters will not restart this warranty period. If your Microsoft Small Business Financial Manager 97 warranty support period has expired, paid phone support and alternative options are available.

If your license to the Microsoft Small Business Financial Manager 97 product was obtained from a hardware manufacturer, then technical support for these filters is not available from Microsoft. Please contact your hardware manufacturer before installing these filters to  determine your support options.

These filters, for use only with Microsoft Small Business Financial Manager 97 for Microsoft Excel, are considered to be part of Microsoft Small Business Financial Manager 97 for Microsoft Excel. Therefore, their use is subject to the same terms and conditions governing the use of Microsoft Small Business Financial Manager 97 software. Additional query words: 2.00 XL97 sbfm readme update Keywords         : kbtool xlsbfm Version          : WINDOWS:97 Platform         : WINDOWS
 * }