I would like to delete an investment account.

I have tried to move all transactions to another account but I have found that for some of the securities there are identical transactions in both accounts.

If I delete the transactions in the account I wish to remove they also disappear from the account I wish to keep.

If I re-key the deleted transaction in the account that I wish to keep they also re-appear in the account I wish to delete.

I have run Tools->Consistency Check which reports my database is consistent.

Any suggestions on what would be the best way to proceed?
TIA

Not a whole lot of ideas out there...

You do not mention it, but is this an investment account? Does it have an attached brokerage account?

Yes and yes.

Funny thing is I have moved most of the transactions out (buy,sell,dividend) but there are a few securities that won't move and I cannot for the life of me see why.

I'll spend some more time today and see if I can't get more of a handle on what's gone wrong.

If you unzip the database, stock transactions are not that hard to decipher; see <SPLITS> definitions under <TRANSACTION...>. I see two lines per transaction, one with null action for the brokerage account and one with action="Buy", etc. for the investment account. Maybe you can see something different for these duplicate transactions. Also, I bet you can simply substitute the account names in those lines to move the transactions, or even simpler, replace the accounts they refer to by the new accounts. Of course that does not explain why transaction don't move properly.

Thanks for that, I'll give it a try...

Meanwhile I tried the following:
I deleted all transactions in the account for an investment.
I then tried to delete the investment and got the pop-up window:
"Unable to delete investment: Unknown account 'A000374'"
At this point KMyMoney crashed to a bug report screen but since I have not got the debug installed this was not of much help.

Should I install the debug and get a backtrace or will this be a waste of time?

Thanks

If you did not change the kmy file manually, it should not be possible to end up with an unknown account (here, account means investment). Your file contains an inconsistency, e.g. investment A000374 was deleted but not all references were cleaned up. It may be hard to reproduce how that came to be (for debugging purposes). To clean up, you can run a consistency check, or uncompress it and check if and where A000374 is still referenced. I would not be surprised it is all a consequence of the duplicate transactions that were introduced.

I've uncompressed and had a look at my kmy file and find that the security that I was trying to move, which has an id of A000374 appeared as a subaccount of BOTH dealing accounts.

I deleted its definition under the account I wanted it removed from and on firing up KMyMoney it has disappeared from the ledger of the unwanted account. All transactions are still present in the "wanted" account.

Everything seems to be in order but I need to do the same for a handful of other securities and then do some careful checking before I change my working data file. This seems too easy so I will look for trouble!

I have never before edited my .kmy file so the duplication has ocurred under KMyMoney and not by finger trouble, which is a little worrying.

Thanks for encouragement!

Actually, I manage both my wife's and my retirement account in the same .kmy file. These accounts have several securities in common, and that does not pose any problems. A common security does have different identifiers in each parent account, e.g. A0000079 in account A000070 and A000102 in account A000090. For the stock price table, there is a third identifier, E000009, and that one is unique. It is referenced in both account definitions:

Code: Select all

  <ACCOUNT parentaccount="A000070" lastmodified="2012-02-03" lastreconciled="" institution="" number="" opened="2010-05-06" currency="E000009" type="15" id="A000079" name="XYZ"
  <ACCOUNT parentaccount="A000090" lastmodified="2012-02-03" lastreconciled="" institution="" number="" opened="2010-05-09" currency="E000009" type="15" id="A000102" name="XYZ"

So, an investment is sometimes called an account, and sometimes a currency

Likewise I manage multiple investment accounts within the same .kmy.

I have not experienced a problem before and was surprised when I could not do a routine move of some securities from one investment account to another.

It seemed as if the move did half the job and left the securities behind in the old account such that they could not be deleted using the transaction options.

Moving transactions between accounts is a fairly normal process for me as I have nearly 200 securities and need to have them organised according to what I am going to do with them next.

Anyway, now I have the transactions in the account I want and not duplicated I am happy again.