Tuesday 9 December 2014

Crashes when going to Investment Portfolio in Microsoft Money

For some reason, my Money 2005 suddenly freeze and closed, without an error message.

Microsoft Money Deluxe Version 14.0.120.1105

With a quick search on Google, I got this link: http://money.mvps.org/faq/article/21.aspx

However, creating a temp file doesn't help.  And that suggest me to Microsoft's knowledge base 272211.  The problem is, Microsoft has removed that articles for whatever reason.  You cannot find it.  Luckily, by a search of this number, I can find a Portuguese link:

http://support.microsoft.com/kb/272211/pt

In case they might remove the resolution from KB future, I copied it here for my own use.

And my solution is:
  1. Open Money and my file.
  2. Go to "Banking" from the tabs, expand "Investment Accounts", and change one of my investment account to "Account is Closed".
  3. Go to "Investing" (Portfolio) and see if it crash or not.  If not, change the view type to "Show by Accounts" (the cause of crash was selected "Bond" view).
  4. Go back to "Banking" and change that closed account to open.
I hope no one needs this information but just in case, stay clam and don't panic (yet).  Always backup as well.



Resolution

To resolve this issue, replace the damaged account with a new account. To do this, use the following methods in the order that they are presented. 

NOTE: Before you follow these steps, make sure that you have made ​​a data file backup. To do this, click Back Up on the Filemenu.

Find damaged Investment accounts

To find damaged investment accounts:
  1. On the Money navigation bar, click Investing Center on the Investing menu.
  2. In the Investing Center menu, click Accounts.
  3. Change View in the left pane, click Sort account list by, and then click to clear the check box Hide closed accounts.
  4. Click the right mouse button on an open account, and then click Account is Closed. If the following message appears, click No:
    There are some open positions in the account you are about to close or delete. Are you transferring this account to another investment account?
  5. Repeat step 4 for each account opened.
  6. Click Portfolio. Got the message, "You currently do not have any investment accounts" or the Portfolio page appears.
  7. In the Investing Center menu, click Accounts.
  8. Click with the right mouse button on one of the accounts which closed in step 4, and then click Account is Open.
  9. Click Portfolio. 

    If you see the Portfolio page and the account, then the account is damaged. 

    If the page appear and disappear quickly and return to the Accounts page, then the account is damaged. Close the account again.
  10. Repeat steps 8 and 9 for each account until you locate and close all damaged accounts.

Create new investment accounts

To create a new investment account to replace a damaged investment account:
  1. In the left pane, click Set up accounts.
  2. Click Add a new investment account. 

    Follow the instructions in the New Account wizard to create a new account. When prompted to add investments, click No.When you are prompted to enter an estimated value for this account, do not enter any information.
  3. Repeat step 2 for each new account you create.
  4. Click Accounts.

Move Transactions of Damaged Investment Account for New Investment Account

To move transactions from a damaged investment account to a new investment account, follow these steps:
  1. In the Account & Bills menu, click Account List.
  2. Open the new account that you created.
  3. For each transaction with problems, insert a Add Shares transaction that matches the date and amount of the investment.
  4. In the Account & Bills menu, click Account List.
  5. Open the old account that had problems.
  6. Click the right mouse button on each of the transactions with problems and then click Cut and Paste to Account on the shortcut menu.
  7. Select the new account, and then click OK.
  8. Repeat steps 6 and 7 for each transaction that caused the problem.
  9. Run the Salvage Utility on your Money data file.
    1. Quit Money.
    2. Click Start and then click Run.
    3. If the file you want to repair is the last file used in Money, type "C: \ Program Files \ Microsoft Money \ System \ Msmoney.exe" -s in the Open box. 

      NOTE: If you installed Money in a location other than that default, type the correct path to the executable file. Be sure to include the quotation marks as indicated.
    4. Click OK to open and repair the specified file.
  10. In the Account & Bills menu, click Account List.
  11. Open the new account that you created.
  12. Click the right mouse button on each of the Add Shares transactions created, and then click Delete on the shortcut menu.
  13. Click the right mouse button on the remaining transactions, and then click Cut and Paste to Account on the shortcut menu.
  14. Select the investment account with problems, and then click OK.
  15. Repeat steps 13 and 14 for all transactions in the new account.
  16. Run the Salvage Utility on your Money data file.
    1. Quit Money.
    2. Click Start and then click Run.
    3. If the file you want to repair is the last file used in Money, type "C: \ Program Files \ Microsoft Money \ System \ Msmoney.exe" -s in the Open box. 

      NOTE: If you installed Money in a location other than that default, type the correct path to the executable file. Be sure to include the quotation marks as indicated.
    4. Click OK to open and repair the specified file.
  17. In the Account & Bills menu, click Account List.
  18. Then right-click the new account that you created, and then click Delete on the shortcut menu.