[Kmymoney-devel] [Bug 274185] QIF investment import with Lcategory:sub-category creates new incorrect category

[egroegbaker at yahoo.com]

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





--- Comment #10 from  <egroegbaker yahoo com>  2011-06-05 08:15:53 ---
Hi Allan


Regarding the Div transactions.
Agreed.
4 a) and 4 c) are not as per QIF specifications and should be ignored I guess.

4 b) One of my transactions is actually a dividend transaction for which I was 
using the IntInc. When changing IntInc to Div I geta transaction in both the
investment account and the brokerage. 

In the investment account it is an entry with no effect -  only the value is
shown. 
But it has the correct category. You do not mention this entry?

In the brokerage the category is just 'investment transaction', but the
amounts are valid. This would seem to be the correct outcome since there are 
no shares bought, but it is an investment activity.

I have attached snap shots of both accounts with the div transaction
highlighted,. The QIF entry is as follows:-

D21/04/2011
YSatrix 40
NDiv
MSatrix Dividends
LLocal Dividend:Satrix 40
T454.86
I1.0000
Q454.86
^
I will look into 4 d) later and separately so as not to confuse the issue.

Regards
Timothy




________________________________
From: allan <agander93 at gmail.com>
To: egroegbaker at yahoo.com
Sent: Saturday, June 4, 2011 1:56 PM
Subject: [Bug 274185] QIF investment import with Lcategory:sub-category creates
new incorrect category

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





--- Comment #9 from allan <agander93 gmail com>  2011-06-04 13:56:45 ---
(In reply to comment #8)
> (In reply to comment #7)
> > Hi Allan
> > 
> > To recap:
> > Bug #1: Accounts
> > 
> > Fixed
> > 1) No new accounts created
> > 2) L[Account:sub-account]processed correctly
> >
> 1) Using your original QIF, and with the accounts and categories set up as you
> have them, yes, no new accounts/categories get created.
> 2) Yes, with activity codes left as 'IntInc', the transactions are allocated to
> the correct category:sub-category, with the service fee as a Payment, and the
> others as deposits.
> 
> > Bug#2: Categories:sub-categories only in KMM 1.0.5
> >
              More serious in version KMM 4.x
> > 
> > 1)  Categories sorted out except for  " Bank Charges:Service Fee not split"?
> > 2)  IntInc work around for negative (Fees) and positive (Interest) transactions
> >               or use miscexp for negative Fees
> > 3) IntInc transactions are being recorded correctly in brokerage account only
> > 
> > 4) Dividends: use option 'Div' - records in both brokerage and investment a/cs
> 
> 1) All categories are correct.
> 2) Yes, as above. No miscexp necessary.
> 3) Yes, all appear only in the Brokerage account - two deposits and one
> payment.
> 4) Not sure what you mean here?  No Dividend records are now involved in your
> QIF.  If you mean, aside from
 your QIF, if Dividends are entered, how do they
> appear, well, I still have a problem with Div records.
> a) 'Div'  'L[acc]' treated as category.
> b) 'Div'  'Lacc'   deposits in 'acc' with no category.
> c) 'DivX' 'Lacc'   deposits in 'acc' with no category.
> d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category.
> 
> From my reading, b) and d) should be valid, and the other two, who knows?
> It would be interesting to know how V1.x handles these.
> > 

Let me have another go at this, this time using the version with my patches :(

a) 'Div'  'L[acc]' deposits in 'Brokerage' with 'Dividend' category.
b) 'Div'  'Lacc'   deposits in 'Brokerage' with 'Dividend' category.
c) 'DivX' 'Lacc'   deposits in 'acc' with no category.
d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category, (inc any
sub-cat).
so, still a bit to
 do.

> > Is that everything? Is there any thing left out? or have I got anything wrong?
> > Maybe you could sum it up better, but it seems that you have got it working in
> > all the problem areas.
> > 
> I think that covers the problem areas, but I have more testing to do, and a
> tidy up, then it goes to the reviewboard.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.