Microsoft KB Archive/171408

From BetaArchive Wiki

SBFM97: Contents of the Quickbooks 5.0 Filter Readme.txt

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

Last Reviewed: November 4, 1998
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.