Bug 339548 - Can not enter an investment Dividend transaction
Summary: Can not enter an investment Dividend transaction
Status: RESOLVED NOT A BUG
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: git (master)
Platform: RedHat Enterprise Linux Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-30 23:43 UTC by george
Modified: 2016-11-04 20:14 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
Screen shot just prior to pushing the "Enter" button (241.46 KB, image/png)
2014-10-07 15:56 UTC, george
Details
screen shot after the Enter, Edit, and split buttons were pressed. (250.35 KB, image/png)
2014-10-07 15:59 UTC, george
Details

Note You need to log in before you can comment on or make changes to this bug.
Description george 2014-09-30 23:43:27 UTC
This seems weird but when I attempt to enter an investment dividend transaction I always end up with zero.
If I fill in the Interest field with the Brokerage account and then enter the amount when I hit Enter the amount shows as zero.  If I then edit the transaction I find there is a split transaction with two values the one I entered and another with the same fields except the amount is the negative of what I entered.  If I edit the split to remove the second line it is added back when I hit Enter resulting in zero again.

I admit that I may be going at the all wrong, but if so, PLEASE make this a bit more intuitive.
Comment 1 george 2014-10-01 00:05:43 UTC
After trying various things I found a magic key.  If the "Account" field in the editor is change and then changed back the entry works.  This is MOST weird!
Comment 2 allan 2014-10-01 10:04:29 UTC
On 01/10/14 01:05, george@wildturkeyranch.net wrote:
> https://bugs.kde.org/show_bug.cgi?id=339548
>
> --- Comment #1 from george@wildturkeyranch.net ---
> After trying various things I found a magic key.  If the "Account" field in the
> editor is change and then changed back the entry works.  This is MOST weird!
>

This sounds a bit like a problem fixed a while back.

How sure are you that that mysterious plugin (and all traces of previous 
versions) have been removed?  I can't reproduce your problem here.  It 
all works as expected.

Allan
Comment 3 george 2014-10-01 17:28:15 UTC
(In reply to allan from comment #2)
> On 01/10/14 01:05, george@wildturkeyranch.net wrote:
> > https://bugs.kde.org/show_bug.cgi?id=339548
> >
> > --- Comment #1 from george@wildturkeyranch.net ---
> > After trying various things I found a magic key.  If the "Account" field in the
> > editor is change and then changed back the entry works.  This is MOST weird!
> >
> 
> This sounds a bit like a problem fixed a while back.
> 
> How sure are you that that mysterious plugin (and all traces of previous 
> versions) have been removed?  I can't reproduce your problem here.  It 
> all works as expected.
> 
> Allan

My git dirs all show the earliest pull was on 8/18/14.  How might I search for this "mysterious plugin"?

George
Comment 4 allan 2014-10-01 21:21:41 UTC
> My git dirs all show the earliest pull was on 8/18/14.  How might I search
> for this "mysterious plugin"?
> 
From your paypal bug -
"#7 0x00007f89b2c9d860 in CsvImporterDlg::dateColumnSelected(int) () from /usr/lib64/kde4/kmm_csvimport.so", so perhaps it's still there.  Anyway, I'd be inclined to do a system search for that file, excluding its path.  But, if that file is still present (what date?) there could be others lurking.  Make sure to do a sudo/su make uninstall, then try a search again, to be on the safe side.
Could you have a mix of 64 and32 bit?
Allan
Comment 5 Jack 2014-10-01 22:42:22 UTC
I wonder if this is a similar issue as another bug I replied to earlier.  Have you ever had a distro version installed?  If you, and you didn't completely uninstall that version before compiling from git, you will definitely have pieces of that one left around.

As I said in the other bug, the issue may be less the building than the installing.  All KDE applications (unless you are extremely careful in the build configuration) install in the same place (or set of places for user and system) so KDE always knows where to look for things like icons, help files, config files, .....  If you run KMM from the build directory, and also have a distro provided version installed, KDE still looks in the system location, so without doing "make install" it will find the system installed plugins and not the ones you just built.
Comment 6 allan 2014-10-05 21:34:32 UTC
May this now be closed?
Comment 7 george 2014-10-05 21:49:03 UTC
(In reply to allan from comment #6)
> May this now be closed?

I am still trying to clean up my system so I clearly have only the git code on it.  It seems that "kmm" files are all over the place (likely because I changed the build destination dir).  I need to verify that they are truly from KMM befor I purge them.  This is a bit of a pain, but I am making progress.  I will advise.
Comment 8 george 2014-10-06 17:57:49 UTC
(In reply to george from comment #7)
> (In reply to allan from comment #6)
> > May this now be closed?
> 
> I am still trying to clean up my system so I clearly have only the git code
> on it.  It seems that "kmm" files are all over the place (likely because I
> changed the build destination dir).  I need to verify that they are truly
> from KMM befor I purge them.  This is a bit of a pain, but I am making
> progress.  I will advise.

Ok, I have removed all the kmymoney references from /usr/... "find" and also any "*kmm*" files that also appear in the git tree.  I then did a "git pull", make, "make uninstall", "make install".
So, I think this is a clean install.  This is what I see:
Steps:
1. open a ledger for an investment account (say foo) with an attached checking account (foo (Brokerage))
2. Click "Edit"
3. For "Activity" select "Dividend". At this point the "Account" entry is set to "foo (Brokerage)"
4. In the "Interest" entry enter "foo (Brokerage)"
5. In the second "interest" entry enter an amount, say 10. At this point the "Enter" button activates.
6. Click the "Enter" button.

On my system this results in a ledger entry which shows $0.00  0.000
If I edit this entry I find "Interest" is "Split transaction" and the split has two entries which are the same except the sign of one entry is negative while the other is not.
I have found two ways to fix this:
1. if at step 3,  insert 3.1: clear the "Account" entry and reenter "foo (Brokerage)" .  Step 6 will then give the expected answer.

2. The bad entry can be edited by:
a. deleting the negative split entry and
b. deleting the "Account" entry and re-entering the "Account" entery, i.e. "foo (Brokerage)"
c. Clicking the "Enter" button.
Comment 9 allan 2014-10-06 23:16:49 UTC
> So, I think this is a clean install.  This is what I see:
> Steps:
> 1. open a ledger for an investment account (say foo) with an attached
> checking account (foo (Brokerage))
OK.
> 2. Click "Edit"
What am I editing here?  An existing transaction?  Is it possible to do this with a new transaction, so I can work with the same data as you?
> 3. For "Activity" select "Dividend". At this point the "Account" entry is
> set to "foo (Brokerage)"
OK.
> 4. In the "Interest" entry enter "foo (Brokerage)"
So you're using/creating a new category?
> 5. In the second "interest" entry enter an amount, say 10.
Sorry, which  second "interest" entry?  Are you now in the split editor?
> At this point the
> "Enter" button activates.
> 6. Click the "Enter" button.
> 
> On my system this results in a ledger entry which shows $0.00  0.000
> If I edit this entry I find "Interest" is "Split transaction" and the split
> has two entries which are the same except the sign of one entry is negative
> while the other is not.
> I have found two ways to fix this:
> 1. if at step 3,  insert 3.1: clear the "Account" entry and reenter "foo
> (Brokerage)" .  Step 6 will then give the expected answer.
Which is what?
> 2. The bad entry can be edited by:
> a. deleting the negative split entry and
> b. deleting the "Account" entry and re-entering the "Account" entery, i.e.
> "foo (Brokerage)"
> c. Clicking the "Enter" button.

I'm sorry, but I'm not yet sure I know what you are trying to achieve, and I don't think I am following your steps correctly.

Perhaps you could provide some screen shots, and ensure your steps are fully explained.

Allan
Comment 10 allan 2014-10-06 23:45:27 UTC
I've gone back to the beginning, and think perhaps you are just trying to enter a simple dividend transaction.  So instead of following your suggested steps, this is what I do -
1. Open a new transaction and select activity Dividend.
2. Enter security name.
3. The account already shows the associated Brokerage account.
4. In the Interest field, select an appropriate income category, say _Dividend.
5. Now enter the interest amount.
6. Select Enter.
7. No Split transaction is showing, only the dividend category entered above. '_Dividend.'
8. Edit the transaction.
9. Click the Split transaction button.
10. Just one entry appears, _Dividend and amount.
11. Right click the transaction.
12. Select Go to Brokerage account.
13. The Brokerage account show the deposit.
14. Right click and select  Go to investment account.
15. Check that the '_Dividend' category shows the entry.

When you reselect the Brokerage category, might you have an income category of that name, which could result in the second entry and the amount therefore getting cancelled?
Comment 11 george 2014-10-07 15:54:19 UTC
(In reply to allan from comment #9)
> > So, I think this is a clean install.  This is what I see:
> > Steps:
> > 1. open a ledger for an investment account (say foo) with an attached
> > checking account (foo (Brokerage))
> OK.
> > 2. Click "Edit"
> What am I editing here?  An existing transaction?  Is it possible to do this
> with a new transaction, so I can work with the same data as you?
My bad.  I ment the click "NEW".

> > 3. For "Activity" select "Dividend". At this point the "Account" entry is
> > set to "foo (Brokerage)"
> OK.
> > 4. In the "Interest" entry enter "foo (Brokerage)"
> So you're using/creating a new category?
No.  While that is a category, it was created when I did the QIF import.  

To be clear here, I am new to KMM after more years that I want to count using Quicken.  They made it too hard to run under "wine" and KMM looked ready so I just switched.  

I imported several investment accounts and am just now trying to get them up to date.  The issue that generated this report was that a OFX update failed to handle a correction transaction where the Fidelity was adding a small amout to fix a miss reported dividend.  I thought that all I needed to do was to make the transaction look like the a downloaded dividend transaction that "appeared" to be correct, in that the amount appeared in both the investment account and in the brokerage and the dollar balance matched Fidelity's.

> > 5. In the second "interest" entry enter an amount, say 10.
> Sorry, which  second "interest" entry?  Are you now in the split editor?
No.  Take a look at the "edit" sub window.  In my system, in this case, there is a column on the left that reads: Activity, Security, Account, Fees, Interest, Memo
and a column about 75% of the window width to the right that reads: Date, , , , Interest, Total, Status
This is the second "Interest" entry and seems to be for the amount which I want to set to "10".

> > At this point the
> > "Enter" button activates.
> > 6. Click the "Enter" button.
> > 
> > On my system this results in a ledger entry which shows $0.00  0.000
> > If I edit this entry I find "Interest" is "Split transaction" and the split
> > has two entries which are the same except the sign of one entry is negative
> > while the other is not.
> > I have found two ways to fix this:
> > 1. if at step 3,  insert 3.1: clear the "Account" entry and reenter "foo
> > (Brokerage)" .  Step 6 will then give the expected answer.
> Which is what?
> > 2. The bad entry can be edited by:
> > a. deleting the negative split entry and
> > b. deleting the "Account" entry and re-entering the "Account" entery, i.e.
> > "foo (Brokerage)"
> > c. Clicking the "Enter" button.
> 
> I'm sorry, but I'm not yet sure I know what you are trying to achieve, and I
> don't think I am following your steps correctly.

I suspect that the only differance is that you do not have a category of "foo (Brokerage)"

If I do as you suggest in your next message, i.e. use "dividend" as the category, I get the same result, i.e. a net zero transactions with a split containing the canceling amount.  Again, the fix is to eliminate and re-enter the "Account" field.

By the way, if category is what is wanted in the "Interest" field, why is it named "Interest" and not "Catagory"?
> 
> Perhaps you could provide some screen shots, and ensure your steps are fully
> explained.
I will attach two screen shots, before Enter and after {Enter, Edit, open split}
> 
> Allan
Comment 12 george 2014-10-07 15:56:40 UTC
Created attachment 89012 [details]
Screen shot just prior to pushing the "Enter" button
Comment 13 george 2014-10-07 15:59:00 UTC
Created attachment 89013 [details]
screen shot after the Enter, Edit, and split buttons were pressed.

This shot shows the entry on the last ledger line with value 0.  Above that is the open split showing the negating split that was created.
Comment 14 allan 2014-10-07 17:35:16 UTC
> To be clear here, I am new to KMM after more years that I want to count
> using Quicken.  They made it too hard to run under "wine" and KMM looked
> ready so I just switched. 

I think I see a glimmer...

> I imported several investment accounts and am just now trying to get them up
> to date.  The issue that generated this report was that a OFX update failed
> to handle a correction transaction where the Fidelity was adding a small
> amout to fix a miss reported dividend.  I thought that all I needed to do
> was to make the transaction look like the a downloaded dividend transaction
> that "appeared" to be correct, in that the amount appeared in both the
> investment account and in the brokerage and the dollar balance matched
> Fidelity's.
> 
> > > 5. In the second "interest" entry enter an amount, say 10.
> > Sorry, which  second "interest" entry?  Are you now in the split editor?
> No.  Take a look at the "edit" sub window.  In my system, in this case,
> there is a column on the left that reads: Activity, Security, Account, Fees,
> Interest, Memo
> and a column about 75% of the window width to the right that reads: Date, ,
> , , Interest, Total, Status
> This is the second "Interest" entry and seems to be for the amount which I
> want to set to "10".

> > I'm sorry, but I'm not yet sure I know what you are trying to achieve, and I
> > don't think I am following your steps correctly.
> 
> I suspect that the only differance is that you do not have a category of
> "foo (Brokerage)"

I suspect what may be behind the confusion goes back to what you said earlier: that this derived from an import from Quicken.  If originally that was a QIF import, the the 'L' line has two variations.  The 'L'  would be followed by an 'account/category' name.  If that name is enclosed in [ ], then that is treated as an account to be used for the funds transfer.  If however it is not so enclosed, then the name is taken to be a category.  I suspect that in this case what should have been an account name was not enclosed and so became a category, and it is that mistake that I think is misleading you.

I can't see a reason for wanting to use a foo (Brokerage) name as a category - it is the name of the accpunt to receive the dividend amount.  This is a Dividend transaction, so, To me, the category should reflect that and be Dividend or _Dividend or....

That was what my example was showing, and your comment below is actually unfixing rather that fixing.  However, it's your file, and you may use it as you wish, of course.

> If I do as you suggest in your next message, i.e. use "dividend" as the
> category, I get the same result, i.e. a net zero transactions with a split
> containing the canceling amount.  Again, the fix is to eliminate and
> re-enter the "Account" field.
> 
> By the way, if category is what is wanted in the "Interest" field, why is it
> named "Interest" and not "Catagory"?

The field is dual purpose, and sometimes, where there is room, it is called "Interest /Category".

> > Perhaps you could provide some screen shots, and ensure your steps are fully
> > explained.

> I will attach two screen shots, before Enter and after {Enter, Edit, open
I haven't yet looked at the screen-shots, so hopefully they don't thow more confusion in.

Allan
Comment 15 allan 2014-10-07 17:39:11 UTC
The second screen-shot is showing, in effect, the reassignment of the category from the (Brokerage) category to the Dividend category.
Comment 16 Jack 2014-10-07 20:24:08 UTC
(In reply to george from comment #11)

> I imported several investment accounts and am just now trying to get them up to date. The issue that generated this report was that a OFX update failed to handle a correction transaction where the Fidelity was adding a small amout to fix a miss reported dividend. I thought that all I needed to do was to make the transaction look like the a downloaded dividend transaction that "appeared" to be correct, in that the amount appeared in both the investment account and in the brokerage and the dollar balance matched Fidelity's. 

I think most of the issues have already been addressed, but this particular comment points out what may be a separate problem.  A "correction" transaction might not match the transaction it is correcting (especially if that transaction was imported or matched) if it is a new transaction, not just a modified version of the same transaction.  The only way to be sure is to compare transaction IDs within the OFX downloads.  I have not checked what the OFX standard say about this, but when I have received a correction transaction from Merrill Lynch, it was simply a new transaction with the correct amounts, and I needed to manually either simply delete the original, or add a reversing transaction to undo the effects of the original.
Comment 17 george 2014-10-07 21:38:11 UTC
On 10/07/14 14:24, Jack wrote:
> https://bugs.kde.org/show_bug.cgi?id=339548
>
> Jack <ostroffjh@users.sourceforge.net> changed:
>
>             What    |Removed                     |Added
> ----------------------------------------------------------------------------
>                   CC|                            |ostroffjh@users.sourceforge
>                     |                            |.net
>
> --- Comment #16 from Jack <ostroffjh@users.sourceforge.net> ---
> (In reply to george from comment #11)
>
>> I imported several investment accounts and am just now trying to get them up to date. The issue that generated this report was that a OFX update failed to handle a correction transaction where the Fidelity was adding a small amout to fix a miss reported dividend. I thought that all I needed to do was to make the transaction look like the a downloaded dividend transaction that "appeared" to be correct, in that the amount appeared in both the investment account and in the brokerage and the dollar balance matched Fidelity's.
> I think most of the issues have already been addressed, but this particular
> comment points out what may be a separate problem.  A "correction" transaction
> might not match the transaction it is correcting (especially if that
> transaction was imported or matched) if it is a new transaction, not just a
> modified version of the same transaction.  The only way to be sure is to
> compare transaction IDs within the OFX downloads.  I have not checked what the
> OFX standard say about this, but when I have received a correction transaction
> from Merrill Lynch, it was simply a new transaction with the correct amounts,
> and I needed to manually either simply delete the original, or add a reversing
> transaction to undo the effects of the original.
>
Let me try to get this correct. We are talking about two things here and 
I filed this report about only one of them, the issue with the Edit/New 
command in KMM not getting what (I think) is desired when Enter is 
pressed in the first screen shot.  In that case I did not use the 
account name category, but rather "dividend".  Also, I need to also 
point out that if I remove and re-enter the "Account", I do get (I 
think) a correct entry which shows the amount in both the investment and 
the Brokerage Ledgers.  This, I think, has nothing to do with the reason 
I tried to make the entry in the first place.

As to the correction, I have not, and don't intended to file a report on 
that as I am not sure if the correction came from a QIF or an OFX 
import.  When I look at the OFX of the transaction it does not mention 
the security at all and yet I clearly remember a security reference in 
the transaction.  Also Fidelity does not "ID" the transaction as a 
correction and gives it an ID (which contains the date) that indicates 
it is a new transaction.
Comment 18 Jack 2014-10-07 23:14:19 UTC
I think we are actually in agreement, and my comment 16 could just be considered a bit off topic.  When I said "most of the issues" I referred to the subject of this bug - which I think has been well addressed, even if not completely solved.  My comment about a correction transaction not matching, as you point out, is a separate issue.  Whether it came from a QIF of OFX import doesn't really m atter - it just triggered my long standing focus on problems with the reality of how brokerage companies use downloads (OFX in my case) in ways that may meet the OFX standard, and might work when used in a printed statement, but almost always require manual intervention when imported into a program like KMM.
Comment 19 Jack 2014-11-11 23:01:55 UTC
Are there still open issues with this bug, or has everything been figured out?
Comment 20 Cristian Oneț 2014-11-12 07:13:20 UTC
Changing the state too needs info based on comment #19.
Comment 21 george 2016-11-04 18:43:28 UTC
On 10/05/14 15:34, allan wrote:
> https://bugs.kde.org/show_bug.cgi?id=339548
>
> --- Comment #6 from allan <agander93@gmail.com> ---
> May this now be closed?
>
This is so far in the past that I have lost track of what it is. Yes, 
please close.