[Kmymoney-devel] [kmymoney4] [Bug 343536] Same stock investments in different accounts

[T.B.]

https://bugs.kde.org/show_bug.cgi?id=343536

--- Comment #9 from T.B. <hummerfisch at yahoo.de> ---
It seems we are closing the circle here. The very first description shows the
neccessary steps to reproduce the faulty behaviour.

In other words: The observation is that it makes a difference if an investment
is created from the investments view (as stated in comment #4) or from the
ledgers view (as originally described). The same forms appear and the user
cannot be aware that it is behaving differently: upon adding the investment
from the ledgers view, the form is not checking the ticker ID against the
existing ones. This results in duplicate investments when operated from the
ledgers view.

Fortunatly my second account contained just a few investments and I was able to
fix that but had a hard time doing so. Eventually this exposed another issue
but currently I am not willing to reproduce it, to be able to describe it as a
real bug. Still maybe a fix description is helpful for others finding this bug:
1. Find out which of the duplicates belong to the second depot. Can be done by
renaming, e.g. both Apples to Apple_1 and Apple_2 (later one may be the
ducplicate to remove)
2. Delete all transaction in the second account.
3. Still the duplicate investment couldn't be deleted as I had already
retrieved online quotes.
4. Deleted all online quote prices from the Extras > Prices view. I double and
triple checked this the view showed no quotes for Apple_2
5. Still deletion was not possible
6. Used File > Save as database. SQL Lite was convenient for me.
7. Used Mozillar Firefox with SQLLite Manager to access that database. In the
table kmmSecurities I identified the ID for Apple_2
8. Went to kmmPrices and found some prices for Apple_2 although these were not
shown in step 4 (maybe that's a bug?). Deleted these prices.
9. Saved the database
10. Went back to kmymoney and used File > Open Database to open the changed
version.
11. Anything looked as before. But now I was able to delete Apple_2
12. Now I could enter my investments for account 2 from the investements view
first before adding transactions.

-- 
You are receiving this mail because:
You are the assignee for the bug.