Microsoft KB Archive/124864

Incorrect Column Headings and/or Amounts in Summary Reports

PSS ID Number: Q124864 Article last modified on 07-14-1997

3.00

WINDOWS

=
=========================================================

3.00 WINDOWS kbusage

= SYMPTOMS =

In a Summary Report that has been customized with Accounts For columns, you may receive the following incorrect results:

Incorrect column headings

Combined amounts from two accounts under one account heading

These errors occur when you are working in a file that has both Regular Accounts and Investment Accounts and one or more Regular Accounts has been deleted from the file.

= CAUSE =

This problem is caused by an incorrect reference to the deleted account.

= WORKAROUND =

To correct this reference, use the Export and Import commands to export the accounts and then import them to a new Money file.

NOTE: Each account be exported individually.

To export the files from the current account


 * 1) From the File menu, choose Export. In the Export dialog box, choose QIF.
 * 2) Type a filename for the account to be exported, and choose OK. For example, if you are exporting the checking account, give it the name “Checking.QIF” (without the quotation marks).
 * 3) When prompted to Choose An Account Type, select Investment for an Investment account or Regular for all other types of accounts.
 * 4) When prompted to Select Export Account, select the account to be exported, and choose the Continue button. When you receive the Export Complete message, choose OK.
 * 5) Repeat steps 1-4 for each additional account to be exported.

To create a new file and import your accounts to the new file

  From the File menu, choose New.   When prompted to create the first account, choose the name and type of the first account you exported.   From the File menu, choose Import.   In the File Name box, select all of the files that were exported from the old money file. The Select Import Account dialog box will display the first account to be imported and a list of available accounts will be displayed.   If the correct account is listed, select it. If not, choose the Create Account button and create the appropriate account to import the account to.   When prompted in the Assign Import Account dialog box, repeat step 5 for each account to be imported. 

The Summary Report will now be displayed correctly.

KBCategory: kbusage KBSubcategory:

Additional reference words: kbhowto 3.00 corrected w_money importing exporting reports ====================================================================== Keywords : kbusage Version : 3.00 Platform : WINDOWS ============================================================================= Copyright Microsoft Corporation 1997.